New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrade problem MySQL Timezone #242

Closed
interduo opened this Issue Jan 31, 2017 · 6 comments

Comments

Projects
None yet
5 participants
@interduo

interduo commented Jan 31, 2017

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

How to do this?

I edited:

/etc/php5/apache2/php.ini:date.timezone = Europe/Warsaw
/etc/php5/cli/php.ini:date.timezone = Europe/Warsaw

And
SET @@global.time_zone = '+01:00';
SET @@session.time_zone = "+01:00";

This did not work.

Also tried to dpkg-reconfigure tzdata and restart mysql.

System: Debian Jessie.

Is it possible to add a short info how to do that or postpone upgrade?

@ronytomen

This comment has been minimized.

Member

ronytomen commented Jan 31, 2017

Really not a Cacti problem. Sounds like you are missing the MySQL time zone data.

https://dev.mysql.com/doc/refman/5.7/en/mysql-tzinfo-to-sql.html

@interduo interduo changed the title from Upgrade problem to Upgrade problem MySQL Timezone Jan 31, 2017

@interduo

This comment has been minimized.

interduo commented Jan 31, 2017

We should be able to postpone the upgrade.

@pautiina

This comment has been minimized.

Contributor

pautiina commented Jan 31, 2017

It's not problem.
On FreeBSD:

cd /usr/local/share/mysql 
mysql -u root mysql < mysql_test_data_timezone.sql 

Other UNIX:

cd /usr/share/mysql 
mysql -u root mysql < mysql_test_data_timezone.sql 

If you have mysql root passrword:
mysql -u root -p mysql < mysql_test_data_timezone.sql

And you must add access cacti databes user for databases mysql or only for table:
mysql.time_zone_name

@pnyet

This comment has been minimized.

pnyet commented Jan 31, 2017

Here is to add privileges for cacti database to time_zone_name table:

GRANT SELECT ON mysql. time_zone_name TO 'cacti'@'localhost' IDENTIFIED BY 'your-db-password';

@interduo

This comment has been minimized.

interduo commented Jan 31, 2017

I did forgot about that @pnyet Thank You.

@interduo interduo closed this Jan 31, 2017

@imax64

This comment has been minimized.

imax64 commented Feb 1, 2017

works for me as well, thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment