ERROR: Your MySQL TimeZone database is not populated

[nimenhao]

please help me (my English is poor )
when I install the cacti-1.0.1
my problem:

Pre-installation Checks

MySQL TimeZone Support

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



system infomation
centos6.3
mysql version 5.6.35
# date -R
Wed, 08 Feb 2017 17:28:51 +0800

mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | CST |
| time_zone | +08:00 |
+------------------+--------+
2 rows in set (0.00 sec)



###################################
i have solve my problem
将系统时区导入数据库中

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

[klatta]

This site should help you with that problem. It worked for me.

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

[nimenhao]

This site should help you with that problem. It worked for me.

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

thak you very much,I have read your solutions and solve my problem.
geekssengine is a good site.
do you use Social software? like facebook or whatapps?

[joca]

I have this erro;
root@cacti:/home/joca# mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -u root -p cacti
Enter password:
ERROR 1146 (42S02) at line 1: Table 'cacti.time_zone' doesn't exist

[phalek]

You need to load this into the mysql database, not into the cacti database. So try this:

Code: Select all

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

[joca]

root@cacti:/home/joca# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
Enter password:
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.

[phalek]

Check the pre-install steps if you can now proceed with the installation.

[camerabob]

You need to load this into the mysql database, not into the cacti database. So try this:

Code: Select all

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

I believe the syntax is a bit off (after doing this a dozen times myself...)

Code: Select all

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

The database name follows the user name in the sequence, followed by the password parameter.

Good luck.

[phalek]

Both work, but you can look here for the official syntax(or examples): https://dev.mysql.com/doc/refman/5.7/en/connecting.html

[joca]

mysql> GRANT ALL PRIVILEGES ON mysql.* TO 'cacti'@'localhost' WITH GRANT OPTION;
Solved My Problem!

[nimenhao]

mysql> GRANT ALL PRIVILEGES ON mysql.* TO 'cacti'@'localhost' WITH GRANT OPTION;
Solved My Problem!

this problem maybe is datebase version ,my mysql is 5.7,but mysql5.3 tables is different.
(My English is poor,May be unclear)
(I have a questonWhat social software do you use?)

[izmenoff]

nimenhao, you can try:
cd cacti/cli
php repair_database.php --force
php upgrade_database.php

it solved my the same problem

[nimenhao]

I have this erro;
root@cacti:/home/joca# mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -u root -p cacti
Enter password:
ERROR 1146 (42S02) at line 1: Table 'cacti.time_zone' doesn't exist

It is database version problem

[nimenhao]

nimenhao, you can try:
cd cacti/cli
php repair_database.php --force
php upgrade_database.php

it solved my the same problem

thank you very much!!!

[alipsit]

Hi, I followed the following video series:

https://www.youtube.com/watch?v=5COQumLGDzY

I also have the "ERROR: Your MySQL TimeZone database is not populated. Please populate this database before proceeding."

Is there anything that this tutorial misses that I need to do regarding the timezones?

Thanks