remote database xca 2.0.0-pre03

[dknubben]

If I try to open a remote connection to a MySQL database with xca 2.0.0-pre03 (Windows) this results in error "driver not loaded", perhaps of not loaded qsqlmysql.dll? No problem under linux (same version build from sources)

[chris2511]

I've also been investigating this issue, but no success, yet.
qsqlmysql.dll is in the sqldrivers subdirectory. If you remove it, it is not selectable anymore in the dropdown.
The qsqlmysql.dll itself seems to depend on the mysql client library. I tried to install the client libs from the mysql page, but no success.

[dknubben]

I have no QT build environment for windows. Can I start xca with a debug/verbose switch from command line? If qsqlmysql.dll builds fine, it should be linked proper to the qt mysql libs, I guess. For Linux, libqsqlmysql.so is of course linked to libmysqlclient.so.18 or similar. This is perhaps the problem, if the mysqllib for windows has a wrong version or wrong path.

Independently of that: Thanks a lot for your work!

[chris2511]

Hi, Actually I don't build the QT libs and plugins but use the binaries (dll) from the Qt5 SDK for windows as i use the debian packages on linux. On windows the actual mysql client dll must be installed additionally, me thinks.... On linux I'd use ldd to check the runtime dependencies of qsqlmysql.so. Maybe windows has a similar tool. I tried to download and install the mysql client for windows and put the libmysql.dll into the XCA directory. But that was only a wild unsuccessful guess.... Cheers Christian Am 19. März 2018 22:26:19 MEZ schrieb dknubben <notifications@github.com>:

…

I have no QT build environment for windows. Can I start xca with a debug/verbose switch from command line? If qsqlmysql.dll builds fine, it should be linked proper to the qt mysql libs, I guess. For Linux, libqsqlmysql.so is of course linked to libmysqlclient.so.18 or similar. This is perhaps the problem, if the mysqllib for windows has a wrong version or wrong path. Besides that: Thanks a lot for your work! -- You are receiving this because you commented. Reply to this email directly or view it on GitHub: #11 (comment)

-- Diese Nachricht wurde von meinem Android-Gerät mit K-9 Mail gesendet.

[chris2511]

You need the 32bit libmysql.dll from the mysql connector mysql-connector-c-6.1.11-win32.msi package
copied into the XCA installation directory. I put both into the download section:
https://hohnstaedt.de/downloads/

[dknubben]

Yes, thank you. Now the connection to the remote database is working. But only with read access. It's not possible to insert new items.

[chris2511]

I have the same problem with mysql. This is most probably a version missmatch, which results in not supporting transactions. The libmysql.dll is version 6.1.1, while my server has version 5.3. See https://forum.qt.io/topic/58848/qmysql-transaction-support/6

In case of no transaction support, XCA will warn the user and continue without transactions.

[chris2511]

I tried the mariaDB-10 driver from https://downloads.mariadb.org/interstitial/mariadb-10.2.13/win32-packages/mariadb-10.2.13-win32.msi/from/http%3A//ftp.hosteurope.de/mirror/mariadb.org/?serve
renamed libmariadb.dll to libmysql.dll and copied it to the XCA directory and voilà it works.

This driver will be part of the next XCA pre version. You may try it now with
https://hohnstaedt.de/downloads/libmysql.dll (signed by the mariadb corp.)

[dknubben]

Fast response, thanks!
Yes, it's working now (MySQL 5.5). Your version 2.0 is going in the right direction, very useful new features.