upgrade problem to cacti to 1.0.0

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Moderators, Developers

Post Reply
Author
Message
cheytac
Posts: 2
Joined: Wed Jan 25, 2017 4:27 am

upgrade problem to cacti to 1.0.0

#1 Post by cheytac » Wed Feb 01, 2017 9:41 am

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 19178 times

cheytac
Posts: 2
Joined: Wed Jan 25, 2017 4:27 am

Re: upgrade problem to cacti to 1.0.0

#2 Post by cheytac » Wed Feb 01, 2017 10:35 am

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/

User avatar
Osiris
Cacti Pro User
Posts: 863
Joined: Mon Jan 05, 2015 10:10 am

Re: upgrade problem to cacti to 1.0.0

#3 Post by Osiris » Tue Feb 07, 2017 9:41 pm

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.

nimenhao
Posts: 14
Joined: Wed Feb 08, 2017 3:58 am

Re: upgrade problem to cacti to 1.0.0

#4 Post by nimenhao » Wed Feb 08, 2017 4:07 am

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

nimenhao
Posts: 14
Joined: Wed Feb 08, 2017 3:58 am

Re: upgrade problem to cacti to 1.0.0

#5 Post by nimenhao » Thu Feb 09, 2017 9:33 am

I have solve this problem

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

kipkoech
Posts: 2
Joined: Mon Oct 10, 2016 8:12 am

Re: upgrade problem to cacti to 1.0.0

#6 Post by kipkoech » Fri Mar 17, 2017 5:05 am

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.

User avatar
camerabob
Cacti User
Posts: 291
Joined: Fri Feb 10, 2017 2:45 pm
Location: Long Island, New York, USA
Contact:

Re: upgrade problem to cacti to 1.0.0

#7 Post by camerabob » Fri Mar 17, 2017 2:28 pm

Log into SQL and run the command: GRANT SELECT ON mysql.time_zone_name TO [email protected] IDENTIFIED BY 'cacti';

See below

[[email protected]]# 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 [email protected] IDENTIFIED BY 'cacti';
MariaDB [(none)]> FLUSH privileges;
MariaDB [(none)]> quit;
See the Cacti 1.x templates I use at: http://www.camerabob.com/cacti

Live: Cacti 1.2.3 @ CentOS 7-6.1810.2.el7 & PHP 5.4.16-46.el7
Flowview @ 2.1
Mactrack @ 4.2
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4

Test: Cacti 1.2.6-1.el7 @ CentOS 7-7.1908.0.el7 & PHP 5.4.16-46.el7
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4

bhesterberg
Posts: 2
Joined: Tue Apr 11, 2017 10:36 am

Re: upgrade problem to cacti to 1.0.0

#8 Post by bhesterberg » Wed Aug 14, 2019 7:56 pm

camerabob wrote:
Fri Mar 17, 2017 2:28 pm
Log into SQL and run the command: GRANT SELECT ON mysql.time_zone_name TO [email protected] IDENTIFIED BY 'cacti';

See below

[[email protected]]# 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 [email protected]alhost IDENTIFIED BY 'cacti';
MariaDB [(none)]> FLUSH privileges;
MariaDB [(none)]> quit;
That fixed it!
Now I have the "Your MYSQL TimeZone database is not populated" issue. Thanks!


Post Reply