MySQL SSL connection

Forum related to the ZDBC API-Layer

Moderators: gto, cipto_kh, EgonHugeist

ManUtdFans
Fresh Boarder
Fresh Boarder
Posts: 23
Joined: 23.06.2010, 05:33

MySQL SSL connection

Postby ManUtdFans » 04.07.2011, 00:49

We are using MySQL5 would like to make the initials connection using SSL.

From doc the example:

Properties.Strings = (
'MYSQL_SSL=TRUE'
'MYSQL_SSL_CA=D:/mysql/certs/ca-cert.pem'
'MYSQL_SSL_CERT=D:/mysql/certs/client-cert.pem'
'MYSQL_SSL_KEY=D:/mysql/certs/client-key.pem')

I guess the '/' will be replaced with '\' in Windows OS?

Are these three files have to be generated under MySQL using MySQL commands? Cannot generate 'manually' like open the 'certificated' and copy and paste the 'key text part' to create?

One more question it is different from website SSL, eg. https, the browsers do not need a certificate install on browser pc, why?

ManUtdFans
Fresh Boarder
Fresh Boarder
Posts: 23
Joined: 23.06.2010, 05:33

Postby ManUtdFans » 18.07.2011, 00:47

Anyone has any experience or knowledge about these please?

guidoaerts
Senior Boarder
Senior Boarder
Posts: 93
Joined: 01.07.2009, 16:07

Postby guidoaerts » 23.07.2011, 12:06

certificates (.pem files) have to be generated and signed with a program like openssl. essentially it is the same as used with https in browsers, where the certificates are mostly installed together with the application

guido


Return to “ZDBC (ZEOS Database Connectivity)”

Who is online

Users browsing this forum: No registered users and 1 guest