View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Connecting ProjeQtOr to a remote MySql server over SSL - ProjeQtOr
 
 

[SOLVED] Connecting ProjeQtOr to a remote MySql server over SSL

More
12 Apr 2016 13:31 #1 by desperados
Connecting ProjeQtOr to a remote MySql server over SSL was created by desperados
Hi Everyone !

I just have installed my ProjeQtOr on my web server.

I'm on the configuration page.

Here are the results of the configuration checks :

PHP version is 7.0.5 : OK
Module PDO is available : OK
Module PDO for 'MYSQL' is available : OK
Module MBSTRING is available : OK
GD Library is available and correctly installed : OK
Module IMAP is available : OK
Module OPENSSL is available : OK
Module XML is available : OK
max_input_vars=4000 : OK
max_execution_time=30 : OK
memory_limit=512M : OK
file_uploads=1 : OK
session.auto_start is disabled : OK
magic_quotes_gpc is disabled : OK
register_globals is disabled : OK

So, all is OK.

On the other hand, my MySql server refuse all no-SLL connection. So, my ProjeQtOr can't connect to my database.

How can I configure the PDO::MYSQL_ATTR_SSL_KEY, PDO::MYSQL_ATTR_SSL_CERT and PDO::MYSQL_ATTR_SSL_CA database parameters on ProjeQtOr ?
Jordan LE NUFF
IT Project Manager

Please Log in or Create an account to join the conversation.

More
12 Apr 2016 13:53 #2 by desperados
Replied by desperados on topic Connecting ProjeQtOr to a remote MySql server over SSL
Re all,

I've found a way to connect to my MySql server.

In the "tool/configCheck.php" file, i added theses lines at line 87 and 106 :
$connexion = new PDO($dsn, $param['DbUser'], $param['DbPassword'],
array(
            \PDO::MYSQL_ATTR_SSL_KEY    =>'/etc/pki/tls/private/my-key.pem',
            \PDO::MYSQL_ATTR_SSL_CERT=>'/etc/pki/tls/certs/my-cert.pem',
            \PDO::MYSQL_ATTR_SSL_CA    =>'/etc/pki/CA/certs/my-ca-cert.pem'
        ));

I also added these lines in the "model/persistence/Sql.php" file at line 280 :
self::$connexion = new PDO($dsn, self::$dbUser, self::$dbPassword,
array(
            \PDO::MYSQL_ATTR_SSL_KEY    =>'/etc/pki/tls/private/my-key.pem',
            \PDO::MYSQL_ATTR_SSL_CERT=>'/etc/pki/tls/certs/my-cert.pem',
            \PDO::MYSQL_ATTR_SSL_CA    =>'/etc/pki/CA/certs/my-ca-cert.pem'
        ));
Jordan LE NUFF
IT Project Manager

Please Log in or Create an account to join the conversation.

More
14 Apr 2016 20:30 #3 by babynus
Replied by babynus on topic Connecting ProjeQtOr to a remote MySql server over SSL
Thanks for sharing the solution.
Will possibly include it in community version (Ticket #2046)
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.032 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