Mysql can't connect on MacBook

[SGaist]

Explain what ?

[Eternus]

@SGaist
how too add qt_debug_plugins...

[Eternus]

@SGaist I find this https://forum.qt.io/topic/106565/mysql-qt-create-plugin-mysql-for-qt-on-mac

can't find thes gunzip qt-everywhere-opensource-src-%VERSION%.tar.gz
I have only this : qt5

and then I try this https://doc.qt.io/qt-5/macos-building.html
I can't find thes gunzip qt-everywhere-opensource-src-%VERSION%.tar.gz
I have only this : qt5

[SGaist]

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

@SGaist
how too add qt_debug_plugins...

You do realize that is indicated precisely where you should do it in Qt Creator ?

[Eternus]

@SGaist ??if I install Mysql on vps should be work ?

[SGaist]

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

@SGaist ??if I install Mysql on vps should be work ?

What do you mean ?

[Eternus]

sorry nothing I mean how can I fix this problem ? I think add qt_debug_plugins... this isn't solution ...

[SGaist]

I never said it would be the solution, the goal is to gather information about why the plugin is not loading in order to fix it. And be careful, the name of the variable is all in upper case.

[Eternus]

@SGaist
if I start debugging I have same this :
23:08:46: Debugging starts
2020-08-21 23:08:51.949814+0200 Test[946:23566] QPixmap::scaled: Pixmap is a null pixmap
2020-08-21 23:08:53.840401+0200 Test[946:23566] QSqlDatabase: QMYSQL driver not loaded
2020-08-21 23:08:53.840464+0200 Test[946:23566] QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7

2020-08-21 23:09:50.887121+0200 Test[946:23566] QSqlDatabasePrivate::addDatabase: duplicate connection name 'qt_sql_default_connection', old connection removed.

[SGaist]

The application output shows one thing: you are misusing the QSqlDatabase class. It also does not show the plugin loading debug data.

Did you add the QT_DEBUG_PLUGINS variable in Qt Creator like I suggested ? If so, did you set it to 1 ?

[Eternus]

@SGaist sorry iam beginner noob where I need add QT_DEBUG PUGINS where ?

[mrjj]

@Eternus
Hi

[Eternus]

@mrjj thanks <3
@SGaist

and this is says me ..

