Changeing servers - unable to connect to mysql

Plight · 2009-03-04 23:38:29

We are putting glpi on a newer server and are leaving the database on the previous box. I can not get the GLPI installer to recognize the MYSQL database on the older server.

I get this error:

Can't connect to the database :
The server answered : Can't connect to MySQL server on 'helpdesk' (13)

I can connect to the db fine from the console of the new server, its only through the GLPI installer that I can not connect. The older server used localhost of course and did not have this issue.

Im still learning linux so please bare with me!

JMD · 2009-03-05 00:25:57

What is the content of config_db.php ? did your change the host of mysql in ?

Plight · 2009-03-05 00:55:22

I figured it out. It was SElinux preventing apache from connecting to the sql db port.

Then I connected it to the database and it wiped my older database. I wasnt thinking and because they were different versions (old install was 71.3) and I did not choose upgrade, it wiped my existing database. Luckily I had a backup and we just lost a few hours.

Yall need to put a warning on that install script that if you choose a existing database, the data will be wiped if its not the same version. I know it was my fault that it happened (my first foray into a sql based app), but it may be useful for others that do not have a backup job running.

JMD · 2009-03-05 01:06:58

Ok i close.

apt-get install brain ?

Forum GLPI-Project

Announcement

#1 2009-03-04 23:38:29

Changeing servers - unable to connect to mysql

#2 2009-03-05 00:25:57

Re: Changeing servers - unable to connect to mysql

#3 2009-03-05 00:55:22

Re: Changeing servers - unable to connect to mysql

#4 2009-03-05 01:06:58

Re: Changeing servers - unable to connect to mysql

Board footer