Hi, Have you tried whether this happens with the 2.4 version of MaxScale? If it doesn't, it sounds like it could be a bug in MaxScale 2.5. If it does happen even with 2.4, it is likely that the problem lies in the grants of that particular user. Check that you can connect to the database from both the host where the application connects to MaxScale as well as from the host where MaxScale is located. Markus On 11/20/20 6:53 PM, Micha Ballmann wrote:

Hi @all,

I have a problem and I stuck with MaxScale 2.5.

I deployed a 5 node galeracluster and installed MaxScale as proxy. First i thought everthing is fine. I can monitor and connect each galera node but i have a strange problem by connecting a client through the proxy.

I have a media wiki db and user.

user: wiki dbname: wiki permissions: grant all host: wiki@%

I can successful connect the dabatabse from my client server on cli like:

# mysql -u wiki -p jlkadjfg78 -h maxscale.example.com -> this ist working.

Now when configuring the database in media wiki my proxy throws the following error:

Nov 20 16:17:45 maxscale maxscale[12714]: (95) [mariadbclient] (process_authentication): User accounts have been recently updated, cannot update again for 'wiki'@'<IP.-from-media-wiki>'. Nov 20 16:17:45 maxscale maxscale[12714]: (95) [mariadbclient] (send_authetication_error): Authentication failed for user 'wiki'@['<IP.-from-media-wiki>] to service 'Galera-Service'. Originating listener: 'Galera-Listener'. MariaDB error: 'Access denied for user 'wiki'@''<IP.-from-media-wiki>' to database 'wiki''.

I dont know why access denied. I can connect with the local mysql client from the media wiki server. I checked the grants of my maxscale "admin" user (https://mariadb.com/kb/en/maxscale-troubleshooting/).

This is my maxscale config:

##################

# Globals [maxscale] threads                 = auto syslog                    = 1 maxlog                  = 1 log_augmentation      = 1 ms_timestamp            = 1

# Servers [maria1] type                    = server address              = 10.20.105.224 port                    = 3306 protocol             = MariaDBBackend

...

# Galera Monitor [Galera-Monitor] type                      = monitor module                = galeramon servers                 = maria1,maria2,maria3,maria4,maria5 user                      =maxscale password             =passwd monitor_interval= 2000

# Galera Router [Galera-Service] type                     = service router                  = readwritesplit servers                = maria1,maria2,maria3,maria4,maria5 user                     = maxscale password            = passwd

# Galera Listener [Galera-Listener] type                     = listener service                 = Galera-Service protocol              = MariaDBClient port                     = 3306 address               = 0.0.0.0

##################

I hope you can help. Feel free to ask for information. All servers are running on Ubuntu 20.04 - latest mariadb and maxscale.

Br

fettfoen

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

-- Markus Mäkelä, Senior Software Engineer MariaDB Corporation t: +358 40 7740484