[jira] [Comment Edited] (GUACAMOLE-760) add timezone info using DB Connection string

["Michael Stoffel (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/GUACAMOLE-760?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17068795#comment-17068795 ] 

Michael Stoffel edited comment on GUACAMOLE-760 at 3/27/20, 3:07 PM:
---------------------------------------------------------------------

[~jon@jondrews.com] Could you please provide more info on what you did? Every time I try to reload mysql after that it is failing. Also using 18.04 LTS.

sudo systemctl restart mysql
 Job for mysql.service failed because the control process exited with error code.
 See "systemctl status mysql.service" and "journalctl -xe" for details.


was (Author: guiltykeyboard):
Could you please provide more info on what you did? Every time I try to reload mysql after that it is failing. Also using 18.04 LTS.

sudo systemctl restart mysql
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.

> add timezone info using DB Connection string
> --------------------------------------------
>
>                 Key: GUACAMOLE-760
>                 URL: https://issues.apache.org/jira/browse/GUACAMOLE-760
>             Project: Guacamole
>          Issue Type: Improvement
>          Components: guacamole-client
>    Affects Versions: 1.0.0
>            Reporter: Not Speedy
>            Assignee: Nick Couchman
>            Priority: Minor
>
> 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.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)