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 : [email protected]
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
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
