PHP mysql_connect ssl
Posted: 09. November 2007 14:10
I've tried to troubleshoot this as much as I can before registering and posting.
I have an application running under xampp 1.6.4 (Windows) written in php which accesses a remote database. The web page is https so I know that ssl is working fine for the apache server. The application works fine when I access the database server using the default mysql_connect form, but fails when I use the MYSQL_CLIENT_SSL flag. I've verified that my.cnf has the client key and certificate along with the ca cert. The mysql command line client can connect to the server using the certificate so it looks like an issue with the php mysql client or I've missed something in the configuration.
Any assistance would be greatly appreciated as I cannot use the unsecured database connection except for testing purposes.
Thanks in advance - and for such a wonderful package as well!
Scott
I have an application running under xampp 1.6.4 (Windows) written in php which accesses a remote database. The web page is https so I know that ssl is working fine for the apache server. The application works fine when I access the database server using the default mysql_connect form, but fails when I use the MYSQL_CLIENT_SSL flag. I've verified that my.cnf has the client key and certificate along with the ca cert. The mysql command line client can connect to the server using the certificate so it looks like an issue with the php mysql client or I've missed something in the configuration.
Any assistance would be greatly appreciated as I cannot use the unsecured database connection except for testing purposes.
Thanks in advance - and for such a wonderful package as well!
Scott