Simplest way to install Qt in Ubuntu (19.10) with MySQL driver?

[jsulm]

@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?

[JonB]

@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-get for 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]

@JonB Did you use Qt provided by the distribution?

[enne9]

@SGaist Thanks, I uninstalled everything using the maintenance tool and then reinstalled again using, as usual, the offline installer.
I run ./configure -sql-mysql as first command and finally there was "yes" near "MySql" and the process ended well.

In the previous attempt I had already run ./configure before ./configure -sql-mysql without cleaning, was that the problem in your opinion?

[JonB]

@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]

@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]

@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]

@jsulm

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 the libqtmysql stuff as supplied with distro via apt-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?

[jsulm]

@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]

@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.

[enne9]

The make compilation completed successfully but make install terminates with the error

g++: error: /home/enrico/Qt5.14.1/5.14.1/Src/qtvirtualkeyboard/lib/libqtopenwnn.a: No such file or directory

Any idea?

[enne9]

I have just noticed that I have used make instead of qmake. Is that the problem?

Should I repeat the whole process using qmake and, if this is the case, should I clean run a make clean before?
Thanks

An update: now the error is

Error copying ../../../lib/libQt5Bootstrap.a to /usr/local/Qt-5.14.1/lib/libQt5Bootstrap.a: Destination file exists

[jsulm]

@enne9 Did you run qmake before make?
The sequence is:

• qmake
• make
• make install

[enne9]

I used

./configure -sql-mysql
make
make install

How can I proceed now? Do I need to clean (using which commands?) and do the operations in the order you listed?

[jsulm]

@enne9 As @SGaist already suggested do out of source builds, this way you will have less troubles.
Use "make clean" to clean up.

[enne9]

Isn't qmake included in ./configure -sql-mysql? I just run it and the output is the same.

[SGaist]

It's the first thing that gets built however, you are currently making things more complicated than necessary. You should just build the plugin using your already installed Qt rather than the full thing.