View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Installation - Can't connect to MySQL server on '127.0.0.1' - ProjeQtOr

Prochaines sessions de formation

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

Installation - Can't connect to MySQL server on '127.0.0.1'

More
27 Fév 2016 12:09 - 27 Fév 2016 14:29 #1 by ericcarson
Installing is giving me an error of
SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13)
dsn = mysql:host=127.0.0.1;port=3306

CentOS 7
MariaDB 5.5.44 (Mysql)
PHP version is 5.4.16

MySQL is monitoring the default port.
I have created a MySql database.
I have created a MySql user.
The projeqtor database has the user granted database-specific permissions, all but grant
The error occurs also with 'localhost'

I have double-checked the MySQL user
I have double-checked the MySQL user password

I'm at a loss right now...

the root user will not connect either. I'm thinking it may be related to the way in which MySQL is accessed. Hesk (a helpdesk/ticket system) and WordPress are installed and running on the system successfully.

Could this be related to SELinux? Is there a file I should be changing the context to httpd_sys_rw_content_t to allow read/write access for the configuration changes to actually be written?

Added all directories for projeqtor to the rw context
changed database host to localhost
error changed to access denied.
changed database user to root
SUCESS!

I still do not consider this solved. A perfectly good non-root user is available but does not authenticate?
# Privileges for `projeqtor`@`127.0.0.1`

GRANT USAGE ON *.* TO 'projeqtor'@'127.0.0.1' IDENTIFIED BY PASSWORD '*CENSORED';

GRANT ALL PRIVILEGES ON `projeqtor`.* TO 'projeqtor'@'127.0.0.1';

What am I missing everyone?
Last edit: 27 Fév 2016 14:29 by ericcarson. Reason: More troubleshooting

Please Connexion or Create an account to join the conversation.

More
27 Fév 2016 16:53 #2 by babynus
Did you revert your configuration to 127.0.0.1 insted of localhost ?
Did you try grant usages to 'projeqtor'@'localhost' with access to localhost ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.029 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.