maria-discuss team mailing list archive

[Micha Ballmann <ballmann@xxxxxxxxxxxxx>]

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