mysql basic replication setup

Posted: 24th October 2009 by trunty in Mysql

mysql replication is fairly common and the benefits go without saying.  Below is what I have found to be the best process for configuring replication on two vanilla mysql devices.

Install mysql on both nodes.

yum install mysql-server -y

On both nodes confirm that mysql is started and listening for remote connection, not bound to loopback.

/etc/init.d/mysqld start

chkconfig mysqld on

netstat -ntlp | grep mysqld Read the rest of this entry »

install cacti on rhel-5/centos-5

Posted: 5th October 2009 by admin in Cacti
Tags: , , ,

Hopefully this short and simple how-to will be useful to someone. There may be inaccuracies so please feel free to let me know if you see anything that needs correcting.

Download all necessary packages

yum install httpd php php-mysql php-snmp mysql mysql-server net-snmp net-snmp-utils rrdtool libart_lgpl -y

rrd-tool can be obtained from dag (http://dag.wieers.com/rpm/packages/rrdtool/perl-rrdtool-1.2.23-1.el5.rf.x86_64.rpm and http://dag.wieers.com/rpm/packages/rrdtool/rrdtool-1.2.23-1.el5.rf.x86_64.rpm for 64-bit) if it is not in your repos.

Verify that the required daemons are started and configured to start on boot

chkconfig httpd on
chkconfig snmpd on
chkconfig mysqld on
/etc/init.d/httpd restart
/etc/init.d/mysqld restart
/etc/init.d/snmpd restart

Configure mysql daemon to listen only on localhost (optional)

vi /etc/my.cnf
add ‘bind=127.0.0.1′
restart mysql ‘/etc/init.d/mysqld restart’
confirm that it is listening on localhost ‘netstat -ntlp | grep :3306′

Configure mysql users

mysql -u root
set mysql password for root user
use mysql;
update user set Password=PASSWORD(‘selectapw’) where User=’root’;
create cacti database
create database cacti;
create cacti user and grant them permissions to the cacti database
grant all privileges on cacti.* to ‘cacti’@'localhost’ identified by ‘selectpw’ with grant option;
apply all new permission changes
flush privileges;
or you can simply restart mysql

Get and extract the cacti tarball

cd /var/www/html/
wget http://www.cacti.net/downloads/cacti-0.8.7d.tar.gz
tar -xvzf cacti-0.8.7d.tar.gz

Create symbolic link and change the owernship to apache

ln -s /var/www/html/cacti-0.8.7d.tar.gz
chown -R apache:apache /var/www/html/cacti

Create the necessary cacti tables

mysql -u root -p cacti < /var/www/html/cacti/cacti.sql

Create cacti user and create the poller cron

useradd cacti
passwd cacti
crontab -e -u cacti
insert `*/5 * * * * php /var/www/html/cacti/poller.php > /dev/null 2>&1` and save `:wq`

Change ownership of rra and log to cacti

chown -R cacti /var/www/html/cacti/rra/ /var/www/html/cacti/log/

Populate the cacti config with mysql information

vi /var/www/html/cacti/include/config.php
update the below accordingly
$database_type = “mysql”;
$database_default = “cacti”;
$database_hostname = “127.0.0.1″;
$database_username = “cacti”;
$database_password = “createdpass”;

Point your web browser to `http://your-server/cacti/` and follow the on-screen instructions

accept defaults
when prompted the default usernamd and password is admin

Current repolist
repo id repo name status
addons CentOS-5 – Addons enabled : 0
base CentOS-5 – Base enabled : 3,272
centosplus CentOS-5 – Plus enabled : 63
contrib CentOS-5 – Contrib enabled : 0
epel Epel from fedora enabled : 4,970
extras CentOS-5 – Extras enabled : 266
updates CentOS-5 – Updates enabled : 25

For the sake of convenience I have also included the raw output of a complete install below…

[root@testme ~]# yum repolist
Loaded plugins: fastestmirror
Determining fastest mirrors
* addons: hpc.arc.georgetown.edu
* base: mirrors.cmich.edu
* extras: updates.interworx.info
* updates: updates.interworx.info
addons                                                                                                                                                                                                                              |  951 B     00:00
addons/primary                                                                                                                                                                                                                      |  204 B     00:00
base                                                                                                                                                                                                                                | 2.1 kB     00:00
base/primary_db                                                                                                                                                                                                                     | 2.1 MB     00:03
extras                                                                                                                                                                                                                              | 2.1 kB     00:00
extras/primary_db                                                                                                                                                                                                                   | 226 kB     00:00
updates                                                                                                                                                                                                                             | 1.9 kB     00:00
updates/primary_db                                                                                                                                                                                                                  | 508 kB     00:00
repo id                                                                                                          repo name                                                                                                                   status
addons                                                                                                           CentOS-5 – Addons                                                                                                           enabled:     0
base                                                                                                             CentOS-5 – Base                                                                                                             enabled: 3,434
extras                                                                                                           CentOS-5 – Extras                                                                                                           enabled:   298
updates                                                                                                          CentOS-5 – Updates                                                                                                          enabled:   541
repolist: 4,273
[root@testme ~]# cat /etc/redhat-release; uname -m
CentOS release 5.4 (Final)
x86_64
[root@testme ~]# rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-3.noarch.rpm
Retrieving http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-3.noarch.rpm
warning: /var/tmp/rpm-xfer.zXdqQj: Header V3 DSA signature: NOKEY, key ID 217521f6
Preparing…                ########################################### [100%]
1:epel-release           ########################################### [100%]
[root@testme ~]# yum repolist
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* addons: hpc.arc.georgetown.edu
* base: mirrors.cmich.edu
* epel: mirrors.rit.edu
* extras: updates.interworx.info
* updates: updates.interworx.info
epel                                                                                                                                                                                                                                | 3.4 kB     00:00
epel/primary_db                                                                                                                                                                                                                     | 3.3 MB     00:00
repo id                                                                                            repo name                                                                                                                                 status
addons                                                                                             CentOS-5 – Addons                                                                                                                         enabled:     0
base                                                                                               CentOS-5 – Base                                                                                                                           enabled: 3,434
epel                                                                                               Extra Packages for Enterprise Linux 5 – x86_64                                                                                            enabled: 5,675
extras                                                                                             CentOS-5 – Extras                                                                                                                         enabled:   298
updates                                                                                            CentOS-5 – Updates                                                                                                                        enabled:   541
repolist: 9,948
[root@testme ~]# yum install httpd php php-mysql php-snmp mysql mysql-server net-snmp net-snmp-utils rrdtool libart_lgpl -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* addons: hpc.arc.georgetown.edu
* base: mirrors.cmich.edu
* epel: mirrors.rit.edu
* extras: updates.interworx.info
* updates: updates.interworx.info
Setting up Install Process
Resolving Dependencies
–> Running transaction check
—> Package httpd.x86_64 0:2.2.3-43.el5.centos set to be updated
addons/filelists                                                                                                                                                                                                                    |  197 B     00:00
base/filelists_db                                                                                                                                                                                                                   | 4.0 MB     00:10
epel/filelists_db                                                                                                                                                                                                                   | 4.5 MB     00:01
extras/filelists_db                                                                                                                                                                                                                 | 220 kB     00:00
updates/filelists_db                                                                                                                                                                                                                | 1.4 MB     00:00
–> Processing Dependency: /etc/mime.types for package: httpd
–> Processing Dependency: libaprutil-1.so.0()(64bit) for package: httpd
–> Processing Dependency: libapr-1.so.0()(64bit) for package: httpd
—> Package libart_lgpl.i386 0:2.3.17-4 set to be updated
—> Package libart_lgpl.x86_64 0:2.3.17-4 set to be updated
—> Package mysql.i386 0:5.0.77-4.el5_5.3 set to be updated
–> Processing Dependency: perl(DBI) for package: mysql
–> Processing Dependency: libncurses.so.5 for package: mysql
—> Package mysql.x86_64 0:5.0.77-4.el5_5.3 set to be updated
—> Package mysql-server.x86_64 0:5.0.77-4.el5_5.3 set to be updated
–> Processing Dependency: perl-DBD-MySQL for package: mysql-server
—> Package net-snmp.x86_64 1:5.3.2.2-9.el5_5.1 set to be updated
–> Processing Dependency: net-snmp-libs = 1:5.3.2.2-9.el5_5.1 for package: net-snmp
–> Processing Dependency: libnetsnmpmibs.so.10()(64bit) for package: net-snmp
–> Processing Dependency: libnetsnmpagent.so.10()(64bit) for package: net-snmp
–> Processing Dependency: libnetsnmp.so.10()(64bit) for package: net-snmp
–> Processing Dependency: libsensors.so.3()(64bit) for package: net-snmp
–> Processing Dependency: libnetsnmptrapd.so.10()(64bit) for package: net-snmp
–> Processing Dependency: libnetsnmphelpers.so.10()(64bit) for package: net-snmp
—> Package net-snmp-utils.x86_64 1:5.3.2.2-9.el5_5.1 set to be updated
—> Package php.x86_64 0:5.1.6-27.el5 set to be updated
–> Processing Dependency: php-common = 5.1.6-27.el5 for package: php
–> Processing Dependency: php-cli = 5.1.6-27.el5 for package: php
–> Processing Dependency: libaspell.so.15()(64bit) for package: php
–> Processing Dependency: libpspell.so.15()(64bit) for package: php
–> Processing Dependency: libcurl.so.3()(64bit) for package: php
–> Processing Dependency: libidn.so.11()(64bit) for package: php
–> Processing Dependency: libgmp.so.3()(64bit) for package: php
—> Package php-mysql.x86_64 0:5.1.6-27.el5 set to be updated
–> Processing Dependency: php-pdo for package: php-mysql
—> Package php-snmp.x86_64 0:5.1.6-27.el5 set to be updated
—> Package rrdtool.i386 0:1.2.27-3.el5 set to be updated
–> Processing Dependency: libfreetype.so.6 for package: rrdtool
–> Processing Dependency: libpng12.so.0(PNG12_0) for package: rrdtool
–> Processing Dependency: libpng12.so.0 for package: rrdtool
—> Package rrdtool.x86_64 0:1.2.27-3.el5 set to be updated
–> Processing Dependency: libpng12.so.0(PNG12_0)(64bit) for package: rrdtool
–> Processing Dependency: libpng12.so.0()(64bit) for package: rrdtool
–> Processing Dependency: libfreetype.so.6()(64bit) for package: rrdtool
–> Running transaction check
—> Package apr.x86_64 0:1.2.7-11.el5_3.1 set to be updated
—> Package apr-util.x86_64 0:1.2.7-11.el5 set to be updated
–> Processing Dependency: libpq.so.4()(64bit) for package: apr-util
—> Package aspell.x86_64 12:0.60.3-7.1 set to be updated
–> Processing Dependency: aspell-en for package: aspell
—> Package curl.x86_64 0:7.15.5-9.el5 set to be updated
—> Package freetype.i386 0:2.2.1-26.el5_5 set to be updated
—> Package freetype.x86_64 0:2.2.1-26.el5_5 set to be updated
—> Package gmp.x86_64 0:4.1.4-10.el5 set to be updated
—> Package libidn.x86_64 0:0.6.5-1.1 set to be updated
—> Package libpng.i386 2:1.2.10-7.1.el5_5.3 set to be updated
—> Package libpng.x86_64 2:1.2.10-7.1.el5_5.3 set to be updated
—> Package lm_sensors.x86_64 0:2.10.7-9.el5 set to be updated
–> Processing Dependency: /usr/sbin/dmidecode for package: lm_sensors
—> Package mailcap.noarch 0:2.1.23-1.fc6 set to be updated
—> Package ncurses.i386 0:5.5-24.20060715 set to be updated
—> Package net-snmp-libs.x86_64 1:5.3.2.2-9.el5_5.1 set to be updated
—> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated
—> Package perl-DBI.x86_64 0:1.52-2.el5 set to be updated
—> Package php-cli.x86_64 0:5.1.6-27.el5 set to be updated
—> Package php-common.x86_64 0:5.1.6-27.el5 set to be updated
—> Package php-pdo.x86_64 0:5.1.6-27.el5 set to be updated
–> Running transaction check
—> Package aspell-en.x86_64 50:6.0-2.1 set to be updated
—> Package dmidecode.x86_64 1:2.10-3.el5 set to be updated
—> Package postgresql-libs.x86_64 0:8.1.21-1.el5_5.1 set to be updated
–> Finished Dependency Resolution

Dependencies Resolved

===========================================================================================================================================================================================================================================================
Package                                                         Arch                                                   Version                                                              Repository                                               Size
===========================================================================================================================================================================================================================================================
Installing:
httpd                                                           x86_64                                                 2.2.3-43.el5.centos                                                  base                                                    1.2 M
libart_lgpl                                                     i386                                                   2.3.17-4                                                             base                                                     76 k
libart_lgpl                                                     x86_64                                                 2.3.17-4                                                             base                                                     75 k
mysql                                                           i386                                                   5.0.77-4.el5_5.3                                                     updates                                                 4.8 M
mysql                                                           x86_64                                                 5.0.77-4.el5_5.3                                                     updates                                                 4.8 M
mysql-server                                                    x86_64                                                 5.0.77-4.el5_5.3                                                     updates                                                 9.8 M
net-snmp                                                        x86_64                                                 1:5.3.2.2-9.el5_5.1                                                  updates                                                 702 k
net-snmp-utils                                                  x86_64                                                 1:5.3.2.2-9.el5_5.1                                                  updates                                                 188 k
php                                                             x86_64                                                 5.1.6-27.el5                                                         base                                                    2.3 M
php-mysql                                                       x86_64                                                 5.1.6-27.el5                                                         base                                                     89 k
php-snmp                                                        x86_64                                                 5.1.6-27.el5                                                         base                                                     30 k
rrdtool                                                         i386                                                   1.2.27-3.el5                                                         epel                                                    464 k
rrdtool                                                         x86_64                                                 1.2.27-3.el5                                                         epel                                                    466 k
Installing for dependencies:
apr                                                             x86_64                                                 1.2.7-11.el5_3.1                                                     base                                                    118 k
apr-util                                                        x86_64                                                 1.2.7-11.el5                                                         base                                                     79 k
aspell                                                          x86_64                                                 12:0.60.3-7.1                                                        base                                                    946 k
aspell-en                                                       x86_64                                                 50:6.0-2.1                                                           base                                                    1.6 M
curl                                                            x86_64                                                 7.15.5-9.el5                                                         base                                                    230 k
dmidecode                                                       x86_64                                                 1:2.10-3.el5                                                         base                                                     74 k
freetype                                                        i386                                                   2.2.1-26.el5_5                                                       updates                                                 311 k
freetype                                                        x86_64                                                 2.2.1-26.el5_5                                                       updates                                                 310 k
gmp                                                             x86_64                                                 4.1.4-10.el5                                                         base                                                    201 k
libidn                                                          x86_64                                                 0.6.5-1.1                                                            base                                                    195 k
libpng                                                          i386                                                   2:1.2.10-7.1.el5_5.3                                                 updates                                                 241 k
libpng                                                          x86_64                                                 2:1.2.10-7.1.el5_5.3                                                 updates                                                 234 k
lm_sensors                                                      x86_64                                                 2.10.7-9.el5                                                         base                                                    525 k
mailcap                                                         noarch                                                 2.1.23-1.fc6                                                         base                                                     14 k
ncurses                                                         i386                                                   5.5-24.20060715                                                      base                                                    1.1 M
net-snmp-libs                                                   x86_64                                                 1:5.3.2.2-9.el5_5.1                                                  updates                                                 1.3 M
perl-DBD-MySQL                                                  x86_64                                                 3.0007-2.el5                                                         base                                                    148 k
perl-DBI                                                        x86_64                                                 1.52-2.el5                                                           base                                                    600 k
php-cli                                                         x86_64                                                 5.1.6-27.el5                                                         base                                                    2.2 M
php-common                                                      x86_64                                                 5.1.6-27.el5                                                         base                                                    153 k
php-pdo                                                         x86_64                                                 5.1.6-27.el5                                                         base                                                     66 k
postgresql-libs                                                 x86_64                                                 8.1.21-1.el5_5.1                                                     updates                                                 196 k

Transaction Summary
===========================================================================================================================================================================================================================================================
Install     35 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total download size: 36 M
Downloading Packages:
(1/35): mailcap-2.1.23-1.fc6.noarch.rpm                                                                                                                                                                                             |  14 kB     00:00
(2/35): php-snmp-5.1.6-27.el5.x86_64.rpm                                                                                                                                                                                            |  30 kB     00:00
(3/35): php-pdo-5.1.6-27.el5.x86_64.rpm                                                                                                                                                                                             |  66 kB     00:00
(4/35): dmidecode-2.10-3.el5.x86_64.rpm                                                                                                                                                                                             |  74 kB     00:00
(5/35): libart_lgpl-2.3.17-4.x86_64.rpm                                                                                                                                                                                             |  75 kB     00:00
(6/35): libart_lgpl-2.3.17-4.i386.rpm                                                                                                                                                                                               |  76 kB     00:00
(7/35): apr-util-1.2.7-11.el5.x86_64.rpm                                                                                                                                                                                            |  79 kB     00:00
(8/35): php-mysql-5.1.6-27.el5.x86_64.rpm                                                                                                                                                                                           |  89 kB     00:00
(9/35): apr-1.2.7-11.el5_3.1.x86_64.rpm                                                                                                                                                                                             | 118 kB     00:00
(10/35): perl-DBD-MySQL-3.0007-2.el5.x86_64.rpm                                                                                                                                                                                     | 148 kB     00:00
(11/35): php-common-5.1.6-27.el5.x86_64.rpm                                                                                                                                                                                         | 153 kB     00:00
(12/35): net-snmp-utils-5.3.2.2-9.el5_5.1.x86_64.rpm                                                                                                                                                                                | 188 kB     00:00
(13/35): libidn-0.6.5-1.1.x86_64.rpm                                                                                                                                                                                                | 195 kB     00:00
(14/35): postgresql-libs-8.1.21-1.el5_5.1.x86_64.rpm                                                                                                                                                                                | 196 kB     00:00
(15/35): gmp-4.1.4-10.el5.x86_64.rpm                                                                                                                                                                                                | 201 kB     00:00
(16/35): curl-7.15.5-9.el5.x86_64.rpm                                                                                                                                                                                               | 230 kB     00:01
(17/35): libpng-1.2.10-7.1.el5_5.3.x86_64.rpm                                                                                                                                                                                       | 234 kB     00:00
(18/35): libpng-1.2.10-7.1.el5_5.3.i386.rpm                                                                                                                                                                                         | 241 kB     00:00
(19/35): freetype-2.2.1-26.el5_5.x86_64.rpm                                                                                                                                                                                         | 310 kB     00:00
(20/35): freetype-2.2.1-26.el5_5.i386.rpm                                                                                                                                                                                           | 311 kB     00:00
(21/35): rrdtool-1.2.27-3.el5.i386.rpm                                                                                                                                                                                              | 464 kB     00:00
(22/35): rrdtool-1.2.27-3.el5.x86_64.rpm                                                                                                                                                                                            | 466 kB     00:00
(23/35): lm_sensors-2.10.7-9.el5.x86_64.rpm                                                                                                                                                                                         | 525 kB     00:01
(24/35): perl-DBI-1.52-2.el5.x86_64.rpm                                                                                                                                                                                             | 600 kB     00:01
(25/35): net-snmp-5.3.2.2-9.el5_5.1.x86_64.rpm                                                                                                                                                                                      | 702 kB     00:00
(26/35): aspell-0.60.3-7.1.x86_64.rpm                                                                                                                                                                                               | 946 kB     00:02
(27/35): ncurses-5.5-24.20060715.i386.rpm                                                                                                                                                                                           | 1.1 MB     00:03
(28/35): httpd-2.2.3-43.el5.centos.x86_64.rpm                                                                                                                                                                                       | 1.2 MB     00:01
(29/35): net-snmp-libs-5.3.2.2-9.el5_5.1.x86_64.rpm                                                                                                                                                                                 | 1.3 MB     00:00
(30/35): aspell-en-6.0-2.1.x86_64.rpm                                                                                                                                                                                               | 1.6 MB     00:03
(31/35): php-cli-5.1.6-27.el5.x86_64.rpm                                                                                                                                                                                            | 2.2 MB     00:04
(32/35): php-5.1.6-27.el5.x86_64.rpm                                                                                                                                                                                                | 2.3 MB     00:06
(33/35): mysql-5.0.77-4.el5_5.3.i386.rpm                                                                                                                                                                                            | 4.8 MB     00:00
(34/35): mysql-5.0.77-4.el5_5.3.x86_64.rpm                                                                                                                                                                                          | 4.8 MB     00:00
(35/35): mysql-server-5.0.77-4.el5_5.3.x86_64.rpm                                                                                                                                                                                   | 9.8 MB     00:01
———————————————————————————————————————————————————————————————————————————————————–
Total                                                                                                                                                                                                                      1.0 MB/s |  36 MB     00:35
warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID 217521f6
epel/gpgkey                                                                                                                                                                                                                         | 1.7 kB     00:00
Importing GPG key 0x217521F6 “Fedora EPEL <epel@fedoraproject.org>” from /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing     : php-common                                                                                                                                                                                                                         1/35
Installing     : perl-DBI                                                                                                                                                                                                                           2/35
Installing     : mysql                                                                                                                                                                                                                              3/35
Installing     : libidn                                                                                                                                                                                                                             4/35
Installing     : net-snmp-libs                                                                                                                                                                                                                      5/35
Installing     : curl                                                                                                                                                                                                                               6/35
Installing     : gmp                                                                                                                                                                                                                                7/35
Installing     : libpng                                                                                                                                                                                                                             8/35
Installing     : apr                                                                                                                                                                                                                                9/35
Installing     : perl-DBD-MySQL                                                                                                                                                                                                                    10/35
Installing     : php-pdo                                                                                                                                                                                                                           11/35
Installing     : dmidecode                                                                                                                                                                                                                         12/35
Installing     : lm_sensors                                                                                                                                                                                                                        13/35
Installing     : net-snmp                                                                                                                                                                                                                          14/35
Installing     : freetype                                                                                                                                                                                                                          15/35
Installing     : postgresql-libs                                                                                                                                                                                                                   16/35
Installing     : apr-util                                                                                                                                                                                                                          17/35
Installing     : libart_lgpl                                                                                                                                                                                                                       18/35
Installing     : libpng                                                                                                                                                                                                                            19/35
Installing     : ncurses                                                                                                                                                                                                                           20/35
Installing     : freetype                                                                                                                                                                                                                          21/35
Installing     : libart_lgpl                                                                                                                                                                                                                       22/35
Installing     : mailcap                                                                                                                                                                                                                           23/35
Installing     : httpd                                                                                                                                                                                                                             24/35
Installing     : rrdtool                                                                                                                                                                                                                           25/35
Installing     : net-snmp-utils                                                                                                                                                                                                                    26/35
Installing     : php-snmp                                                                                                                                                                                                                          27/35
Installing     : php-mysql                                                                                                                                                                                                                         28/35
Installing     : mysql-server                                                                                                                                                                                                                      29/35
Installing     : rrdtool                                                                                                                                                                                                                           30/35
Installing     : mysql                                                                                                                                                                                                                             31/35
Installing     : aspell                                                                                                                                                                                                                            32/35
Installing     : php-cli                                                                                                                                                                                                                           33/35
Installing     : php                                                                                                                                                                                                                               34/35
Installing     : aspell-en                                                                                                                                                                                                                         35/35

Installed:
httpd.x86_64 0:2.2.3-43.el5.centos         libart_lgpl.i386 0:2.3.17-4  libart_lgpl.x86_64 0:2.3.17-4    mysql.i386 0:5.0.77-4.el5_5.3   mysql.x86_64 0:5.0.77-4.el5_5.3  mysql-server.x86_64 0:5.0.77-4.el5_5.3  net-snmp.x86_64 1:5.3.2.2-9.el5_5.1
net-snmp-utils.x86_64 1:5.3.2.2-9.el5_5.1  php.x86_64 0:5.1.6-27.el5    php-mysql.x86_64 0:5.1.6-27.el5  php-snmp.x86_64 0:5.1.6-27.el5  rrdtool.i386 0:1.2.27-3.el5      rrdtool.x86_64 0:1.2.27-3.el5

Dependency Installed:
apr.x86_64 0:1.2.7-11.el5_3.1          apr-util.x86_64 0:1.2.7-11.el5         aspell.x86_64 12:0.60.3-7.1          aspell-en.x86_64 50:6.0-2.1                     curl.x86_64 0:7.15.5-9.el5                 dmidecode.x86_64 1:2.10-3.el5
freetype.i386 0:2.2.1-26.el5_5         freetype.x86_64 0:2.2.1-26.el5_5       gmp.x86_64 0:4.1.4-10.el5            libidn.x86_64 0:0.6.5-1.1                       libpng.i386 2:1.2.10-7.1.el5_5.3           libpng.x86_64 2:1.2.10-7.1.el5_5.3
lm_sensors.x86_64 0:2.10.7-9.el5       mailcap.noarch 0:2.1.23-1.fc6          ncurses.i386 0:5.5-24.20060715       net-snmp-libs.x86_64 1:5.3.2.2-9.el5_5.1        perl-DBD-MySQL.x86_64 0:3.0007-2.el5       perl-DBI.x86_64 0:1.52-2.el5
php-cli.x86_64 0:5.1.6-27.el5          php-common.x86_64 0:5.1.6-27.el5       php-pdo.x86_64 0:5.1.6-27.el5        postgresql-libs.x86_64 0:8.1.21-1.el5_5.1

Complete!
[root@testme ~]# chkconfig httpd on
[root@testme ~]# chkconfig snmpd on
[root@testme ~]# chkconfig mysqld on
[root@testme ~]# /etc/init.d/httpd restart
Stopping httpd:                                            [FAILED]
Starting httpd: httpd: Could not reliably determine the server’s fully qualified domain name, using 184.106.212.215 for ServerName
[  OK  ]
[root@testme ~]# /etc/init.d/mysqld restart
Stopping MySQL:                                            [FAILED]
Initializing MySQL database:  Installing MySQL system tables…
OK
Filling help tables…
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h testme password ‘new-password’

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com
[  OK  ]
Starting MySQL:                                            [  OK  ]
[root@testme ~]# /etc/init.d/snmpd restart
Stopping snmpd:                                            [FAILED]
Starting snmpd:                                            [  OK  ]
[root@testme ~]# rpm -qa | grep rrd
rrdtool-1.2.27-3.el5
rrdtool-1.2.27-3.el5
[root@testme ~]# vi /etc/my.cnf
[root@testme ~]# /etc/init.d/mysqld restart
Stopping MySQL:                                            [  OK  ]
Starting MySQL:                                            [  OK  ]
[root@testme ~]# netstat -ntlp | grep :3306
tcp        0      0 127.0.0.1:3306              0.0.0.0:*                   LISTEN      1350/mysqld
[root@testme ~]# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.77 Source distribution

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set Password=PASSWORD(‘password’) where User=’root’;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> create database cacti;
Query OK, 1 row affected (0.00 sec)

mysql> grant all privileges on cacti.* to ‘cacti’@'localhost’ identified by ‘password’ with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
[root@testme ~]# cd /var/www/html/
[root@testme html]# wget http://www.cacti.net/downloads/cacti-0.8.7g.tar.gz
–15:20:40–  http://www.cacti.net/downloads/cacti-0.8.7g.tar.gz
Resolving www.cacti.net… 140.211.167.231, 209.242.232.5
Connecting to www.cacti.net|140.211.167.231|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 2236916 (2.1M) [application/x-gzip]
Saving to: `cacti-0.8.7g.tar.gz’

100%[==================================================================================================================================================================================================================>] 2,236,916    131K/s   in 19s

15:20:59 (114 KB/s) – `cacti-0.8.7g.tar.gz’ saved [2236916/2236916]

[root@testme html]# tar -xvzf cacti-0.8.7g.tar.gz
cacti-0.8.7g/
cacti-0.8.7g/poller.php
cacti-0.8.7g/docs/
cacti-0.8.7g/docs/html/
cacti-0.8.7g/docs/html/delete_users.html
cacti-0.8.7g/docs/html/unix_apply_patches.html
cacti-0.8.7g/docs/html/cli_add_data_query.html
cacti-0.8.7g/docs/html/new_graphs.html
cacti-0.8.7g/docs/html/cli_poller_output_empty.html
cacti-0.8.7g/docs/html/testing_script_in_script_server.html
cacti-0.8.7g/docs/html/data_presentation.html
cacti-0.8.7g/docs/html/basics.html
cacti-0.8.7g/docs/html/bsd_ports.html
cacti-0.8.7g/docs/html/data_queries.html
cacti-0.8.7g/docs/html/host_variables.html
cacti-0.8.7g/docs/html/faq.html
cacti-0.8.7g/docs/html/copying_user.html
cacti-0.8.7g/docs/html/install_unix.html
cacti-0.8.7g/docs/html/migration_php_scripts_to_script_server.html
cacti-0.8.7g/docs/html/user_management.html
cacti-0.8.7g/docs/html/check_rrd_graph.html
cacti-0.8.7g/docs/html/check_cacti_poller.html
cacti-0.8.7g/docs/html/variables.html
cacti-0.8.7g/docs/html/cacti_help.html
cacti-0.8.7g/docs/html/debug_rpm_installation.html
cacti-0.8.7g/docs/html/installation.html
cacti-0.8.7g/docs/html/graph_viewing.html
cacti-0.8.7g/docs/html/check_rrd_owner.html
cacti-0.8.7g/docs/html/script_query_xml.html
cacti-0.8.7g/docs/html/scripts.html
cacti-0.8.7g/docs/html/templates.html
cacti-0.8.7g/docs/html/data_input_methods.html
cacti-0.8.7g/docs/html/how_to.html
cacti-0.8.7g/docs/html/check_data_gathering.html
cacti-0.8.7g/docs/html/rrdtool_features.html
cacti-0.8.7g/docs/html/cdefs.html
cacti-0.8.7g/docs/html/using_spine.html
cacti-0.8.7g/docs/html/advanced_topics.html
cacti-0.8.7g/docs/html/php_script_server.html
cacti-0.8.7g/docs/html/check_rrd_updating.html
cacti-0.8.7g/docs/html/batch_copy_users.html
cacti-0.8.7g/docs/html/debugging.html
cacti-0.8.7g/docs/html/graph_snmp_oid.html
cacti-0.8.7g/docs/html/unix_configure_httpd.html
cacti-0.8.7g/docs/html/template_import.html
cacti-0.8.7g/docs/html/cli_add_graphs.html
cacti-0.8.7g/docs/html/create_new_user.html
cacti-0.8.7g/docs/html/check_rrd_numbers.html
cacti-0.8.7g/docs/html/upgrade.html
cacti-0.8.7g/docs/html/images/
cacti-0.8.7g/docs/html/images/user_management_delete_1.png
cacti-0.8.7g/docs/html/images/user_management_enable_disable_2.png
cacti-0.8.7g/docs/html/images/host_template.png
cacti-0.8.7g/docs/html/images/user_management_delete_2.png
cacti-0.8.7g/docs/html/images/user_management_batch_copy_2.png
cacti-0.8.7g/docs/html/images/data_source_title_template.png
cacti-0.8.7g/docs/html/images/user_management_edit.png
cacti-0.8.7g/docs/html/images/graph_template.png
cacti-0.8.7g/docs/html/images/principles_of_operation.png
cacti-0.8.7g/docs/html/images/data_template.png
cacti-0.8.7g/docs/html/images/import_template.png
cacti-0.8.7g/docs/html/images/user_management_copy_1.png
cacti-0.8.7g/docs/html/images/graph_tree.png
cacti-0.8.7g/docs/html/images/user_management_copy_2.png
cacti-0.8.7g/docs/html/images/user_management_enable_disable_1.png
cacti-0.8.7g/docs/html/images/user_management_new.png
cacti-0.8.7g/docs/html/images/user_management_batch_copy_1.png
cacti-0.8.7g/docs/html/images/data_source_title_example2.png
cacti-0.8.7g/docs/html/images/data_source_title_example1.png
cacti-0.8.7g/docs/html/images/new_graphs.png
cacti-0.8.7g/docs/html/images/new_device.png
cacti-0.8.7g/docs/html/images/user_management_list.png
cacti-0.8.7g/docs/html/images/export_template.png
cacti-0.8.7g/docs/html/graph_templates.html
cacti-0.8.7g/docs/html/cli_copy_user.html
cacti-0.8.7g/docs/html/template_export.html
cacti-0.8.7g/docs/html/cli_poller_reindex_hosts.html
cacti-0.8.7g/docs/html/check_mysql_updating.html
cacti-0.8.7g/docs/html/reference.html
cacti-0.8.7g/docs/html/install_windows.html
cacti-0.8.7g/docs/html/unix_configure_php.html
cacti-0.8.7g/docs/html/unix_configure_cacti.html
cacti-0.8.7g/docs/html/snmp_query_xml.html
cacti-0.8.7g/docs/html/data_storage.html
cacti-0.8.7g/docs/html/graph_overview.html
cacti-0.8.7g/docs/html/host_templates.html
cacti-0.8.7g/docs/html/cli_poller_graphs_reapply_names.html
cacti-0.8.7g/docs/html/cli_add_tree.html
cacti-0.8.7g/docs/html/debug_miscellaneous.html
cacti-0.8.7g/docs/html/requirements.html
cacti-0.8.7g/docs/html/index.html
cacti-0.8.7g/docs/html/unix_configure_mysql.html
cacti-0.8.7g/docs/html/guest_access.html
cacti-0.8.7g/docs/html/cli_add_device.html
cacti-0.8.7g/docs/html/cli_add_graph_template.html
cacti-0.8.7g/docs/html/check_zero_values.html
cacti-0.8.7g/docs/html/graph_howto.html
cacti-0.8.7g/docs/html/cli_add_perms.html
cacti-0.8.7g/docs/html/making_scripts_work_with_cacti.html
cacti-0.8.7g/docs/html/upgrade_using_hostmib_data_queries.html
cacti-0.8.7g/docs/html/LICENSE.html
cacti-0.8.7g/docs/html/unix_configure_spine.html
cacti-0.8.7g/docs/html/operating_principles.html
cacti-0.8.7g/docs/html/enable_disable_users.html
cacti-0.8.7g/docs/README
cacti-0.8.7g/docs/CONTRIB
cacti-0.8.7g/docs/txt/
cacti-0.8.7g/docs/txt/manual.txt
cacti-0.8.7g/docs/pdf/
cacti-0.8.7g/docs/pdf/README
cacti-0.8.7g/docs/CHANGELOG
cacti-0.8.7g/host.php
cacti-0.8.7g/templates_import.php
cacti-0.8.7g/cli/
cacti-0.8.7g/cli/rebuild_poller_cache.php
cacti-0.8.7g/cli/poller_graphs_reapply_names.php
cacti-0.8.7g/cli/upgrade_database.php
cacti-0.8.7g/cli/add_graphs.php
cacti-0.8.7g/cli/add_perms.php
cacti-0.8.7g/cli/add_tree.php
cacti-0.8.7g/cli/repair_database.php
cacti-0.8.7g/cli/add_graph_template.php
cacti-0.8.7g/cli/add_data_query.php
cacti-0.8.7g/cli/import_template.php
cacti-0.8.7g/cli/add_device.php
cacti-0.8.7g/cli/copy_user.php
cacti-0.8.7g/cli/.htaccess
cacti-0.8.7g/cli/poller_reindex_hosts.php
cacti-0.8.7g/cli/poller_output_empty.php
cacti-0.8.7g/cli/poller_data_sources_reapply_names.php
cacti-0.8.7g/cli/convert_innodb.php
cacti-0.8.7g/cli/host_update_template.php
cacti-0.8.7g/cli/structure_rra_paths.php
cacti-0.8.7g/cli/repair_templates.php
cacti-0.8.7g/cmd.php
cacti-0.8.7g/utilities.php
cacti-0.8.7g/color.php
cacti-0.8.7g/lib/
cacti-0.8.7g/lib/poller.php
cacti-0.8.7g/lib/html_validate.php
cacti-0.8.7g/lib/functions.php
cacti-0.8.7g/lib/html.php
cacti-0.8.7g/lib/api_tree.php
cacti-0.8.7g/lib/import.php
cacti-0.8.7g/lib/html_utility.php
cacti-0.8.7g/lib/api_data_source.php
cacti-0.8.7g/lib/graph_export.php
cacti-0.8.7g/lib/auth.php
cacti-0.8.7g/lib/database.php
cacti-0.8.7g/lib/snmp.php
cacti-0.8.7g/lib/xml.php
cacti-0.8.7g/lib/adodb/
cacti-0.8.7g/lib/adodb/adodb-pear.inc.php
cacti-0.8.7g/lib/adodb/lang/
cacti-0.8.7g/lib/adodb/lang/adodb-pt-br.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-sv.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-es.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-fr.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-hu.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-ro.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-ca.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-it.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-pl.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-ru1251.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-bg.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-nl.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-cz.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-ar.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-de.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-en.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-cn.inc.php
cacti-0.8.7g/lib/adodb/lang/adodb-bgutf8.inc.php
cacti-0.8.7g/lib/adodb/adodb-xmlschema.inc.php
cacti-0.8.7g/lib/adodb/license.txt
cacti-0.8.7g/lib/adodb/adodb-csvlib.inc.php
cacti-0.8.7g/lib/adodb/adodb.inc.php
cacti-0.8.7g/lib/adodb/adodb-php4.inc.php
cacti-0.8.7g/lib/adodb/adodb-lib.inc.php
cacti-0.8.7g/lib/adodb/adodb-perf.inc.php
cacti-0.8.7g/lib/adodb/datadict/
cacti-0.8.7g/lib/adodb/datadict/datadict-generic.inc.php
cacti-0.8.7g/lib/adodb/datadict/datadict-informix.inc.php
cacti-0.8.7g/lib/adodb/datadict/datadict-oci8.inc.php
cacti-0.8.7g/lib/adodb/datadict/datadict-sapdb.inc.php
cacti-0.8.7g/lib/adodb/datadict/datadict-mssql.inc.php
cacti-0.8.7g/lib/adodb/datadict/datadict-mysql.inc.php
cacti-0.8.7g/lib/adodb/datadict/datadict-sybase.inc.php
cacti-0.8.7g/lib/adodb/datadict/datadict-access.inc.php
cacti-0.8.7g/lib/adodb/datadict/datadict-ibase.inc.php
cacti-0.8.7g/lib/adodb/datadict/datadict-postgres.inc.php
cacti-0.8.7g/lib/adodb/datadict/datadict-db2.inc.php
cacti-0.8.7g/lib/adodb/datadict/datadict-firebird.inc.php
cacti-0.8.7g/lib/adodb/adodb-error.inc.php
cacti-0.8.7g/lib/adodb/drivers/
cacti-0.8.7g/lib/adodb/drivers/adodb-postgres7.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-ado.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-odbtp.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-informix72.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-sybase.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-mysqlt.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-oci805.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-borland_ibase.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-ado_access.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-postgres.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-firebird.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-netezza.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-ibase.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-postgres64.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-db2.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-proxy.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-oci8po.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-odbc_mssql.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-mysqli.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-access.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-fbsql.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-sqlitepo.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-sqlite.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-mssqlpo.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-ado5.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-mysql.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-odbtp_unicode.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-vfp.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-oracle.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-odbc.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-ldap.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-sqlanywhere.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-oci8.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-pdo.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-csv.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-sapdb.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-informix.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-ado_mssql.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-mssql.inc.php
cacti-0.8.7g/lib/adodb/drivers/adodb-odbc_oracle.inc.php
cacti-0.8.7g/lib/adodb/adodb-time.inc.php
cacti-0.8.7g/lib/adodb/adodb-iterator.inc.php
cacti-0.8.7g/lib/adodb/adodb-datadict.inc.php
cacti-0.8.7g/lib/adodb/tohtml.inc.php
cacti-0.8.7g/lib/adodb/toexport.inc.php
cacti-0.8.7g/lib/adodb/adodb-exceptions.inc.php
cacti-0.8.7g/lib/adodb/adodb-errorpear.inc.php
cacti-0.8.7g/lib/adodb/adodb-errorhandler.inc.php
cacti-0.8.7g/lib/html_tree.php
cacti-0.8.7g/lib/api_device.php
cacti-0.8.7g/lib/html_form_template.php
cacti-0.8.7g/lib/api_poller.php
cacti-0.8.7g/lib/sort.php
cacti-0.8.7g/lib/graph_variables.php
cacti-0.8.7g/lib/rrd.php
cacti-0.8.7g/lib/variables.php
cacti-0.8.7g/lib/time.php
cacti-0.8.7g/lib/html_form.php
cacti-0.8.7g/lib/cdef.php
cacti-0.8.7g/lib/timespan_settings.php
cacti-0.8.7g/lib/utility.php
cacti-0.8.7g/lib/ldap.php
cacti-0.8.7g/lib/data_query.php
cacti-0.8.7g/lib/export.php
cacti-0.8.7g/lib/ping.php
cacti-0.8.7g/lib/tree.php
cacti-0.8.7g/lib/api_automation_tools.php
cacti-0.8.7g/lib/template.php
cacti-0.8.7g/lib/api_graph.php
cacti-0.8.7g/graphs_new.php
cacti-0.8.7g/graph_templates_inputs.php
cacti-0.8.7g/scripts/
cacti-0.8.7g/scripts/unix_processes.pl
cacti-0.8.7g/scripts/ss_fping.php
cacti-0.8.7g/scripts/unix_tcp_connections.pl
cacti-0.8.7g/scripts/sql.php
cacti-0.8.7g/scripts/diskfree.sh
cacti-0.8.7g/scripts/linux_memory.pl
cacti-0.8.7g/scripts/ss_sql.php
cacti-0.8.7g/scripts/unix_users.pl
cacti-0.8.7g/scripts/ss_host_cpu.php
cacti-0.8.7g/scripts/ping.pl
cacti-0.8.7g/scripts/weatherbug.pl
cacti-0.8.7g/scripts/loadavg.pl
cacti-0.8.7g/scripts/query_host_cpu.php
cacti-0.8.7g/scripts/query_unix_partitions.pl
cacti-0.8.7g/scripts/query_host_partitions.php
cacti-0.8.7g/scripts/diskfree.pl
cacti-0.8.7g/scripts/webhits.pl
cacti-0.8.7g/scripts/ss_host_disk.php
cacti-0.8.7g/scripts/3com_cable_modem.pl
cacti-0.8.7g/scripts/loadavg_multi.pl
cacti-0.8.7g/log/
cacti-0.8.7g/log/.htaccess
cacti-0.8.7g/log/cacti.log
cacti-0.8.7g/poller_export.php
cacti-0.8.7g/graph.php
cacti-0.8.7g/settings.php
cacti-0.8.7g/auth_changepassword.php
cacti-0.8.7g/data_input.php
cacti-0.8.7g/logout.php
cacti-0.8.7g/README
cacti-0.8.7g/templates_export.php
cacti-0.8.7g/user_admin.php
cacti-0.8.7g/graph_settings.php
cacti-0.8.7g/install/
cacti-0.8.7g/install/0_8_7f_to_0_8_7g.php
cacti-0.8.7g/install/0_8_7e_to_0_8_7f.php
cacti-0.8.7g/install/0_8_4_to_0_8_5.php
cacti-0.8.7g/install/0_8_3_to_0_8_4.php
cacti-0.8.7g/install/0_8_2a_to_0_8_3.php
cacti-0.8.7g/install/0_8_6j_to_0_8_7.php
cacti-0.8.7g/install/0_8_7d_to_0_8_7e.php
cacti-0.8.7g/install/0_8_to_0_8_1.php
cacti-0.8.7g/install/install_finish.gif
cacti-0.8.7g/install/0_8_5a_to_0_8_6.php
cacti-0.8.7g/install/0_8_6d_to_0_8_6e.php
cacti-0.8.7g/install/0_8_7b_to_0_8_7c.php
cacti-0.8.7g/install/0_8_6f_to_0_8_6g.php
cacti-0.8.7g/install/0_8_7a_to_0_8_7b.php
cacti-0.8.7g/install/0_8_7c_to_0_8_7d.php
cacti-0.8.7g/install/0_8_7_to_0_8_7a.php
cacti-0.8.7g/install/0_8_6g_to_0_8_6h.php
cacti-0.8.7g/install/0_8_6_to_0_8_6a.php
cacti-0.8.7g/install/0_8_2_to_0_8_2a.php
cacti-0.8.7g/install/0_8_1_to_0_8_2.php
cacti-0.8.7g/install/0_8_6h_to_0_8_6i.php
cacti-0.8.7g/install/install_next.gif
cacti-0.8.7g/install/0_8_6c_to_0_8_6d.php
cacti-0.8.7g/install/index.php
cacti-0.8.7g/graph_templates.php
cacti-0.8.7g/graphs_items.php
cacti-0.8.7g/images/
cacti-0.8.7g/images/tab_settings_down.gif
cacti-0.8.7g/images/tab_console_down.gif
cacti-0.8.7g/images/tab_console.gif
cacti-0.8.7g/images/button_refresh.gif
cacti-0.8.7g/images/button_export.gif
cacti-0.8.7g/images/show.gif
cacti-0.8.7g/images/button_add.gif
cacti-0.8.7g/images/move_left.gif
cacti-0.8.7g/images/favicon.ico
cacti-0.8.7g/images/button_view.gif
cacti-0.8.7g/images/calendar.gif
cacti-0.8.7g/images/button_create.gif
cacti-0.8.7g/images/graph_properties.gif
cacti-0.8.7g/images/button_import.gif
cacti-0.8.7g/images/tab_graphs_down.gif
cacti-0.8.7g/images/tab_mode_list.gif
cacti-0.8.7g/images/hide.gif
cacti-0.8.7g/images/tab_mode_preview.gif
cacti-0.8.7g/images/cacti_logo.gif
cacti-0.8.7g/images/tab_settings.gif
cacti-0.8.7g/images/auth_login.gif
cacti-0.8.7g/images/graph_page_top.gif
cacti-0.8.7g/images/button_cancel2.gif
cacti-0.8.7g/images/button_purge.gif
cacti-0.8.7g/images/button_help.gif
cacti-0.8.7g/images/shadow_gray.gif
cacti-0.8.7g/images/tab_mode_tree_down.gif
cacti-0.8.7g/images/button_no.gif
cacti-0.8.7g/images/auth_logout.gif
cacti-0.8.7g/images/arrow.gif
cacti-0.8.7g/images/cacti_backdrop.gif
cacti-0.8.7g/images/delete_icon.gif
cacti-0.8.7g/images/shadow.gif
cacti-0.8.7g/images/button_default.gif
cacti-0.8.7g/images/delete_icon_large.gif
cacti-0.8.7g/images/move_down.gif
cacti-0.8.7g/images/tab_cacti.gif
cacti-0.8.7g/images/tab_graphs.gif
cacti-0.8.7g/images/transparent_line.gif
cacti-0.8.7g/images/button_yes.gif
cacti-0.8.7g/images/move_right.gif
cacti-0.8.7g/images/button_colapse_all.gif
cacti-0.8.7g/images/button_clear.gif
cacti-0.8.7g/images/button_save.gif
cacti-0.8.7g/images/menu_line.gif
cacti-0.8.7g/images/cacti_about_logo.gif
cacti-0.8.7g/images/cacti_backdrop2.gif
cacti-0.8.7g/images/reload_icon_small.gif
cacti-0.8.7g/images/left_border.gif
cacti-0.8.7g/images/auth_deny.gif
cacti-0.8.7g/images/graph_zoom.gif
cacti-0.8.7g/images/button_delete.gif
cacti-0.8.7g/images/button_expand_all.gif
cacti-0.8.7g/images/tab_mode_list_down.gif
cacti-0.8.7g/images/move_up.gif
cacti-0.8.7g/images/graph_query.png
cacti-0.8.7g/images/button_cancel.gif
cacti-0.8.7g/images/menuarrow.gif
cacti-0.8.7g/images/tab_mode_preview_down.gif
cacti-0.8.7g/images/button_go.gif
cacti-0.8.7g/images/tab_mode_tree.gif
cacti-0.8.7g/graphs.php
cacti-0.8.7g/script_server.pl
cacti-0.8.7g/LICENSE
cacti-0.8.7g/graph_view.php
cacti-0.8.7g/host_templates.php
cacti-0.8.7g/graph_templates_items.php
cacti-0.8.7g/cacti.sql
cacti-0.8.7g/poller_commands.php
cacti-0.8.7g/include/
cacti-0.8.7g/include/global.php
cacti-0.8.7g/include/global_form.php
cacti-0.8.7g/include/top_header.php
cacti-0.8.7g/include/top_graph_header.php
cacti-0.8.7g/include/global_settings.php
cacti-0.8.7g/include/main.css
cacti-0.8.7g/include/treeview/
cacti-0.8.7g/include/treeview/ftv2lastnode.gif
cacti-0.8.7g/include/treeview/ftv2mnode.gif
cacti-0.8.7g/include/treeview/ftv2node.gif
cacti-0.8.7g/include/treeview/ftiens4_export.js
cacti-0.8.7g/include/treeview/ua.js
cacti-0.8.7g/include/treeview/ftv2blank.gif
cacti-0.8.7g/include/treeview/ftiens4.js
cacti-0.8.7g/include/treeview/ftv2pnode.gif
cacti-0.8.7g/include/treeview/ftv2plastnode.gif
cacti-0.8.7g/include/treeview/ftv2vertline.gif
cacti-0.8.7g/include/treeview/ftv2mlastnode.gif
cacti-0.8.7g/include/config.php
cacti-0.8.7g/include/auth.php
cacti-0.8.7g/include/bottom_footer.php
cacti-0.8.7g/include/layout.js
cacti-0.8.7g/include/jscalendar/
cacti-0.8.7g/include/jscalendar/lang/
cacti-0.8.7g/include/jscalendar/lang/calendar-ko.js
cacti-0.8.7g/include/jscalendar/lang/calendar-en.js
cacti-0.8.7g/include/jscalendar/lang/calendar-big5.js
cacti-0.8.7g/include/jscalendar/lang/cn_utf8.js
cacti-0.8.7g/include/jscalendar/lang/calendar-ru_win_.js
cacti-0.8.7g/include/jscalendar/lang/calendar-da.js
cacti-0.8.7g/include/jscalendar/lang/calendar-es.js
cacti-0.8.7g/include/jscalendar/lang/calendar-sk.js
cacti-0.8.7g/include/jscalendar/lang/calendar-cs-utf8.js
cacti-0.8.7g/include/jscalendar/lang/calendar-br.js
cacti-0.8.7g/include/jscalendar/lang/calendar-al.js
cacti-0.8.7g/include/jscalendar/lang/calendar-el.js
cacti-0.8.7g/include/jscalendar/lang/calendar-si.js
cacti-0.8.7g/include/jscalendar/lang/calendar-ro.js
cacti-0.8.7g/include/jscalendar/lang/calendar-bg.js
cacti-0.8.7g/include/jscalendar/lang/calendar-pl.js
cacti-0.8.7g/include/jscalendar/lang/calendar-af.js
cacti-0.8.7g/include/jscalendar/lang/calendar-nl.js
cacti-0.8.7g/include/jscalendar/lang/calendar-no.js
cacti-0.8.7g/include/jscalendar/lang/calendar-fi.js
cacti-0.8.7g/include/jscalendar/lang/calendar-ru.js
cacti-0.8.7g/include/jscalendar/lang/calendar-it.js
cacti-0.8.7g/include/jscalendar/lang/calendar-tr.js
cacti-0.8.7g/include/jscalendar/lang/calendar-jp.js
cacti-0.8.7g/include/jscalendar/lang/calendar-lt.js
cacti-0.8.7g/include/jscalendar/lang/calendar-lv.js
cacti-0.8.7g/include/jscalendar/lang/calendar-lt-utf8.js
cacti-0.8.7g/include/jscalendar/lang/calendar-pt.js
cacti-0.8.7g/include/jscalendar/lang/calendar-sv.js
cacti-0.8.7g/include/jscalendar/lang/calendar-sp.js
cacti-0.8.7g/include/jscalendar/lang/calendar-fr.js
cacti-0.8.7g/include/jscalendar/lang/calendar-cs-win.js
cacti-0.8.7g/include/jscalendar/lang/calendar-hr-utf8.js
cacti-0.8.7g/include/jscalendar/lang/calendar-du.js
cacti-0.8.7g/include/jscalendar/lang/calendar-de.js
cacti-0.8.7g/include/jscalendar/lang/calendar-hr.js
cacti-0.8.7g/include/jscalendar/lang/calendar-hu.js
cacti-0.8.7g/include/jscalendar/lang/calendar-ca.js
cacti-0.8.7g/include/jscalendar/lang/calendar-he-utf8.js
cacti-0.8.7g/include/jscalendar/lang/calendar-zh.js
cacti-0.8.7g/include/jscalendar/lang/calendar-big5-utf8.js
cacti-0.8.7g/include/jscalendar/lang/calendar-ko-utf8.js
cacti-0.8.7g/include/jscalendar/lang/calendar-pl-utf8.js
cacti-0.8.7g/include/jscalendar/calendar.js
cacti-0.8.7g/include/jscalendar/calendar-setup.js
cacti-0.8.7g/include/global_constants.php
cacti-0.8.7g/include/global_arrays.php
cacti-0.8.7g/include/zoom.js
cacti-0.8.7g/graph_image.php
cacti-0.8.7g/gprint_presets.php
cacti-0.8.7g/script_server.php
cacti-0.8.7g/rra/
cacti-0.8.7g/rra/.htaccess
cacti-0.8.7g/data_sources.php
cacti-0.8.7g/cdef.php
cacti-0.8.7g/resource/
cacti-0.8.7g/resource/snmp_queries/
cacti-0.8.7g/resource/snmp_queries/netware_disk.xml
cacti-0.8.7g/resource/snmp_queries/host_disk.xml
cacti-0.8.7g/resource/snmp_queries/interface.xml
cacti-0.8.7g/resource/snmp_queries/net-snmp_disk.xml
cacti-0.8.7g/resource/snmp_queries/netware_cpu.xml
cacti-0.8.7g/resource/snmp_queries/kbridge.xml
cacti-0.8.7g/resource/script_server/
cacti-0.8.7g/resource/script_server/host_disk.xml
cacti-0.8.7g/resource/script_server/host_cpu.xml
cacti-0.8.7g/resource/script_queries/
cacti-0.8.7g/resource/script_queries/unix_disk.xml
cacti-0.8.7g/resource/script_queries/host_disk.xml
cacti-0.8.7g/resource/script_queries/host_cpu.xml
cacti-0.8.7g/data_templates.php
cacti-0.8.7g/index.php
cacti-0.8.7g/about.php
cacti-0.8.7g/auth_login.php
cacti-0.8.7g/tree.php
cacti-0.8.7g/rra.php
cacti-0.8.7g/graph_xport.php
cacti-0.8.7g/data_queries.php
[root@testme html]# ln -s /var/www/html/cacti-0.8.7g /var/www/html/cacti
[root@testme html]# chown -R apache:apache /var/www/html/cacti*
[root@testme html]# mysql -u root -p cacti < /var/www/html/cacti/cacti.sql
Enter password:
[root@testme html]# mysql -u root -p cacti -e “show tables;”
Enter password:
+—————————+
| Tables_in_cacti           |
+—————————+
| cdef                      |
| cdef_items                |
| colors                    |
| data_input                |
| data_input_data           |
| data_input_fields         |
| data_local                |
| data_template             |
| data_template_data        |
| data_template_data_rra    |
| data_template_rrd         |
| graph_local               |
| graph_template_input      |
| graph_template_input_defs |
| graph_templates           |
| graph_templates_gprint    |
| graph_templates_graph     |
| graph_templates_item      |
| graph_tree                |
| graph_tree_items          |
| host                      |
| host_graph                |
| host_snmp_cache           |
| host_snmp_query           |
| host_template             |
| host_template_graph       |
| host_template_snmp_query  |
| poller                    |
| poller_command            |
| poller_item               |
| poller_output             |
| poller_reindex            |
| poller_time               |
| rra                       |
| rra_cf                    |
| settings                  |
| settings_graphs           |
| settings_tree             |
| snmp_query                |
| snmp_query_graph          |
| snmp_query_graph_rrd      |
| snmp_query_graph_rrd_sv   |
| snmp_query_graph_sv       |
| user_auth                 |
| user_auth_perms           |
| user_auth_realm           |
| user_log                  |
| version                   |
+—————————+
[root@testme html]# useradd cacti
[root@testme html]# passwd cacti
Changing password for user cacti.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@testme html]# crontab -e -u cacti
no crontab for cacti – using an empty one
crontab: installing new crontab
[root@testme html]# crontab -l -u cacti
*/5 * * * * php /var/www/html/cacti/poller.php > /dev/null 2>&1
[root@testme html]# chown -R cacti /var/www/html/cacti/rra* /var/www/html/cacti/log*
[root@testme html]# vi /var/www/html/cacti/include/config.php
[root@testme html]# cat /var/www/html/cacti/include/config.php
<?php
/*
+————————————————————————-+
| Copyright (C) 2004-2010 The Cacti Group                                 |
|                                                                         |
| This program is free software; you can redistribute it and/or           |
| modify it under the terms of the GNU General Public License             |
| as published by the Free Software Foundation; either version 2          |
| of the License, or (at your option) any later version.                  |
|                                                                         |
| This program is distributed in the hope that it will be useful,         |
| but WITHOUT ANY WARRANTY; without even the implied warranty of          |
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the           |
| GNU General Public License for more details.                            |
+————————————————————————-+
| Cacti: The Complete RRDTool-based Graphing Solution                     |
+————————————————————————-+
| This code is designed, written, and maintained by the Cacti Group. See  |
| about.php and/or the AUTHORS file for specific developer information.   |
+————————————————————————-+
| http://www.cacti.net/                                                   |
+————————————————————————-+
*/

