Cacti: traffic analysis and monitoring network: Difference between revisions

From Alpine Linux
m (added how to modify cacti.sql for work with recent Mysql due to an outdated syntax)
(some formating to commands)
Line 18: Line 18:
Quit from Mysql command prompt:
Quit from Mysql command prompt:
{{Cmd| mysql> \q }}
{{Cmd| mysql> \q }}
Edit /var/www/localhost/htdocs/cacti/include/config.php and put in the password you used in the above step for the mysql user. Import the initial Cacti MySQL config:
Edit /var/www/localhost/htdocs/cacti/include/config.php and put in the password you used in the above step for the mysql user.  
{{Cmd|mysql --user=cacti -p cacti < /usr/share/webapps/cacti/cacti.sql }}
Import the initial Cacti MySQL config:
If you are using most recent Mysql version from Alpine 2.2.2, have to fix cacti.sql:
 
{{Cmd|mv /usr/share/webapps/cacti/cacti.sql cacti.tmp && sed s/TYPE=/ENGINE=/g cacti.tmp > cacti.sql }}
mysql --user=cacti -p cacti < /usr/share/webapps/cacti/cacti.sql
 
If you are using most recent Mysql version from Alpine 2.2.2, have to fix cacti.sql syntax then import:
 
cd /usr/share/webapps/cacti/
mv cacti.sql cacti.tmp && sed s/TYPE=/ENGINE=/g cacti.tmp > cacti.sql
mysql --user=cacti -p cacti < /usr/share/webapps/cacti/cacti.sql
 
Set lighttpd to autostart and start the daemon.
Set lighttpd to autostart and start the daemon.
{{Cmd|rc-update add lighttpd && rc-service lighttpd start}}
{{Cmd|rc-update add lighttpd && rc-service lighttpd start}}

Revision as of 22:40, 16 June 2011

Install needed packages:

apk add lighttpd php cacti net-snmp-tools fcgi

Add php support to lighttpd (uncomment this line in /etc/lighttpd/lighttpd.conf):

include "mod_fastcgi.conf"

Save and exit editor. Create a softlink for the cacti web files:

ln -s /usr/share/webapps/cacti /var/www/localhost/htdocs/cacti

If it hasn't already been done, setup MySQL:

apk add mysql-client

mysql_install_db --user=mysql

/etc/init.d/mysql start

mysql_secure_installation

Create the cacti database and populate it

mysql -u root -p

mysql> create database cacti;

Grant Cacti MySQL user access (give it a more secure password):

mysql> grant all on cacti.* to 'cactiuser'@'localhost' identified by 'MostSecurePassword'; flush privileges;

Quit from Mysql command prompt:

mysql> \q

Edit /var/www/localhost/htdocs/cacti/include/config.php and put in the password you used in the above step for the mysql user. Import the initial Cacti MySQL config:

mysql --user=cacti -p cacti < /usr/share/webapps/cacti/cacti.sql

If you are using most recent Mysql version from Alpine 2.2.2, have to fix cacti.sql syntax then import:

cd /usr/share/webapps/cacti/
mv cacti.sql cacti.tmp && sed s/TYPE=/ENGINE=/g cacti.tmp > cacti.sql
mysql --user=cacti -p cacti < /usr/share/webapps/cacti/cacti.sql

Set lighttpd to autostart and start the daemon.

rc-update add lighttpd && rc-service lighttpd start

Browse to http://localhost/cacti/

-> Next
-> New install, Next
-> Finish

Login using admin:admin, change password.
Add to crontab:

*/5 * * * * php /var/www/localhost/cacti/poller.php > /dev/null 2>&1

Add your devices and you're ready to start monitoring!