You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2013-08-22 12:21:55

m.forlani
Member
Registered: 2013-08-22
Posts: 2

[SOLVED] Problems with connecting to mysql

Hi all, i'm new in this forum.

I've installed glpi on june 2013 in my server using pre built packages, server is centos 6.3 64bit, and fusioninventory plugin, everything goes fine and working.

Yesterday i had to move default mysql databases location to a new hdd, so that's what i did:
stop mysqld service
created the new folder
copied the original db to the new folder
adjusted permissions and selinux (althought selinux is in permissive)
changed my.cnf to specify the socket for clients (after moving db local clients can't connect to mysql)
adjusted php.ini mysql.default_socket and mysqli.default_socket
restarted httpd service
restarted mysqld service and test

Access from console works
Phpmyadmin access needed to specify connection socket in config.inc.php (althought present in php.ini) then worked
Apps from network can access their db
GLPI can't connect to mysql db

A link to the Mysql server could not be established. Please check your configuration.
Le serveur Mysql est inaccessible. Vérifiez votre configuration

so i tried:
delete config_db.php
accessing glpi from web puts me to the install wizard, then i select update
insert mysql user/password/server (localhost)
in step 2 (Test of the connection at the database) i got this error message:

Can't connect to the database :
The server answered : Can't connect to local MySQL server through socket '/MysqlData/databases/mysqld.sock' (2)

user,password and server are the same as first installation, from console i can access using them.

mysql.sock permissins are 777
full path permissions are 755
path and files are owned by mysql/mysql

Any idea?
Thanks in advice and excuse for my little english.

Edit:
I was finding a way to get the glpi version, from yum: 0.83.8-1.el6
Thanks

Last edited by m.forlani (2013-08-23 13:35:05)

Offline

#2 2013-08-23 13:34:50

m.forlani
Member
Registered: 2013-08-22
Posts: 2

Re: [SOLVED] Problems with connecting to mysql

Found solution by myself.
Edited config_db.php:
Use 127.0.0.1 instead of localhost as server
Changed user permission (from any host)

Please close this topic.

Offline

Board footer

Powered by FluxBB