[Solved] Restoring Cacti to an other Server.

[Maximeva]

Hello,
I am actually doing an internship in a company and I am using Cacti for my project.
I installed it on a "Test machine" and when it was working I installed it on a real server and now it's in use on the network of the company.
But they asked me to show them that the backup/restore was working. So I have to take a backup of my "real cacti server" and to put it on my "Test machine" (Same os on both, CactiEZ on CentOS 6.3 )

But It's not working ! At first it told me about an sql error in "/include/config.php" file when trying to go on the web interface.
I guess it's normal beacause the Sql password on my test machine and on my real server wasn't the same. I changed the password in the file with the good one, but now I have an other error :

Code: Select all

Warning: Mysqli_real_connect():(28000/1045): Acces denied for user 'cactiuser@localhost' (using password:YES) in /var/www/html/lib/adodb/drivers/adodb-mysqli.inc.php on line 83 Can not connect

I took a look at the file, but I can't see where is the problem..Can anyone help me to find what i should change ?
My restore have to work for the end of the week, it's imperative

Thanks in advance !

[BSOD2600]

are you certain the cactiuser pw is correct on the new server? That error message would lead one to believe otherwise.

[Maximeva]

Yes i'm pretty sure because when I set intentionally a bad password in /includ/config.php I get an other error :

Code: Select all

FATAL: cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'

And when I change for the good password, the error change to :

Code: Select all

Warning: Mysqli_real_connect():(28000/1045): Acces denied for user 'cactiuser@localhost' (using password:YES) in /var/www/html/lib/adodb/drivers/adodb-mysqli.inc.php on line 83 Can not connect

I don't understand..

[Maximeva]

I solved it.
Instead of searching all the files where i should change the password to match with the sql password.
I did the opposite, Ichanged the cactiuser password of my sql base to match with the one used in the backup files.