View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Add SSL settings for mysql PDO connection - ProjeQtOr
 

[SOLVED] Add SSL settings for mysql PDO connection

More
02 Sep 2016 12:48 #1 by desperados
Add SSL settings for mysql PDO connection was created by desperados
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
The topic has been locked.
More
02 Sep 2016 12:51 #2 by babynus
Replied by babynus on topic Add SSL settings for mysql PDO connection
This is subject of Ticket #2046, planned on V5.6
Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: desperados
The topic has been locked.
Moderators: babynus, protion
Time to create page: 0.031 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form