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

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

  
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

  
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

  

 

 

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

More
12 Avr 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 Connexion or Create an account to join the conversation.

More
12 Avr 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 Connexion or Create an account to join the conversation.

More
14 Avr 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 Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.032 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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

Login Form