New install having issues

[jcpolo]

Hey there I followed a guide on how to do a completely new install and I got to the point where I'm at the web based install and I am running into some road blocks. Anyone care to take a look and let me know what they think?

[camerabob]

For the first error, the one preventing you from going further, execute the below from the CLI:

Code: Select all

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

Additionally, you may have to go into MariaDB and execute the below as well:

Code: Select all

MariaDB [(none)]> GRANT SELECT ON mysql.time_zone_name TO cacti@localhost IDENTIFIED BY 'cacti';
MariaDB [(none)]> quit;

For the others, you should just edit the file as indicated in the window with the recommended values.

[jcpolo]

Hey there thanks for the information. I did put these in and it had no affect.

[root@cacti ~]# mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -u root mysql -p
Enter password:
[root@cacti ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 107
Server version: 5.5.52-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> GRANT SELECT ON mysql.time_zone_name TO cacti@localhost IDENTIFIED BY 'cacti';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> quit;
Bye

[camerabob]

Have you added your time zone into the php.ini file?

Code: Select all

# vi /etc/php.ini

Under "[DATE]", uncomment the line

Code: Select all

;date.timezone =

and change to your time zone string like

Code: Select all

date.timezone = America/New_York