[GUACAMOLE-339] Add Remote Host IP to Guacamole Connection History table

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.9.12-incubating
• Fix Version/s: 0.9.14
• Component/s: guacamole-auth-jdbc, guacamole-auth-jdbc-mysql, guacamole-auth-jdbc-postgresql, guacamole-client
• Assignee: Nick Couchman
• Reporter: Juan Delard de Rigoulières
• Created: 03/Jul/17 22:53
• Updated: 17/Jul/17 13:15
• Resolved: 17/Jul/17 13:15

Description

Guacamole currently stores the following fields in the :

user_id
username
connection_id
connection_name
sharing_profile_id
sharing_profile_name
start_date
end_date

This tickets is to add the "Remote Host IP Address" (remote_ip) as a new column in that table. Extremely useful for security, reporting, etc. The value is already available. (it's present in for Active Sessions)