Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] Add SSL se...
 
Notifications
Clear all

[SOLVED] Add SSL settings for mysql PDO connection

2 Posts
2 Users
0 Reactions
4,358 Views
jlenuff
(@desperados)
Posts: 16
Active Member
Topic starter
 
[#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

 
Posted : 02 Sep 2016 14H48
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

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


 
Posted : 02 Sep 2016 14H51
Share:

Scroll to Top