[MXS-3167] Access Denied for User Error when Upgrading to 2.5.x and Using Binlogrouter Created: 2020-09-09  Updated: 2020-09-24  Resolved: 2020-09-23

Status: Closed
Project: MariaDB MaxScale
Component/s: Monitor
Affects Version/s: None
Fix Version/s: 2.5.4

Type: Bug Priority: Major
Reporter: Maria M Pflaum Assignee: Niclas Antti
Resolution: Fixed Votes: 0
Labels: None

Sprint: MXS-SPRINT-115

 Description   

When upgrading from MaxScale 2.4.x or lower to 2.5.x or higher there is a new requirement for server=<server list>
to be added to the binlogrouter . If this is not included Maxscale gives an Access denied error:

ERROR 1045 (28000): Access denied for user...

It would be great to get a more informational error message, maybe something like "no servers defined for binlogrouter"
see: https://mariadb.com/kb/en/mariadb-maxscale-25-binlogrouter/
"The list of servers where the database users for authentication are loaded must be explicitly configured with the servers or targets parameter."



 Comments   
Comment by Niclas Antti [ 2020-09-23 ]

This seems to have been fixed already. This is a service message, not specifically binlogrouter.
error : No valid servers from which to query MariaDB user accounts found.

Generated at Thu Feb 08 04:19:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.