/* make sure these values refect your actual database/host/user/password */
$database_type = “mysql”;
$database_default = “cacti”;
$database_hostname = “127.0.0.1″;
$database_username = “cacti”;
$database_password = “password”;
$database_port = “3306″;

/* Default session name – Session name must contain alpha characters */
#$cacti_session_name = “Cacti”;

?>
[root@testme html]# netstat -ntlp | grep :80
tcp        0      0 :::80                       :::*                        LISTEN      1084/httpd

install spine on RHEL-5/CentOS-5

Posted: 5th October 2009 by admin in Cacti
Tags: , , , ,

Quick and dirty how-to how to install the spine poller for cacti on centos or rhel 5. This is useful if you have a ton of sources being polled.

yum install net-snmp-devel mysql mysql-devel openssl-devel ksh automake autoconf libtool gcc make -y
cd
wget http://www.cacti.net/downloads/spine/cacti-spine-0.8.7c.tar.gz
tar -xvzf cacti-spine-0.8.7c.tar.gz
cd cacti-spine-0.8.7c
chmod 744 ./configure
autoconf
autoheader
automake
./configure
make
make install
cp /usr/local/spine/etc/spine.conf.dist /etc/spine.conf
edit ‘/etc/spine.conf’ to match cacti’s config.phpWithin the cacti GUI add the spine binary path in Settings > Paths ‘/usr/local/spine/bin/spine’ and then under the Poller tab change the type from cmd.php to Spine.

