Cacti /install problem

[bebleu]

I installed Cacti on Solaris with Apache2, PHP4 and MySql. Cacti.sql was imported into mysql, and the user cactiuser was created with the proper rights (As it says in the HOWTO of the cacti installation guide). When i load http://myserver/cacti, Apache brings "http://myserver/cacti/install" show this error :

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.

If you have any idea how to resolve this, please let me know

[Howie]

I installed Cacti on Solaris with Apache2, PHP4 and MySql. Cacti.sql was imported into mysql, and the user cactiuser was created with the proper rights (As it says in the HOWTO of the cacti installation guide). When i load http://myserver/cacti, Apache brings "http://myserver/cacti/install" show this error :

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.

If you have any idea how to resolve this, please let me know

Have you tried

Code: Select all

mysql -u cactiuser -p cacti < cacti.sql 

like it says to do?

[bebleu]

Yes I imported the cacti database in my mysql with this command... and I can SELECT, INSERT, etc in this database with cactiuser

[Grogdor]

I am having the same problem trying to install onto a FreeBSD 5.5-STABLE machine with PHP 4.4.4.1 and MySQL 4.1.21.

$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "cacti";
$database_password = "password";
$database_port = "3306";

The user works fine with All privileges, and I've imported cacti.sql into 'cacti' a few different ways. Installer shows same message.

[gabe]

Hello, I had the same problems!

My solution was:

There are 2 files that have to be touched
You have to change both files:

cactid/config.php:
$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "cacti";
$database_password = "password";
$database_port = "3306";
!!!!!AND!!!!!!

cacti-0.8.6\include\config_settings.php:
$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "cacti";
$database_password = "password";
$database_port = "3306";

After this changes it worked fine for me,
cya,
gabe

[maxmim]

Hello,

Excuse me for my english because I'm french.

I don't find this :

cacti-0.8.6\include\config_settings.php:
$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "cacti";
$database_password = "password";
$database_port = "3306";

Can you help me ?

[fmangeant]

Hi

here are the 2 files that need to be modified :

• /path/to/cacti/incude/config.php

  Code: Select all

  $database_type = "mysql";
  $database_default = "cactiboost";
  $database_hostname = "localhost";
  $database_username = "cactiuser";
  $database_password = "*****";
  $database_port = "3306";

• /path/to/cactid/bin/cactid.conf (or /etc/cactid.conf)

  Code: Select all

  DB_Host         localhost
  DB_Database     cacti
  DB_User         cactiuser
  DB_Pass         *******
  DB_Port         3306

[maxmim]

A lot of people speak about the directory "cactid"... I don't have this directiry. Maybe beacause I use a Mandrake ??? To install Cacti, I follow the tutorial on the cacti's website.

Thank you.

[fmangeant]

cactid is the fast poller for Cacti, written in C : http://cacti.net/cactid_info.php

[Grogdor]

helps to read a little, cacti/include/config.php says:

/*
* these are default values. do not change them. set your actual
* database/host/user/password in db-settings.php file instead.
*
*/

amazingly enough, it works just fine after that

[rsaeks]

I am having the same problem as the Org. Poster on this. I am on Mac OS X 10.4.8. I ran the mysql command to import the cacti.sql file, and have used MySQL Manager to verify that the correct tables where added.

I also have tried to login though the CLI mysql -u cacti -p and I am able to login and access the database.

This is the second time I have attempted to install Cacti on a clean machine following the directions, and again I have run into a problem at the exact same part.

Any ideas on what to do with this at this point?

[gandalf]

ARe you running cmd.php or cactid as a poller?
What are settings for sessions directory

Code: Select all

; variable in order to use PHP's session functions.
;session.save_path = /var/lib/php/session
session.save_path = /tmp

Reinhard