Secure mysql connections in multi-host configurations

[Justin Albstmeijer]

Hi,

I while ago I opened a feature request to get mysql SSL support for the remote servers cronjob connecting to the master DB

http://bugtracker.ispconfig.org/inde...s&task_id=1691

Eventually it was closed as 'implemented'.

How should I enable this? or is it still necessary to hack to code to add the 'MYSQL_CLIENT_SSL' flag to the mysql connect functions like mentioned in an older post.

http://www.howtoforge.com/forums/showthread.php?t=50303

Thanks for any feedback.

J.

[till]

To enable this ssl, set:

$conf['db_client_flags'] = 0;

to:

$conf['db_client_flags'] = MYSQL_CLIENT_SSL;

in the server config.inc.php file.

[Justin Albstmeijer]

Thanks Till,

Tried earlier:

$conf['dbmaster_client_flags'] = MYSQL_CLIENT_SSL;

which looked more obvious, but that did not do the trick.

$conf['db_client_flags'] = MYSQL_CLIENT_SSL;

indeed triggers a secure connection to the master database and seems to work with the local database too even when it does not support SSL.

Originally Posted by till

To enable this ssl, set:

$conf['db_client_flags'] = 0;

to:

$conf['db_client_flags'] = MYSQL_CLIENT_SSL;

in the server config.inc.php file.