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
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.
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.
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.
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).
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With