I may have misunderstood the case that doesn’t work.

Can you maybe do a small picture with the setup ?

I have add C:\mysql\mysql-5.7.21-winx64\lib into path variable. but don't work!

As it is now, double is used.

Depending on how your DECIMAL filed is configured, it might be enough. If not, then you can modify the plugin to read the field as described here.

Dear Allerknapper
I have same problem and stacked long time at here .
Now I have use the QT5.10.1 maybe can get succeed.
I have no time on it, but i will try it from July.
If you have any new progress could you update on this topic?
Best regards,
jeff

Are you using a Windows command prompt ?

Hi,

Are you aware of the implications of moving from MySQL to SQLite ?

One of which is: you are using a relative path for your SQLite database which won't work if your users install your application in e.g. Program Files as it's a read-only location.

hi,

@LuAria ,

wat ws the value coming in Numtwo ?.
Nways ur got solution.
Happy coding.

Thanks,

@jsulm Thanks a lot!
Sorry for my miss on the link.
I will try it.

im using qt 5.9 and isolated install on mysql 5.7.20 on mac this piece of code worked like charm for me

brew install mysql-connector-c

I already had MAMP installed.... and wanted to use the mysql from mamp running on port 8889 this code helped me to do that

```

db.setHostName("localhost");
db.setConnectOptions("UNIX_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock");
db.setDatabaseName("xxxxxx");
db.setUserName("root");
db.setPassword("root");
db.setPort(8889);

@SGaist

@SGaist said in MySQL + Qt 5.7 integration on Ubuntu 16.04:

Indeed, however I did misread, the calls seem to have been done.
But something looks wrong since the .so files can't be found.

Interesting to see what ldd on libqsqlmysql.so displays now, after creating the link:

guilherme@k45a:~/Programs/Qt/5.7/gcc_64/plugins/sqldrivers$ ldd libqsqlmysql.so
linux-vdso.so.1 => (0x00007ffe33d5f000)
libmysqlclient.so.20 => /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 (0x00007f8c1fcb1000)
libQt5Sql.so.5 => /home/guilherme/Programs/Qt/5.7/gcc_64/plugins/sqldrivers/./../../lib/libQt5Sql.so.5 (0x00007f8c1fa6c000)
libQt5Core.so.5 => /home/guilherme/Programs/Qt/5.7/gcc_64/plugins/sqldrivers/./../../lib/libQt5Core.so.5 (0x00007f8c1f34d000)
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f8c1efcb000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f8c1ec02000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f8c1e9e7000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f8c1e7e3000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f8c1e5c6000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f8c1e2bc000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f8c1e0a6000)
libicui18n.so.56 => /home/guilherme/Programs/Qt/5.7/gcc_64/plugins/sqldrivers/./../../lib/libicui18n.so.56 (0x00007f8c1dc0b000)
libicuuc.so.56 => /home/guilherme/Programs/Qt/5.7/gcc_64/plugins/sqldrivers/./../../lib/libicuuc.so.56 (0x00007f8c1d853000)
libicudata.so.56 => /home/guilherme/Programs/Qt/5.7/gcc_64/plugins/sqldrivers/./../../lib/libicudata.so.56 (0x00007f8c1be70000)
libgthread-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgthread-2.0.so.0 (0x00007f8c1bc6d000)
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f8c1ba65000)
libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007f8c1b754000)
/lib64/ld-linux-x86-64.so.2 (0x000055a9c6cac000)
libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007f8c1b4e3000)

Seems like it changed the entire dependency table.

@koahnig
Well the "MySQL server has gone away" msg also seems slightly "wooden" so it fits perfectly :)

@SGaist
is VS express not excotic enough ? ;)

Thank you dear friend .

You're right . the drivers names were wrong . it works now

Hi and welcome to devnet,

Please search the forum a bit, I've already provided the solution several times for OS X/macOS.

@MrErfan Did you not check you earlier deleted post ? It had a few answers.

@MrErfan To add to @neda's answer you can convert the image to base64 and set this as value to Image's source property.
Something like:

imageObj->setProperty("source", "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADwAAAA8CAYAAAA6/NlyAAAQvUlEQVRo3t2beYxd1X3Hv79zzr33LTNv3iwez+aNDOCw2WAMKSIgpTZJaUA0SkkrNWnTVhBFolG6pJIb2ihFFk3/aEBJF0VVk0pJS5eoCYVCYwjEwhTbY4PBi7A9tpkZ27O/W

Hi and welcome to devnet,

You have to go to the mysql plugin folder.

can i export this script to windows and use it there?

hi
I like this one
https://sourceforge.net/projects/qtrpt/

I'm just realizing that what I was trying to do was maybe nonsense : I was trying to pass on to the mysql server a value for the client on which my Qt program is running i.e. I was trying to "deceive" the server. And I could understand then that there would be no such method in QSqlDatabase (and that you couldn't understand my question initially).

Could you confirm my reasoning please?

For a beginner I have found Youtube tutorials from VoidRealms very helpful. For example this tutorial is about editing in a database table:
https://www.youtube.com/watch?v=LkbfNoZrTBQ&list=PL2D1942A4688E9D63&index=56 (C++ Qt 56 - QSqlTableModel )

You can't mix architectures. While there should be no problem connecting to a 64bit running server with a 32bit client. Loading the 64bit libraries with a 32bit plugin will not work.

Ok, thanks dude for your help

@smb564 I had the same problem with QMYSQL not loaded. I ran
$sudo apt-get installlibqt4-sql-mysql
and it worked

Thank you. I take a look on it.

The plugin hasn't changed anything related to that between 5.5 and 5.6 so I wonder if it's a change in QVariant.

By the way, why do you need that information ? You should be able to just convert to int without any problem.

@SGaist

... thank you. With QT 5.6.0 it's running.

Jakob

@Randomator Sir,
download the Qt Sources, e.g current the sources available are qt-everywhere-opensource-src-5.5.1, After extracting
cd C:\qt-everywhere-opensource-src-5.5.1\qtbase\src\plugins\sqldrivers\mysql
then make sure you call qmake from Qt5.5, for this purpose you can type the complete path of the qmake.
then use make and make install.
I hope it will help you.

@AlanT1337 said:

I think it was build in my normal Qt folder

I suppose that's possible, if you're using the qmake from that location to run on the project file. In any case I'm glad it's working now.

Auto-replying : I just found this tutorial that will be very helpful.

Glad you found out and thanks for sharing your findings.

Since you have it working now, please mark the thread as solved using the "Topic Tool" button so other forum users may know a solution has been found :)

One more thing:
I'm trying to follow "Option 2" with my compiled files from option 1
I do:
qmake "INCLUDEPATH+=$SR/usr/include/mariadb"...
make install

I'm using .../android_armv7/bin/qmake.
What else do I have to do to get it working?

Hi,

Shouldn't you use COLLATE for that ?

In any case, what do you mean by crash ? The query fails or the application crashes ? If the former, did you check the error returned by QSqlQuery ?