Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.5.3
-
None
-
Percona XtraDB cluster 5.7.29
-
MXS-SPRINT-117
Description
Dear all,
Since the migration to Maxscale 2.4 -> 2.5 (worked well in 2.4), we cannot connect to any database via mysql command:
mysql -u test -ptest -P 3306 -h XXXX: works
mysql -u test -ptest -P 3406 -h XXXX: doesn't works: ERROR 1044 (42000): Access denied for user 'test '@'XXXX' to database 'test'
SELECT permissions has been added to tables_priv & columns_priv also. Not added for roles_mapping because this table doesn't exist with Percona.
Maxscale logs (with info):
2020-09-10 16:53:39 info : (1) Found matching user entry 'test'@'%' for client 'test'@'XXXX' but user does not have access to database 'test'.
|
2020-09-10 16:53:39 info : Read 28 user@host entries from 'XXXX' for service 'XX-Service'. The data was identical to existing user data.
|
2020-09-10 16:53:39 warning: (1) [mariadbclient] Authentication failed for user 'test'@[XXXX] to service 'XX-Service'. Originating listener: 'XX-Listener'.
|
MariaDB error: 'Access denied for user 'test'@'XXXX' to database 'test''.
|
2020-09-10 16:53:39 info : Stopped XX-Service client session [1]
|
Maxscale conf:
[maxscale]
|
threads=auto
|
writeq_high_water=64Mi
|
writeq_low_water=32Mi
|
|
|
[XXXX1]
|
type=server
|
protocol=MariaDBBackend
|
address=XXXX1
|
port=3306
|
priority=2
|
|
|
[XXXX2]
|
type=server
|
protocol=MariaDBBackend
|
address=XXXX2
|
port=3306
|
priority=1
|
|
|
[MariaDB-Monitor]
|
type=monitor
|
module=galeramon
|
servers=XXXX1,XXXX2
|
user=XX
|
password=XX
|
monitor_interval=2000
|
available_when_donor=true
|
use_priority=true
|
|
|
[dt-acc-db-Service]
|
type=service
|
router=readwritesplit
|
servers=XXXX1,XXXX2
|
user=XX
|
password=XX
|
connection_keepalive=10
|
|
|
[XX-Listener]
|
type=listener
|
service=XX-Service
|
protocol=MariaDBClient
|
address=0.0.0.0
|
port=3406
|
Best regards,