[SOLVED] Qt MySQL plugin - installing plugin does not work

[Peppy]

Hello guys, I have an issue of installing MySQL plugin - debugger says that the mysql plugin is available (installed into plugins directory, refreshed cache, added into project's sqldrivers subdirectory) but somehow it can't be loaded (Unable to load QMYSQL)...

Is there any way to specify why? Probably I have mixed platforms...

!http://img163.imageshack.us/img163/9200/qtmysqlplugin.png(Qt plugin is not loaded but present)!

[SGaist]

Hi,

Do you have the mysql binaries available in your PATH ?

[qxoz]

Try put libmysql.dll into same folder with *.exe

[Peppy]

@qxoz: Nope, nothing has changed.
@SGaist: Nope, I don't. Nothing has changed when I did so.

[SGaist]

Try to update the PATH of you run environment so that it also points to the folder where the mysql dlls are

[Peppy]

Nothing, buddy. It did not worked for me...

[mbnoimi]

I faced this issue before. try to fix it as following:

• put libmysql.dll in your application path (not in your project path in case you configured run from shadow build path)
• put SQLDrivers folder in your application's path

[Peppy]

@mbnoimi: Yea man, that's it!

[quote author="mbnoimi" date="1366202366"]I faced this issue before. try to fix it as following:

• put libmysql.dll in your application path (not in your project path in case you configured run from shadow build path)
• put SQLDrivers folder in your application's path[/quote]

Solved.

[dan82]

Hello, guys!
I have same problem with my Ubuntu 12.04

"QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7
can't conect to database server. QSqlError(-1, "Driver not loaded", "Driver not loaded") "

In foldel pluguns/sqldriver have library: libqsqlmysql.so

How and where i can fix this problem?

[Romaniy]

bq. Hello, guys!
I have same problem with my Ubuntu 12.04
“QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7
can’t conect to database server. QSqlError(-1, “Driver not loaded”, “Driver not loaded”) “
In foldel pluguns/sqldriver have library: libqsqlmysql.so
How and where i can fix this problem?

Hello,

look in my topic(the same problem, but I try to fix OCI driver)
"Your text to link here...":http://qt-project.org/forums/viewthread/33398/

Hope, something help you.

[mbnoimi]

[quote author="dan82" date="1381235196"]Hello, guys!
I have same problem with my Ubuntu 12.04

"QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7
can't conect to database server. QSqlError(-1, "Driver not loaded", "Driver not loaded") "

In foldel pluguns/sqldriver have library: libqsqlmysql.so

How and where i can fix this problem?
[/quote]

Try to install the following:
[code]
sudo apt-get install libqt4-sql-mysql libqt5sql5-mysql
[/code]

[dan82]

I am install libqt4-sql-mysql alredy.
When i try run sudo apt-get install libqt4-sql-mysql libqt5sql5-mysql
see
sudo apt-get install libqt5sql5-mysql
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package libqt5sql5-mysql

Google have't answer, how install libqt5sql5-mysql for Ubuntu 12.04
Do you have some idea?

[mbnoimi]

[quote author="dan82" date="1381251183"]
Google have't answer, how install libqt5sql5-mysql for Ubuntu 12.04
Do you have some idea?[/quote]

Sorry my mistake, I forgot you use 12.04 (I'm using 13.04) just call:
[code]sudo apt-get install libqt4-sql-mysql[/code]

[dan82]

Yes, cap! I was install libqt4-sql-mysql alredy.
Not work...
Find at internet this:
ldd libqsqlmysql.so

linux-gate.so.1 => (0xb77b6000)
libmysqlclient_r.so.16 => not found
libQt5Sql.so.5 => /home/dan/Qt/5.1.1/gcc/plugins/sqldrivers/./../../lib/libQt5Sql.so.5 (0xb774a000)
libQt5Core.so.5 => /home/dan/Qt/5.1.1/gcc/plugins/sqldrivers/./../../lib/libQt5Core.so.5 (0xb72c6000)
libstdc++.so.6 => /usr/lib/i386-linux-gnu/libstdc++.so.6 (0xb71dd000)
libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb7033000)
libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb7018000)
libicui18n.so.51 => /home/dan/Qt/5.1.1/gcc/plugins/sqldrivers/./../../lib/libicui18n.so.51 (0xb6df6000)
libicuuc.so.51 => /home/dan/Qt/5.1.1/gcc/plugins/sqldrivers/./../../lib/libicuuc.so.51 (0xb6c7c000)
libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xb6c77000)
libgthread-2.0.so.0 => /usr/lib/i386-linux-gnu/libgthread-2.0.so.0 (0xb6c74000)
librt.so.1 => /lib/i386-linux-gnu/librt.so.1 (0xb6c6b000)
libglib-2.0.so.0 => /lib/i386-linux-gnu/libglib-2.0.so.0 (0xb6b6f000)
libm.so.6 => /lib/i386-linux-gnu/libm.so.6 (0xb6b42000)
libgcc_s.so.1 => /lib/i386-linux-gnu/libgcc_s.so.1 (0xb6b24000)
/lib/ld-linux.so.2 (0xb77b7000)
libicudata.so.51 => /home/dan/Qt/5.1.1/gcc/plugins/sqldrivers/./../../lib/libicudata.so.51 (0xb55db000)
libpcre.so.3 => /lib/i386-linux-gnu/libpcre.so.3 (0xb559b000)

For normaly work need libmysqlclient_r.so.16 - but what need to do - i don't knot...

[SGaist]

IIRC, you need to also install libmysqlclient-dev

[dan82]

I was installed libmysqlclient-dev - nosing change, application not work. same error

[dan82]

So, i was upgrade Ubuntu 12.04 to 13.04
reinstall libqt4-sql-mysql libqt5sql5-mysql libs and all works.
Thks for help!
Solved.