QMYSQL driver not loaded - cross compiling for Raspberry PI 3

JarekT · 7 Jul 2020, 14:53

@KroMignon I did cross-compile according to this procedure: LINK

KroMignon · J JarekT 7 Jul 2020, 14:44

This post is deleted!

KroMignon · 7 Jul 2020, 15:10

@JarekT So you have to add mysql libs on your RPI before creating the sysroot

on RPI

sudo apt-get install libmysqlclient-dev libmysqld-dev

After that you should be able to cross-compile the plugin

JarekT · 7 Jul 2020, 15:13

@KroMignon When I tried to install those packages I got information that mariadb counterparts are available. So I tried to install them and it appeared that libmariadb-dev-compat,libmariadb-dev I already had, but libmariadbd-dev I didn't have so I installed it.

How can I cross-compile the plugin?

KroMignon · 8 Jul 2020, 04:30

@JarekT said in QMYSQL driver not loaded - cross compiling for Raspberry PI 3:

How can I cross-compile the plugin?

After installing the missed packages, you have to recreate/update the sysroot.
Then restart qmake in the sqldrivers directory (I suppose RPI sysroot is located at /home/embsys/raspi/sysroot):

/home/embsys/raspi/qtbase/bin/qmake -- MYSQL_PREFIX=/home/embsys/raspi/sysroot/usr/local

make
make install

jsulm · wrote on 8 Jul 2020, 04:30

@KroMignon said in QMYSQL driver not loaded - cross compiling for Raspberry PI 3:

Then restart qmake in the sqldrivers directory

I would suggest to do out of source builds to avoid problems with build artefacts from previous builds.

JarekT · 8 Jul 2020, 06:58

@KroMignon said in QMYSQL driver not loaded - cross compiling for Raspberry PI 3:

you have to recreate/update the sysroot

In the ~/raspi folder I did this (192.168.0.100 is IP of RPi):
rsync -avz pi@192.168.0.100:/lib sysroot
rsync -avz pi@192.168.0.100:/usr/include sysroot/usr
rsync -avz pi@192.168.0.100:/usr/lib sysroot/usr
rsync -avz pi@192.168.0.100:/opt/vc sysroot/opt

Is this what you meant by "you have to recreate/update the sysroot"?

After that I did qmake and I got the following results:

Unfortunately I don't see that MySql was configured...

Is the prefix "MYSQL_PREFIX=/home/embsys/raspi/sysroot/usr/local" correct and is it enough?

@jsulm Before I did qmake I deleted whole src folder and extracted it again. Only then I did qmake. Is this what you meant?

KroMignon · 8 Jul 2020, 08:06

@JarekT said in QMYSQL driver not loaded - cross compiling for Raspberry PI 3:

Is the prefix "MYSQL_PREFIX=/home/embsys/raspi/sysroot/usr/local" correct and is it enough?

I don't really know, I don't have a RPI to test it.
But according to this post ==> https://raspberrypi.stackexchange.com/a/101366
You should probably use this:

/home/embsys/raspi/qtbase/bin/qmake -- MYSQL_PREFIX=/home/embsys/raspi/sysroot/usr/lib/arm-linux-gnueabihf

JarekT · 8 Jul 2020, 08:09

@KroMignon I've changed the prefix but looks like it didn't help..

What can I do "remove any leftovers from the previous build" before I do reconfiguration?

jsulm · 8 Jul 2020, 08:45

@JarekT said in QMYSQL driver not loaded - cross compiling for Raspberry PI 3:

What can I do "remove any leftovers from the previous build" before I do reconfiguration?

Extract again the source code. To avoid this do out of source builds:

mkdir build
cd build
qmake PATH_TO_SOURCE

JarekT · 8 Jul 2020, 09:04

@jsulm I've extracted again the sources. But I'm not sure if I understand what you meant by: "To avoid this do out of source builds". Do you mean that after I have newly extracted source code, I should always do the qmake in a new folder (eg. "build" as you mentioned) so that I do not affect the source code and in this way I can always do fresh compilation without the need to extract the source code files again?

Assuming that this is what you meant I did this:

As I can see mysql was not compiled... Could you please check if the paths and prefixes are correct?...

jsulm · 8 Jul 2020, 10:00

@JarekT said in QMYSQL driver not loaded - cross compiling for Raspberry PI 3:

I should always do the qmake in a new folder

Yes.

To check why it still does not work please see what is in configure.log file.

