Forum

[SOLVED] Add SSL se...
 
Notifications
Retirer tout

[SOLVED] Add SSL settings for mysql PDO connection

2 Posts
2 Utilisateurs
0 Reactions
4,357 Vu
jlenuff
(@desperados)
Posts: 16
Eminent Member
Début du sujet
 
[#3623]

Hi everybody !

My MySQL connection requires SSL. So, i modified these two files :

/usr/share/projeqtor/projeqtor/model/persistence/Sql.php at line 280 :

self::$connexion = new PDO($dsn, self::$dbUser, self::$dbPassword,
array(
            PDO::MYSQL_ATTR_SSL_KEY    =>'/path/to/my/client-key.pem',
            PDO::MYSQL_ATTR_SSL_CERT=>'/path/to/my/client-cert.pem',
            PDO::MYSQL_ATTR_SSL_CA    =>'/path/to/my/ca-cert.pem'
        ));

/usr/share/projeqtor/projeqtor/tool/configCheck.php at line 87 :

$connexion = new PDO($dsn, $param['DbUser'], $param['DbPassword']
array(
            PDO::MYSQL_ATTR_SSL_KEY    =>'/path/to/my/client-key.pem',
            PDO::MYSQL_ATTR_SSL_CERT=>'/path/to/my/client-cert.pem',
            PDO::MYSQL_ATTR_SSL_CA    =>'/path/to/my/ca-cert.pem'
        ));

and at line 108 :

        $cnxDb = new PDO($dsn, $param['DbUser'], $param['DbPassword']
array(
            PDO::MYSQL_ATTR_SSL_KEY    =>'/path/to/my/client-key.pem',
            PDO::MYSQL_ATTR_SSL_CERT=>'/path/to/my/client-cert.pem',
            PDO::MYSQL_ATTR_SSL_CA    =>'/path/to/my/ca-cert.pem'
        ));

At each update, i have to modify these files.
Can you take in consideration this point in your future evolutions ?


Jordan LE NUFF
IT Project Manager

 
Posté : 02/09/2016 2:48 pm
(@babynus)
Posts: 14952
Membre Admin
 

This is subject of Ticket #2046, planned on V5.6


 
Posté : 02/09/2016 2:51 pm
Share:
Retour en haut