Commit Graph

23 Commits

Author SHA1 Message Date
Christian Hohnstaedt
45253fae99 Close #516, #502: XCA remote database documentation
Create/copy from README.md documentation about remote databases.
Add Help button to Remote database dialog.

Extend documentation in the Windows msi installer
2024-02-25 01:05:24 +01:00
Christian Hohnstaedt
5cdd1e134c Improve database plugin detection
Drivers that fail with "Driver not loaded"
are skipped silently.
2023-09-15 21:45:08 +02:00
Christian Hohnstaedt
5f5ed2f22b Remote database names lost their numbers in recent Qt 2023-05-25 21:24:41 +02:00
Christian Hohnstaedt
2621d20d22 make dbhistory independent of GUI widget OpenDb
the "lastRemote" database is not GUI specific and
has been moved from "OpenDb" to the non-gui class dbhistory,
which in turn becomes independent of OpenDb
2021-06-01 17:48:37 +02:00
Christian Hohnstädt
e4f9dd6389 Fix opening new database, while another one is open
Avoid crashes by checking for model being set.
Thoroughly close previous database before opening a new one.
Drop changeDB() function and replace by init_database.
2020-10-14 22:02:48 +02:00
Christian Hohnstaedt
ef9b3aff3d Drop superflous includes from header files 2020-03-13 12:13:27 +01:00
Christian Hohnstaedt
176c2f8169 Improve password input and handling
Use the Passwd class instead of QString

Move password input into the database model
to be available for commandline use.

Repeat in case of wrong password
2020-03-11 07:19:56 +01:00
Christian Hohnstaedt
113a201d39 Separate database from Mainwin for better cmdline support
New classes:
 - database_model: Manage the database tables (keys, req, cert, crl, templ)
   extracted from widgets/MW_database.cpp
 - arguments: parse commandline, dynamically create help text
2020-03-11 07:19:56 +01:00
Christian Hohnstaedt
63f2ae11a0 Constify OpenDB Strings 2020-02-12 22:43:33 +01:00
Christian Hohnstaedt
953d26c419 Close #21 Support for ODBC (MSSQL)
Add ODBC QSQL Database driver

Column "public" in public_keys table is a keyword in
MSSQL. Double quote it.
Double quotes are invalid on MySQL in non-ANSI mode.
Force ANSI mode for MySQL/MariaDB databases.

MSSQL also has a maximum VARCHAR of 8000

Schema updates are not performed for each new database.
New databases are immediately created conforming to schema:7
Schema 5 and 6 get updated to 7.
Schemas < 5 never have been released officially. (pre 2.0.0)

Switch "Database name" label to "DSN" for ODBC databases.
2020-01-13 07:24:08 +01:00
Christian Hohnstaedt
b928f2510c Close #119: Rename "PostgreSQL 6 and 7" to just "PostgreSQL"
... in Remote Database dialoge

While at it, also improve the MySQL driver name
to "MySQL / MariaDB"
2019-05-13 17:12:12 +02:00
Christian Hohnstaedt
b32e974449 Fix duplicate entries in remote database type selection 2018-06-25 21:20:25 +02:00
Christian Hohnstaedt
4821a181e9 Issue #20: Unable to chose database type
Always fill database select box, even if no previous
remote database connection known.
2018-04-18 10:06:46 +02:00
Christian Hohnstaedt
c67a0471ce Usability: Preset remote database input values with previous ones 2018-03-23 06:00:45 +01:00
Christian Hohnstaedt
e3349aefb0 Accept driver that don't support transactions
Improve report of transaction errors.
2018-03-22 20:26:22 +01:00
Christian Hohnstaedt
64c9c5ccab Add table prefix to be prepended to each table
This allows multiple independent xca databases in one database
2018-03-19 06:14:06 +01:00
Christian Hohnstaedt
6e432238e7 Generalize, simplify and unify settings management
Add settings class to access the settings table in the database
Cache values and improve database writes.
Options dialog simplified
Replace getSetting / storeSetting
Unpack option flags to rows in the settings
2018-03-10 09:04:54 +01:00
Christian Hohnstaedt
f1cf3aeab1 Improve database opening 2018-03-06 11:51:26 +01:00
Christian Hohnstaedt
79d6aa0b10 Improve message boxes. Always display plain text
And show a message if a database connection failed.
2018-03-05 19:47:05 +01:00
Christian Hohnstaedt
84e4301f6d Tell the user if the SqLite driver is missing 2018-03-05 07:46:10 +01:00
Christian Hohnstaedt
a3900b1473 Several fixes for templates, key encryption etc. 2018-03-05 07:46:10 +01:00
Christian Hohnstaedt
3af9094a43 Improve database opening
Don't ask for network parameters when opening a SqLite DB

Don't offer opening a remote database
when no appropriate drivers available
2018-03-05 07:46:10 +01:00
Christian Hohnstaedt
fc7fc357ac Support opening remote databases MySQL and PostgreSQL 2018-03-05 07:46:10 +01:00