Migration of Joomla in 1.4 -- mysql issue

[crewze]

I tried migrating the Joomla VM on 1.4 today and it seemed to go over OK but then would not work as it could not connect to the mysql database.

After poking around it looks like the root password did not get copied across. I started up mysql in safe mode and set the root password and then everything worked OK.

Is this the way it is suppose to work?

I would assume that a migrated VM should come up and work.

 

[apmuthu]

Stop the Joomla VZ container and take a backup. Restore the backup in the v1.4 machine. If it does not work, then the Restore functionality in v1.4 is not backwards compatible.

 

[dietmar]

After poking around it looks like the root password did not get copied across.

Is that problem reproducable?

 

[crewze]

Yes and no --- I migrated back to the original node today and exactly the same problem occurred. The VM appears to migrate fine but when you browse to the VM you get the following:

Database Error: Unable to connect to the database:Could not connect to MySQL

When you ssh to the VM and try to connect to mysql you get the following error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

When I try to restart the mysql server it fails:

joomla:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld failed!
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

I the restrat the VM and then everything works!

So it looks like the VM needs to be restarted after the migration but this time the password did not need to be changed.