[GUACAMOLE-760] add timezone info using DB Connection string

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Implemented
• Affects Version/s: 1.0.0
• Fix Version/s: 1.3.0
• Component/s: Documentation, guacamole-client
• External issue URL: https://lists.apache.org/thread.html/4a6c14efd55da900f5b7a786f3e7eaae6347805d4a6c9626d3d384c2@%3Cuser.guacamole.apache.org%3E
• Assignee: Nick Couchman
• Reporter: Not Speedy
• Created: 22/Mar/19 13:40
• Updated: 29/Oct/20 11:00
• Resolved: 29/Oct/20 11:00

Description

a recent update to with mariadb or its driver prevented guacamole client from loading. 

Cause: java.sql.SQLException: The server time zone value 'CDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property).....

loading the timezone table and setting it globally on the mariadb resolved this, however it might be beneficial to add a system property that will set within the connection string.

Issue Links

• is duplicated by: GUACAMOLE-983 "mysql" authentication provider has encountered an internal error