Current repolist
repo id repo name status
addons CentOS-5 – Addons enabled : 0
base CentOS-5 – Base enabled : 3,272
centosplus CentOS-5 – Plus enabled : 63
contrib CentOS-5 – Contrib enabled : 0
epel Epel from fedora enabled : 4,970
extras CentOS-5 – Extras enabled : 266
updates CentOS-5 – Updates enabled : 258

I have noted below a complete raw install of the newer version of spine.  Note that some of the auto* commands differ from the previous version…

[root@testme html]# cat /etc/redhat-release; uname -m
CentOS release 5.4 (Final)
x86_64
[root@testme html]# yum repolist
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* addons: hpc.arc.georgetown.edu
* base: mirrors.cmich.edu
* epel: mirrors.rit.edu
* extras: updates.interworx.info
* updates: updates.interworx.info
repo id                                                                                            repo name                                                                                                                                 status
addons                                                                                             CentOS-5 – Addons                                                                                                                         enabled:     0
base                                                                                               CentOS-5 – Base                                                                                                                           enabled: 3,434
epel                                                                                               Extra Packages for Enterprise Linux 5 – x86_64                                                                                            enabled: 5,675
extras                                                                                             CentOS-5 – Extras                                                                                                                         enabled:   298
updates                                                                                            CentOS-5 – Updates                                                                                                                        enabled:   541
repolist: 9,948
[root@testme html]# yum install net-snmp-devel mysql mysql-devel openssl-devel ksh automake autoconf libtool gcc make -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* addons: hpc.arc.georgetown.edu
* base: mirrors.cmich.edu
* epel: mirrors.rit.edu
* extras: updates.interworx.info
* updates: updates.interworx.info
Setting up Install Process
Package mysql-5.0.77-4.el5_5.3.x86_64 already installed and latest version
Package mysql-5.0.77-4.el5_5.3.i386 already installed and latest version
Resolving Dependencies
–> Running transaction check
—> Package autoconf.noarch 0:2.59-12 set to be updated
–> Processing Dependency: imake for package: autoconf
–> Processing Dependency: m4 for package: autoconf
—> Package automake.noarch 0:1.9.6-2.3.el5 set to be updated
—> Package gcc.x86_64 0:4.1.2-48.el5 set to be updated
–> Processing Dependency: cpp = 4.1.2-48.el5 for package: gcc
–> Processing Dependency: libgomp >= 4.1.2-48.el5 for package: gcc
–> Processing Dependency: libgcc >= 4.1.2-48.el5 for package: gcc
–> Processing Dependency: glibc-devel >= 2.2.90-12 for package: gcc
—> Package ksh.x86_64 0:20100202-1.el5 set to be updated
—> Package libtool.x86_64 0:1.5.22-7.el5_4 set to be updated
—> Package make.x86_64 1:3.81-3.el5 set to be updated
—> Package mysql-devel.i386 0:5.0.77-4.el5_5.3 set to be updated
—> Package mysql-devel.x86_64 0:5.0.77-4.el5_5.3 set to be updated
—> Package net-snmp-devel.i386 1:5.3.2.2-9.el5_5.1 set to be updated
–> Processing Dependency: libnetsnmpagent.so.10 for package: net-snmp-devel
–> Processing Dependency: libnetsnmptrapd.so.10 for package: net-snmp-devel
–> Processing Dependency: elfutils-devel for package: net-snmp-devel
–> Processing Dependency: elfutils-libelf-devel for package: net-snmp-devel
–> Processing Dependency: libnetsnmpmibs.so.10 for package: net-snmp-devel
–> Processing Dependency: libsnmp.so.10 for package: net-snmp-devel
–> Processing Dependency: libnetsnmphelpers.so.10 for package: net-snmp-devel
–> Processing Dependency: libnetsnmp.so.10 for package: net-snmp-devel
–> Processing Dependency: rpm-devel for package: net-snmp-devel
–> Processing Dependency: lm_sensors-devel for package: net-snmp-devel
–> Processing Dependency: beecrypt-devel for package: net-snmp-devel
—> Package net-snmp-devel.x86_64 1:5.3.2.2-9.el5_5.1 set to be updated
—> Package openssl-devel.i386 0:0.9.8e-12.el5_4.6 set to be updated
–> Processing Dependency: openssl = 0.9.8e-12.el5_4.6 for package: openssl-devel
–> Processing Dependency: zlib-devel for package: openssl-devel
–> Processing Dependency: krb5-devel for package: openssl-devel
—> Package openssl-devel.x86_64 0:0.9.8e-12.el5_4.6 set to be updated
–> Running transaction check
—> Package beecrypt-devel.x86_64 0:4.1.2-10.1.1 set to be updated
–> Processing Dependency: beecrypt = 4.1.2-10.1.1 for package: beecrypt-devel
–> Processing Dependency: libbeecrypt.so.6()(64bit) for package: beecrypt-devel
—> Package cpp.x86_64 0:4.1.2-48.el5 set to be updated
—> Package elfutils-devel.x86_64 0:0.137-3.el5 set to be updated
–> Processing Dependency: elfutils-libs-x86_64 = 0.137-3.el5 for package: elfutils-devel
–> Processing Dependency: elfutils-devel-static-x86_64 = 0.137-3.el5 for package: elfutils-devel
–> Processing Dependency: libdw.so.1()(64bit) for package: elfutils-devel
–> Processing Dependency: libasm.so.1()(64bit) for package: elfutils-devel
—> Package elfutils-libelf-devel.x86_64 0:0.137-3.el5 set to be updated
–> Processing Dependency: elfutils-libelf-devel-static-x86_64 = 0.137-3.el5 for package: elfutils-libelf-devel
—> Package glibc-devel.x86_64 0:2.5-49.el5_5.4 set to be updated
–> Processing Dependency: glibc = 2.5-49.el5_5.4 for package: glibc-devel
–> Processing Dependency: glibc-headers = 2.5-49.el5_5.4 for package: glibc-devel
–> Processing Dependency: glibc-headers for package: glibc-devel
—> Package imake.x86_64 0:1.0.2-3 set to be updated
—> Package krb5-devel.x86_64 0:1.6.1-36.el5_5.5 set to be updated
–> Processing Dependency: krb5-libs = 1.6.1-36.el5_5.5 for package: krb5-devel
–> Processing Dependency: libselinux-devel for package: krb5-devel
–> Processing Dependency: e2fsprogs-devel for package: krb5-devel
–> Processing Dependency: keyutils-libs-devel for package: krb5-devel
—> Package libgcc.i386 0:4.1.2-48.el5 set to be updated
—> Package libgcc.x86_64 0:4.1.2-48.el5 set to be updated
—> Package libgomp.x86_64 0:4.4.0-6.el5 set to be updated
—> Package lm_sensors-devel.x86_64 0:2.10.7-9.el5 set to be updated
—> Package m4.x86_64 0:1.4.5-3.el5.1 set to be updated
—> Package net-snmp-libs.i386 1:5.3.2.2-9.el5_5.1 set to be updated
—> Package openssl.i686 0:0.9.8e-12.el5_4.6 set to be updated
—> Package openssl.x86_64 0:0.9.8e-12.el5_4.6 set to be updated
—> Package rpm-devel.x86_64 0:4.4.2.3-18.el5 set to be updated
–> Processing Dependency: sqlite-devel for package: rpm-devel
–> Processing Dependency: nss-devel for package: rpm-devel
—> Package zlib-devel.x86_64 0:1.2.3-3 set to be updated
–> Running transaction check
—> Package beecrypt.x86_64 0:4.1.2-10.1.1 set to be updated
—> Package e2fsprogs-devel.x86_64 0:1.39-23.el5 set to be updated
—> Package elfutils-devel-static.x86_64 0:0.137-3.el5 set to be updated
—> Package elfutils-libelf-devel-static.x86_64 0:0.137-3.el5 set to be updated
—> Package elfutils-libs.x86_64 0:0.137-3.el5 set to be updated
—> Package glibc.i686 0:2.5-49.el5_5.4 set to be updated
–> Processing Dependency: glibc-common = 2.5-49.el5_5.4 for package: glibc
—> Package glibc.x86_64 0:2.5-49.el5_5.4 set to be updated
—> Package glibc-headers.x86_64 0:2.5-49.el5_5.4 set to be updated
–> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers
–> Processing Dependency: kernel-headers for package: glibc-headers
—> Package keyutils-libs-devel.x86_64 0:1.2-1.el5 set to be updated
—> Package krb5-libs.i386 0:1.6.1-36.el5_5.5 set to be updated
—> Package krb5-libs.x86_64 0:1.6.1-36.el5_5.5 set to be updated
—> Package libselinux-devel.x86_64 0:1.33.4-5.5.el5 set to be updated
–> Processing Dependency: libsepol-devel >= 1.15.2-1 for package: libselinux-devel
—> Package nss-devel.x86_64 0:3.12.6-2.el5.centos set to be updated
–> Processing Dependency: nss = 3.12.6-2.el5.centos for package: nss-devel
–> Processing Dependency: nspr-devel >= 4.8.4 for package: nss-devel
–> Processing Dependency: pkgconfig for package: nss-devel
—> Package sqlite-devel.x86_64 0:3.3.6-5 set to be updated
–> Running transaction check
—> Package glibc-common.x86_64 0:2.5-49.el5_5.4 set to be updated
—> Package kernel-headers.x86_64 0:2.6.18-194.8.1.el5 set to be updated
—> Package libsepol-devel.x86_64 0:1.15.2-3.el5 set to be updated
–> Processing Dependency: libsepol = 1.15.2-3.el5 for package: libsepol-devel
—> Package nspr-devel.x86_64 0:4.8.4-1.el5_4 set to be updated
–> Processing Dependency: nspr = 4.8.4-1.el5_4 for package: nspr-devel
—> Package nss.i386 0:3.12.6-2.el5.centos set to be updated
—> Package nss.x86_64 0:3.12.6-2.el5.centos set to be updated
—> Package pkgconfig.x86_64 1:0.21-2.el5 set to be updated
–> Running transaction check
—> Package libsepol.i386 0:1.15.2-3.el5 set to be updated
—> Package libsepol.x86_64 0:1.15.2-3.el5 set to be updated
—> Package nspr.i386 0:4.8.4-1.el5_4 set to be updated
—> Package nspr.x86_64 0:4.8.4-1.el5_4 set to be updated
–> Finished Dependency Resolution

