[MXS-40] Display logged in users Created: 2015-03-13  Updated: 2015-05-13  Resolved: 2015-05-13

Status: Closed
Project: MariaDB MaxScale
Component/s: None
Affects Version/s: 1.0.5
Fix Version/s: 1.2.0

Type: New Feature Priority: Major
Reporter: Joffrey MICHAIE (Inactive) Assignee: Timofey Turenko
Resolution: Fixed Votes: 0
Labels: None


 Description   

Hi,

when my application is connected to maxscale, i don't see the originating IP on my MySQL/MariaDB database in show processlist.

Is it possible to get this information via maxadmin?

I would like to be able to see, a bit like in show processlist (very simple example)
mysqluser @ client_host connected to 'service', since xxx, idle for xxx seconds

Thanks in advance!
Joffrey

 Comments   
Comment by markus makela [ 2015-05-13 ]

Added output into show sessions.

example output:

Session 54 (0x226d0c60)
State: Session ready for routing
Service: SchemaRouter Router (0x1c1347f0)
Client DCB: 0x2182d5e0
Client Address: tester@127.0.0.1
Connected: Wed May 13 14:59:50 2015
Idle: 0 seconds

Comment by Timofey Turenko [ 2015-05-13 ]

reopen to set correct resolution

Comment by Timofey Turenko [ 2015-05-13 ]

checked manually:
Session 13 (0x1b89bd0)
State: Session ready for routing
Service: RW Split Router (0x1b7a590)
Client DCB: 0x1b782c0
Client Address: skysql@192.168.122.1
Connected: Wed May 13 15:17:10 2015
Idle: 2 seconds

Generated at Thu Feb 08 03:56:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.