Bug #77190 Default connection attributes to include more data
Submitted: 29 May 2015 8:43 Modified: 19 Nov 2015 15:20
Reporter: Shlomi Noach Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: C API (client library) Severity:S4 (Feature request)
Version:>= 5.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: connection attributes, connectors

[29 May 2015 8:43] Shlomi Noach 
Description:
For all official connectors (I am unable to choose multiple for this bug report), the default connection attributes should also include, where possible:

- Username/login -- the name of the user running the process identified by _pid
- Hostname -- the name by which the host of the originating connection identifies itself -- this may be different from the hostname resolved by MySQL

How to repeat:
-

Suggested fix:
Add `_login` and `_hostname` as new default connection attributes
[1 Jun 2015 10:40] Daniël van Eeden 
Patch:
https://github.com/mysql/mysql-server/pull/10
[4 Jun 2015 14:20] Shlomi Noach 
I wish to add a simple and common use case; MySQL's interpretation of the originating hostname may be different than the true originating hostname; either due to DNS and resolving issues, or due to proxies (e.g. HAProxy) standing in the middle. 
Hence providing the _hostname as connection attribute can be sometime the only way of learning the true source of connection.
[29 Jun 2015 17:27] Daniël van Eeden 
The related bug: https://bugs.mysql.com/bug.php?id=77228
[19 Nov 2015 15:20] Georgi Kodinov 
Thank you for the reasonable feature request. Even if the bug # is lower I'd like to close it as a duplicate of Daniel's bug (77228) if that's ok with you.