I had to do the following:
1) mysql_tzinfo_to_sql /usr/share/zoneinfo/|mysql -u root mysql -p 2) From within MySQL: SET GLOBAL time_zone = 'America/New_York'; Then everything seemed to work. Thanks, Harry From: Mike Jumper <[email protected]> Sent: Thursday, March 28, 2019 11:02 AM To: [email protected] Subject: Re: Database issue installing version 1.0.0 On Thu, Mar 28, 2019 at 6:49 AM <[email protected]<mailto:[email protected]>> wrote: 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? Assuming you mean restarting Tomcat/Guacamole (only the webapp talks to MySQL / MariaDB, not guacd), no, this should have no effect on MariaDB. Restarting MariaDB may have an effect depending on how things were set. How did you set the timezone specifically? There are a few methods described at the page linked above, some of which (SET GLOBAL) will not persist across restarts. - Mike