Dependencies Resolved

===========================================================================================================================================================================================================================================================
Package                                                                   Arch                                                Version                                                          Repository                                            Size
===========================================================================================================================================================================================================================================================
Installing:
autoconf                                                                  noarch                                              2.59-12                                                          base                                                 647 k
automake                                                                  noarch                                              1.9.6-2.3.el5                                                    base                                                 476 k
gcc                                                                       x86_64                                              4.1.2-48.el5                                                     base                                                 5.3 M
ksh                                                                       x86_64                                              20100202-1.el5                                                   base                                                 1.2 M
libtool                                                                   x86_64                                              1.5.22-7.el5_4                                                   base                                                 667 k
make                                                                      x86_64                                              1:3.81-3.el5                                                     base                                                 470 k
mysql-devel                                                               i386                                                5.0.77-4.el5_5.3                                                 updates                                              2.4 M
mysql-devel                                                               x86_64                                              5.0.77-4.el5_5.3                                                 updates                                              2.5 M
net-snmp-devel                                                            i386                                                1:5.3.2.2-9.el5_5.1                                              updates                                              1.9 M
net-snmp-devel                                                            x86_64                                              1:5.3.2.2-9.el5_5.1                                              updates                                              2.0 M
openssl-devel                                                             i386                                                0.9.8e-12.el5_4.6                                                base                                                 1.9 M
openssl-devel                                                             x86_64                                              0.9.8e-12.el5_4.6                                                base                                                 1.9 M
Installing for dependencies:
beecrypt                                                                  x86_64                                              4.1.2-10.1.1                                                     base                                                  87 k
beecrypt-devel                                                            x86_64                                              4.1.2-10.1.1                                                     base                                                 118 k
cpp                                                                       x86_64                                              4.1.2-48.el5                                                     base                                                 2.9 M
e2fsprogs-devel                                                           x86_64                                              1.39-23.el5                                                      base                                                 632 k
elfutils-devel                                                            x86_64                                              0.137-3.el5                                                      base                                                  62 k
elfutils-devel-static                                                     x86_64                                              0.137-3.el5                                                      base                                                 119 k
elfutils-libelf-devel                                                     x86_64                                              0.137-3.el5                                                      base                                                  24 k
elfutils-libelf-devel-static                                              x86_64                                              0.137-3.el5                                                      base                                                  64 k
elfutils-libs                                                             x86_64                                              0.137-3.el5                                                      base                                                 183 k
glibc-devel                                                               x86_64                                              2.5-49.el5_5.4                                                   updates                                              2.4 M
glibc-headers                                                             x86_64                                              2.5-49.el5_5.4                                                   updates                                              592 k
imake                                                                     x86_64                                              1.0.2-3                                                          base                                                 319 k
kernel-headers                                                            x86_64                                              2.6.18-194.8.1.el5                                               updates                                              1.1 M
keyutils-libs-devel                                                       x86_64                                              1.2-1.el5                                                        base                                                  27 k
krb5-devel                                                                x86_64                                              1.6.1-36.el5_5.5                                                 updates                                              1.9 M
libgomp                                                                   x86_64                                              4.4.0-6.el5                                                      base                                                  68 k
libselinux-devel                                                          x86_64                                              1.33.4-5.5.el5                                                   base                                                 149 k
libsepol-devel                                                            x86_64                                              1.15.2-3.el5                                                     base                                                 192 k
lm_sensors-devel                                                          x86_64                                              2.10.7-9.el5                                                     base                                                  85 k
m4                                                                        x86_64                                              1.4.5-3.el5.1                                                    base                                                 171 k
net-snmp-libs                                                             i386                                                1:5.3.2.2-9.el5_5.1                                              updates                                              1.3 M
nspr-devel                                                                x86_64                                              4.8.4-1.el5_4                                                    updates                                              111 k
nss-devel                                                                 x86_64                                              3.12.6-2.el5.centos                                              updates                                              233 k
pkgconfig                                                                 x86_64                                              1:0.21-2.el5                                                     base                                                  61 k
rpm-devel                                                                 x86_64                                              4.4.2.3-18.el5                                                   base                                                 1.3 M
sqlite-devel                                                              x86_64                                              3.3.6-5                                                          base                                                 257 k
zlib-devel                                                                x86_64                                              1.2.3-3                                                          base                                                 102 k
Updating for dependencies:
glibc                                                                     i686                                                2.5-49.el5_5.4                                                   updates                                              5.3 M
glibc                                                                     x86_64                                              2.5-49.el5_5.4                                                   updates                                              4.7 M
glibc-common                                                              x86_64                                              2.5-49.el5_5.4                                                   updates                                               16 M
krb5-libs                                                                 i386                                                1.6.1-36.el5_5.5                                                 updates                                              662 k
krb5-libs                                                                 x86_64                                              1.6.1-36.el5_5.5                                                 updates                                              675 k
libgcc                                                                    i386                                                4.1.2-48.el5                                                     base                                                  95 k
libgcc                                                                    x86_64                                              4.1.2-48.el5                                                     base                                                  98 k
libsepol                                                                  i386                                                1.15.2-3.el5                                                     base                                                 128 k
libsepol                                                                  x86_64                                              1.15.2-3.el5                                                     base                                                 131 k
nspr                                                                      i386                                                4.8.4-1.el5_4                                                    updates                                              120 k
nspr                                                                      x86_64                                              4.8.4-1.el5_4                                                    updates                                              119 k
nss                                                                       i386                                                3.12.6-2.el5.centos                                              updates                                              1.1 M
nss                                                                       x86_64                                              3.12.6-2.el5.centos                                              updates                                              1.1 M
openssl                                                                   i686                                                0.9.8e-12.el5_4.6                                                base                                                 1.4 M
openssl                                                                   x86_64                                              0.9.8e-12.el5_4.6                                                base                                                 1.4 M

