[MXS-1717] When having two listeners use the same service "show dbusers serviceName" shows the user list twice Created: 2018-03-12  Updated: 2018-03-15  Resolved: 2018-03-13

Status: Closed
Project: MariaDB MaxScale
Component/s: Authenticator, Core
Affects Version/s: None
Fix Version/s: 2.2.4

Type: Bug Priority: Major
Reporter: Hartmut Holzgraefe Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None


 Description   

When having two listeners use the same service, like here

[Service]
 
type=service
 
router=readwritesplit
 
servers=server1
 
max_slave_connections=100%
 
user=maxuser
 
passwd=secret
 
 
 
[Listener1]
 
type=listener
 
service=RWSm
 
protocol=MySQLClient
 
port=4006
 
 
 
[Listener2]
 
type=listener
 
service=RWSm
 
protocol=MySQLClient
 
port=4007

"show dbusers" shows the user information reported by both listeners on separate lines, but it is not distinguishable what users were reported by which listener:

MaxScale> show dbusers Service
 
User names: debian-sys-maint@localhost maxuser@% maxmon@% 
User names: debian-sys-maint@localhost maxuser@% maxmon@%



 Comments   
Comment by Johan Wikman [ 2018-03-13 ]

The output will now look like

MaxScale> show dbusers Service
 
User names (MyOneListener): debian-sys-maint@localhost maxuser@% maxmon@% 
User names (MyOtherListener): debian-sys-maint@localhost maxuser@% maxmon@%

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