Installation problems

[sadique]

I am getting an error message while calling cacti/install for the first time.

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 cactiuser -p cacti < 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.

I have issued command GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'cactiuser'; after importing database from cacti.sql. I could see all files in /var/lib/mysql/cacti as imported. But why I do get this error message after that.

MySQL 4.1, Php 4.4.2, apache-1.3.34. Any help would be appreciated.

Thanks
Sadique

[egarnel]

I am getting an error message while calling cacti/install for the first time.

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 cactiuser -p cacti < 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.

I have issued command GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'cactiuser'; after importing database from cacti.sql. I could see all files in /var/lib/mysql/cacti as imported. But why I do get this error message after that.

MySQL 4.1, Php 4.4.2, apache-1.3.34. Any help would be appreciated.

Thanks
Sadique

You imported the cact.sql as cactiuser with a password of cacti, but your grant statement indicates that the password is cactiuser. Make sure they match and you should be fine

[sadique]

mysql -u cactiuser -p cacti < cacti.sql

cacti after -p is not the password but the database name. Password should be prompted after executing this command and I entered the password there cactiuser to import the database.

Any way on a reinstallation it didn't work. Getting the same error message. Is it likely to be an issue with MySQL and php-4.4? I have installed cacti (previous version of cacti) successfully on MySQL-4.0 and php-4.3 without any problems. I have repeated the same step here to install.

Any help would be appreciated.

Thanks
Sadique