[MXS-1627] MySQLAuth loads users that use authentication plugins Created: 2018-01-25  Updated: 2019-05-22  Resolved: 2018-01-29

Status: Closed
Project: MariaDB MaxScale
Component/s: Authenticator
Affects Version/s: 2.1.13
Fix Version/s: 2.1.14

Type: Bug Priority: Major
Reporter: markus makela Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
causes MXS-1693 In Maxscale 2.2.2 getting users with ... Closed
Relates
relates to MXS-2494 MySQLAuth load users query doesn't ch... Closed

 Description   

The MySQLAuth authenticator loads all users regardless of the authentication plugin they use. This means that MaxScale does authentication with users as if they used the default authentication plugin when in reality they use a specific plugin. The problem with this is that any user that uses an authentication plugin, will have an empty password and will appear to behave like a normal user without a password.

The correct behavior is to add a WHERE clause that has plugin = ''.



 Comments   
Comment by markus makela [ 2018-01-29 ]

Fixed in 6068850b181e5af1451a6668a227eb97212965e6.

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