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

Connect to the server with VMmanager 5 via SSH.
Open the database console:
```
mysql
```

Allow access from the local IP address 127.0.0.1:

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

FLUSH PRIVILEGES;

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    |
+-------+-----------+-------------------------------------------+

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
Exit the database console:
```
exit
```