[SOLVED]MySQL library problem

mcosta

I got the same error.

BTW I think the application works (by default all sqldrivers plugins are copied)

The installer installs sqlite, mysql, odbc and postgresql also if you don't have the libraries installed

UPDATE Qt drivers are loaded at runtime so there's no way to understand which drivers are used; for this reason macdeplyqt copy all drivers

cpuin

Doesn't work after the deployment!!!

SGaist

Hi,

Do you have the MySQL libraries installed in /opt ? (i.e. using macports) If not then the error message is normal.

cpuin

@SGaist

I have installed MySQL from the installer.I don't know where is the opt/ (the path to it)

SGaist

Then you probably have the MySQL libraries in a path like /usr/local/mysql/. Right ?

cpuin

YES it is there

SGaist

Then you have to do

install_name_tool -change /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib /usr/local/mysql/PATH_TO_libmysqlclient.X.dylib PATH_TO_libqsqlmysql.dylib

In any case, if you are not using it in your application, you can also ignore the message and remove the plugin from the bundle.

[edit: added missing target SGaist]

cpuin

I deleted all plugins , left only libqsqlite.dylib
The app doesn't work!

SGaist

You have to give more details. "Doesn't work" doesn't give enough information to help you. Do you have any error message ?

mcosta

seems that macqtdeploy has some hardcoded PATH for MySQL and PostgreSQL.

SGaist

@mcosta not it doesn't, macdeployqt parses the output of otool to get the dependencies of the libraries/plugins of Qt. AFAICT, the plugins are built with dependencies coming from MacPorts hence the libmysqlclient.18.dylib in /opt/local/lib/

cpuin

@SGaist said:

install_name_tool -

LSOpenURLsWithRole() failed with error -10810 for the file

cpuin

@SGaist said:

/opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib

install_name_tool -change /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib /usr/local/mysql-5.6.25-osx10.8-x86_64/lib/libmysqlclient.18.dylib
Usage: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/install_name_tool [-change old new] ... [-rpath old new] ... [-add_rpath new] ... [-delete_rpath old] ... [-id name] input

SGaist

Which version of OS X and Qt are you using ?

I've corrected the example line

cpuin

@SGaist

OS X 10.10.3
QT 5.4

cpuin

@SGaist said:

PATH_TO_libqsqlmysql.dylib

install_name_tool -change /opt/local/lib/mysql55/mysql/libmysqlclient.18.dylib /usr/local/mysql-5.6.25-osx10.8-x86_64/lib/libmysqlclient.18.dylib Users/jorost/Qt5.4.2/5.4/clang_64/plugins/sqldrivers/libqsqlmysql.dylib
error: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/install_name_tool: can't open file: Users/jorost/Qt5.4.2/5.4/clang_64/plugins/sqldrivers/libqsqlmysql.dylib (No such file or directory)

SGaist

You're missing a slash before Users

cpuin

@SGaist
Now i got only Postgre error

ERROR: no file at "/usr/local/lib/libpq.5.dylib"

Does it mean that i have working mysql plugin?

SGaist

You should, unless the libmysqlclient is very different from the one Qt was built with.

cpuin

I have now mysql working, but i still can't have working app because of this:
ERROR: no file at "/usr/local/lib/libpq.5.dylib"

This is not very good approach: include all plug-ins w/out need of them.