The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Unable to use host/mask grants access rules with maxscale

When I'm trying to run MaxScale I've got a below errors: {code} 2016-10-16 17:30:20 notice : Server changed state: db2[172.28.11.72:3306]: new_master. [Running] -> [Master, Running] 2016-10-16 17:30:20 notice : Server changed state: db1[172.28.11.71:3306]: new_slave. [Running] -> [Slave, Running] 2016-10-16 17:30:20 notice : A Master Server is now available: 172.28.11.72:3306 2016-10-16 17:30:20 error : Failed to obtain address for host db%.rn, Name or service not known 2016-10-16 17:30:20 warning: Failed to add user mon_check@db%.rn. for service [Read-Only Service]. This user will be unavailable via MaxScale. 2016-10-16 17:30:20 error : Failed to obtain address for host 172.28.11.0/255.255.255.0, Name or service not known 2016-10-16 17:30:20 warning: Failed to add user user@172.28.11.0/255.255.255.0 for service [Read-Only Service]. This user will be unavailable via MaxScale. 2016-10-16 17:30:20 error : Failed to obtain address for host 172.28.11.0/255.255.255.0, Name or service not known 2016-10-16 17:30:20 warning: Failed to add user user@172.28.11.0/255.255.255.0 for service [Read-Only Service]. This user will be unavailable via MaxScale. 2016-10-16 17:30:20 error : Failed to obtain address for host 172.28.11.0/255.255.255.0, Name or service not known 2016-10-16 17:30:20 warning: Failed to add user user@172.28.11.0/255.255.255.0 for service [Read-Only Service]. This user will be unavailable via MaxScale. 2016-10-16 17:30:20 error : Failed to obtain address for host 172.28.11.0/255.255.255.0, Name or service not known 2016-10-16 17:30:20 warning: Failed to add user user@172.28.11.0/255.255.255.0 for service [Read-Only Service]. This user will be unavailable via MaxScale. 2016-10-16 17:30:20 notice : Loaded 16 MySQL Users for service [Read-Only Service]. {code}

1st question: is it a bug or a feature? 2nd question: can I use "wildcard" ("%") in hostnames as in example for user mon_check. Hosts db2.rn and db3.rn exist and resolvable via DNS in local network Thanks.

http://dev.mysql.com/doc/refman/5.7/en/connection-access.html

Answer Answered by Markus Mäkelä in this comment.

Hi,

MaxScale is currently missing the netmask based grant detection. You can work around this by using the wildcard characters in place of the netmask if you use an IP address. MaxScale does not yet support wildcards in hostnames.

This missing feature for netmasks has already been reported here and the wildcards in hostnames is reported here. Please vote and comment on the issues to signal that they are important to you. We aim to prioritize fixes that affect users.

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.