Answer the question
In order to leave comments, you need to log in
Why does mascale sometimes fail to authorize a user despite valid credentials?
Hello.
There is maxscale + Galera Cluster (2 nodes Percona 5.7+ arbitrator), configured to separate write operations (we write to only one node) and reads (read from both nodes).
The problem is that in the maxscale logs once a minute or a little less often there are entries like
Sep 14 21:03:01 maxscale2 maxscale[9394]: [MySQLAuth] Splitter Service: login attempt for user 'username'@[10.20.30.40]:54198, authentication failed.
Sep 14 21:03:01 maxscale2 maxscale[9394]: [MySQLAuth] [Splitter Service] Loaded 55 MySQL users for listener Splitter Listener.
php: /var/lib/asterisk/agi-bin/lib/adodb/drivers/adodb-mysqli.inc.php[109]: mysqli_real_connect(): (28000/1045): Access denied for user 'username'@'xxxx ' (using password: YES) to database 'DATABASE'
2017-09-15T08:43:18.376924+03:00 1038984 [Note] Aborted connection 1038984 to db: 'DATABASE' user: 'username' host: 'xxxx' (Got an error reading communication packets)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question