search

chris2511 / xca

X Certificate and Key management
http://xca.hohnstaedt.de
Other
1.5k stars 202 forks source link

No available SQL option #555

Closed SteveBredebach closed 4 months ago

SteveBredebach commented 4 months ago

I downloaded and installed the 2.6.0 Version of xca, we use a SQL database for the certificates. I added the MinGW compiled .dll files and added them in the application directory of xca. But if i try to open a network database, there is still only the ODBC option visible. Did i miss something? I already tried an older version of the driver, but xca crashes instantly with them... So i know it must be loading the SQL drivers.

grafik

chris2511 commented 4 months ago

There are 2 required drivers 1) qsqlmysql.dll placed in the sqldrivers subdirectory, written by QT, connecting the QT-SQL interface to the MySQL C-Functions 2) libmysql.dll placed in the application directory of xca (or any other standard DLL location), written by Oracle/mysql, implementing the MySQL C-Functions to talk to the mysql server via network or socket

Please see https://github.com/thecodemonkey86/qt_mysql_driver?tab=readme-ov-file#deployment

Once the qsqlmysql.dll is available in the sqldrivers directory, it should be selectable in the XCA GUI. If the libmysql.dll is not available, XCA will show the error "Driver not loaded"

SteveBredebach commented 4 months ago

Thanks for your answer!

grafik This is my sqldrivers-folder with the qsqlmysql.dll

grafik This is my application folder.

As you can see, both dlls are available, but neither i am getting the "Driver not loaded" error or the SQL option in the dropdown.