Commit Graph

291 Commits

Author SHA1 Message Date
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
Ylian Saint-Hilaire 6411fbea42 Fixed account password reset when used with 2FA accounts. 2020-09-25 13:58:36 -07:00
Ylian Saint-Hilaire 1918006bc6 Added WebDAV auto-backup support 2020-09-10 12:43:48 -07:00
Ylian Saint-Hilaire fb0994e77e Improved messages when using autobackup command in MyServer console. 2020-09-08 13:02:05 -07:00
Ylian Saint-Hilaire 672235e0a3 Removed SMBIOS collection when using NeDB. 2020-09-08 11:58:23 -07:00
Ylian Saint-Hilaire 926e7888e0 Fixed --recordencryptionrecode when used with NeDB, added mesh record encryption. 2020-08-27 16:57:39 -07:00
Ylian Saint-Hilaire d0e718a775 Improved NeDB expire of old records. 2020-08-24 13:26:27 -07:00
Ylian Saint-Hilaire bf87bbd4a3 Improved Google Drive autobackup. 2020-08-21 11:47:34 -07:00
Ylian Saint-Hilaire 9d1b0f6134 First version of auto-upload backup to Google Cloud. 2020-08-21 01:57:03 -07:00
Ylian Saint-Hilaire 3a016138ad Added support for oldPasswordBan to not allow old password re-use. 2020-08-16 11:10:02 -07:00
Ylian Saint-Hilaire 0d59f937e0 MySQL fix. 2020-07-23 22:44:21 -07:00
Ylian Saint-Hilaire f84220a7f4 Added discovery key support. 2020-07-14 15:39:14 -07:00
Ylian Saint-Hilaire fc75bff5ad Added warning for older MongoDB versions. 2020-07-08 15:35:35 -07:00
Ylian Saint-Hilaire 3079f0185c Fixed DbExpire with NeDB. 2020-07-08 14:29:32 -07:00
Ylian Saint-Hilaire d3825eb496 Improved agent core dump collection system. 2020-07-08 11:59:20 -07:00
Ylian Saint-Hilaire 6b3b4e4ee2 Added --removeaccount command to MeshCentral. 2020-05-26 12:46:48 -07:00
Ylian Saint-Hilaire 43c8567b0d Fixed GCM cookie decoding authtag. 2020-05-03 14:12:26 -07:00
Ylian Saint-Hilaire 7653d1c398 Added way to not save SMBIOS information in the DB. 2020-04-24 13:37:37 -07:00
Ylian Saint-Hilaire 5f762550d2 More work on user device rights. 2020-03-29 22:40:13 -07:00
Ylian Saint-Hilaire 2314a58cd2 More work done on per-device permissions. 2020-03-26 19:33:13 -07:00
Ylian Saint-Hilaire e916836f0a Improved DbExpire in sample-config.json. 2020-03-16 13:30:12 -07:00
Ylian Saint-Hilaire 672517f27d Improved database error handling, new Let's Encrypt server console commands. 2020-03-04 14:57:03 -08:00
Ylian Saint-Hilaire fa929b3467 Fixed server exception within performBackup() 2020-02-28 10:37:50 -08:00
Ylian Saint-Hilaire 31e0f5c726 MeshCentral now works with both MariaDB and MySQL. 2020-02-03 18:58:58 -08:00
Ylian Saint-Hilaire bb989a4b82 First version that works with MariaDB. 2020-02-03 16:50:44 -08:00
Ylian Saint-Hilaire ab57626a03 MariaDB improvements. 2020-02-02 15:31:30 -08:00
Ylian Saint-Hilaire 33202e9e1c More MariaDB improvements. 2020-02-02 14:02:50 -08:00
Ylian Saint-Hilaire 01676c39c7 Added two more MariaDB tables (Power & SMBIOS) 2020-02-02 13:37:19 -08:00
Ylian Saint-Hilaire d28b5667b7 First signs of life with MariaDB. 2020-02-02 12:37:27 -08:00
Aaron 1f439c3624 Fix mongodump command syntax 2020-01-29 21:12:09 +01:00
Ylian Saint-Hilaire f2961e3d42 Fixed web site no localstorage, MongoDB backup with URL. 2020-01-29 10:31:58 -08:00
Ylian Saint-Hilaire fdd56b2dc5 Updated file headers. 2020-01-02 18:30:12 -08:00
Ylian Saint-Hilaire 7307152dbb More user groups improvements. 2020-01-02 00:30:14 -08:00
Ylian Saint-Hilaire ffb10a82be Added remove previous events selector when adding a new user. 2019-12-26 13:52:09 -08:00
Ylian Saint-Hilaire a7c39f30c7 Added portuguese, translate.js merge command. 2019-12-09 13:43:02 -08:00
Ylian Saint-Hilaire 2494f1b1d4 SMBios improvements 2019-12-09 11:30:08 -08:00
Ylian Saint-Hilaire 4ca5be4b2e Improved Czech, Improved Let's Encrypt validation, added --dbstats and --showsmbios. 2019-12-08 20:46:25 -08:00
Ylian Saint-Hilaire 75d49db30b Plugin system improvements. 2019-11-25 14:12:43 -08:00
Ryan Blenis a5007c995a Merge branch 'master' into plugin-admin 2019-11-22 14:26:44 -05:00
Ryan Blenis 145c898c70 Tweaks to plugin install/removal so server does not require a restart. Initial support for downgrading plugins. 2019-11-22 14:25:13 -05:00
Ylian Saint-Hilaire 8573d45753 Added bad login IP address limitation. 2019-11-18 17:31:42 -08:00
Ylian Saint-Hilaire 32eb3fe72b Added failed login logging and reporting. 2019-11-17 16:20:53 -08:00
Ryan Blenis 942eafb70d Type updates for NeDB 2019-11-11 11:58:23 -05:00
Ryan Blenis 6d3673a858 Add plugin "type" to plugins (permission sets coming soon) 2019-11-11 09:46:38 -05:00
Ryan Blenis 53a2d5ab59 Add NeDB compatibility 2019-11-08 10:20:35 -05:00
Ryan Blenis 0516b0afd3 gui plugin admin updates part 2 2019-11-01 16:49:18 -04:00
Ryan Blenis c57ac19cba gui plugin updates partial 2019-10-30 04:17:17 -04:00
Ylian Saint-Hilaire 6165723ef1 Fixed CIRA connections when a device is moved to a different group. 2019-10-10 16:07:32 -07:00
Ylian Saint-Hilaire fcccb18cc8 Probably fixed the MongoDB dot exception. 2019-10-10 14:06:14 -07:00
Ylian Saint-Hilaire 483f270a23 Added checks to catch MongoDB . in key exception. 2019-10-10 13:46:50 -07:00
Ylian Saint-Hilaire c860125a9d Improved DB records encryption support. 2019-10-03 13:32:54 -07:00
Ylian Saint-Hilaire 4d38b390a5 Added optional database record encryption support. 2019-10-02 17:19:33 -07:00
Ylian Saint-Hilaire d470944b8d New MeshAgents, MeshCtrl fix 2019-09-20 15:20:59 -07:00
Ylian Saint-Hilaire 3a161502b0 Added View Self Events only device group permission. 2019-09-18 12:05:33 -07:00
Ylian Saint-Hilaire b9116203f9 Small fixed to MeshPlayer 2019-08-13 17:06:45 -07:00
Ylian Saint-Hilaire bfd56a8a64 Started work on hardware inventory support. 2019-08-06 17:58:29 -07:00
Ylian Saint-Hilaire df271eb36e Added Windows Service control in remote desktop tools 2019-07-31 16:49:23 -07:00
Ylian Saint-Hilaire e18df0c5a1 Fixed MongoDB connection string 2019-07-29 18:21:52 -07:00
Ylian Saint-Hilaire 64f26135e1 Account emails are not always lowercase. 2019-07-15 10:24:31 -07:00
Ylian Saint-Hilaire d443645423 Updated MeshCommander and fixes to message dispatch. 2019-07-10 14:27:38 -07:00
Ylian Saint-Hilaire 5285fd6b40 More Intel AMT ACM/CCM work. 2019-06-24 18:56:14 -07:00
Ylian Saint-Hilaire 4a35d883d5 Server fixes, added locale arg in web app. 2019-06-11 11:33:44 -07:00
Ylian Saint-Hilaire 85ed10abd8 Added backupconfig command in server console. 2019-06-07 16:44:00 -07:00
Ylian Saint-Hilaire 0a62aa8ae3 Added support fo domain MaxDevices limit 2019-06-05 15:24:07 -07:00
Ylian Saint-Hilaire 7bc5394fcc Auto-backup fix 2019-05-31 16:59:48 -07:00
Ylian Saint-Hilaire d3e1b2d387 MongoDB change stream now updates memory objects. 2019-05-31 11:38:35 -07:00
Ylian Saint-Hilaire b0e2914f92 Can now batch add users to a device group. 2019-05-30 12:40:10 -07:00
Ylian Saint-Hilaire 3c0e7c9700 Improved MongoDB change stream. 2019-05-29 14:36:14 -07:00
Ylian Saint-Hilaire 162de5153b Added MongoDbChangeStream option. 2019-05-28 17:42:11 -07:00
Ylian Saint-Hilaire 8416b0a0aa Added MongoDB change stream support. 2019-05-28 17:25:23 -07:00
Ylian Saint-Hilaire 35ed079889 Updated MeshCentral Router. 2019-05-24 10:33:40 -07:00
Ylian Saint-Hilaire 880ca46a19 Fixed CIRA connection problem. 2019-05-23 09:39:36 -07:00
Ylian Saint-Hilaire c9adc4d6e6 Added support for auto-backup path. 2019-05-22 15:22:10 -07:00
Ylian Saint-Hilaire 084a6bab57 Database fixes for new MongoDB driver. 2019-05-20 18:03:14 -07:00
Ylian Saint-Hilaire 96a65a6c3e Error counters in MyServer panel, Autobackup now default, new console msg support. 2019-05-20 16:00:33 -07:00
Ylian Saint-Hilaire 576b079545 Fixed unlink() in auto-backup. 2019-05-17 15:50:09 -07:00
Ylian Saint-Hilaire c02fe3ca03 Improved auto-backup, missing modules recovery. 2019-05-17 15:44:01 -07:00
Ylian Saint-Hilaire c25658f5f0 Added encrypted auto-backup support. 2019-05-17 12:40:15 -07:00
Ylian Saint-Hilaire f9862c6cf2 improved MongoDB driver support, fixed Linux install with multi-domain. 2019-05-09 13:41:14 -07:00
Ylian Saint-Hilaire f01b4f7ee0 Started work on using the official MongoDB module. 2019-05-08 18:14:30 -07:00
Bryan Roe f2207ec3ed removed debug message 2019-04-12 11:46:10 -07:00
Bryan Roe 041ab287a2 1. Updated Diagnostic Registration to escape NodeID
2. Added helper method to db.js to escape base64
3. Updated db.Get to support optional paramter passing
2019-04-12 11:28:57 -07:00
Ylian Saint-Hilaire 0b12b8c03a Improved charts, added no2factorauth switch 2019-03-26 14:11:51 -07:00
Ylian Saint-Hilaire d11210a8c8 Fixed site minification. 2019-03-26 00:14:45 -07:00
Ylian Saint-Hilaire 3c2fd023bf Added server data collection and charting. 2019-03-25 19:59:04 -07:00
Ylian Saint-Hilaire 30eedab177 Server fixes & MongoDB performance improvements. 2019-02-26 14:39:45 -08:00
Ylian Saint-Hilaire 282d5474cd Split SMBIOS information into seperate collection. 2019-02-25 11:13:13 -08:00
Ylian Saint-Hilaire 7b475d57fc DB performance fixes. 2019-02-20 15:26:27 -08:00