QMYSQL driver not loaded on Ubuntu

artem1997262

Hello everybody! I get and installed Qt 5.9.2 x64 edition for Linux ubuntu.
I'm building a project from QT Creator examples: SQL Browser

I have QTPLUGIN += qsqlmysql and QT += sql in file .pro
Next:

$ ldd /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/libqsqlmysql.so
linux-vdso.so.1 (0x00007fffabbb6000)
libQt5Sql.so.5 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libQt5Sql.so.5 (0x00007f65f3e00000)
libQt5Core.so.5 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libQt5Core.so.5 (0x00007f65f3600000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f65f45ae000)
libmysqlclient.so.18 => /lib/x86_64-linux-gnu/libmysqlclient.so.18 (0x00007f65f3000000)
libstdc++.so.6 => /lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f65f2dd6000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f65f44c5000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f65f44a5000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f65f2bae000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f65f4489000)
libicui18n.so.56 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libicui18n.so.56 (0x00007f65f2600000)
libicuuc.so.56 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libicuuc.so.56 (0x00007f65f2200000)
libicudata.so.56 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libicudata.so.56 (0x00007f65f0800000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f65f4482000)
libgthread-2.0.so.0 => /lib/x86_64-linux-gnu/libgthread-2.0.so.0 (0x00007f65f447d000)
libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007f65f40c6000)
/lib64/ld-linux-x86-64.so.2 (0x00007f65f45cc000)
libssl.so.10 => not found
libcrypto.so.10 => not found
libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007f65f4050000)
3) I have installed the libraries: libssl 1.0.0
4) Created links:
cd /lib/x86_64-linux-gnu
sudo ln -s libssl.so.1.0.0 libssl.so.10
sudo ln -s libcrypto.so.1.0.0 libcrypto.so.10
5) *.so10 files are sometimes identified. This error always occurs in QT Creator when I want to connect to SQL:
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7
How to fix this error? Thank you.

JonB

@artem1997262
Start with

ls -lL /lib/x86_64-linux-gnu/libssl.so.10  /lib/x86_64-linux-gnu/libcrypto.so.10

?

If ldd still says not found it's not going to work....

artem1997262

@JonB said in QMYSQL driver not loaded on Ubuntu:

@artem1997262
Start with
ls -lL /lib/x86_64-linux-gnu/libssl.so.10  /lib/x86_64-linux-gnu/libcrypto.so.10 
?

If ldd still says not found it's not going to work....

everything remains the same...

root@user:/lib/x86_64-linux-gnu# ls -lL /lib/x86_64-linux-gnu/libssl.so.10 /lib/x86_64-linux-gnu/libcrypto.so.10
-rw-r--r-- 1 root root 2206128 дек 1 16:15 /lib/x86_64-linux-gnu/libcrypto.so.10
-rw-r--r-- 1 root root 461076 дек 1 16:16 /lib/x86_64-linux-gnu/libssl.so.10
root@user:/lib/x86_64-linux-gnu# ldd /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/libqsqlmysql.so
linux-vdso.so.1 (0x00007ffe06bc2000)
libQt5Sql.so.5 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libQt5Sql.so.5 (0x00007fa881e00000)
libQt5Core.so.5 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libQt5Core.so.5 (0x00007fa881600000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fa882436000)
libmysqlclient.so.18 => /lib/x86_64-linux-gnu/libmysqlclient.so.18 (0x00007fa881000000)
libstdc++.so.6 => /lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007fa880dd6000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fa882119000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007fa882414000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fa880bae000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007fa8820fd000)
libicui18n.so.56 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libicui18n.so.56 (0x00007fa880600000)
libicuuc.so.56 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libicuuc.so.56 (0x00007fa880200000)
libicudata.so.56 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libicudata.so.56 (0x00007fa87e800000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fa8820f6000)
libgthread-2.0.so.0 => /lib/x86_64-linux-gnu/libgthread-2.0.so.0 (0x00007fa8820f1000)
libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007fa87e6c6000)
/lib64/ld-linux-x86-64.so.2 (0x00007fa882454000)
libssl.so.10 => not found
libcrypto.so.10 => not found
libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007fa882079000)

JonB

@artem1997262 said in QMYSQL driver not loaded on Ubuntu:

libssl.so.10 => not found
libcrypto.so.10 => not found

I'm not sure, but ldd might report "not found" against a library file if it is its dependents which cannot be found. Try running ldd on these files directly and check the output?

artem1997262

@JonB

all file defines

