[SOLVED]MySQL library problem

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.

cpuin · S SGaist 28 Jun 2015, 20:58

@SGaist

As i answered before when removing all other plugins from the bundle, the app doesn't open!

SGaist · 30 Jun 2015, 13:03

I didn't suggest to remove all other plugins, just the SQL related plugins you don't use

cpuin · S SGaist 30 Jun 2015, 12:52

@SGaist Exactly, i left only sqlite plugin and the app doesn't open

SGaist · 30 Jun 2015, 13:37

Start it from the command line, what does it tell you ?

cpuin · S SGaist 30 Jun 2015, 13:07

@SGaist Strangely the ERROR disappear and working app bundle was created w/out changing anything.Unfortunately the app created database.db in the path i set (in this case in the program.app/contents/MacOS but can't write inside!

Starting the app from QT can write in to the db, but starting it outside Qt doesn't write, but creates it.