The Ultimate Guide to High Availability with MariaDB

Maxscale not connecting

Hi

We are trying to configure maxscale with 3 MariaDB in Galera cluster. But we are getting the below error ERROR 1130 (HY000): Host '*' is not allowed to connect to this MariaDB server

Also the client application is directly connecting to mariadb, but if we route it via maxscale it doesnt work and we get error stating. authentication failed.

Could you pls guide?

Thanks Mary

Answer Answered by Harry Pask in this comment.

If you are not using the proxy settings, have you added the maxscale IP to the user accounts? I prefer to use the proxy settings, so maxscale will send the original IP in the packet header.

In each node's my.cnf add the following (change the IPs base on the maxscale IP)

proxy-protocol-networks= 127.0.0.1,10.0.0.4

in Maxctrl add the following option to all servers

proxy_protocol=true

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.