Error during Cacti Installation Wizard

[shailu2014]

Hi All,

I am getting error during Cacti Installation Wizard, I have attached screenshot, Please help me to fix it.

Thanks,
Shailu2014

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

2.version 5.5.52-MariaDB >= 5.6 MySQL 5.6+ and MariaDB 10.0+ are great releases, and are very good versions to choose. Make sure you run the very latest release though which fixes a long standing low level networking issue that was casuing spine many issues with reliability.

3. max_heap_table_size 16M >=88M If using the Cacti Performance Booster and choosing a memory storage engine, you have to be careful to flush your Performance Booster buffer before the system runs out of memory table space. This is done two ways, first reducing the size of your output column to just the right size. This column is in the tables poller_output, and poller_output_boost. The second thing you can do is allocate more memory to memory tables. We have arbitrarily chosen a recommended value of 10% of system memory, but if you are using SSD disk drives, or have a smaller system, you may ignore this recommendation or choose a different storage engine. You may see the expected consumption of the Performance Booster tables under Console -> System Utilities -> View Boost Status.

[Osiris]

By now you should have figured it out right?

[Stefey]

Hi all,

I'm currently having the same issue than shailu. I'm trying to install Cacti on CentOS 7 with the last Cacti release (1.1.5), and I'm having the exact same issue.

Here are some screeshots attached.

cacti1.PNG (46.29 KiB) Viewed 15763 times

cacti2.PNG (70.52 KiB) Viewed 15763 times

cacti3.PNG (74.06 KiB) Viewed 15763 times

I guess the first error is just a connexion issue to the database so I'm going to check that.

I then checked the last Mariadb version doing a "yum install mariadb updateinfo" and it says 5.5.52 is the last version.

Can you please help me guys ?

Thank you very much

[tyrr]

Hi,

I'm new as user cacti but I had this problem.
For the configuration of mysql and all your error, you need to parameterize by hand my.cnf in /etc like my attachment.
For your first error of timezone, i continues to seek in my memori because i had the same error but forgot the solution

I hope this info will help you

