[
https://issues.apache.org/jira/browse/GUACAMOLE-760?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16891707#comment-16891707
]
Whitemoon edited comment on GUACAMOLE-760 at 7/25/19 12:43 PM:
---------------------------------------------------------------
After some tests i found a solution that works for me. I use as database server
MariaDB (10.1.40-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04).
Execute follow command:
{code:java}
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
{code}
Add follow lines into the file /etc/mysql/mariadb.conf.d/50-server.cnf:
{code:java}
[mysqld]
...
# Timezone
default_time_zone=Europe/Berlin
...
{code}
Don't forget to adjust the timezone for your environment.
After an restart of the database service (in my case mariadb), the error had be
gone.
was (Author: whitemoon):
After some tests i found a solution that works for me. I use as database server
MariaDB (10.1.40-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04).
Execute follow command:
{code:java}
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
{code}
Add follow lines into the file /etc/mysql/mariadb.conf.d/50-server.cnf:
{code:java}
[mysqld]
...
# Timezone
default_time_zone=Europe/Berlin
...
{code}
Don't forget to adjust the timezone for your environment.
After an restart of the database server, the error had be gone.
> 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
> 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
(v7.6.14#76016)
