Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Sat Mar 25, 2017 8:37 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: upgrade problem to cacti to 1.0.0
PostPosted: Wed Feb 01, 2017 9:41 am 
Offline

Joined: Wed Jan 25, 2017 4:27 am
Posts: 2
Hello, I have strange problem with upgrade process.

ERROR: Your MySQL TimeZone database is not populated. Please populate this database before proceeding.

please see attached file


Attachments:
Ashampoo_Snap_2017.02.01_18h40m12s_008_Cacti Server Installation-Upgrade - Mozilla Firefox.png
Ashampoo_Snap_2017.02.01_18h40m12s_008_Cacti Server Installation-Upgrade - Mozilla Firefox.png [ 175.09 KiB | Viewed 1935 times ]
Top
 Profile  
 
 Post subject: Re: upgrade problem to cacti to 1.0.0
PostPosted: Wed Feb 01, 2017 10:35 am 
Offline

Joined: Wed Jan 25, 2017 4:27 am
Posts: 2
I have searched and found solution.

if anyone has same problem please try.

vi /etc/my.cnf and add bellow lines.

[mysqld]
default_time_zone=Europe/Paris



Source: https://mariadb.com/kb/en/mariadb/time-zones/


Top
 Profile  
 
 Post subject: Re: upgrade problem to cacti to 1.0.0
PostPosted: Tue Feb 07, 2017 9:41 pm 
Offline
Cacti User
User avatar

Joined: Mon Jan 05, 2015 10:10 am
Posts: 109
Check the install instructions. The solution is not what you indicated, but to import the time zone database and grant the cacti user select access to the time_zone_name table.

_________________
Before history, there was a paradise, now dust.


Top
 Profile  
 
 Post subject: Re: upgrade problem to cacti to 1.0.0
PostPosted: Wed Feb 08, 2017 4:07 am 
Offline

Joined: Wed Feb 08, 2017 3:58 am
Posts: 6
cheytac wrote:
I have searched and found solution.

if anyone has same problem please try.

vi /etc/my.cnf and add bellow lines.

[mysqld]
default_time_zone=Europe/Paris



Source: https://mariadb.com/kb/en/mariadb/time-zones/



can you help me ,
I add default_time_zone=Europe/Paris(or default_time_zone='Asia/Shanghai') to my.cnf
but my mysql don't start,
mysql version 5.6.35


Top
 Profile  
 
 Post subject: Re: upgrade problem to cacti to 1.0.0
PostPosted: Thu Feb 09, 2017 9:33 am 
Offline

Joined: Wed Feb 08, 2017 3:58 am
Posts: 6
I have solve this problem

# mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -u root -p mysql


Top
 Profile  
 
 Post subject: Re: upgrade problem to cacti to 1.0.0
PostPosted: Fri Mar 17, 2017 5:05 am 
Offline

Joined: Mon Oct 10, 2016 8:12 am
Posts: 2
I also have the same problem. Aparently I updated my server ad this is what I got
ERROR: Your Cacti database login account does not have access to the MySQL TimeZone database. Please provide the Cacti database account "select" access to the "time_zone_name" table in the "mysql" database, and populate MySQL's TimeZone information before proceeding.

I know this is something to do with my login but I can't quit figure out how to go about it.


Top
 Profile  
 
 Post subject: Re: upgrade problem to cacti to 1.0.0
PostPosted: Fri Mar 17, 2017 2:28 pm 
Offline

Joined: Fri Feb 10, 2017 2:45 pm
Posts: 35
Log into SQL and run the command: GRANT SELECT ON mysql.time_zone_name TO cacti@localhost IDENTIFIED BY 'cacti';

See below

[root@CBcacti]# mysql -u root -p
Enter password: YOUR-PASSWORD-HERE <--****replace with your own password, of course****
MariaDB [(none)]> GRANT SELECT ON mysql.time_zone_name TO cacti@localhost IDENTIFIED BY 'cacti';
MariaDB [(none)]> FLUSH privileges;
MariaDB [(none)]> quit;


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

All times are UTC - 5 hours


Who is online

Users browsing this forum: Bing [Bot] and 2 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