[MXS-1716] "show dbusers ...service..." returns empty list when using PAMAuth Created: 2018-03-12  Updated: 2020-08-25  Resolved: 2018-03-20

Status: Closed
Project: MariaDB MaxScale
Component/s: Authenticator
Affects Version/s: 2.2.3
Fix Version/s: 2.2.4

Type: Bug Priority: Major
Reporter: Hartmut Holzgraefe Assignee: Esa Korhonen
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MXS-2267 Document which accounts PAM authentic... Closed
relates to MXS-2493 Database users can't be queried with ... Closed

 Description   

The PAM authenticator retrieves users from the MariaDB server side in a similar way as the MySQL authenticator, retrieving all candidate users from the MariaDB side mysql.user table, just restricting the related query to users with "WHERE plugin = 'pam'".

So I'd expect it to return a list of users found this way on "show dbusers", but it just returns an empty list instead.

Looking at the code I can see that MyQLAuth implements its own mysql_auth_diagnostics() and mysql_auth_diagnostic_json() functions, while PAMAuth just uses the default users_default_diagnostic() and users_default_diagnostic_json() implementations.


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