Transaction Summary
===========================================================================================================================================================================================================================================================
Install     39 Package(s)
Update      15 Package(s)
Remove       0 Package(s)

Total download size: 69 M
Downloading Packages:
(1/54): elfutils-libelf-devel-0.137-3.el5.x86_64.rpm                                                                                                                                                                                |  24 kB     00:00
(2/54): keyutils-libs-devel-1.2-1.el5.x86_64.rpm                                                                                                                                                                                    |  27 kB     00:00
(3/54): pkgconfig-0.21-2.el5.x86_64.rpm                                                                                                                                                                                             |  61 kB     00:00
(4/54): elfutils-devel-0.137-3.el5.x86_64.rpm                                                                                                                                                                                       |  62 kB     00:00
(5/54): elfutils-libelf-devel-static-0.137-3.el5.x86_64.rpm                                                                                                                                                                         |  64 kB     00:00
(6/54): libgomp-4.4.0-6.el5.x86_64.rpm                                                                                                                                                                                              |  68 kB     00:00
(7/54): lm_sensors-devel-2.10.7-9.el5.x86_64.rpm                                                                                                                                                                                    |  85 kB     00:00
(8/54): beecrypt-4.1.2-10.1.1.x86_64.rpm                                                                                                                                                                                            |  87 kB     00:00
(9/54): libgcc-4.1.2-48.el5.i386.rpm                                                                                                                                                                                                |  95 kB     00:00
(10/54): libgcc-4.1.2-48.el5.x86_64.rpm                                                                                                                                                                                             |  98 kB     00:00
(11/54): zlib-devel-1.2.3-3.x86_64.rpm                                                                                                                                                                                              | 102 kB     00:00
(12/54): nspr-devel-4.8.4-1.el5_4.x86_64.rpm                                                                                                                                                                                        | 111 kB     00:00
(13/54): beecrypt-devel-4.1.2-10.1.1.x86_64.rpm                                                                                                                                                                                     | 118 kB     00:00
(14/54): nspr-4.8.4-1.el5_4.x86_64.rpm                                                                                                                                                                                              | 119 kB     00:00
(15/54): elfutils-devel-static-0.137-3.el5.x86_64.rpm                                                                                                                                                                               | 119 kB     00:00
(16/54): nspr-4.8.4-1.el5_4.i386.rpm                                                                                                                                                                                                | 120 kB     00:00
(17/54): libsepol-1.15.2-3.el5.i386.rpm                                                                                                                                                                                             | 128 kB     00:00
(18/54): libsepol-1.15.2-3.el5.x86_64.rpm                                                                                                                                                                                           | 131 kB     00:00
(19/54): libselinux-devel-1.33.4-5.5.el5.x86_64.rpm                                                                                                                                                                                 | 149 kB     00:00
(20/54): m4-1.4.5-3.el5.1.x86_64.rpm                                                                                                                                                                                                | 171 kB     00:00
(21/54): elfutils-libs-0.137-3.el5.x86_64.rpm                                                                                                                                                                                       | 183 kB     00:00
(22/54): libsepol-devel-1.15.2-3.el5.x86_64.rpm                                                                                                                                                                                     | 192 kB     00:00
(23/54): nss-devel-3.12.6-2.el5.centos.x86_64.rpm                                                                                                                                                                                   | 233 kB     00:00
(24/54): sqlite-devel-3.3.6-5.x86_64.rpm                                                                                                                                                                                            | 257 kB     00:00
(25/54): imake-1.0.2-3.x86_64.rpm                                                                                                                                                                                                   | 319 kB     00:00
(26/54): make-3.81-3.el5.x86_64.rpm                                                                                                                                                                                                 | 470 kB     00:00
(27/54): automake-1.9.6-2.3.el5.noarch.rpm                                                                                                                                                                                          | 476 kB     00:00
(28/54): glibc-headers-2.5-49.el5_5.4.x86_64.rpm                                                                                                                                                                                    | 592 kB     00:00
(29/54): e2fsprogs-devel-1.39-23.el5.x86_64.rpm                                                                                                                                                                                     | 632 kB     00:00
(30/54): autoconf-2.59-12.noarch.rpm                                                                                                                                                                                                | 647 kB     00:01
(31/54): krb5-libs-1.6.1-36.el5_5.5.i386.rpm                                                                                                                                                                                        | 662 kB     00:00
(32/54): libtool-1.5.22-7.el5_4.x86_64.rpm                                                                                                                                                                                          | 667 kB     00:01
(33/54): krb5-libs-1.6.1-36.el5_5.5.x86_64.rpm                                                                                                                                                                                      | 675 kB     00:00
(34/54): nss-3.12.6-2.el5.centos.i386.rpm                                                                                                                                                                                           | 1.1 MB     00:00
(35/54): kernel-headers-2.6.18-194.8.1.el5.x86_64.rpm                                                                                                                                                                               | 1.1 MB     00:00
(36/54): nss-3.12.6-2.el5.centos.x86_64.rpm                                                                                                                                                                                         | 1.1 MB     00:00
(37/54): ksh-20100202-1.el5.x86_64.rpm                                                                                                                                                                                              | 1.2 MB     00:04
(38/54): net-snmp-libs-5.3.2.2-9.el5_5.1.i386.rpm                                                                                                                                                                                   | 1.3 MB     00:00
(39/54): rpm-devel-4.4.2.3-18.el5.x86_64.rpm                                                                                                                                                                                        | 1.3 MB     00:01
(40/54): openssl-0.9.8e-12.el5_4.6.i686.rpm                                                                                                                                                                                         | 1.4 MB     00:01
(41/54): openssl-0.9.8e-12.el5_4.6.x86_64.rpm                                                                                                                                                                                       | 1.4 MB     00:01
(42/54): openssl-devel-0.9.8e-12.el5_4.6.x86_64.rpm                                                                                                                                                                                 | 1.9 MB     00:02
(43/54): krb5-devel-1.6.1-36.el5_5.5.x86_64.rpm                                                                                                                                                                                     | 1.9 MB     00:00
(44/54): openssl-devel-0.9.8e-12.el5_4.6.i386.rpm                                                                                                                                                                                   | 1.9 MB     00:02
(45/54): net-snmp-devel-5.3.2.2-9.el5_5.1.i386.rpm                                                                                                                                                                                  | 1.9 MB     00:00
(46/54): net-snmp-devel-5.3.2.2-9.el5_5.1.x86_64.rpm                                                                                                                                                                                | 2.0 MB     00:00
(47/54): glibc-devel-2.5-49.el5_5.4.x86_64.rpm                                                                                                                                                                                      | 2.4 MB     00:00
(48/54): mysql-devel-5.0.77-4.el5_5.3.i386.rpm                                                                                                                                                                                      | 2.4 MB     00:00
(49/54): mysql-devel-5.0.77-4.el5_5.3.x86_64.rpm                                                                                                                                                                                    | 2.5 MB     00:00
(50/54): cpp-4.1.2-48.el5.x86_64.rpm                                                                                                                                                                                                | 2.9 MB     00:03
(51/54): glibc-2.5-49.el5_5.4.x86_64.rpm                                                                                                                                                                                            | 4.7 MB     00:00
(52/54): gcc-4.1.2-48.el5.x86_64.rpm                                                                                                                                                                                                | 5.3 MB     00:08
(53/54): glibc-2.5-49.el5_5.4.i686.rpm                                                                                                                                                                                              | 5.3 MB     00:00
(54/54): glibc-common-2.5-49.el5_5.4.x86_64.rpm                                                                                                                                                                                     |  16 MB     00:02
———————————————————————————————————————————————————————————————————————————————————–
Total                                                                                                                                                                                                                      1.8 MB/s |  69 MB     00:39
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Updating       : libgcc                                                                                                                                                                                                                             1/69
Updating       : glibc-common                                                                                                                                                                                                                       2/69
Installing     : lm_sensors-devel                                                                                                                                                                                                                   3/69
Installing     : zlib-devel                                                                                                                                                                                                                         4/69
Installing     : e2fsprogs-devel                                                                                                                                                                                                                    5/69
Installing     : sqlite-devel                                                                                                                                                                                                                       6/69
Installing     : kernel-headers                                                                                                                                                                                                                     7/69
Installing     : keyutils-libs-devel                                                                                                                                                                                                                8/69
Updating       : libgcc                                                                                                                                                                                                                             9/69
Updating       : glibc                                                                                                                                                                                                                             10/69
Updating       : glibc                                                                                                                                                                                                                             11/69
Updating       : nspr                                                                                                                                                                                                                              12/69
Updating       : krb5-libs                                                                                                                                                                                                                         13/69
Updating       : openssl                                                                                                                                                                                                                           14/69
Updating       : nss                                                                                                                                                                                                                               15/69
Installing     : beecrypt                                                                                                                                                                                                                          16/69
Installing     : elfutils-libs                                                                                                                                                                                                                     17/69
Installing     : libgomp                                                                                                                                                                                                                           18/69
Installing     : pkgconfig                                                                                                                                                                                                                         19/69
Installing     : m4                                                                                                                                                                                                                                20/69
Updating       : libsepol                                                                                                                                                                                                                          21/69
Installing     : cpp                                                                                                                                                                                                                               22/69
Installing     : imake                                                                                                                                                                                                                             23/69
Installing     : make                                                                                                                                                                                                                              24/69
Installing     : ksh                                                                                                                                                                                                                               25/69
Updating       : krb5-libs                                                                                                                                                                                                                         26/69
Updating       : openssl                                                                                                                                                                                                                           27/69
Updating       : nspr                                                                                                                                                                                                                              28/69
Updating       : nss                                                                                                                                                                                                                               29/69
Installing     : net-snmp-libs                                                                                                                                                                                                                     30/69
Updating       : libsepol                                                                                                                                                                                                                          31/69
Installing     : autoconf                                                                                                                                                                                                                          32/69
Installing     : beecrypt-devel                                                                                                                                                                                                                    33/69
Installing     : automake                                                                                                                                                                                                                          34/69
Installing     : libsepol-devel                                                                                                                                                                                                                    35/69
Installing     : libselinux-devel                                                                                                                                                                                                                  36/69
Installing     : krb5-devel                                                                                                                                                                                                                        37/69
Installing     : openssl-devel                                                                                                                                                                                                                     38/69
Installing     : nspr-devel                                                                                                                                                                                                                        39/69
Installing     : nss-devel                                                                                                                                                                                                                         40/69
Installing     : glibc-headers                                                                                                                                                                                                                     41/69
Installing     : glibc-devel                                                                                                                                                                                                                       42/69
Installing     : mysql-devel                                                                                                                                                                                                                       43/69
Installing     : mysql-devel                                                                                                                                                                                                                       44/69
Installing     : openssl-devel                                                                                                                                                                                                                     45/69
Installing     : libtool                                                                                                                                                                                                                           46/69
Installing     : gcc                                                                                                                                                                                                                               47/69
Installing     : elfutils-libelf-devel                                                                                                                                                                                                             48/69
Installing     : rpm-devel                                                                                                                                                                                                                         49/69
Installing     : elfutils-libelf-devel-static                                                                                                                                                                                                      50/69
Installing     : elfutils-devel                                                                                                                                                                                                                    51/69
Installing     : net-snmp-devel                                                                                                                                                                                                                    52/69
Installing     : net-snmp-devel                                                                                                                                                                                                                    53/69
Installing     : elfutils-devel-static                                                                                                                                                                                                             54/69
Cleanup        : nspr                                                                                                                                                                                                                              55/69
Cleanup        : glibc-common                                                                                                                                                                                                                      56/69
Cleanup        : openssl                                                                                                                                                                                                                           57/69
Cleanup        : krb5-libs                                                                                                                                                                                                                         58/69
Cleanup        : libgcc                                                                                                                                                                                                                            59/69
Cleanup        : nss                                                                                                                                                                                                                               60/69
Cleanup        : libsepol                                                                                                                                                                                                                          61/69
Cleanup        : glibc                                                                                                                                                                                                                             62/69
Cleanup        : nspr                                                                                                                                                                                                                              63/69
Cleanup        : libsepol                                                                                                                                                                                                                          64/69
Cleanup        : openssl                                                                                                                                                                                                                           65/69
Cleanup        : nss                                                                                                                                                                                                                               66/69
Cleanup        : glibc                                                                                                                                                                                                                             67/69
Cleanup        : krb5-libs                                                                                                                                                                                                                         68/69
Cleanup        : libgcc                                                                                                                                                                                                                            69/69

