I have the main Piwik database running on a remote MySQL box from my web servers. The users on the box require MySQL over SSL. Does anyone know how to enable this with Piwik? Basically how do I tell the connection to use SSL and pass it our certificate?
For example, using shell I must pass the cert to get a valid connection:
mysql -uuser -p–ssl-ca=/certs/mysql-cert.pem -hremotehostsomwhere.com
The config file for Piwik doesn’t allow me to pass the cert, so I get connection errors. I wasn’t sure where to look to edit the main connection string.