[SOLVED]MySQL library problem

mcosta · wrote on 27 Jun 2015, 19:39

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 · wrote on 27 Jun 2015, 19:40

Doesn't work after the deployment!!!

SGaist · 27 Jun 2015, 19:50

Hi,

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

cpuin · S SGaist 27 Jun 2015, 19:47

@SGaist

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

SGaist · wrote on 27 Jun 2015, 19:53

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

cpuin · wrote on 27 Jun 2015, 19:53

YES it is there

SGaist · 27 Jun 2015, 20:09

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 · wrote on 27 Jun 2015, 20:00

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

SGaist · 27 Jun 2015, 20:06

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

mcosta · wrote on 27 Jun 2015, 20:01

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

SGaist · wrote on 27 Jun 2015, 20:03

@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 · S SGaist 27 Jun 2015, 20:01

@SGaist said:

install_name_tool -

LSOpenURLsWithRole() failed with error -10810 for the file

cpuin · S SGaist 27 Jun 2015, 19:57

@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 · 27 Jun 2015, 20:31

Which version of OS X and Qt are you using ?

I've corrected the example line

cpuin · S SGaist 27 Jun 2015, 20:25

@SGaist

OS X 10.10.3
QT 5.4

cpuin · S SGaist 27 Jun 2015, 20:25

@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 · 27 Jun 2015, 20:46

You're missing a slash before Users

cpuin · S SGaist 27 Jun 2015, 20:44

@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 · wrote on 27 Jun 2015, 21:43

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

cpuin · wrote on 28 Jun 2015, 20:55

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.