A default Cacti database/SQL file to work with mariadb 10.8? or upgrade it to work with mariadb 10.8?

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
pooq2013
Posts: 4
Joined: Tue Sep 24, 2013 11:36 am

A default Cacti database/SQL file to work with mariadb 10.8? or upgrade it to work with mariadb 10.8?

Post by pooq2013 »

I am trying to install a brand new copy of cacti 1.2.19 on CentOS release 7.9.2009. Database is mariadb 10.8

I am at this step to Import the default SQL file.

[root@host doc]# mysql -u root -p cacti < /usr/share/doc/cacti-1.2.19/cacti.sql
Enter password:
ERROR 1558 (HY000) at line 8: Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50568, now running 100802. Please use mariadb-upgrade to fix this error.

When I tried the following, I got the output "upgrade failed"
[root@host doc]# mariadb-upgrade /usr/share/doc/cacti-1.2.19/cacti.sql
Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
FATAL ERROR: Upgrade failed

I cannot find a good similar thread from previous discussion. Can any one help me? thanks!
User avatar
macan
Cacti Guru User
Posts: 1137
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

Re: A default Cacti database/SQL file to work with mariadb 10.8? or upgrade it to work with mariadb 10.8?

Post by macan »

run mysql_upgrade -uroot -p (maybe mysql-upgrade)
(or mariadb-upgrade with the same paaremeters
Let the Cacti grow!
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests