cacti 0.8.7 compatibility issues?

[mariog]

hello
i have:
mysql-client 4.0.25-0
mysql-server 4.0.25-0
mysql-shared-compat-4.0.25-0
mysql-devel-4.0.25-0
apache 2.0.52
php 4.3.2
php-mysql-4.3.2
i would like to install 0.8.7g a installation of 0.8.7d exists

but whenever i point my directory to the new cacti i get the following. (see below) and I have made sure several times that the import has been done, i have tried with the default cacti.sql provided in the tar.gz and also with the export of the existing cacti database of 0.8.7d

the idea is to upgrade to correct bugs.

Code: Select all

Error

You have created a new database, but have not yet imported the 'cacti.sql' file. At the command line, execute the following to continue:

mysql -u yser -p 087g < cacti.sql

This error may also be generated if the cacti database user does not have correct permissions on the cacti database. Please ensure that the cacti database user has the ability to SELECT, INSERT, DELETE, UPDATE, CREATE, ALTER, DROP, INDEX on the cacti database.

any ideas?

thank you

[Linegod]

It says it right there:

Code: Select all

This error may also be generated if the cacti database user does not have correct permissions on the cacti database. Please ensure that the cacti database user has the ability to SELECT, INSERT, DELETE, UPDATE, CREATE, ALTER, DROP, INDEX on the cacti database.

The user you are using (yser), does not have the ability to write to the database '087g'. Fix that.

[mariog]

hello
actually my user has all privileges on the database, i have tested via mysql cli as well as logging in via phpmyadmin,

so it's not a permission issues,

i have even put root user in the include/config.php to have the same results.. so definetely not a permission issue


thank you

Mario G

[peter669]

I have the exact same issue upgrading from 0.8.7e to 0.8.7g. I really don't think it is a permission issue:

mysql> show grants for cactiuser@localhost;
+--------------------------------------------------------------------------------------------------+
| Grants for cactiuser@localhost |
+--------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'cactiuser'@'localhost' IDENTIFIED BY PASSWORD 'xxxxxx' |
| GRANT ALL PRIVILEGES ON `cacti`.* TO 'cactiuser'@'localhost' |
+--------------------------------------------------------------------------------------------------+


I still get the same error message with the following config.php file:

/* make sure these values refect your actual database/host/user/password */
$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "cactiuser";
$database_password = "$censored$";
$database_port = "3306";

/* Default session name - Session name must contain alpha characters */
#$cacti_session_name = "Cacti";


I never had an issue upgrading on older versions...

[peter669]

OK I applied all patches to the 0.8.7g version and now it works!