How to add QMySQL driver for Raspberry Pi?

SGaist · 10 Oct 2016, 00:33

Seems like you didn't install the MySQL client libraries on your RPi3.

If you can't find the mysql.pro file it's likely that you didn't download Qt's sources.

JamesDin · 10 Oct 2016, 04:54

I installed MySQL client libraried on my RPI3. libmysqlclient.so file could be found.
And I didn't download Qt sources like you said.
Because I thought that the MySQL driver for RPI would be made by cross-compilation.
(MySQL driver for RPI is built on linux machine and is transferd into RPI.)
Should I have both Qt source and MySQL client libraries in RPI3 and follow above instructions for building driver?

SGaist · 11 Oct 2016, 00:44

My bad, I forgot you cross-compiled so you already should have the sources for that.

If the MySQL dev package wasn't installed when cross-compiling Qt, then the driver won't be built. You can however follow the documentation by using the qmake from your cross-compiled Qt and the path to the sysroot where the libraries/headers can be found.

JamesDin · S SGaist 10 Oct 2016, 07:15

@SGaist

I solved the problem. Thank you very much!!! :D

SGaist · 11 Oct 2016, 08:24

You're welcome !

What was the problem in the end ?

JamesDin · 6 Jun 2017, 07:33

@SGaist

I did 'qmake' that was created by cross-compilation as your guide.
After that, compiled MySQL driver was copied into mounted RPI image.
My mistake is that I understood instruction is need to be done on RPI.

SGaist · wrote on 11 Oct 2016, 11:23

Cross-compilation is a tricky subject.

Happy coding ! :)

andquesada · 6 Jun 2017, 07:34

@JamesDin

Hi!

So I followed the instructions here to cross-build a MySql driver. I have the same environment as you but I get this error:
Project ERROR: Library 'mysql' is not defined.

I am using Ubuntu Mate on my Raspberry Pi 3.

mysql_config --include says -I/usr/include/mysql
mysql_config --libs says -L/usr/lib/arm-linux-gnueabihf -lmysqlclient -lpthread -lz -lm -lrt -ldl

So the line to compile I am using is:
${CROSS_BUILT_QMAKE}/./qmake "INCLUDEPATH+=${SYSROOT}/usr/include/mysql" "LIBS+=-L${SYSROOT}/usr/lib/arm-linux-gnueabihf -lmysqlclient_r" mysql.pro

Any help would be appretiated.

Thank you!

Hervinsen · wrote on 25 Jun 2017, 11:22

@SGaist
Hello, I am new in Qt programming, I have the same situation as sir @andquesada . When i want to qmake the sql driver, the output is : Project ERROR: Library 'mysql' is not defined.

Hope that you can help us. Thx

SGaist · wrote on 25 Jun 2017, 21:33

Which version of Qt are you trying to build ?