Hello:
Have set up maxscale-1.2.1-1.x86_64 and trying to connect
it too a Galera three node cluster. When I start the service I am
getting:
2016-01-11 08:54:23 Error : Monitor was unable to connect to server
10.1.10.80:3306 : "Access denied for user 'sst_user'@'10.1.10.86' (using password: YES)"
2016-01-11 08:54:23 Error : Monitor was unable to connect to server
10.1.10.81:3306 : "Access denied for user 'sst_user'@'10.1.10.86' (using password: YES)"
2016-01-11 08:54:23 Error : Monitor was unable to connect to server
10.1.10.82:3306 : "Access denied for user 'sst_user'@'10.1.10.86' (using password: YES)"
and in /etc/maxscale.cnf I have:
[Galera Monitor]
type=monitor
module=galeramon
servers=dbc01,dbc02,dbc03
user=sst_user
passwd=*******
monitor_interval=15000
disable_master_failback=1
backend_connect_timeout=10
backend_read_timeout=10
backend_write_timeout=10
but if I try from the CLI using:
mysql -h 10.1.10.80 -P 3306 -u sst_user -p
and
enter the same password as specified in the configuration file it
connects fine. SSL is enabled on the cluster but is not required at
present.
What could be wrong please ?
Thanks.