Installed:
autoconf.noarch 0:2.59-12             automake.noarch 0:1.9.6-2.3.el5         gcc.x86_64 0:4.1.2-48.el5                 ksh.x86_64 0:20100202-1.el5                 libtool.x86_64 0:1.5.22-7.el5_4          make.x86_64 1:3.81-3.el5
mysql-devel.i386 0:5.0.77-4.el5_5.3   mysql-devel.x86_64 0:5.0.77-4.el5_5.3   net-snmp-devel.i386 1:5.3.2.2-9.el5_5.1   net-snmp-devel.x86_64 1:5.3.2.2-9.el5_5.1   openssl-devel.i386 0:0.9.8e-12.el5_4.6   openssl-devel.x86_64 0:0.9.8e-12.el5_4.6

Dependency Installed:
beecrypt.x86_64 0:4.1.2-10.1.1                    beecrypt-devel.x86_64 0:4.1.2-10.1.1              cpp.x86_64 0:4.1.2-48.el5                                e2fsprogs-devel.x86_64 0:1.39-23.el5          elfutils-devel.x86_64 0:0.137-3.el5
elfutils-devel-static.x86_64 0:0.137-3.el5        elfutils-libelf-devel.x86_64 0:0.137-3.el5        elfutils-libelf-devel-static.x86_64 0:0.137-3.el5        elfutils-libs.x86_64 0:0.137-3.el5            glibc-devel.x86_64 0:2.5-49.el5_5.4
glibc-headers.x86_64 0:2.5-49.el5_5.4             imake.x86_64 0:1.0.2-3                            kernel-headers.x86_64 0:2.6.18-194.8.1.el5               keyutils-libs-devel.x86_64 0:1.2-1.el5        krb5-devel.x86_64 0:1.6.1-36.el5_5.5
libgomp.x86_64 0:4.4.0-6.el5                      libselinux-devel.x86_64 0:1.33.4-5.5.el5          libsepol-devel.x86_64 0:1.15.2-3.el5                     lm_sensors-devel.x86_64 0:2.10.7-9.el5        m4.x86_64 0:1.4.5-3.el5.1
net-snmp-libs.i386 1:5.3.2.2-9.el5_5.1            nspr-devel.x86_64 0:4.8.4-1.el5_4                 nss-devel.x86_64 0:3.12.6-2.el5.centos                   pkgconfig.x86_64 1:0.21-2.el5                 rpm-devel.x86_64 0:4.4.2.3-18.el5
sqlite-devel.x86_64 0:3.3.6-5                     zlib-devel.x86_64 0:1.2.3-3

