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
    BASH

  3. Allow access from the local IP address 127.0.0.1:

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

  4. Define the password hash for the vmmgr user:

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

    The hash value is stored in the password column.

    Example answer

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

  5. Set the password for the vmmgr user again:

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

    <hash> — hash value received in the previous query

  6. Exit the database console:

    exit
    BASH