Comments (8)
chris2511
commented on August 19, 2024
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.
from xca.
dknubben
commented on August 19, 2024
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!
from xca.
chris2511
commented on August 19, 2024
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 <[email protected]>:
…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.
from xca.
chris2511
commented on August 19, 2024
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/
from xca.
dknubben
commented on August 19, 2024
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.
from xca.
chris2511
commented on August 19, 2024
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.
from xca.
chris2511
commented on August 19, 2024
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.)
from xca.
dknubben
commented on August 19, 2024
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.
from xca.
Related Issues (20)
- permanent processor load / stucked instances as background process HOT 2
- Docker image HOT 1
- Problems exporting PKCS#12 HOT 1
- Exporting private keys with MacOS doesn't work HOT 9
- XCA cannot properly access a YubiHSM2 (login issues maybe) HOT 8
- New XCA v2.6.0 - It's not in English HOT 10
- XCA version 2.6.0 very slow (Win 10) HOT 1
- XCA 2.5.0 & 2.6.0 very slow HOT 12
- pfx certificate cannot be imported in ios and macos: incorrect password
- XCA 2.6 on macOS - mySQL ODBC issue HOT 3
- What's wrong with hohnstaedt.de HOT 1
- XCA 2.6.0 gui language bug under macOS HOT 8
- Can't connect remote database
- export certificate: error using child folder
- Disorder in displaying Persian words that are links HOT 5
- Error in compiling code in linux HOT 2
- issues with icons in gnome dock
- Missing option to disable file association in Windows setup
- No available SQL option HOT 2
- Implement full command-line support for XCA HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from xca.