edit :
For the timezone, you can test that :
cd /usr/share/mysql
mysql -u root mysql < mysql_test_data_timezone.sql
and then log in mysql and write (don't forget flush privilege at the end)
GRANT SELECT ON mysql.time_zone_name TO cactiuser@localhost

I'm really not sure but it seems to me that it worked for me

[Stefey]

Hi tyrr,

Thank you very much for your help.
First, I upgraded the version of MariaDB. I followed that tutorial where that is pretty well explained : http://www.tecmint.com/upgrade-mariadb- ... an-ubuntu/

Then, I installed again these packages :

# yum install php-mysql
# yum install php-pdo

Finally, I followed your advice. I edited the /etc/my.cnf file and I added what you just wrote down.

For the TimeZone issue, I changed the /etc/php.ini file. You normally have :

[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
;date.timezone =


That part was empty for me. I uncommented the line ";date.timezone = " and changed it :

date.timezone = Europe/Paris


Now I have to find out how to populate that Timezone.

Thank you very much for your time, hope that will help some people

[shailu2014]

Hi Stefey & tyrr,

I followed same steps which mentioned and edited the /etc/my.cnf file and I added line which mentioned below (Screenshot attached)

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
character_set_server = utfs
max_heap_table_size = 98M
max_allowed_packet = 16777216
tmp_table_size = 64M
join_buffer_size = 64M
innodb_file_per_table = ON
innodb_buffer_pool_size = 1024M
innodb_doublewrite = OFF
innodb_additional-mem-pool-size = 80M
innodb_flush_log_at_timeout = 3
innodb_read_io_threads = 32
innodb_write_io_threads = 16

Symbolic_links=0

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

After that I started the mariadb services and then i refresh the browser and got the below error

FATAL: Connection to Cacti database failed. Please insure the database is running and your credentials in config.php are valid.



Please let me know where is the issue during edit the file (/etc/my.cnf)

Thanks,
Shailu

[Stefey]

Hi shailu,

- What is your linux distro ?
- Is the service mariadb running or it failed when you restarted it ?
- Have you correctly filled in your database's information in the include/config.php file ?

In addition to that, when you uninstalled the old version of MariaDB, did you make a backup of the database, and have you imported it again ?
If not, it won't work, and you maybe will to have to create the database again, and import cacti.sql again in your database.

Please let me know so that I try to help you a bit more.

[Stefey]

You can also do a :

# tail -f /var/log/httpd/error_log

And check if there is something wrong. You can write down the output here.

[shailu2014]

Hi Stefey,

- I am using Centos-7 OS in Vmware.

- I have direct installed New Version of MariaDB by below link, so i don't require the data backup.
http://www.tecmint.com/install-mariadb-in-centos-7/

- mariadb Version mentioned below-
# mysql -V
mysql Ver 15.1 Distrib 10.1.22-MariaDB, for Linux (x86_64) using readline 5.1


- database's information in the include/config.php file working before edit the my.cnf file,

- after edit my.cnf file restart the MariaDB service it's giving error mentioned below.
# systemctl restart mariadb
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

- Sending the logs of httpd

# tail -f /var/log/httpd/error_log (result)
# tail -f /var/log/httpd/error_log
[Fri Apr 28 00:27:09.187956 2017] [mpm_prefork:notice] [pid 895] AH00163: Apache/2.4.6 (CentOS) PHP/5.4.16 configured -- resuming normal operations
[Fri Apr 28 00:27:09.188020 2017] [core:notice] [pid 895] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Fri Apr 28 00:28:04.627916 2017] [autoindex:error] [pid 2237] [client 192.168.81.1:51414] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Fri Apr 28 00:29:25.297590 2017] [mpm_prefork:notice] [pid 895] AH00170: caught SIGWINCH, shutting down gracefully
[Fri Apr 28 00:29:55.725249 2017] [suexec:notice] [pid 891] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::20cfe8c:81d. Set the 'ServerName' directive globally to suppress this message
[Fri Apr 28 00:29:56.252330 2017] [auth_digest:notice] [pid 891] AH01757: generating secret for digest authentication ...
[Fri Apr 28 00:29:56.252681 2017] [lbmethod_heartbeat:notice] [pid 891] AH02282: No slotmem from mod_heartmonitor
[Fri Apr 28 00:29:59.727812 2017] [mpm_prefork:notice] [pid 891] AH00163: Apache/2.4.6 (CentOS) PHP/5.4.16 configured -- resuming normal operations
[Fri Apr 28 00:29:59.727937 2017] [core:notice] [pid 891] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'

Please let me know where is the issue....

Thanks,
Shailu

[camerabob]

What is the location of your Cacti install? Apache should be pointing to that.

[datnq3]

Hi Stefey & tyrr,

I followed same steps which mentioned and edited the /etc/my.cnf file and I added line which mentioned below (Screenshot attached)

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
character_set_server = utfs
max_heap_table_size = 98M
max_allowed_packet = 16777216
tmp_table_size = 64M
join_buffer_size = 64M
innodb_file_per_table = ON
innodb_buffer_pool_size = 1024M
innodb_doublewrite = OFF
innodb_additional-mem-pool-size = 80M
innodb_flush_log_at_timeout = 3
innodb_read_io_threads = 32
innodb_write_io_threads = 16

Symbolic_links=0

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

After that I started the mariadb services and then i refresh the browser and got the below error

FATAL: Connection to Cacti database failed. Please insure the database is running and your credentials in config.php are valid.



Please let me know where is the issue during edit the file (/etc/my.cnf)

Thanks,
Shailu

Can you share fix this issue? Thanks

[dldiego]

Hi, for Ubuntu i had the same error about Timezone populate.
I fixed it editing this.

root@akenaton:/usr/share/mysql# nano /etc/mysql/conf.d/mysql.cnf

Here i added

[mysql]
[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = America/Montevideo

Then i restart the mysql server

root@akenaton:/usr/share/mysql# /etc/init.d/mysql restart
[ ok ] Restarting mysql (via systemctl): mysql.service.
root@akenaton:/usr/share/mysql#

It s works!

Thanks.
Regars..

Diego