guacamole-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <harry.dev...@faa.gov>
Subject RE: Database issue installing version 1.0.0
Date Thu, 28 Mar 2019 15:06:40 GMT
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 <mjumper@apache.org>
Sent: Thursday, March 28, 2019 11:02 AM
To: user@guacamole.apache.org
Subject: Re: Database issue installing version 1.0.0

On Thu, Mar 28, 2019 at 6:49 AM <harry.devine@faa.gov<mailto:harry.devine@faa.gov>>
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

Mime
View raw message