[SOLVED]MySQL library problem

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.

SGaist · 29 Jun 2015, 08:14

That's the PostgreSQL plugin. Like I suggested before, just remove the plugins you don't need from your bundle.