Possible issues with migration from VMmanager 5

This article contains information about errors that occur when migrating from VMmanager 5 to VMmanager 6.

Error 1130: Host '127.0.0.1' is not allowed to connect to this MariaDB server

The error occurs if the vmmgr user does not have sufficient permissions to access the database on a server with VMmanager 5.

Solution

1. Connect to the server with VMmanager 5 via SSH.

2. Open the database console:

   mysql

3. Allow access from the local IP address 127.0.0.1:

   GRANT ALL PRIVILEGES ON *.* TO 'vmmgr'@'127.0.0.1';

   FLUSH PRIVILEGES;

4. Define the password hash for the vmmgr user:

   SELECT user,host,password FROM mysql.user WHERE user='vmmgr';

   The hash value is stored in the password column.

   Example answer

   +-------+-----------+-------------------------------------------+
   | user  | host      | password                                  |   
   +-------+-----------+-------------------------------------------+
   | vmmgr | localhost | *25221266341B6A49D82711291F47556E6D716    |
   +-------+-----------+-------------------------------------------+

5. Set the password for the vmmgr user again:

   UPDATE mysql.user SET password='<hash>' WHERE user='vmmgr' AND host='127.0.0.1';

   Comments to the command

   <hash> — hash value received in the previous query

6. Exit the database console:

   exit