what is your suggestion about server app design ?

People usually refer to "server app" as "middleware" or "web application". There are tons of web frameworks and ORMs for various languages including Java and C# on "enterprise" side and scripting languages (pphp, python, perl, ruby, node.js). C++ is not really convenient language here. As for protocol, if you are not pursuing real-time data processing with lowest possible latency, it makes sense to use REST API on top of HTTP, so that on server side you have the most typical "web app" with ORM inside and REST outside, and on client side you can easily add web client if needed, and even if not, you get some additional convenience as compared to e.g. RPC over plain TCP

@SnuggleKat said in Cannot access MySQL running on another machine:

Looks like skip-networking solved the problem

Could you describe what this skip-networking concept is? for the sake of completeness and benefit of documenting the case for other future users having the same issue.

And if your issue is solved, please don't forget to mark your post as such. Thanks

@raven-worx
Thanks a lot. Now, I got a perspective on how I can proceed further. I will try the solution with the QWebSocket and see how that goes.
Cheers!

@SGaist

I have OpenSSL recently installed, but I am stating explicitly "no" for SSL connection option in MySql workbench.
The connection give a warning, but this relates to the workbench version which seem to be higher than the actual MySql install at the web domain. No mention of SSL at all there.

Since I have not really used OpenSSL I am lost on those parameters as used above. They are from the Qt document example and potentially completely wrong

Hi,

There’s also no need to allocate the query on the heap as the QSqlQueryModel::setQuery method parameter suggests.

@SGaist , thanks

No, bad design. The child should never even know who its parent is.

The correct process is to push information downstream.

The child should have setters for all the data it need. The manwindow calls those setters.

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

Zapewne już jakoś sobie poradziłeś ale gdyby nie to musisz na systemie z Win7 sprawdzić czego brakuje.
Jest kilka aplikacji, które posiadają funkcjonalność Linuksowego ldd.
Popatrz też na stronę: https://wiki.qt.io/Show_library_dependencies

Good afternoon. The topic is old, but still relevant to this day. I decided to try to connect MYSQL for Android.

Article: https://wiki.qt.io/Build_Qt_5_MySQL_Plugin_for_Android
Ct 5.10.1
I write under android
Faced with difficulties.

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