Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySql SSL connection with Zend-Framework

I'm pretty new to Zend-Framework, but I managed to build a simple site in my PC with 2 pages that show the content of a table in a local database. The problem is that when I installed the site on the server, it didn't work because in the production server the connection to the local mysql server must be established using SSL.

I searched for the keys that I need to add to the application.ini to enable the ssl connection but I couldn't find any in the ZendFramework documentation. Here is the code of my application.ini

    resources.multidb.config.adapter = "pdo_mysql"
    resources.multidb.config.host = "localhost"
    resources.multidb.config.username = "Administrator"
    resources.multidb.config.password = "xxx"
    resources.multidb.config.dbname = "config"
    resources.multidb.config.default = true 

do you know if the ZendFramework supports ssl connection to mysql server and how to configure it? if no: is there some workaround?

Thanks for your help

like image 769
Daniele Pozzobon Avatar asked Aug 20 '12 14:08

Daniele Pozzobon


People also ask

How can I tell if MySQL SSL is enabled?

OFFICIAL SOLUTION ACCORDING TO MYSQL WEBSITE Run this in the session you want to verify: SELECT * FROM performance_schema. session_status WHERE VARIABLE_NAME IN ('Ssl_version','Ssl_cipher'); If you get the cipher and version strings, then the connection is encrypted.

What is SSL connection in MySQL?

On the server side, the --ssl option specifies that the server permits but does not require encrypted connections. This option is enabled by default, so it need not be specified explicitly. To require that clients connect using encrypted connections, enable the require_secure_transport system variable.

Does MySQL need SSL?

By default, MySQL is configured to only allow connections from the local system. If you want to connect to a MySQL server from a remote system, it is recommended to secure it with SSL/TLS. Enabling SSL/TLS will encrypt the data being sent to and from the database.


1 Answers

I don't think it's currently supported. Carl Welch patched it in ticket #6140 (see the library.diff attachment), however, changes don't seem to be in the trunk yet.

I suggest to vote for the issue (you have to log in first).

like image 194
cprn Avatar answered Oct 07 '22 08:10

cprn