upgrade problem to cacti to 1.0.0

[cheytac]

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

[cheytac]

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/

[Osiris]

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.

[nimenhao]

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]

I have solve this problem

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

[kipkoech]

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.

[camerabob]

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;

[bhesterberg]

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;

That fixed it!
Now I have the "Your MYSQL TimeZone database is not populated" issue. Thanks!

[netniV]

Things like this are covered in the documentation such as: Requirements and General Installation - MySQL