Commit Graph

278 Commits

Author SHA1 Message Date
JSuenram 2ab250a10b Small fix for using mySQL Database backend. Switch mysql.CreateConnection to mysql.CreatePool. 2022-01-21 15:14:10 +01:00
Ylian Saint-Hilaire 8acbfd2a30 PostgreSQL now skips table and index creation when DB already exists, #3487 2022-01-19 12:21:50 -08:00
Ylian Saint-Hilaire c8ef09f94c Fixed PostgreSQL getDbStats(), #3487 2022-01-19 12:11:28 -08:00
Ylian Saint-Hilaire 354f77eac3 Fixed PostgreSQL authfail query error, #3487 2022-01-19 11:52:51 -08:00
Ylian Saint-Hilaire 01dbc70098 Added --removesubdomain command, #3440 2022-01-11 17:30:50 -08:00
Ylian Saint-Hilaire 0e549631ac Event log is now userid based instead of username based. 2022-01-11 13:10:36 -08:00
Ylian Saint-Hilaire f8e9426350 Improved MongoDB indexes. 2022-01-10 12:25:31 -08:00
Ylian Saint-Hilaire 7219aa5a44 Added DB query checks. 2022-01-09 18:44:43 -08:00
Ylian Saint-Hilaire c0bdc38ef2 Added MongoDB index to improve query targetting. 2022-01-09 17:45:51 -08:00
Ylian Saint-Hilaire 1d76a50e47 Added intelamt.uuid index in MongoDB to improve query targetting. 2022-01-09 16:09:36 -08:00
Noah Zalev c3b9de37f9 Add MySQL AWS RDS support to mysqldump 2021-11-17 19:12:18 -05:00
Noah Zalev c5c27820c9 Added awsrds config option 2021-11-17 17:24:43 -05:00
Ylian Saint-Hilaire 72b92284d4 Fixed server stats for SQL databases. 2021-11-08 10:31:52 -08:00
Ylian Saint-Hilaire c741a29c10 Server stats fix on MySQL, MariaDB, PostgreSQL. 2021-11-07 18:25:08 -08:00
Ylian Saint-Hilaire 244399c329 First version with working PostgreSQL support. 2021-11-04 11:53:54 -07:00
Ylian Saint-Hilaire 11ff538ec5 More work on Postgres support. 2021-11-03 23:42:01 -07:00
Ylian Saint-Hilaire 97bd723e4e Early work on Postgres SQL support. 2021-11-02 19:44:41 -07:00
Ylian Saint-Hilaire 959c147295 Fixed insecure dependencies. 2021-10-12 11:20:33 -07:00
Ryan Blenis 470a313ee7 MC greater than 0.9.7 plugin arch fixes 2021-09-19 22:50:00 -04:00
Ylian Saint-Hilaire dbd7209070 db.changestream fix for #3135 2021-09-15 08:25:05 -07:00
Ylian Saint-Hilaire 10fe94557b More report fixes. 2021-09-09 14:50:59 -07:00
Ylian Saint-Hilaire eb30d40e25 Added desktop session length into event log when multiplexor is used. 2021-09-09 10:37:54 -07:00
Ylian Saint-Hilaire ce8b2a6bd8 Added MySQL/MariaDB support for reports. 2021-09-09 10:09:18 -07:00
Ylian Saint-Hilaire a15a5e779d Started work on reports feature. 2021-09-08 15:55:07 -07:00
Ylian Saint-Hilaire b2905bfe29 More auto device removal fixes. #3089 2021-09-01 22:30:43 -07:00
Ylian Saint-Hilaire 7d25391f78 Improvements for automatic device removal, #3089 2021-09-01 22:21:39 -07:00
Ylian Saint-Hilaire 88ae5a30b4 Fixed MongoDB bulk write of events and power events. 2021-08-26 14:48:17 -07:00
Ylian Saint-Hilaire adae944146 Added terminal start command option 2021-08-19 14:10:03 -07:00
Ylian Saint-Hilaire 994834f57c Added removeInactiveDevices() to maintenance tasks. 2021-08-04 11:00:15 -07:00
Ylian Saint-Hilaire 2281a61e30 Completed device inactive auto-remove feature. 2021-08-04 10:55:33 -07:00
Ylian Saint-Hilaire dbf0dd446f Fixed CIRA connections for devices that changed device group. 2021-07-31 10:05:32 -07:00
Noah Zalev 47a050fb0d Bugfix - correct power timeline query 2021-07-27 16:09:11 -04:00
Noah Zalev 53d837a052 Refactor mongodump command 2021-07-06 23:59:22 -04:00
Ylian Saint-Hilaire f48536c40d Fix for #2801. 2021-06-22 08:40:26 -07:00
Ylian Saint-Hilaire 29e30504f0 Fix for #2663. Invitation codes are removed for deleted device groups. 2021-05-21 09:01:06 -07:00
Ylian Saint-Hilaire 76fde352f6 Fix for #2666 2021-05-21 08:41:30 -07:00
Ylian Saint-Hilaire 626364bab8 One more fix for mongodump.exe invocation. 2021-05-20 13:54:08 -07:00
Fabian G 5cc23d960e
Update db.js
The Slash before the additional parameters inside the mongoDB connectionstring gave us great headaches.
After the AutoBackup initiated it immediately fails as it couldn't find the database with a trailing slash.
Our connectionstring contains information for the local MongoDB User and the authentication DB.
The String looks as follows (user and password have been omitted):
mongodb://{{user}}:{{password}}@localhost:27017/meshcentral?authSource=admin&compressors=zlib&gssapiServiceName=mongodb
2021-05-19 10:15:32 +02:00
Noah Zalev 5a0cba84cc bugfix: dont call createdb callback func 2021-05-06 22:35:24 -04:00
Noah Zalev 2f5c5d9b03 Added addition ssl options 2021-05-02 15:30:38 -04:00
Noah Zalev 8179777f73 Add 2-way auth options to mysqldump 2021-05-02 14:43:55 -04:00
Noah Zalev b8c5623041 Bugfix - don't rely on use database 2021-05-01 18:41:28 -04:00
Noah Zalev 791afb5035 bug fixes checking ssl properties 2021-05-01 15:56:18 -04:00
Noah Zalev e21077b064 clean up sqldumpcmd, add ssl 2021-05-01 15:08:29 -04:00
Noah Zalev dc75589bd3 Added selfsigned cert support to mysql/mariadb ssl 2021-04-30 23:16:48 -04:00
Noah Zalev 740559f2f8 Improved connectionObject creation 2021-04-29 23:55:37 -04:00
Ylian Saint-Hilaire 84b9d3df09
Merge pull request #2542 from nzalev/add-mysql/mariadb-to-getbackupconfig
Added mysql/mariadb to getBackupConfig
2021-04-24 18:51:47 -07:00
Noah Zalev f0751bab39 Added mysql/mariadb to getBackupConfig 2021-04-24 19:51:10 -04:00
Noah Zalev 0612f23b36 Bail if unable to connect to db 2021-04-24 17:22:39 -04:00
Noah Zalev e163662610 Added dbname to mysql/mariadb autobackup 2021-04-23 12:23:58 -04:00
Noah Zalev d6aaecc4a6 Add dbname to checkBackupCapability 2021-04-23 12:13:43 -04:00
Noah Zalev 4ca9c391a2 Connect without db in connection obj 2021-04-22 20:06:08 -04:00
Noah Zalev 416a713c68 Removed database name from queries 2021-04-22 17:37:54 -04:00
Noah Zalev 4c34797915 Include dbname in mysql/mariadb connectionObj 2021-04-22 17:14:31 -04:00
Ylian Saint-Hilaire 6c3e010ce9 More work on login tokens. 2021-04-16 12:42:54 -07:00
Noah Zalev 3707d10fe1 Register output error listener in autobackups 2021-04-11 21:47:25 -04:00
Noah Zalev e79b2b8070
Update db.js
Updated failure string
2021-04-10 20:41:50 -04:00
Noah Zalev 72afaaa908 Fixed sqldump pw escaping on windows 2021-04-10 20:11:17 -04:00
Noah Zalev 4b9cf142e1 Added mysqldump to performBackup 2021-04-10 18:18:27 -04:00
Noah Zalev 34aa47a813 Added MariaDB/MySQL to checkBackupCapability 2021-04-10 17:21:02 -04:00
Noah Zalev b0579baa85 mongodump to dev null for dry-run effect 2021-04-10 14:23:07 -04:00
Noah Zalev 71817137cd Fix for #2486
if dburl then use --uri option
2021-04-07 17:27:23 -04:00
Ylian Saint-Hilaire 8771313fc4 Fix for #2423 2021-03-27 00:26:18 -07:00
Ylian Saint-Hilaire 746fe62fd1 Added auto-create tables/indexes for MySQL/MariaDB databases. 2021-03-10 14:48:20 -08:00
Ylian Saint-Hilaire 0a4fae413b MySQL previous logins fix. 2021-03-10 14:24:55 -08:00
Ylian Saint-Hilaire 19cfae4295 Fixed MySQL/MariaDB server exception. 2021-03-10 13:09:43 -08:00
Ylian Saint-Hilaire bb8e6d6511 Fixed previous login dialog. 2021-03-09 17:26:54 -08:00
Ylian Saint-Hilaire 70c9252f60 Added background color to device filter box when active. 2021-03-09 13:04:59 -08:00
Ylian Saint-Hilaire c9035b80c8 Added database counters. 2021-03-01 19:32:19 -08:00
Ylian Saint-Hilaire f5e22c1067 Improved database query for account login events. 2021-03-01 13:23:37 -08:00
Ylian Saint-Hilaire 1b4f2f6002 Merged MongoDB bulk operations support. 2021-02-25 19:13:51 -08:00
Ylian Saint-Hilaire e6f24582bd Improved Android push messaging token handling. 2021-02-22 16:54:30 -08:00
Ylian Saint-Hilaire 027810259d Rolled back MongoDB fast bulk operations until more testing is done. 2021-01-27 02:23:36 -08:00
Ylian Saint-Hilaire 89d5e8bbbd Improved MongoDB handling. 2021-01-26 13:34:48 -08:00
Ylian Saint-Hilaire 1845950fdb MongoDB remove fix. 2021-01-26 13:06:18 -08:00
Ylian Saint-Hilaire 394a2e2878 Added MongoDB bulk remove for added performance. 2021-01-12 14:02:11 -08:00
Ylian Saint-Hilaire fe72281dcd Added way to remove test agents. 2021-01-12 12:43:27 -08:00
Ylian Saint-Hilaire e5694aeb93 MongoDB record encryption fix. 2021-01-11 13:37:40 -08:00
Ylian Saint-Hilaire 6107723304 Old Intel ACM removed, MongoDB targetting improvement. 2021-01-11 13:02:30 -08:00
Ylian Saint-Hilaire 21e6b0320b Fixed notification translation. 2021-01-11 11:56:21 -08:00
Ylian Saint-Hilaire cb8fc7d150 MongoDB bulk get fix. 2021-01-10 14:41:25 -08:00
Ylian Saint-Hilaire e9bd782418 Added MongoDB bulk find support to boost performance. 2021-01-10 13:57:38 -08:00
Ylian Saint-Hilaire b6a257c1e4 More MongoDB bulkWrite() improvements. 2021-01-10 06:19:16 -08:00
Ylian Saint-Hilaire e41ac08221 MongoDB speed boost using bulkWrite() 2021-01-10 04:53:30 -08:00
Ylian Saint-Hilaire b195852399 Updated file headers. 2021-01-09 14:31:09 -08:00
Ylian Saint-Hilaire 397fe9fb63 Fixed mongodump error. 2021-01-09 00:40:03 -08:00
Ylian Saint-Hilaire 8ac8953298 Added new --nedbtodb to transfer all NeDB records into the database. 2021-01-04 16:26:25 -08:00
Ylian Saint-Hilaire 333c7c7876 Second fix for mesh link escaping. 2020-12-30 22:18:29 -08:00
Ylian Saint-Hilaire 5a4fdd3d8d Fix database escaping problem in device groups. 2020-12-30 18:52:44 -08:00
Ylian Saint-Hilaire 93ace89b69 Rolled back the mtype fix. 2020-12-30 17:14:57 -08:00
Ylian Saint-Hilaire 0769185831 Fixed mtype not being a number type in database. 2020-12-28 23:33:08 -08:00
Ylian Saint-Hilaire cce68922d7 Improved MongoDB autobackup and error handling. 2020-12-28 19:25:21 -08:00
Ylian Saint-Hilaire 67b748d1e6 Fixes for SSO accounts and server peering. 2020-11-28 18:03:09 -08:00
Ylian Saint-Hilaire 1b2a63977b Added terminal device sharing. 2020-11-27 13:55:02 -08:00
Ylian Saint-Hilaire 39541f8755 Fixes Intel AMT MEI calls. 2020-11-24 19:56:59 -08:00
Ylian Saint-Hilaire a3d712d207 Server peering fixes. 2020-11-12 18:42:26 -08:00
Ylian Saint-Hilaire 49c41cb02c Fixes for MeshCore and MariaDB. 2020-11-03 02:58:29 -08:00
Ylian Saint-Hilaire 248909d056 Added device sharing link revocation. 2020-10-30 17:08:07 -07:00
Ylian Saint-Hilaire 6fb8beb164 AMT Manager now configures randomized MPS passwords. 2020-10-24 23:34:00 -07:00
Ylian Saint-Hilaire 6e97282ea1 First version with Intel AMT Manager module. 2020-10-06 19:47:28 -07:00