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

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