Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri May 25, 2018 9:29 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: [Solved] - MySQL TimeZone Database Error
PostPosted: Fri Mar 09, 2018 5:03 am 
Offline
Cacti User

Joined: Wed Oct 29, 2014 5:08 am
Posts: 89
Did search alot and still could not fix by myself

I done below step still not work
under php.ini
[Date]
date.timezone="Asia/Hong_Kong"

under mysql -> bin -> my.ini
[mysql]
[Date]
;Defines the default timezone used by the date functions
Date.timezone = Asia/Hong_Kong

Saw few post about "mysql_tzinfo_to_sql — Load the Time Zone Tables"
But I have no idea how to start? (is that a .sql table import to?)
Have some expert can sharp the full step how to config ?


Attachments:
Untitled.png
Untitled.png [ 12.13 KiB | Viewed 249 times ]


Last edited by areast on Sun Mar 11, 2018 9:23 pm, edited 1 time in total.
Top
 Profile  
 
 Post subject: Re: MySQL TimeZone Support ERROR: Your MySQL TimeZone datab
PostPosted: Fri Mar 09, 2018 11:42 am 
Offline
Cacti Pro User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 994
.

_________________
Cacti Resources:
Cacti Website
Cacti Issues
Cacti Releases

My resources:
How to submit Pull Requests
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Last edited by netniV on Sat Mar 10, 2018 2:11 am, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: MySQL TimeZone Support ERROR: Your MySQL TimeZone datab
PostPosted: Fri Mar 09, 2018 7:18 pm 
Offline

Joined: Wed Mar 01, 2017 2:34 pm
Posts: 36
areast wrote:
Saw few post about "mysql_tzinfo_to_sql — Load the Time Zone Tables"
But I have no idea how to start? (is that a .sql table import to?)
Have some expert can sharp the full step how to config ?

The time zone table in mysql is a different thing than setting a timezone in php.ini.
That table has to be filled with the all of the timezone information that is installed on the system. There is a program that reads this data and produces a *.sql file with INSERT INTO statements to populate that table.
The program is mysql_tzinfo_to_sql and is contained in the mysql-server package (or mariadb-server, if you use mariadb instead of mysql).
Call "man mysql_tzinfo_to_sql" to get command line parameter help. It is probably called as "mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql" to populate the table in one step, but depending on your system the directory may vary or the mysql user.


Top
 Profile  
 
 Post subject: Re: MySQL TimeZone Support ERROR: Your MySQL TimeZone datab
PostPosted: Sun Mar 11, 2018 9:22 pm 
Offline
Cacti User

Joined: Wed Oct 29, 2014 5:08 am
Posts: 89
Hi Tertius
Thanks for explain

I did solve "MySql timezone" with below step

http://www.geeksengine.com/article/popu ... mysql.html

Download the "timezone_2018c_posix" and paste under MySql -> Data


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group