[MXS-2174] MaxScale returns different error messages for authentication failures Created: 2018-11-19  Updated: 2020-03-27  Resolved: 2020-03-11

Status: Closed
Project: MariaDB MaxScale
Component/s: Authenticator
Affects Version/s: None
Fix Version/s: 2.5.0

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


 Description   

The error messages are not consistent with a direct connection:

Non-existent user
 
Wrong error: `Access denied for user 'not-a-user'@'' (using password: YES) to database 'test'` (original: `Access denied for user 'not-a-user'@'' (using password: YES)`)
 
0.074041: TEST_FAILED! readwritesplit returned wrong error
 
Wrong error: `Access denied for user 'not-a-user'@'' (using password: YES) to database 'test'` (original: `Access denied for user 'not-a-user'@'' (using password: YES)`)
 
0.074056: TEST_FAILED! readconnroute returned wrong error
 
Wrong password
 
No permissions on database
 
Wrong error: `Access denied for user 'bob'@'' (using password: YES) to database 'error_messages'` (original: `Access denied for user 'bob'@'' to database 'error_messages'`)
 
0.128459: TEST_FAILED! readwritesplit returned wrong error
 
Wrong error: `Access denied for user 'bob'@'' (using password: YES) to database 'error_messages'` (original: `Access denied for user 'bob'@'' to database 'error_messages'`)
 
0.128474: TEST_FAILED! readconnroute returned wrong error

There is a test case for this, error_messages, where the success criteria is inverted. Once this is fixed, the test also needs to be updated.
Generated at Thu Feb 08 04:12:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.