[SOLVED] Need a HowTo for setting SSL certificates for a MySQL Connection - QT5

GiveMeMyName

Seems that this is not possible by using the current driver of mysql with qt5. And i am not enough skilled to rewrite the driver for supporting this ^^. I will use it like this until a new update maybe :/. I don't mark this as resolved because it's still unsolved :)

nicolas_rolando

Hi. I send you a little contribution to qt-project. Many developers are waiting for this feature: "Enhanced source code":http://www.sendspace.com/file/i5kvej
Thanks. Bye

GiveMeMyName

Hey :) I saw your work, and you did it very well :) I will have a try in my project and i'll give you my feedback :)

Thanks you again for working on this !

GiveMeMyName

Well, after one week testing, on OS X Lion and Win7 (32 + 64 bits) mysql clients, i just have one word for you : GREAT :D

The MySQL server used for testing is under mysql 5.5.31 + Ubuntu 12.04. OpenSSL version here is 1.0.1.

That can be useful for other people. Maybe someone can pin this topic ?

I can mark it as solved now :)

nicolas_rolando

Thanks, pal. I'm glad it has been useful. Bye

Lukoch

Hi, I know thread is closed for 2 years, but is there any chance someone has this example project from nicolas_rolando ? It would really help me since I am not able to set secure MySQL connection.

Thanks.

SGaist

Hi and welcome to devnet,

There's a patch currently under review that implements this. Have a look here

Lukoch

Thank you, I'll try this.

Lukoch

One more question, how can I apply this patch ?

I can' t find those files in Qt 5.4 folder (src_sql_kernel_qsqldatabase.cpp,...).

Thanks.

SGaist

Might be a silly question but did you install the Qt sources ?

Lukoch

Oh, right, sorry... I am using prebuilt components now, thanks.

Lukoch

Actually, it would be easier for me to migrate DB to other solution, such as PostgreSQL. I am using mulitiple devices and platforms for my project and it would mean to apply the patch for all of them.

Is SSL connection using certificates working for PostgreSQL driver in Qt ? I wasn' t able to find examples.

SGaist

What about that thread ?

tinysoft

@nicolas_rolando said:

Hi. I send you a little contribution to qt-project. Many developers are waiting for this feature: "Enhanced source code":http://www.sendspace.com/file/i5kvej
Thanks. Bye

hello @nicolas_rolando , @GiveMeMyName

could you re upload the link .. it looks like it's expired

thank you in advance