Dependency Updated:
glibc.i686 0:2.5-49.el5_5.4         glibc.x86_64 0:2.5-49.el5_5.4   glibc-common.x86_64 0:2.5-49.el5_5.4  krb5-libs.i386 0:1.6.1-36.el5_5.5  krb5-libs.x86_64 0:1.6.1-36.el5_5.5  libgcc.i386 0:4.1.2-48.el5        libgcc.x86_64 0:4.1.2-48.el5
libsepol.i386 0:1.15.2-3.el5        libsepol.x86_64 0:1.15.2-3.el5  nspr.i386 0:4.8.4-1.el5_4             nspr.x86_64 0:4.8.4-1.el5_4        nss.i386 0:3.12.6-2.el5.centos       nss.x86_64 0:3.12.6-2.el5.centos  openssl.i686 0:0.9.8e-12.el5_4.6
openssl.x86_64 0:0.9.8e-12.el5_4.6

Complete!
[root@testme html]# cd
[root@testme ~]# wget http://www.cacti.net/downloads/spine/cacti-spine-0.8.7g.tar.gz
–15:36:03–  http://www.cacti.net/downloads/spine/cacti-spine-0.8.7g.tar.gz
Resolving www.cacti.net… 140.211.167.231, 209.242.232.5
Connecting to www.cacti.net|140.211.167.231|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 592801 (579K) [application/x-gzip]
Saving to: `cacti-spine-0.8.7g.tar.gz’

100%[==================================================================================================================================================================================================================>] 592,801      462K/s   in 1.3s

15:36:05 (462 KB/s) – `cacti-spine-0.8.7g.tar.gz’ saved [592801/592801]

