Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Sun May 28, 2017 1:32 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: ERROR: Your MySQL TimeZone database is not populated
PostPosted: Fri Feb 17, 2017 9:42 pm 
Offline

Joined: Tue Sep 23, 2008 12:44 pm
Posts: 23
Received this error on upgrade from 1.0.2 to 1.0.3

What do I need to change to get it to pass the pre-install check?



mysql> show variables like '%time_zone%';
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| system_time_zone | Pacific Standard Time |
| time_zone | SYSTEM |
+------------------+-----------------------+
2 rows in set (0.00 sec)

mysql>


Top
 Profile  
 
 Post subject: Re: ERROR: Your MySQL TimeZone database is not populated
PostPosted: Sun Feb 19, 2017 10:29 pm 
Offline

Joined: Wed Nov 23, 2016 2:42 am
Posts: 44
I dont know if this may help you. But I solved my timezone table by:
- Downloading timezone_2016j_posix_sql.zip in http://dev.mysql.com/downloads/timezones.html
- Then go to cmd and type this mysql -u root mysql < file_name
- Restart server

Steps above came from this link https://dev.mysql.com/doc/refman/5.7/en ... pport.html


Top
 Profile  
 
 Post subject: Re: ERROR: Your MySQL TimeZone database is not populated
PostPosted: Tue Feb 21, 2017 4:28 pm 
Offline

Joined: Mon Apr 11, 2011 9:21 am
Posts: 32
The above is missing some steps.

http://dev.mysql.com/downloads/timezones.html

Download the appropriate file. Then unzip the .sql file.

From cmd run mysql -u root -p mysql < file_name.sql
Then type mysql -u root -p and enter your root password for MySQL.

Next type: grant select on mysql.time_zone_name to 'cactiuser'@'localhost' identified by 'cactiuser';
Then type: flush priveleges;

No need to reboot. If you refresh the page you shouldn't get the error again.

_________________
Operating System: Windows 7 Pro x64
Webserver: Apache 2.2.22
Cacti: .8.8G
Spine: .8.8A (Yes this is correct :-/, but I think I'm using CMD.PHP )
MySQL: 5.5.27 (x86)
PHP: 5.3.17
RRDTool (Cygwin or Win32 version): win32 1.4.5
Net-SNMP: 5.5
Cygwin (cygwin1.dll version): 1007.9.0.0


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

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 4 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