Mysql can't connect on MacBook

[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

[SGaist]

Use the full path to the executable.

[Eternus]

@SGaist have you mean for mysql or what mysql its full path

[JonB]

@Eternus
@SGaist wants you to use the full path to your qmake executable (nothing to do with MySQL) when you run your make command, like:

<path-to-qmake-in-your-Qt-distribution>/qmake -- MYSQL_PREFIX=/usr/local/mysql

He wants you to do that to make you run the exact right version of qmake which is in the Qt 5.15 installation area. At the moment there is no qmake on your PATH.

[Eternus]

@JonB