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 ?
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
Unable to insert Cacti tables inside the Cacti database
Moderators: Developers, Moderators
- 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
What was the error for the highlighted command?
R.
R.
Who is online
Users browsing this forum: No registered users and 0 guests