Simplest way to install Qt in Ubuntu (19.10) with MySQL driver?
-
@enne9 As far as I know you need to build MySQL plug-in by yourself (because of legal reasons).
Install the libmysql-dev package and check https://doc.qt.io/qt-5/sql-driver.html for instructions how to build.@jsulm This is part of the output when I just run
./configure. Why is there no "yes" near "MySql"?
If I run
./configure -sql-mysqlit shows
ERROR: Feature 'sql-mysql' was enabled, but the pre-condition 'libs.mysql' failed.
What am I doing wrong?I also noted that there was already a file
/usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.soand I copied it in~/Qt5.14.1/5.14.1/gcc_64/plugins/sqldriversbut it says:
Cannot mix incompatible Qt library (version 0x50c04) with this library (version 0x50e01)
How can I get the compatible version? -
@enne9 Please check the configure log and read once more what I wrote before: "Install the libmysql-dev package".
And please do not push for answers - people here are volunteers spending their own time to help...@jsulm there is no
libmysql-devpackage, I instead installedlibmysqlclient-dev.
The error I am getting is stillERROR: Feature 'sql-mysql' was enabled, but the pre-condition 'libs.mysql' failed.Sorry, I wasn't pushing and I am sorry if it seemed so.
-
Did you re-run configure from a clean state ? If not, as suggested in the summary, you should clean the sources if you called configure it.
Better yet, do an out of source build so that you can just nuke the build folder to restart fresh.
If it is still failing, then check the test logs to see exactly why the detection failed.
-
@jsulm there is no
libmysql-devpackage, I instead installedlibmysqlclient-dev.
The error I am getting is stillERROR: Feature 'sql-mysql' was enabled, but the pre-condition 'libs.mysql' failed.Sorry, I wasn't pushing and I am sorry if it seemed so.
@enne9 said in Simplest way to install Qt in Ubuntu (19.10) with MySQL driver?:
libmysqlclient-dev
This one should be the correct one.
Did you check config.log to see whether there are more specific errors regarding MySQL plug-in? -
@enne9 As far as I know you need to build MySQL plug-in by yourself (because of legal reasons).
Install the libmysql-dev package and check https://doc.qt.io/qt-5/sql-driver.html for instructions how to build.@jsulm said in Simplest way to install Qt in Ubuntu (19.10) with MySQL driver?:
@enne9 As far as I know you need to build MySQL plug-in by yourself (because of legal reasons).
Install the libmysql-dev package and check https://doc.qt.io/qt-5/sql-driver.html for instructions how to build.Just for clarification: I have used Qt & MySQL up to Ubuntu 19.04. I have only ever had to use
apt-getfor packages, I have never had to compile/build/configure Qt or anything MySQL. Did the change requiring needing to build MySQL plug-in come in at 19.10? -
@jsulm said in Simplest way to install Qt in Ubuntu (19.10) with MySQL driver?:
@enne9 As far as I know you need to build MySQL plug-in by yourself (because of legal reasons).
Install the libmysql-dev package and check https://doc.qt.io/qt-5/sql-driver.html for instructions how to build.Just for clarification: I have used Qt & MySQL up to Ubuntu 19.04. I have only ever had to use
apt-getfor packages, I have never had to compile/build/configure Qt or anything MySQL. Did the change requiring needing to build MySQL plug-in come in at 19.10?@JonB Did you use Qt provided by the distribution?
-
Did you re-run configure from a clean state ? If not, as suggested in the summary, you should clean the sources if you called configure it.
Better yet, do an out of source build so that you can just nuke the build folder to restart fresh.
If it is still failing, then check the test logs to see exactly why the detection failed.
@SGaist Thanks, I uninstalled everything using the maintenance tool and then reinstalled again using, as usual, the offline installer.
I run./configure -sql-mysqlas first command and finally there was "yes" near "MySql" and the process ended well.In the previous attempt I had already run
./configurebefore./configure -sql-mysqlwithout cleaning, was that the problem in your opinion? -
@jsulm said in Simplest way to install Qt in Ubuntu (19.10) with MySQL driver?:
@JonB Did you use Qt provided by the distribution?
Yes, absolutely, the Qt 5.12.2 which came with Ubuntu 19.04 was adequate for me. I didn't see anything in OP's question which said he had built Qt for himself. Given that, I have never had to build/configure Qt, any the libraries to hook Qt to MySQL also come from
apt-get. Hence why I was asking whether that will have changed at 19.10? Because if so I shall not be moving off 19.04 till I have to, hence my question.... -
@SGaist Thanks, I uninstalled everything using the maintenance tool and then reinstalled again using, as usual, the offline installer.
I run./configure -sql-mysqlas first command and finally there was "yes" near "MySql" and the process ended well.In the previous attempt I had already run
./configurebefore./configure -sql-mysqlwithout cleaning, was that the problem in your opinion?@enne9 said in Simplest way to install Qt in Ubuntu (19.10) with MySQL driver?:
In the previous attempt I had already run ./configure before ./configure -sql-mysql without cleaning, was that the problem in your opinion?
Yes, as suggested in the summary message, if you changed something like adding a new dependency library and re-run configure, you have to clean before calling configure again.
But as I already wrote, out of source builds are way simpler to handle that kind use case. You keep the sources clean and can nuke easily the faulty build/configure to start anew.
-
@jsulm said in Simplest way to install Qt in Ubuntu (19.10) with MySQL driver?:
@JonB Did you use Qt provided by the distribution?
Yes, absolutely, the Qt 5.12.2 which came with Ubuntu 19.04 was adequate for me. I didn't see anything in OP's question which said he had built Qt for himself. Given that, I have never had to build/configure Qt, any the libraries to hook Qt to MySQL also come from
apt-get. Hence why I was asking whether that will have changed at 19.10? Because if so I shall not be moving off 19.04 till I have to, hence my question....@JonB said in Simplest way to install Qt in Ubuntu (19.10) with MySQL driver?:
he had built Qt for himself
It applies to Qt installed via installer as well
-
@JonB said in Simplest way to install Qt in Ubuntu (19.10) with MySQL driver?:
he had built Qt for himself
It applies to Qt installed via installer as well
It applies to Qt installed via installer as well
Hmm, I've never done that. Only ever
apt-get. I hope I'm not hijacking (tell me if I am), but let's put it this way: if I move to a newer Ubuntu, and I want the Qt and thelibqtmysqlstuff as supplied with distro viaapt-get, can I still do that (absolutely no compiling/building/configuring of either), or at 19.10+ has something been removed which means it won't work any longer? -
It applies to Qt installed via installer as well
Hmm, I've never done that. Only ever
apt-get. I hope I'm not hijacking (tell me if I am), but let's put it this way: if I move to a newer Ubuntu, and I want the Qt and thelibqtmysqlstuff as supplied with distro viaapt-get, can I still do that (absolutely no compiling/building/configuring of either), or at 19.10+ has something been removed which means it won't work any longer?@JonB said in Simplest way to install Qt in Ubuntu (19.10) with MySQL driver?:
can I still do that
Yes, the prebuild Qt provided by Ubuntu should have everything you need (but I did not yet use any of 19.x Ubuntu).
-
@JonB said in Simplest way to install Qt in Ubuntu (19.10) with MySQL driver?:
can I still do that
Yes, the prebuild Qt provided by Ubuntu should have everything you need (but I did not yet use any of 19.x Ubuntu).
@jsulm
That's great. Then at least the OP knows that if he is happy with the Qt version in the 19.10 distro has has the option of doing it all with no compiling etc. Having said that, his latest may imply he is now progressing OK with what he has, which is equally fine. -
I have just noticed that I have used
makeinstead ofqmake. Is that the problem?Should I repeat the whole process using
qmakeand, if this is the case, should I clean run amake cleanbefore?
ThanksAn update: now the error is
Error copying ../../../lib/libQt5Bootstrap.a to /usr/local/Qt-5.14.1/lib/libQt5Bootstrap.a: Destination file exists -
I have just noticed that I have used
makeinstead ofqmake. Is that the problem?Should I repeat the whole process using
qmakeand, if this is the case, should I clean run amake cleanbefore?
ThanksAn update: now the error is
Error copying ../../../lib/libQt5Bootstrap.a to /usr/local/Qt-5.14.1/lib/libQt5Bootstrap.a: Destination file exists -
I used
./configure -sql-mysql make make installHow can I proceed now? Do I need to clean (using which commands?) and do the operations in the order you listed?
