Unable to load '/usr/share/zoneinfo/iso3166.tab'
Posted: Thu May 07, 2015 1:33 pm
Timetrex couldn't load timezone was the error.
So I followed the forum answer which was:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -p -u root mysql
(I typed in the root password)
I got an error:
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
I was sure time and date were syncing correctly ntp already setup and working and server new the correct date and time.
I set the timezone again just for giggles:
( set time zone ) ln -sf /usr/share/zoneinfo/America/Chicago /etc/localtime
( restart mysql daemon ) /etc/init.d/mysqld restart.
and now I see no red at the top, how do I KNOW everything is now happy?
So I followed the forum answer which was:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -p -u root mysql
(I typed in the root password)
I got an error:
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
I was sure time and date were syncing correctly ntp already setup and working and server new the correct date and time.
I set the timezone again just for giggles:
( set time zone ) ln -sf /usr/share/zoneinfo/America/Chicago /etc/localtime
( restart mysql daemon ) /etc/init.d/mysqld restart.
and now I see no red at the top, how do I KNOW everything is now happy?