3. Custom Databases
While all data saved in these databases is encrypted where necessary, please make sure that user accounts, user privileges, backup, etc. are properly configured in the database. Just because the data is encrypted, an unauthorized user can still delete it.
Any database configuration changes will result in Krptn assuming that all data has been migrated to the new database and is ready to use.
Please set these strings at:
1krypton.configs.SQLDefaultCryptoDBpath = # for DB used by Crypto Class 2krypton.configs.SQLDefaultKeyDBpath = # for DB used by Key Management System (you most likely don't need this) 3krypton.configs.SQLDefaultUserDBpath = # for DB used by User Authentication System
3.1. Microsoft SQL Server
The string that you need to pass to this extension should look like this:
1"mssql+pyodbc://user:password@host:port/dbname?driver=odbc driver e.g:ODBC+Driver+18+for+SQL+Server"
If you are only doing development, you may add the following to prevent installing an SSL certificate:
To use windows authentication, please remove
user:password from the string.
Please install mysqlclient.
Please install psycopg2.