Comments (8)
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.
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.
from xca.
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.
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.
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.
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.
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.