Mysql can't connect on MacBook

[Eternus]

@SGaist said in Mysql can't connect on MacBook:

documentation

i try this : https://forum.qt.io/topic/106565/mysql-qt-create-plugin-mysql-for-qt-on-mac

Then, we cd to mysql folder (folder inside sqldrivers) and make plugin through 2 commands
qmake
make install

if i qmake and make install i dont have libsqlmysql.dylib in file sqldrivers i dont know why ..

[SGaist]

And what about following the documentation I linked ?

Are you sure you are using the correct qmake executable ?
Did you check the qmake output ?
Did you check the make output ?

[Eternus]

@SGaist i do this:
https://doc.qt.io/qt-5/sql-driver.html

cd $QTDIR/qtbase/src/plugins/sqldrivers -- i need write full path
qmake -- MYSQL_PREFIX=/usr/local - this working..
i stopped on this step : make sub-mysql

[Christian Ehrlicher]

@Eternus said in Mysql can't connect on MacBook:

this working..

Please remove all generated files (as explained in the documentation) and post the output of this command.

[Eternus]

@Christian-Ehrlicher said in Mysql can't connect on MacBook:

working..

Please remove all generated files (as explained in the documentation) and post the output of this

how ?? i cant find in documentation

[SGaist]

By deleting the files that have been generated in the folder you are in.

[Eternus]

@SGaist have you mean all in sqldrivers ?

[jsulm]

@Eternus In the build directory, $QTDIR/qtbase/src/plugins/sqldrivers in your case.
This is now a good example why it is way better to use out of source builds...

[Eternus]

@jsulm i deleted all files and still have same error
https://ddgobkiprc33d.cloudfront.net/e229edb5-5f7b-4d09-b351-f42b5aa9c97b.png

documentation says me delete config i deleted comfig and its same..

[SGaist]

Look into config.tests to see what is happening.

[Eternus]

@SGaist

this is config for mysql what there please ?

[Christian Ehrlicher]

@Eternus said in Mysql can't connect on MacBook:

this is config for mysql what there please ?

You should take a look at the config.log as described in the documentation

[Eternus]

@Christian-Ehrlicher
i cant find in documentation

[Christian Ehrlicher]

@Eternus said in Mysql can't connect on MacBook:

i cant find in documentation

"If something goes wrong and you want qmake to recheck your available drivers, you must remove config.cache in <QTDIR>/qtbase/src/plugins/sqldrivers - otherwise qmake will not search for the available drivers again. If you encounter an error during the qmake stage, open config.log to see what went wrong."

[Eternus]

@Christian-Ehrlicher

=> source failed condition 'config.win32'.
Trying source 1 (type sybaseEnv) of library tds ...

• cd /Users/macbook/Qt/5.13.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds && /usr/local/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'QMAKE_USE += tds' 'QMAKE_LIBS_TDS = -lsybdb' /Users/macbook/Qt/5.13.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds
• cd /Users/macbook/Qt/5.13.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds && MAKEFLAGS= make

/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/Cellar/qt/5.15.0/mkspecs/macx-clang -o main.o main.cpp
main.cpp:2:10: fatal error: 'sybfront.h' file not found
#include <sybfront.h>
^~~~~~~~~~~~
1 error generated.
make: *** [main.o] Error 1
=> source failed verification.
test config.sqldrivers.libraries.tds FAILED

this is my config.....

but I found something else... In /usr/local/Cellar/qt/5.15.0/plugins/sqldrivers
I have there libqsqlmysql.dylib its is it ? terminal says me he created here but If I change path I have same error....

[SGaist]

You are building Qt 5.13.2. You installed Qt 5.15.0 using brew.

[Eternus]

@SGaist if I not install qt with home-brew I have this :
macbook@MacBook-Pro-uzivatela-Macbook sqldrivers % qmake -- MYSQL_PREFIX=/usr/local/mysql

zsh: command not found: qmake
macbook@MacBook-Pro-uzivatela-Macbook sqldrivers %

[Eternus]

@SGaist
and if I do what I say its same with 5.15
Trying source 1 (type sybaseEnv) of library tds ...

• cd /Users/macbook/Qt/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/tds && /usr/local/bin/qmake "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" 'QMAKE_USE += tds' 'QMAKE_LIBS_TDS = -lsybdb' /Users/macbook/Qt/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/tds
• cd /Users/macbook/Qt/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/tds && MAKEFLAGS= make

/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang++ -c -pipe -stdlib=libc++ -O2 -std=gnu++11 -arch x86_64 -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.15.sdk -mmacosx-version-min=10.13 -w -fPIC -I. -I/usr/local/Cellar/qt/5.15.0/mkspecs/macx-clang -o main.o main.cpp
main.cpp:2:10: fatal error: 'sybfront.h' file not found
#include <sybfront.h>
^~~~~~~~~~~~
1 error generated.
make: *** [main.o] Error 1
=> source failed verification.
test config.sqldrivers.libraries.tds FAILED

[SGaist]

Use the qmake executable that comes with the Qt version you installed. You can't just mix and match.

[Eternus]

@SGaist but I have qmake not found