[MXS-4084] Client port is not in 'maxctrl show sessions' output Created: 2022-04-07  Updated: 2022-07-07  Resolved: 2022-04-22

Status: Closed
Project: MariaDB MaxScale
Component/s: maxctrl, REST-API
Affects Version/s: 6
Fix Version/s: 6.3.1

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


 Description   

When displaying the output from 'maxctrl show sessions' or 'maxctrl list sessions' as well as the remote clients ip address it would be useful to see the remote clients port number in the same way that the remote port number is displayed by the database when 'show processlist' is run. For example:

[root@ip-172-16-12-13 ~]# maxctrl show sessions
.
.
├───────────────────┼──────────────────────────┤
│ Host │ ::ffff:172.16.12.224 │ <------ current output
├───────────────────┼──────────────────────────┤
.
.

[root@ip-172-16-12-13 ~]# maxctrl show sessions
.
.
├───────────────────┼──────────────────────────┤
│ Host │ ::ffff:172.16.12.224:12345 │ <------ desired output
├───────────────────┼──────────────────────────┤
.
.

This would help in identifying which process on the remote client has established the connection to Maxscale.



 Comments   
Comment by markus makela [ 2022-04-08 ]

That's a good point, the IP alone isn't enough to identify which process owns it. Should be easy to add.

Comment by markus makela [ 2022-04-08 ]

I changed this to a bug as it really should've been there in the first place.

Comment by markus makela [ 2022-04-22 ]

Added the client port to the show sessions output.

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