Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Failed to Create galera users #67

Open
gaolitao opened this issue Feb 21, 2020 · 0 comments
Open

Failed to Create galera users #67

gaolitao opened this issue Feb 21, 2020 · 0 comments
Assignees

Comments

@gaolitao
Copy link
Collaborator

From the exception message, address of '172.20.1.154' is used for the mysql client address which is not allowed.

TASK [galera_server : Create galera users] *************************************
Friday 21 February 2020  01:56:25 -0500 (0:00:00.085)       0:00:50.477 *******
<controller-1> Because this is a task using "delegate_to" pipelining has been disabled. but will be restored upon completion of this task.
FAILED - RETRYING: Create galera users (3 retries left).
FAILED - RETRYING: Create galera users (2 retries left).
FAILED - RETRYING: Create galera users (1 retries left).
failed: [controller-1 -> 172.20.1.154] (item={u'priv': u'*.*:ALL,GRANT', u'state': u'present', u'password': u'Z-2cce26ccd06fa155', u'host': u'%', u'name': u'root'}) => {"attempts": 3, "changed": false, "failed": true, "item": {"host": "%", "name": "root", "password": "Z-2cce26ccd06fa155", "priv": "*.*:ALL,GRANT", "state": "present"}, "msg": "unable to connect to database, check login_user and login_password are correct or /home/root/.my.cnf has the credentials. Exception message: (1130, \"Host '172.20.1.154' is not allowed to connect to this MariaDB server\")"}

And the address of '172.20.1.154' is configured on vlan144@eno1, this infra_internal network plane configured in user_config.yaml

    infra_internal:
        network_domains:
            rack-1:
                cidr: 172.20.1.152/29
                vlan: 144
                ip_range_start: 172.20.1.154
                ip_range_end: 172.20.1.158
16: vlan144@eno1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP group default qlen 1000
    link/ether ec:f4:bb:db:98:40 brd ff:ff:ff:ff:ff:ff
    inet 172.20.1.154/29 brd 172.20.1.159 scope global vlan144
       valid_lft forever preferred_lft forever
@gaolitao gaolitao self-assigned this Feb 21, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant