[GUACAMOLE-95] Sessions do not appear in the usage history of a connection when using postgresql

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 0.9.10-incubating
• Fix Version/s: 0.9.10-incubating
• Component/s: guacamole-auth-jdbc-postgresql
• Assignee: Mike Jumper
• Reporter: L.J. van Ruiten
• Created: 26/Aug/16 17:15
• Updated: 04/Dec/16 00:28
• Resolved: 26/Aug/16 18:15

Description

Using the current scripts to create a database for postgresql guacamole sessions (like VNC) will not appear in the usage history. This is due to the fact that the script will set the sharing_profile_name column in guacamole_connection_history to NOT NULL. If a session is not shared this is in fact NULL and an exception is thrown when guacamole attempts to save the session to the database.

Issue Links

• relates to: GUACAMOLE-5 Allow creation of per-connection share links