OK, so I set the timezone to be ‘America/New_York’ as described here: https://mariadb.com/kb/en/library/time-zones/. Will I have to do this every time the guacd or mariadb services are restarted?
Thanks, Harry From: Nick Couchman <[email protected]> Sent: Thursday, March 28, 2019 9:35 AM To: [email protected] Subject: Re: Database issue installing version 1.0.0 On Thu, Mar 28, 2019 at 9:01 AM <[email protected]<mailto:[email protected]>> wrote: We have a new machine that we’re setting up with Guacamole, and I’m putting version 1.0.0 on it (we have 2 others that are running 0.9.13 currently). When I try to implement the MySQL database portion, I’m getting the following errors in /var/log/messages (this is a RHEL 7.6 server): Mar 28 08:56:26 armt server: Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. Interesting. This might merit a JIRA issue - looks like a warning that we need to change the JDBC driver. Mar 28 08:56:26 armt server: 08:56:26.452 [http-bio-8080-exec-5] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: Mar 28 08:56:26 armt server: ### Error querying database. Cause: java.sql.SQLException: The server time zone value 'EDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support. Looks like this: https://issues.apache.org/jira/browse/GUACAMOLE-760 -Nick
