Unable to insert Cacti tables inside the Cacti database

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

Moderators: Developers, Moderators

Post Reply
Logicalis
Posts: 1
Joined: Wed Feb 23, 2011 8:54 pm

Unable to insert Cacti tables inside the Cacti database

Post by Logicalis »

I was follow the manual installation of cacti by using Ubuntu 10.10 and i was not able to insert this command line highlighted as below. Anyone could assists me on this issue ? :cry:

MANUAL INSTALL OF CACTI

Download Catci at http://www.cacti.net
uncompress the tar.gz file

#tar -xvf cacti-0.8.6h.tar.gz
move the uncompressed folder inside your /var/www folder, for example:

#mv /home/po/Desktop/cacti /var/www/
Then Configure the Cacti database

#mysqladmin -u root -p create cacti
We now have to insert the Cacti tables inside the cacti database:

mysql -u root -p cacti < /var/www/cacti/sql/cacti.sql
As always, it's better to access the database without the root user.
So, login into the database and create a new MySQL user:


#mysql -u root -p cacti
We give all the rights to the cactiuser on the cacti database:

mysql> grant all on cacti.* to cactiuser@localhost identified by 'cactiuser';
Now, reload mysql rights:

mysql>flush privileges;
mysql>exit
We need to change the database connection settings located in the
/var/www/cacti/include/config.php file

$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "cactiuser";
$database_password = "cactiuser";
$database_port = "3306";
We then need to create a user to run cacti, this user will not be allowed tu run any shell command (/bin/false):

#useradd cacti -d /var/www/cacti/ -s /bin/false

The cacti user we need to write in two folders, so:

#chown -R cacti /var/www/cacti/
We will need to do a cron job to run the php script every 5 minutes

#crontab -e -u cacti
*/5 * * * * php5 /var/www/cacti/poller.php > /dev/null 2>&1
Restart the apache webserver:

#/etc/init.d/apache2 restart
Finally we can log in to cacti with a web browser:

http://your_ip_address/cacti
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Unable to insert Cacti tables inside the Cacti database

Post by gandalf »

What was the error for the highlighted command?
R.
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests