Error After Change Server's IP

[Aulia Dani]

Hi everyone,

I've already installed iTop (x.x.x.11) on virtual server (php virtualbox) and now it's running well. I also made a rsync script to backup iTop (i just copy the vdi file).

Last week i needed to create another iTop server for testing purposes. So i made a clone from the vdi backup and i configure it to new ip address (x.x.x.22). At the first time it show an error with mysql (the service won't start) but then i solved it.

When i tried to start the setup file (x.x.x.22/setup) it show an erro like below:

Fatal error, iTop cannot continue.

Error: Failed to issue SQL query: query = SELECT COUNT(DISTINCT COALESCE(`Organization_organization`.`id`, 0)) AS COUNT FROM `organization` AS `Organization_organization` WHERE 1, mysql_error = MySQL server has gone away, mysql_errno = 2006.

It also give me an error when backup the database (error dumping database with table attachment)

Failed to execute mysqldump: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `attachment` at row: 5601

, and if i unthick the option for backup it give me these error:

Fatal error:  Call to a member function query() on a non-object in /var/www/html/itop/core/cmdbsource.class.inc.php on line 366

Is there any solution for this? Any suggestion or solution will be appreciate.



Thanks,

Dani

[Jeffrey Bostoen]

Seems to be a MySQL-error rather than an iTop error. Have you checked if the config of your clone's iTop refers to the proper database server?

[Aulia Dani]

Hi Jeffrey,
Yes i had. I just changed my ip, that's it. Any clue for mySQL setting?
Thank