JarekT · 7 Aug 2020, 10:02

@jsulm Here is what I have in the config.log (I'm showing here only the part that contains information about the failures)

Could you please help me understand those problems?

KroMignon · 8 Jul 2020, 10:23

@JarekT said in QMYSQL driver not loaded - cross compiling for Raspberry PI 3:

Could you please help me understand those problems?

Can you says which is the local path where you have put the sysroot? I supposed it was /home/embsys/raspi/sysroot.
Then search in this path where is located libmysqlclient with find:

find /home/embsys/raspi/sysroot -name libmysqlclient*.*

Then use the path to configure/compile your plugin:

/home/embsys/raspi/qtbase/bin/qmake -- MYSQL_PREFIX=<lib_mysqlclient_path>

JarekT · wrote on 8 Jul 2020, 10:23

@KroMignon said in QMYSQL driver not loaded - cross compiling for Raspberry PI 3:

Can you says which is the local path where you have put the sysroot? I supposed it was /home/embsys/raspi/sysroot.

Yes, this is my sysroot. I did it as you can see below

This command I tried also before and the results are unsuccessful as before..
Here I'm configuring/compiling the plugin using sqldriver.pro file, but I also read somewhere that mysql.pro (/home/embsys/raspi/qt-everywhere-src-5.12.3/qtbase/src/plugins/sqldrivers/mysql/mysql.pro) file should compiled. Do you know anything about it?

JarekT · 7 Aug 2020, 11:04

Another idea: shouldn't I configure qmake itself before I try to use it to compile the plugin?

That was my configure command when I was doing cross-compiling configuration (as in the LINK)

./configure -release -opengl es2 -device linux-rasp-pi3-g++ -device-option CROSS_COMPILE=~/raspi/tools/arm-bcm2708/gcc-linaro-arm-linux-gnueabihf-raspbian-x64/bin/arm-linux-gnueabihf- -sysroot ~/raspi/sysroot -opensource -confirm-license -make libs -prefix /usr/local/qt5pi -extprefix ~/raspi/qt5pi -hostprefix ~/raspi/qt5 -no-use-gold-linker -v -no-gbm

The above doesn't include mysql feature (should it??)

jsulm · 8 Jul 2020, 11:09

@JarekT said in QMYSQL driver not loaded - cross compiling for Raspberry PI 3:

shouldn't I configure qmake itself

What do you want to configure?

JarekT · 8 Jul 2020, 11:12

@jsulm Sorry if the way I explained it was not correct. I meant that when I was preparing the framework for cross-compilation in the folder /home/embsys/raspi/qtbase I did

./configure -release -opengl es2 -device linux-rasp-pi3-g++ -device-option CROSS_COMPILE=~/raspi/tools/arm-bcm2708/gcc-linaro-arm-linux-gnueabihf-raspbian-x64/bin/arm-linux-gnueabihf- -sysroot ~/raspi/sysroot -opensource -confirm-license -make libs -prefix /usr/local/qt5pi -extprefix ~/raspi/qt5pi -hostprefix ~/raspi/qt5 -no-use-gold-linker -v -no-gbm

Should it contain something about mysql?

jsulm · 8 Jul 2020, 11:21

@JarekT said in QMYSQL driver not loaded - cross compiling for Raspberry PI 3:

Should it contain something about mysql?

It should be possible to build MySQL related stuff after compiling Qt.

Did you search for libmysqlclient* as @KroMignon suggested to make sure you pass correct paths?

Also, please post text instead of screen-shots.

JarekT · 10 Jul 2020, 16:27

@jsulm said in QMYSQL driver not loaded - cross compiling for Raspberry PI 3:

Did you search for libmysqlclient* as @KroMignon suggested to make sure you pass correct paths?

Yes, the paths for libmysqlclient.. is correct.

embsys@JT-UBUNTU:~/qmakeBuild$ find /home/embsys/raspi/sysroot -name libmysqlclient*.*
/home/embsys/raspi/sysroot/usr/lib/arm-linux-gnueabihf/libmysqlclient.a
/home/embsys/raspi/sysroot/usr/lib/arm-linux-gnueabihf/libmysqlclient_r.so
/home/embsys/raspi/sysroot/usr/lib/arm-linux-gnueabihf/libmysqlclient.so
/home/embsys/raspi/sysroot/usr/lib/arm-linux-gnueabihf/libmysqlclient_r.a

Ok, I will try to post text instead of screen-shots.