I'm not seeing any options in Piwik for enabling the
MySQL connectors to use SSL. It's very important that we are given the capability of encrypting our connections to database servers, since they may not always be on the same server as Piwik.
For reference, projects such as
osTicket provide additional config variables as the following:
define('DBSSLCA','/path/to/ca.crt'); define('DBSSLCERT','/path/to/client.crt'); define('DBSSLKEY','/path/to/client.key');
So for example, an Amazon RDS connection will only need to define
DBSSLCA in the config for an SSL connection to operate.
Not directly related to resolve this issue but maybe an interesting read: https://www.facebook.com/MySQLatFacebook/posts/10153074619236696
The pull request @ https://github.com/piwik/piwik/pull/8049 is a great start - we have closed it for now as nobody is working on it, but if you are reading this, please consider finish the pull request so we can merge it in Piwik!
Since this issue has been in the works for over 2 years, does it mean something is blocking it so much that it is unlikely to be implemented soon?
If so, is there a recommended workaround to prevent Piwik from sending database passwords in clear text, without encryption? Many thanks for your time working on this issue and for answering my question.