13:04:44: Starting /Users/macbook/Documents/Projekty_programovanie/QT_APPS/build-Test-Desktop_Qt_5_15_0_clang_64bit-Debug/Test.app/Contents/MacOS/Test ...
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platforms" ...
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platforms/libqcocoa.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platforms/libqcocoa.dylib, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"cocoa"
]
},
"archreq": 0,
"className": "QCocoaIntegrationPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("cocoa")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platforms/libqminimal.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platforms/libqminimal.dylib, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"minimal"
]
},
"archreq": 0,
"className": "QMinimalIntegrationPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("minimal")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platforms/libqoffscreen.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platforms/libqoffscreen.dylib, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"offscreen"
]
},
"archreq": 0,
"className": "QOffscreenIntegrationPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("offscreen")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platforms/libqwebgl.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platforms/libqwebgl.dylib, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"webgl"
]
},
"archreq": 0,
"className": "QWebGLIntegrationPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("webgl")
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Projekty_programovanie/QT_APPS/build-Test-Desktop_Qt_5_15_0_clang_64bit-Debug/Test.app/Contents/MacOS/platforms" ...
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platforms/libqcocoa.dylib"
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platformthemes" ...
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platformthemes/libqxdgdesktopportal.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/platformthemes/libqxdgdesktopportal.dylib, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformThemeFactoryInterface.5.1",
"MetaData": {
"Keys": [
"xdgdesktopportal",
"flatpak",
"snap"
]
},
"archreq": 0,
"className": "QXdgDesktopPortalThemePlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("xdgdesktopportal", "flatpak", "snap")
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Projekty_programovanie/QT_APPS/build-Test-Desktop_Qt_5_15_0_clang_64bit-Debug/Test.app/Contents/MacOS/platformthemes" ...
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/styles" ...
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/styles/libqmacstyle.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/styles/libqmacstyle.dylib, metadata=
{
"IID": "org.qt-project.Qt.QStyleFactoryInterface",
"MetaData": {
"Keys": [
"macintosh"
]
},
"archreq": 0,
"className": "QMacStylePlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("macintosh")
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Projekty_programovanie/QT_APPS/build-Test-Desktop_Qt_5_15_0_clang_64bit-Debug/Test.app/Contents/MacOS/styles" ...
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/styles/libqmacstyle.dylib"
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats" ...
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqgif.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqgif.dylib, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"gif"
],
"MimeTypes": [
"image/gif"
]
},
"archreq": 0,
"className": "QGifPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("gif")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqicns.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqicns.dylib, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"icns"
],
"MimeTypes": [
"image/x-icns"
]
},
"archreq": 0,
"className": "QICNSPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("icns")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqico.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqico.dylib, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"ico",
"cur"
],
"MimeTypes": [
"image/vnd.microsoft.icon",
"image/vnd.microsoft.icon"
]
},
"archreq": 0,
"className": "QICOPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("ico", "cur")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqjpeg.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqjpeg.dylib, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"jpg",
"jpeg"
],
"MimeTypes": [
"image/jpeg",
"image/jpeg"
]
},
"archreq": 0,
"className": "QJpegPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("jpg", "jpeg")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqmacheif.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqmacheif.dylib, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"heic",
"heif"
],
"MimeTypes": [
"image/heic",
"image/heif"
]
},
"archreq": 0,
"className": "QMacHeifPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("heic", "heif")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqmacjp2.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqmacjp2.dylib, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"jp2"
],
"MimeTypes": [
"image/jp2",
"image/jpx",
"image/jpm",
"video/mj2"
]
},
"archreq": 0,
"className": "QMacJp2Plugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("jp2")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqsvg.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqsvg.dylib, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"svg",
"svgz"
],
"MimeTypes": [
"image/svg+xml",
"image/svg+xml-compressed"
]
},
"archreq": 0,
"className": "QSvgPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("svg", "svgz")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqtga.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqtga.dylib, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"tga"
],
"MimeTypes": [
"image/x-tga"
]
},
"archreq": 0,
"className": "QTgaPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("tga")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqtiff.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqtiff.dylib, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"tiff",
"tif"
],
"MimeTypes": [
"image/tiff",
"image/tiff"
]
},
"archreq": 0,
"className": "QTiffPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("tiff", "tif")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqwbmp.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqwbmp.dylib, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"wbmp"
],
"MimeTypes": [
"image/vnd.wap.wbmp"
]
},
"archreq": 0,
"className": "QWbmpPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("wbmp")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqwebp.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqwebp.dylib, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"webp"
],
"MimeTypes": [
"image/webp"
]
},
"archreq": 0,
"className": "QWebpPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("webp")
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Projekty_programovanie/QT_APPS/build-Test-Desktop_Qt_5_15_0_clang_64bit-Debug/Test.app/Contents/MacOS/imageformats" ...
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqgif.dylib"
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqicns.dylib"
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqico.dylib"
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqjpeg.dylib"
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqmacheif.dylib"
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqmacjp2.dylib"
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqsvg.dylib"
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqtga.dylib"
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqtiff.dylib"
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqwbmp.dylib"
loaded library "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/imageformats/libqwebp.dylib"
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/iconengines" ...
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/iconengines/libqsvgicon.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/iconengines/libqsvgicon.dylib, metadata=
{
"IID": "org.qt-project.Qt.QIconEngineFactoryInterface",
"MetaData": {
"Keys": [
"svg",
"svgz",
"svg.gz"
]
},
"archreq": 0,
"className": "QSvgIconPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("svg", "svgz", "svg.gz")
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Projekty_programovanie/QT_APPS/build-Test-Desktop_Qt_5_15_0_clang_64bit-Debug/Test.app/Contents/MacOS/iconengines" ...
QPixmap::scaled: Pixmap is a null pixmap
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/accessible" ...
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Projekty_programovanie/QT_APPS/build-Test-Desktop_Qt_5_15_0_clang_64bit-Debug/Test.app/Contents/MacOS/accessible" ...
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/sqldrivers" ...
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/sqldrivers/libqsqlite.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/sqldrivers/libqsqlite.dylib, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QSQLITE"
]
},
"archreq": 0,
"className": "QSQLiteDriverPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("QSQLITE")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/sqldrivers/libqsqlodbc.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/sqldrivers/libqsqlodbc.dylib, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QODBC3",
"QODBC"
]
},
"archreq": 0,
"className": "QODBCDriverPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("QODBC3", "QODBC")
QFactoryLoader::QFactoryLoader() looking at "/Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/sqldrivers/libqsqlpsql.dylib"
Found metadata in lib /Users/macbook/Documents/Qt/5.15.0/clang_64/plugins/sqldrivers/libqsqlpsql.dylib, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QPSQL7",
"QPSQL"
]
},
"archreq": 0,
"className": "QPSQLDriverPlugin",
"debug": false,
"version": 331520
}

Got keys from plugin meta data ("QPSQL7", "QPSQL")
QFactoryLoader::QFactoryLoader() checking directory path "/Users/macbook/Documents/Projekty_programovanie/QT_APPS/build-Test-Desktop_Qt_5_15_0_clang_64bit-Debug/Test.app/Contents/MacOS/sqldrivers" ...
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7

[SGaist]

Due to a change of licence by Oracle, the MySQL prebuilt plugin cannot be provided. You have to build it yourself.

[Eternus]

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

Due to a change of licence by Oracle, the MySQL prebuilt plugin cannot be provided. You have to build it yourself.

but how ??? tell me please :(

[SGaist]

Did you even try to read the related Qt's documentation ?

It's explained there.
There are also numerous thread on this forum about that subject.

[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.