MySQL SSL

Added in tiki12

For some system, e.g. cloud based systems such as WIndows Azure, it is recommended to use an SSL connection to the MySQL database.

To enable a MySQL SSL connection, 3 keys must be specified, in PEM format

• Client key. Filename must end with -key.pem
• Client cert. Filename must end with -cert.pem
• CA cert. Filename must end with -ca.pem

These files are placed in the tikiroot/db/cert folder. Tiki will detect these files and initiate an SSL connection.
The db/cert folder could look something like this (Azure Clear DB sample)

The MySQL SSL status can be checked in the Admin / Security panel

If any one of the key files are missing, a regular non-SSL connection is used.