Re: DBI/ssl help - now querying but can't confirm encryption

[Cyril Spiro]

I was able to solve the problem posted by Richard Schumert by placing the ssl certs directly into the mysql directory and so that there was no need to point down a PATH to the files.

But, even though I have the ssl certs pointed to by the my.cnf file and I've placed "mysql_ssl=1;mysql_ssl_client_key=server.key;mysql_ssl_client_cert=certfile.crt;mysql_ssl_ca_file=sf_issuing.crt" in the DBI connect line I'm not convinced the packet is being sent in an encrypted format.

I am querying the database on a server from a script on a PC within my network, and I have an ethereal sniffer loaded on the server. When I query the database, I can see the packet going from the server to the PC (IP addresses identified by the sniffer) and I can read the data unencrypted!

Any ideas on how I can confirm that the data is actually encrypted??