[MXS-4230] Maxscale doesn't match regex user's host Created: 2022-08-02  Updated: 2022-09-19  Resolved: 2022-09-01

Status: Closed
Project: MariaDB MaxScale
Component/s: mariadbbackend
Affects Version/s: 6.3.1
Fix Version/s: 6.3.1

Type: Bug Priority: Major
Reporter: Pon Suresh Pandian (Inactive) Assignee: Esa Korhonen
Resolution: Not a Bug Votes: 0
Labels: maxscale
Environment:

Red Hat Enterprise Linux release 8.6 (Ootpa)


Attachments: Text File Maxscale_config_test.txt    
Sprint: MXS-SPRINT-164, MXS-SPRINT-165

 Description   

Hi Team,

When I try to connect from host "maxscalecrit2.test.mariadb.it" to our database with user 'ejbca_text'@'max%' we receive: 'access denied'.

  1. mysql -u ejbca_text -p'xxx' -h 'maxscalecrit2.test.mariadb.it' -P4006 -e "select @@hostname;"
    ERROR 1927 (HY000) at line 1: Authentication to 'server1' failed: 1698, #28000: Access denied for user 'ejbca_text'@'ip-172-31-25-182.ec2.internal' (server1)

Here I have attached my config file for your reference please check it..

MariaDB user details..

MariaDB [(none)]> select user,host from mysql.user;
+--------------+-----------+
| User         | Host      |
+--------------+-----------+
| mariadb_test | %         |
| max_user     | %         |
| mariadb.sys  | localhost |
| mysql        | localhost |
| root         | localhost |
| ejbca_text        | max%      |
+--------------+-----------+
6 rows in set (0.001 sec)


Generated at Thu Feb 08 04:27:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.