artem@user:/lib/x86_64-linux-gnu$ ldd libcrypto.so.10
linux-gate.so.1 (0xf7f71000)
libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xf7d39000)
libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xf7d1b000)
libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xf7ae6000)
/lib/ld-linux.so.2 (0xf7f73000)
artem@user:/lib/x86_64-linux-gnu$ ldd libssl.so.10
linux-gate.so.1 (0xf7ee1000)
libcrypto.so.10 => /lib/x86_64-linux-gnu/libcrypto.so.10 (0xf7c3e000)
libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xf7c39000)
libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xf7c1b000)
libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xf79e6000)
/lib/ld-linux.so.2 (0xf7ee3000)
artem@user:/lib/x86_64-linux-gnu$

Christian Ehrlicher

@artem1997262 said in QMYSQL driver not loaded on Ubuntu:

artem@user:/lib/x86_64-linux-gnu$ ldd libcrypto.so.10
linux-gate.so.1 (0xf7f71000)
libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xf7d39000)

As you can see this links to 32bit libraries but

root@user:/lib/x86_64-linux-gnu# ldd /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/libqsqlmysql.so

This is a 64 bit library

Install the libraries for your 64 bit architecture.

artem1997262

@Christian-Ehrlicher
package name was 64 bit...
"libssl1.0.0_1.0.2n-1ubuntu5.10_amd64.deb"
which version should i download?

Christian Ehrlicher

@artem1997262 said in QMYSQL driver not loaded on Ubuntu:

which version should i download?

download? None - install via your normal package manager is the way to go.

artem1997262

@Christian-Ehrlicher

if I use this command, the terminal says that the latest version is installed. If I add something else in the name, the terminal says that the package was not found.

sudo apt-get install libssl1.0.0

Christian Ehrlicher

@artem1997262 I don't know much about ubuntu but you must tell apt-get to install the 64 bit version. See e.g. here - looks like they had a similar problem.

artem1997262

@Christian-Ehrlicher
I have reinstalled the packages. *.so10 was determined, but the errors did not go away. How do you get rid of them anyway?

root@user:/lib/x86_64-linux-gnu# ldd /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/libqsqlmysql.so
/home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/libqsqlmysql.so: /lib/x86_64-linux-gnu/libcrypto.so.10: version libcrypto.so.10' not found (required by /lib/x86_64-linux-gnu/libmysqlclient.so.18) /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/libqsqlmysql.so: /lib/x86_64-linux-gnu/libssl.so.10: version libssl.so.10' not found (required by /lib/x86_64-linux-gnu/libmysqlclient.so.18)
linux-vdso.so.1 (0x00007ffe4fdbf000)
libQt5Sql.so.5 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libQt5Sql.so.5 (0x00007ff22ee00000)
libQt5Core.so.5 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libQt5Core.so.5 (0x00007ff22e600000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007ff22f5ab000)
libmysqlclient.so.18 => /lib/x86_64-linux-gnu/libmysqlclient.so.18 (0x00007ff22e000000)
libstdc++.so.6 => /lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007ff22ddd6000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007ff22f4c2000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007ff22f4a2000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007ff22dbae000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007ff22f486000)
libicui18n.so.56 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libicui18n.so.56 (0x00007ff22d600000)
libicuuc.so.56 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libicuuc.so.56 (0x00007ff22d200000)
libicudata.so.56 => /home/artem/Qt5.9.2/5.9.2/gcc_64/plugins/sqldrivers/../../lib/libicudata.so.56 (0x00007ff22b800000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007ff22f47f000)
libgthread-2.0.so.0 => /lib/x86_64-linux-gnu/libgthread-2.0.so.0 (0x00007ff22f47a000)
libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007ff22f0c6000)
/lib64/ld-linux-x86-64.so.2 (0x00007ff22f5c9000)
libssl.so.10 => /lib/x86_64-linux-gnu/libssl.so.10 (0x00007ff22b400000)
libcrypto.so.10 => /lib/x86_64-linux-gnu/libcrypto.so.10 (0x00007ff22ae00000)
libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007ff22f050000)

Christian Ehrlicher

@artem1997262 said in QMYSQL driver not loaded on Ubuntu:

How do you get rid of them anyway?

Did you read the link I gave you? They had the same problem and a solution afaics.

artem1997262

@Christian-Ehrlicher said in QMYSQL driver not loaded on Ubuntu:

Did you read the link I gave you? They had the same problem and a solution afaics.

I fixed the error that you linked. *.so10 files are read, it can be seen in the log. Now another error has arisen, adjacent.
Last time he said:
libssl.so.10 => not found
libcrypto.so.10 => not found
I fixed it.
I installed the latest version of the 64-bit packages that were in your link.
He's writing: "version libcrypto.so.10' not found" Although below shows found that file. I don't understand what he wants.

artem1997262

This post is deleted!

jsulm

@artem1997262 said in QMYSQL driver not loaded on Ubuntu:

Although below shows found that file

Where is it located?
And did you check whether it is 64bit this time?