[root@testme ~]# tar -xvzf cacti-spine-0.8.7g.tar.gz
cacti-spine-0.8.7g/
cacti-spine-0.8.7g/configure.ac
cacti-spine-0.8.7g/keywords.c
cacti-spine-0.8.7g/ChangeLog
cacti-spine-0.8.7g/snmp.c
cacti-spine-0.8.7g/package
cacti-spine-0.8.7g/Makefile.am
cacti-spine-0.8.7g/INSTALL
cacti-spine-0.8.7g/README-WINDOWS
cacti-spine-0.8.7g/configure
cacti-spine-0.8.7g/util.h
cacti-spine-0.8.7g/COPYING
cacti-spine-0.8.7g/locks.c
cacti-spine-0.8.7g/spine.h
cacti-spine-0.8.7g/ping.c
cacti-spine-0.8.7g/ping.h
cacti-spine-0.8.7g/README
cacti-spine-0.8.7g/nft_popen.h
cacti-spine-0.8.7g/Makefile.in
cacti-spine-0.8.7g/poller.h
cacti-spine-0.8.7g/sql.c
cacti-spine-0.8.7g/NEWS
cacti-spine-0.8.7g/php.h
cacti-spine-0.8.7g/autom4te.cache/
cacti-spine-0.8.7g/autom4te.cache/requests
cacti-spine-0.8.7g/autom4te.cache/traces.1
cacti-spine-0.8.7g/autom4te.cache/output.1
cacti-spine-0.8.7g/autom4te.cache/output.0
cacti-spine-0.8.7g/autom4te.cache/traces.0
cacti-spine-0.8.7g/LICENSE.LGPL
cacti-spine-0.8.7g/LICENSE
cacti-spine-0.8.7g/aclocal.m4
cacti-spine-0.8.7g/bootstrap
cacti-spine-0.8.7g/error.h
cacti-spine-0.8.7g/keywords.h
cacti-spine-0.8.7g/snmp.h
cacti-spine-0.8.7g/error.c
cacti-spine-0.8.7g/config/
cacti-spine-0.8.7g/config/ltmain.sh
cacti-spine-0.8.7g/config/config.sub
cacti-spine-0.8.7g/config/config.guess
cacti-spine-0.8.7g/config/missing
cacti-spine-0.8.7g/config/config.h.in
cacti-spine-0.8.7g/config/depcomp
cacti-spine-0.8.7g/config/install-sh
cacti-spine-0.8.7g/spine.c
cacti-spine-0.8.7g/common.h
cacti-spine-0.8.7g/AUTHORS
cacti-spine-0.8.7g/util.c
cacti-spine-0.8.7g/nft_popen.c
cacti-spine-0.8.7g/poller.c
cacti-spine-0.8.7g/sql.h
cacti-spine-0.8.7g/spine.conf.dist
cacti-spine-0.8.7g/locks.h
cacti-spine-0.8.7g/php.c
[root@testme ~]# cd cacti-spine-0.8.7g
[root@testme cacti-spine-0.8.7g]# autoreconf -fvi
autoreconf: Entering directory `.’
autoreconf: configure.ac: not using Gettext
autoreconf: running: aclocal –force
autoreconf: configure.ac: tracing
autoreconf: running: libtoolize –copy –force
Using `AC_PROG_RANLIB’ is rendered obsolete by `AC_PROG_LIBTOOL’
Putting files in AC_CONFIG_AUX_DIR, `config’.
autoreconf: running: /usr/bin/autoconf –force
autoreconf: running: /usr/bin/autoheader –force
autoreconf: running: automake –add-missing –copy –force-missing
autoreconf: Leaving directory `.’
[root@testme cacti-spine-0.8.7g]# make
make: *** No targets specified and no makefile found.  Stop.
[root@testme cacti-spine-0.8.7g]# ./configure
checking build system type… x86_64-unknown-linux-gnu
checking host system type… x86_64-unknown-linux-gnu
checking for a BSD-compatible install… /usr/bin/install -c
checking whether build environment is sane… yes
checking for gawk… gawk
checking whether make sets $(MAKE)… yes
checking for gawk… (cached) gawk
checking for gcc… gcc
checking for C compiler default output file name… a.out
checking whether the C compiler works… yes
checking whether we are cross compiling… no
checking for suffix of executables…
checking for suffix of object files… o
checking whether we are using the GNU C compiler… yes
checking whether gcc accepts -g… yes
checking for gcc option to accept ANSI C… none needed
checking for style of include used by make… GNU
checking dependency style of gcc… gcc3
checking how to run the C preprocessor… gcc -E
checking for a BSD-compatible install… /usr/bin/install -c
checking whether ln -s works… yes
checking for a sed that does not truncate output… /bin/sed
checking for egrep… grep -E
checking for ld used by gcc… /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld… yes
checking for /usr/bin/ld option to reload object files… -r
checking for BSD-compatible nm… /usr/bin/nm -B
checking how to recognise dependent libraries… pass_all
checking for ANSI C header files… yes
checking for sys/types.h… yes
checking for sys/stat.h… yes
checking for stdlib.h… yes
checking for string.h… yes
checking for memory.h… yes
checking for strings.h… yes
checking for inttypes.h… yes
checking for stdint.h… yes
checking for unistd.h… yes
checking dlfcn.h usability… yes
checking dlfcn.h presence… yes
checking for dlfcn.h… yes
checking for g++… no
checking for c++… no
checking for gpp… no
checking for aCC… no
checking for CC… no
checking for cxx… no
checking for cc++… no
checking for cl… no
checking for FCC… no
checking for KCC… no
checking for RCC… no
checking for xlC_r… no
checking for xlC… no
checking whether we are using the GNU C++ compiler… no
checking whether g++ accepts -g… no
checking dependency style of g++… none
checking for g77… no
checking for f77… no
checking for xlf… no
checking for frt… no
checking for pgf77… no
checking for fort77… no
checking for fl32… no
checking for af77… no
checking for f90… no
checking for xlf90… no
checking for pgf90… no
checking for epcf90… no
checking for f95… no
checking for fort… no
checking for xlf95… no
checking for ifc… no
checking for efc… no
checking for pgf95… no
checking for lf95… no
checking for gfortran… no
checking whether we are using the GNU Fortran 77 compiler… no
checking whether  accepts -g… no
checking the maximum length of command line arguments… 32768
checking command to parse /usr/bin/nm -B output from gcc object… ok
checking for objdir… .libs
checking for ar… ar
checking for ranlib… ranlib
checking for strip… strip
checking if gcc supports -fno-rtti -fno-exceptions… no
checking for gcc option to produce PIC… -fPIC
checking if gcc PIC flag -fPIC works… yes
checking if gcc static flag -static works… yes
checking if gcc supports -c -o file.o… yes
checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries… yes
checking whether -lc should be explicitly linked in… no
checking dynamic linker characteristics… GNU/Linux ld.so
checking how to hardcode library paths into programs… immediate
checking whether stripping libraries is possible… yes
checking if libtool supports shared libraries… yes
checking whether to build shared libraries… yes
checking whether to build static libraries… yes
configure: creating libtool
appending configuration tag “CXX” to libtool
appending configuration tag “F77″ to libtool
checking for ranlib… (cached) ranlib
checking whether to enable -Wall… no
checking for threadsafe gethostbyname()… no
checking for gethostbyname_r in -lnls… no
checking for socket in -lsocket… no
checking for floor in -lm… yes
checking for pthread_exit in -lpthread… yes
checking for deflate in -lz… yes
checking for kstat_close in -lkstat… no
checking for CRYPTO_realloc in -lcrypto… yes
checking for ANSI C header files… (cached) yes
checking sys/socket.h usability… yes
checking sys/socket.h presence… yes
checking for sys/socket.h… yes
checking sys/select.h usability… yes
checking sys/select.h presence… yes
checking for sys/select.h… yes
checking sys/wait.h usability… yes
checking sys/wait.h presence… yes
checking for sys/wait.h… yes
checking sys/time.h usability… yes
checking sys/time.h presence… yes
checking for sys/time.h… yes
checking assert.h usability… yes
checking assert.h presence… yes
checking for assert.h… yes
checking ctype.h usability… yes
checking ctype.h presence… yes
checking for ctype.h… yes
checking errno.h usability… yes
checking errno.h presence… yes
checking for errno.h… yes
checking signal.h usability… yes
checking signal.h presence… yes
checking for signal.h… yes
checking math.h usability… yes
checking math.h presence… yes
checking for math.h… yes
checking malloc.h usability… yes
checking malloc.h presence… yes
checking for malloc.h… yes
checking netdb.h usability… yes
checking netdb.h presence… yes
checking for netdb.h… yes
checking for signal.h… (cached) yes
checking stdarg.h usability… yes
checking stdarg.h presence… yes
checking for stdarg.h… yes
checking stdio.h usability… yes
checking stdio.h presence… yes
checking for stdio.h… yes
checking syslog.h usability… yes
checking syslog.h presence… yes
checking for syslog.h… yes
checking for netinet/in_systm.h… yes
checking for netinet/in.h… yes
checking for netinet/ip.h… yes
checking for netinet/ip_icmp.h… yes
checking for unsigned long long… yes
checking for long long… yes
checking for an ANSI C-conforming const… yes
checking for size_t… yes
checking whether time.h and sys/time.h may both be included… yes
checking whether struct tm is in sys/time.h or time.h… time.h
checking return type of signal handlers… void
checking for malloc… yes
checking for calloc… yes
checking for gettimeofday… yes
checking for strerror… yes
checking for strtoll… yes
checking priv.h usability… no
checking priv.h presence… no
checking for priv.h… no
checking whether we are using Solaris privileges… no
checking for mysql_init in -lmysqlclient_r… yes
checking for mysql_thread_init in -lmysqlclient_r… yes
checking if UCD-SNMP needs crypto support… no
checking if Net-SNMP needs crypto support… yes
checking for snmp_timeout in -lnetsnmp… yes
checking for the spine results buffer size… 1024 bytes
checking for the maximum simultaneous spine scripts… 20
checking for the maximum MySQL buffer size… 65536
checking whether we are using traditional popen… no
checking whether to verify net-snmp library vs header versions… no
checking for glibc gethostbyname_r… yes
checking for Solaris/Irix gethostbyname_r… no
checking for HP-UX gethostbyname_r… no
configure: creating ./config.status
config.status: creating Makefile
config.status: creating config/config.h
config.status: executing depfiles commands
[root@testme cacti-spine-0.8.7g]# make
if gcc -DHAVE_CONFIG_H -I. -I. -I./config     -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT sql.o -MD -MP -MF “.deps/sql.Tpo” -c -o sql.o sql.c; \
then mv -f “.deps/sql.Tpo” “.deps/sql.Po”; else rm -f “.deps/sql.Tpo”; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config     -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT spine.o -MD -MP -MF “.deps/spine.Tpo” -c -o spine.o spine.c; \
then mv -f “.deps/spine.Tpo” “.deps/spine.Po”; else rm -f “.deps/spine.Tpo”; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config     -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT util.o -MD -MP -MF “.deps/util.Tpo” -c -o util.o util.c; \
then mv -f “.deps/util.Tpo” “.deps/util.Po”; else rm -f “.deps/util.Tpo”; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config     -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT snmp.o -MD -MP -MF “.deps/snmp.Tpo” -c -o snmp.o snmp.c; \
then mv -f “.deps/snmp.Tpo” “.deps/snmp.Po”; else rm -f “.deps/snmp.Tpo”; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config     -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT locks.o -MD -MP -MF “.deps/locks.Tpo” -c -o locks.o locks.c; \
then mv -f “.deps/locks.Tpo” “.deps/locks.Po”; else rm -f “.deps/locks.Tpo”; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config     -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT poller.o -MD -MP -MF “.deps/poller.Tpo” -c -o poller.o poller.c; \
then mv -f “.deps/poller.Tpo” “.deps/poller.Po”; else rm -f “.deps/poller.Tpo”; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config     -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT nft_popen.o -MD -MP -MF “.deps/nft_popen.Tpo” -c -o nft_popen.o nft_popen.c; \
then mv -f “.deps/nft_popen.Tpo” “.deps/nft_popen.Po”; else rm -f “.deps/nft_popen.Tpo”; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config     -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT php.o -MD -MP -MF “.deps/php.Tpo” -c -o php.o php.c; \
then mv -f “.deps/php.Tpo” “.deps/php.Po”; else rm -f “.deps/php.Tpo”; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config     -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT ping.o -MD -MP -MF “.deps/ping.Tpo” -c -o ping.o ping.c; \
then mv -f “.deps/ping.Tpo” “.deps/ping.Po”; else rm -f “.deps/ping.Tpo”; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config     -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT keywords.o -MD -MP -MF “.deps/keywords.Tpo” -c -o keywords.o keywords.c; \
then mv -f “.deps/keywords.Tpo” “.deps/keywords.Po”; else rm -f “.deps/keywords.Tpo”; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config     -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -MT error.o -MD -MP -MF “.deps/error.Tpo” -c -o error.o error.c; \
then mv -f “.deps/error.Tpo” “.deps/error.Po”; else rm -f “.deps/error.Tpo”; exit 1; fi
/bin/sh ./libtool –tag=CC –mode=link gcc  -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2  -L/usr/lib64 -L/usr/lib64/mysql  -o spine  sql.o spine.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o error.o  -lnetsnmp -lmysqlclient_r -lmysqlclient_r -lcrypto -lz -lpthread -lm
mkdir .libs
gcc -I/usr/include/net-snmp -I/usr/include/net-snmp/.. -I/usr/include/mysql -g -O2 -o spine sql.o spine.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o error.o  -L/usr/lib64 -L/usr/lib64/mysql -lnetsnmp -lmysqlclient_r -lcrypto -lz -lpthread -lm
[root@testme cacti-spine-0.8.7g]# make install
make[1]: Entering directory `/root/cacti-spine-0.8.7g’
test -z “/usr/local/spine/bin” || mkdir -p — “/usr/local/spine/bin”
/bin/sh ./libtool –mode=install /usr/bin/install -c ‘spine’ ‘/usr/local/spine/bin/spine’
/usr/bin/install -c spine /usr/local/spine/bin/spine
test -z “/usr/local/spine/etc” || mkdir -p — “/usr/local/spine/etc”
/usr/bin/install -c -m 644 ‘spine.conf.dist’ ‘/usr/local/spine/etc/spine.conf.dist’
make[1]: Leaving directory `/root/cacti-spine-0.8.7g’
[root@testme cacti-spine-0.8.7g]# cp /usr/local/spine/etc/spine.conf.dist /etc/spine.conf
[root@testme cacti-spine-0.8.7g]# vi /etc/spine.conf
[root@testme cacti-spine-0.8.7g]# stat /usr/local/spine/bin/spine
File: `/usr/local/spine/bin/spine’
Size: 247573        Blocks: 496        IO Block: 4096   regular file
Device: ca01h/51713d    Inode: 65634       Links: 1
Access: (0755/-rwxr-xr-x)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2010-08-10 17:01:16.000000000 +0000
Modify: 2010-08-10 17:01:16.000000000 +0000
Change: 2010-08-10 17:01:16.000000000 +0000
[root@testme cacti-spine-0.8.7g]# cat /etc/spine.conf
# +————————————————————————-+
# | Copyright (C) 2005-2010 The Cacti Group                                 |
# |                                                                         |
# | This program is free software; you can redistribute it and/or           |
# | modify it under the terms of the GNU Lesser General Public License      |
# | as published by the Free Software Foundation; either version 2.1        |
# | of the License, or (at your option) any later version.                  |
# |                                                                         |
# | This program is distributed in the hope that it will be useful,         |
# | but WITHOUT ANY WARRANTY; without even the implied warranty of          |
# | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the           |
# | GNU General Public License for more details.                            |
# +————————————————————————-+
# | spine: a backend data gatherer for Cacti                                |
# +————————————————————————-+
# | This poller would not have been possible without:                       |
# |   – Larry Adams (current development and enhancements)                  |
# |   – Rivo Nurges (rrd support, mysql poller cache, misc functions)       |
# |   – RTG (core poller code, pthreads, snmp, autoconf examples)           |
# |   – Brady Alleman/Doug Warner (threading ideas, implimentation details) |
# +————————————————————————-+
# | Settings                                                                |
# +————————————————————————-+
# | DB_Host         ‘localhost’ or socket file for UNIX/Linux               |
# |                 IP Address for Windows                                  |
# | DB_Database     Database name, typically ‘cacti’                        |
# | DB_Port         The database port to use                                |
# | DB_User         The user to access the database, typically ‘cactiuser’  |
# | DB_Pass         The password for the Cacti user                         |
# | SNMP_Clientaddr Bind SNMP to a specific address for sites that use      |
# |                 higher security levels                                  |
# | DB_PreG         Set to 1 if you wish to work with older versions of     |
# |                 cacti 0.8.7.                                            |
# +————————————————————————-+
DB_Host         127.0.0.1
DB_Database     cacti
DB_User         cacti
DB_Pass         password
DB_Port         3306
DB_PreG         0

install smokeping on fedora 9/10

Posted: 5th October 2009 by admin in Smokeping
Tags: ,

Smokeping – http://oss.oetiker.ch/smokeping/ – is an AWESOME tool to keep track of the latency of your sites, servers, and best of all your ISP! Currently I have ATT Uverse and I’m loving it, however, I used to live in a more rural area and had to use a fixed wireless ISP for my “broadband”. They often had issues and had minimal monitoring on their end so they depended on users telling them when things were not going so well (reactive and not proactive, great…).

Smokeping pings each destination on a regular interval and graphs each response noting packetloss and jitter with “smoke”.

I personally use it to ping my home router along with a very reliable url such as www.fedora.com. This helps when I am seeing a high amount of packet loss as I can just call up my ISP and point them to my website so that they can see first hand the trends that are occurring and cannot deny the degraded service in any way.

A sample of a smokeping is shown below.


On both debian and fedora smokeping can be found in the default repositories. Once this has been installed all you need to do is configure ‘/etc/smokeping/config’

Example noted below.

+ trunty

menu = trunty
title = Travis Runty’s ping tests

++ Home

menu = trunty’s home connection
title = Trunty’s home Internet America connection (UVERSE)
host = kyle.travisrunty.com

Once you have made the configuration changes save them and restart the smokeping daemon.

reset mysql root password

Posted: 5th October 2009 by admin in Mysql

If you have forgotten the root mysql password and you do not have an alternate user with equivalent permissions you can easily define a new root password following the below steps.

Note: Obviously mysql connections will be interrupted during this processes as we will be restarting the service and not listening on the network for a bit.

/etc/init.d/mysqld stop
mysqld_safe –skip-networking –skip-grant-tables
mysql -u root
mysql> use mysql;
mysql> update user set Password=PASSWORD(‘testpassword’) where User=’root’;
mysql> quit
/etc/init.d/mysqld restart

    add mysql user

    Posted: 5th October 2009 by admin in Mysql
    Tags: , ,

    How to add a mysql user, define permissions, and set password in one command.

    mysql> GRANT ALL PRIVILEGES ON *.* TO ‘monty’@'localhost’
    -> IDENTIFIED BY ‘some_pass’ WITH GRANT OPTION;
    mysql> GRANT ALL PRIVILEGES ON *.* TO ‘monty’@'%’
    -> IDENTIFIED BY ‘some_pass’ WITH GRANT OPTION;
    mysql> GRANT RELOAD,PROCESS ON *.* TO ‘admin’@'localhost’;
    mysql> GRANT USAGE ON *.* TO ‘dummy’@'localhost’;

    I primarily use the first method, however, obviously different circumstances (permissions) call for different commands.

    After you make any permission or user changes be sure to run ‘flush privileges;’ to apply your changes. (Note: when you restart mysql new changes are applied at this time as well).

    Link where information was taken from: http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

    simple mysql health check

    Posted: 5th October 2009 by admin in Mysql
    Tags: ,

    Simple? Yes. Useful? Yes.

    Although the below is very simple it can be a very useful and effective way to regularly check apache functionality and its ability to communicate with mysql.

    <html>
    <head>
    <title>Test mysql communications</title>
    </head>
    <body>
    <!–test–>
    <?php
    $dbhost = ‘localhost:3306′;
    $dbuser = ‘trunty’;
    $dbpass = ‘password’;
    $conn = mysql_connect($dbhost, $dbuser, $dbpass);
    if(! $conn)
    {
    die(‘Could not connect: ‘ . mysql_error());
    }
    echo ‘Connected successfully’;
    mysql_close($conn);
    ?>
    </body>
    </html>

    identify high memory usage

    Posted: 5th October 2009 by admin in Snippets
    Tags: , , ,

    Simple snippets to identify general memory usage.

    Show top 10 memory consuming processes
    ps xuaw –sort -rss | head

    Display general memory summary
    free -m

    Display detailed memory breakdown
    cat /proc/meminfo

    high CPU usage

    Posted: 5th October 2009 by admin in Snippets
    Tags: , ,

    Snippets useful for investigating high CPU usage

    Top 10 CPU consuming processes
    ps -eo pcpu,pid,user,args | sort -k 1 -r | head -10

    Identify device encountering IO wait (x is optional and will display more details)
    iostat -x 5

    Identify processes encountering IO wait (and usually causing the IO)
    ps -eo pid,stat,args,wchan | grep ‘ D’

    And of course the awesome tool of ‘sar’ that is provided within the ‘sysstat’ package.

    low disk space

    Posted: 5th October 2009 by admin in Snippets
    Tags: , , , , ,

    Simple snippets useful for troubleshooting low disk space.

    Using ‘du’ against a directory and single filesystem and sorting i
    du -hxc –max-depth=1 / | sort -n

    Find command that displays the 10 largest files within the defined directory
    find /tmp -mount -type f -ls | sort -k 7 -r -n | head -10