Commit Graph

291 Commits

Author SHA1 Message Date
si458 4bcec73e07 forgot new lines in backupconfig
Signed-off-by: si458 <simonsmith5521@gmail.com>
2024-09-10 22:01:44 +01:00
si458 d81c00c0b0 add extra info to backupconfig
Signed-off-by: si458 <simonsmith5521@gmail.com>
2024-09-10 21:54:44 +01:00
Simon Smith ad1d82152a fix clonesafenode in dbNodeChange #5591
Signed-off-by: Simon Smith <simonsmith5521@gmail.com>
2024-09-05 15:39:45 +01:00
si458 21e196e35c dont do utf8 validation for mongodb #6340
Signed-off-by: si458 <simonsmith5521@gmail.com>
2024-08-24 00:12:14 +01:00
Simon Smith c1e3354c91 fix mysql autoback zippassword
Signed-off-by: Simon Smith <simonsmith5521@gmail.com>
2024-08-15 13:06:40 +01:00
si458 aae551dab9 autobackup improvements #6324
Signed-off-by: si458 <simonsmith5521@gmail.com>
2024-08-15 11:32:24 +01:00
Simon Smith adeaac1588 getLocalAmtNodes only show intelamt devices fix #6321
Signed-off-by: Simon Smith <simonsmith5521@gmail.com>
2024-08-13 18:55:59 +01:00
Simon Smith 77f44fc308 fix local amt with sqlite/mysql/postgres #6321
Signed-off-by: Simon Smith <simonsmith5521@gmail.com>
2024-08-13 17:46:37 +01:00
Ylian Saint-Hilaire fc29e60939 Improved configuration file encryption in the database, added testing. 2024-08-04 22:00:37 -07:00
Josiah Baldwin 5b76a31644
Changed database file encryption to pbkdf2 for key derivation and aes-256-gcm for encryption (#6296)
* Added pbkdf2 and aes-256-gcm options for database file encryption

* Added dbCipherAlgorithm option

* Changed pbkdf2 to default

Maintains backward compatibility, but will require a manual repush to update to the new version

* Removed dbkeyderivationiterations option, as this branch is to be more opinionated
2024-08-04 16:02:22 -07:00
Simon Smith 6da9222871
add s3 autobackup support (#6280)
Signed-off-by: si458 <simonsmith5521@gmail.com>
2024-07-29 14:41:36 +01:00
si458 7e504a28e6 fix autoRemoveInactiveDevices again #6268
Signed-off-by: si458 <simonsmith5521@gmail.com>
2024-07-23 17:28:36 +01:00
si458 9264b9d281 fix autoRemoveInactiveDevices is 1 #6268
Signed-off-by: si458 <simonsmith5521@gmail.com>
2024-07-23 15:58:13 +01:00
Simon Smith 410c84c30b
add --mysql --mariadb arguments for stateless run (#6031)
Signed-off-by: si458 <simonsmith5521@gmail.com>
2024-04-18 17:07:01 +01:00
Simon Smith 102489447d
check db exists first before creating in postgres (#5968)
Signed-off-by: si458 <simonsmith5521@gmail.com>
2024-03-31 19:20:15 +01:00
si458 7b67b992e2 fix postgres nedbtodb
Signed-off-by: si458 <simonsmith5521@gmail.com>
2024-03-31 13:52:16 +01:00
Simon Smith 95bbd7157f
add filter for events (#5975)
* add filter to node events
* add filter to my events
* add filter to user events
* improve sql querys

Signed-off-by: si458 <simonsmith5521@gmail.com>
2024-03-31 13:50:38 +01:00
jrf280 eadf6fbaf0
Fix plugins installation for PostgreSQL (#5517)
* Fix plugins installation for PostgreSQL

* Fix setPluginStatus for MySQL/MariaDB/SQLite/PostgreSQL
2023-11-07 09:17:24 -08:00
jrf280 6ba4bf7202
Fix plugins installation for MySQL/MariaDB/SQLite (#5513) 2023-11-06 19:01:42 +00:00
Simon Smith 5c99db9edb
fix postgres sqlbatch (#5514)
Signed-off-by: si458 <simonsmith5521@gmail.com>
2023-11-06 13:54:17 +00:00
Simon Smith 13ead1ddeb
fix mariadb parsing with mysql (#5488) 2023-10-31 12:11:17 -07:00
Simon Smith c6ebcc6e8e
fix sql batch must use same connection from pool (#5469)
Signed-off-by: si458 <simonsmith5521@gmail.com>
2023-10-24 19:28:29 +01:00
Simon Smith e20a585b3a
use mysql2 package to support mysql8 (#5427)
Signed-off-by: Simon Smith <simonsmith5521@gmail.com>
2023-10-20 17:30:57 -07:00
Simon Smith bca4f1c217
remove duplicate pendingTransfer++ 2023-09-15 14:41:41 +01:00
Simon Smith 53a96fb26b
fix-netodb-again 2023-09-15 14:38:17 +01:00
Ylian Saint-Hilaire a3dfc30607
Merge pull request #5330 from si458/fix-webdav-upload
Fix webdav upload
2023-09-09 23:02:04 -07:00
Simon Smith 23c2627b3b
fix nedb to sqlite migrate 2023-09-07 19:35:03 +01:00
Simon Smith 7ea744fdfe
use new nedb instead of old 2023-09-07 19:31:26 +01:00
Simon Smith f297857d70
fix-webdav-upload 2023-09-06 13:53:28 +01:00
Ylian Saint-Hilaire 79faaaee1f Fixed various server exceptions. 2022-12-10 12:02:33 -08:00
Ylian Saint-Hilaire cc7670cc31 Improved state-less server code (#4645) 2022-10-24 16:58:05 -07:00
Ewout Stortenbeker 6a31e3fc02 fix syntax 2022-09-17 00:04:53 +02:00
Ewout Stortenbeker 883f9ffd6e fast remove queries with new AceBase version 2022-09-16 22:50:12 +02:00
Ewout Stortenbeker c745a5e31e Fixes & improvements:
* use `.child` instead of string concats on paths
* remove unnecessary `limit(999999)` for queries with filters
* use `.get` instead of `.query` to get all data
* using `skip` and `limit` args of `GetAllTypeNoTypeFieldMeshFiltered`
* use `==` instead of `in` operator in `RemoveSMBIOS` and `GetSMBIOS`
* use `.count` insetad of `.get` in `getDbStats`
* use `.get` instead of `.query` in `getPlugins`, custom sort function
2022-09-16 22:38:40 +02:00
Ewout Stortenbeker 30753982ff Fix typos 2022-09-16 22:25:00 +02:00
Ylian Saint-Hilaire 8f89665421 PostgreSQL support will now test if main table exists and if not, create all tables and indexes (#4507) 2022-09-06 12:48:02 -07:00
Ylian Saint-Hilaire 43abf32dba MongoDB TextEncoder is not defined fix (#4499) 2022-09-05 01:40:43 -07:00
Ylian Saint-Hilaire 2eb8cbf2d6 Indicate proper error if auto-backup path is not correct (#4483) 2022-09-02 14:37:12 -07:00
Ylian Saint-Hilaire 26f134c95d Completed server-side device paging support. 2022-08-31 14:16:59 -07:00
Ylian Saint-Hilaire 15c882f24e Partial support for device paging support on the server side, allows a user to view only a subset of the devices. 2022-08-31 11:28:36 -07:00
Ylian Saint-Hilaire 0ce946bd90 Fix for MongoDB change stream exception (#4429) 2022-08-22 10:42:50 -07:00
Ylian Saint-Hilaire af1e5f52ca Removed debug code around running mongodump.exe. 2022-08-22 10:27:25 -07:00
Ylian Saint-Hilaire 57d37b7c8a Fixed server console dbstats command when using SQLite (#4430) 2022-08-22 10:19:24 -07:00
Ylian Saint-Hilaire 8c9067ed4a SQLite fixes and addition to config.json schema. 2022-08-15 16:28:06 -07:00
Ylian Saint-Hilaire fa33595700 Improved SQLite support (#4398) 2022-08-15 14:11:30 -07:00
Ylian Saint-Hilaire 1680138e8d First pass at adding SQLite3 database support (#4398) 2022-08-15 00:33:50 -07:00
Ylian Saint-Hilaire 0f3e1c2c3a Fix to AceBase insertMany() 2022-08-14 14:41:24 -07:00
Ylian Saint-Hilaire c9244a662f Boosted the speed of InsertMany() for AceBase. 2022-08-14 14:16:52 -07:00
Ylian Saint-Hilaire 0fd8b17f5e Added AceBase maintenance. AceBase record removal seems to be terribly slow. 2022-08-14 13:24:14 -07:00
Ylian Saint-Hilaire 670aeea10d Added AceBase indexes. 2022-08-14 12:09:09 -07:00