New installation - Trying to use old data

[..::BFS::..]

Hi all,

We had to reinstall our Cacti server, we updated the server to Windows 2003 Standard Edition. After the installation I installed PHP, RRD, Apache en MySQL. I imported my database dump into the new installation of MySQL, this didn't cause any problems. After I confirmed that PHP en Apache where both working I copied the old cacti folder back into the \Apache2\htdocs folder.

I installed the new version of Cacti and it asked me if I would like to upgrade my existing installation and so I did. But after installing Cacti won't show graphs. I see *.rrd files in the RRA directory but Cacti won't show the old graphs. And it doesn't create new graphs.

I know I'm missing something here but can't seem to find out what I did wrong, can somebody help me with this?

OS:
Windows 2003 Standard Edition
Cacti version:
0.8.6f
Apache version:
Apache 2.0.54
PHP version:
PHP 5.0.4
MySQL version:
MySQL 4.1

When I take a look at my graphs I can see:

Code: Select all

D:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=1124717618 \
--end=1124804018 \
--title="balbilpix01 - CPU Usage" \
--rigid \
--base=1000 \
--height=90 \
--width=370 \
--alt-autoscale-max \
--lower-limit=0 \
COMMENT:"From 2005/08/22 15:33:38 To 2005/08/23 15:33:38\c" \
COMMENT:"  \n" \
--vertical-label="percent" \
DEF:a="D\:\Apache2\htdocs/rra/balbilpix01_5min_cpu_545.rrd":5min_cpu:AVERAGE \
AREA:a#FF0000:"CPU Usage"  \
GPRINT:a:LAST:"Current\:%8.0lf"  \
GPRINT:a:AVERAGE:"Average\:%8.0lf"  \
GPRINT:a:MAX:"Maximum\:%8.0lf" 

If somebody needs more information, please ask...

Grtz Kc

[BSOD2600]

Turn the polling level in cacti to debug (Settings | Polling level) for one cycle and paste the output of the log file (./cacti/cacti.log). If it contains WEBLOG entries, then don't bother posting since they just clutter up the log. Turn off WEBEVENTS logging and try again.

Sure NTFS permissions are properly set on cmd.exe, rrdtool.exe and the rrd folder?

[sirprotos]

Turn the polling level in cacti to debug (Settings | Polling level) for one cycle and paste the output of the log file (./cacti/cacti.log). If it contains WEBLOG entries, then don't bother posting since they just clutter up the log. Turn off WEBEVENTS logging and try again.

Sure NTFS permissions are properly set on cmd.exe, rrdtool.exe and the rrd folder?

how really to do that ! i have an NTFS file system but i can't see any security tab or any in the meaning of security in the properties ?

Please guide me !?

[..::BFS::..]

I'm running Cacti as Administrator first, after I get it to create graphs again I'll use a Cacti-User for running the scheduled task.


Output from the logfile:

Code: Select all

21/2005 11:26:58 AM - POLLER: Poller[0] Maximum runtime of 296 seconds exceeded. Exiting.
07/21/2005 11:31:58 AM - POLLER: Poller[0] Maximum runtime of 296 seconds exceeded. Exiting.
07/21/2005 11:36:58 AM - POLLER: Poller[0] Maximum runtime of 296 seconds exceeded. Exiting.
07/21/2005 11:41:58 AM - POLLER: Poller[0] Maximum runtime of 296 seconds exceeded. Exiting.
07/21/2005 11:46:58 AM - POLLER: Poller[0] Maximum runtime of 296 seconds exceeded. Exiting.

[BSOD2600]

Turn the polling level in cacti to debug (Settings | Polling level) for one cycle and paste the output of the log file (./cacti/cacti.log). If it contains WEBLOG entries, then don't bother posting since they just clutter up the log. Turn off WEBEVENTS logging and try again.

Hmm, your a system administrator and don't know how to set NTFS security? turn off simple security (I think it's called) and then you should see a security tab on all files/folders.

[..::BFS::..]

@BSOD2600, This is the logfile while debugging. And the security question wasn't my question.

[BSOD2600]

No, that is the log file for LOW output. If you turned it to DEBUG, you will see a LOT more information.

[..::BFS::..]

Here you go:

09/09/2005 11:36:07 AM - WEBLOG: Poller[0] CACTI2RRD: D:/rrd_tool/rrdtool.exe graph - --imgformat=PNG --start=1126172159 --end=1126258559 --title="balbilpix01 - Current Connections" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2005/09/08 11:35:59 To 2005/09/09 11:35:59\c" COMMENT:"\n" --vertical-label="Conn" DEF:a="D\:\Apache2\htdocs\Cacti/rra/balbilpix01_pixconn_546.rrd":pixconn:AVERAGE AREA:a#CCBB00:"" GPRINTAVERAGE:"Current Conn%8.2lf %s\n" GPRINTMAX:"Max Conns%8.2lf %s\n" GPRINTLAST:"Current Conns%8.2lf %s"


I see the following path:

D\:\Apache2\htdocs\Cacti/rra/balbilpix01_pixconn_546.rrd

This should be D:\Apache2\htdocs\Cacti/rra/balbilpix01_pixconn_546.rrd but how do I change this path?

[Edit]
I've been searching and found that this path is correct... But I don't see why it isn't working
[/Edit]

[TheWitness]

Nope, all colons must be escaped with "\" character. Send an e-mail to Bill Gates, it's his fault.

Ok, here's a few pointers:

1) mysql -u root -p cacti
>truncate table poller_output;
>quit;

2) Increase Max memory and Max execution time in php.ini file.

3) from a command line run: "php <patch_cacti>/cmd.php - you should see some good output

4) from a command line run: "php <path_cacti>/poller.php - you should see, "Waiting on Poller..." and a bunch of Ok's. If there are to be any error's you will see them here.

TheWitness

[..::BFS::..]

Thanks for your help, I get the following output by using these steps:


SQL Change

Code: Select all

F:\Program Files\MySQL\MySQL Server 4.1\bin>mysql -u root -p cacti
Enter password: *******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 366 to server version: 4.1.12a-nt

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

mysql> truncate table poller_output;
Query OK, 0 rows affected (0.02 sec)

mysql> quit;
Bye

CMD.Php

Code: Select all

09/09/2005 12:46:22 PM - CMDPHP: Poller[0] Host[79] WARNING: Result from SNMP no
t valid.  Partial Result:
09/09/2005 12:46:22 PM - CMDPHP: Poller[0] Host[79] SNMP: v1: 111.222.333.444.187.242, ds
name: 5min_cpu, oid: .1.3.6.1.4.1.9.9.109.1.1.1.1.5.1, output: U
09/09/2005 12:46:24 PM - CMDPHP: Poller[0] Host[79] WARNING: Result from SNMP no
t valid.  Partial Result:
09/09/2005 12:46:24 PM - CMDPHP: Poller[0] Host[79] SNMP: v1: 111.222.333.444, ds
name: pixconn, oid: 1.3.6.1.4.1.9.9.147.1.2.2.2.1.5.40.6, output: U
09/09/2005 12:46:26 PM - CMDPHP: Poller[0] Host[79] WARNING: Result from SNMP no
t valid.  Partial Result:
09/09/2005 12:46:26 PM - CMDPHP: Poller[0] Host[79] SNMP: v1: 111.222.333.444, ds
name: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, output: U
09/09/2005 12:46:28 PM - CMDPHP: Poller[0] Host[79] WARNING: Result from SNMP no
t valid.  Partial Result:
09/09/2005 12:46:28 PM - CMDPHP: Poller[0] Host[79] SNMP: v1: 111.222.333.444, ds
name: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, output: U
09/09/2005 12:46:30 PM - CMDPHP: Poller[0] Host[79] WARNING: Result from SNMP no
t valid.  Partial Result:

Poller.php

Code: Select all

09/09/2005 12:50:47 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces
s [CMD: D:/php/php.exe, ARGS: -q d:\apache2\htdocs\cacti/cmd.php 0 85]
Waiting on 1/1 pollers.
Cannot find module (IP-MIB): At line 0 in (none)
Cannot find module (IF-MIB): At line 0 in (none)
Cannot find module (TCP-MIB): At line 0 in (none)
Cannot find module (UDP-MIB): At line 0 in (none)
Cannot find module (SNMPv2-MIB): At line 0 in (none)
Cannot find module (SNMPv2-SMI): At line 0 in (none)
Cannot find module (UCD-SNMP-MIB): At line 0 in (none)
Cannot find module (UCD-DEMO-MIB): At line 0 in (none)
Cannot find module (SNMP-TARGET-MIB): At line 0 in (none)
Cannot find module (SNMP-VIEW-BASED-ACM-MIB): At line 0 in (none)
Cannot find module (SNMP-COMMUNITY-MIB): At line 0 in (none)
Cannot find module (UCD-DLMOD-MIB): At line 0 in (none)
Cannot find module (SNMP-FRAMEWORK-MIB): At line 0 in (none)
Cannot find module (SNMP-MPD-MIB): At line 0 in (none)
Cannot find module (SNMP-USER-BASED-SM-MIB): At line 0 in (none)
Cannot find module (SNMP-NOTIFICATION-MIB): At line 0 in (none)
Cannot find module (SNMPv2-TM): At line 0 in (none)
Waiting on 1/1 pollers.
09/09/2005 12:55:43 PM - POLLER: Poller[0] Maximum runtime of 296 seconds exceed
ed. Exiting.

On the poller I get a lot of Waiting on 1/1 Pollers but these aren't really usefull in troubleshooting.

[BSOD2600]

When running cmd.php, did you notice all the OIDs which didn't return anything (hence the output of U) ? Those are what you need to fix.

[..::BFS::..]

When running cmd.php, did you notice all the OIDs which didn't return anything (hence the output of U) ? Those are what you need to fix.

Strange, because I imported the database from a export so the OID's are the same as from my last install. And these are standard OID's (most of them are from Cacti 'out of the box'.

Even newly added devices won't give normal output?

[BSOD2600]

1) Does any device return SNMP data?
2) When getting properties on a device, do you see the basic snmp info at the top?
3) If you manully walk the OIDs which are not returning anything with getif or net-snmp snmpwalk, are the results valid?

[..::BFS::..]

1) Does any device return SNMP data?
2) When getting properties on a device, do you see the basic snmp info at the top?
3) If you manully walk the OIDs which are not returning anything with getif or net-snmp snmpwalk, are the results valid?

1) Yes, while adding a new device I go to 'Create graphs for this device' and I get 'normal' data.

2) Yes

Code: Select all

SNMP Information
System: Cisco PIX Firewall Version 6.3(4).
Uptime: 1692207600

3) Let me get back to you on this one but:


I tried running the php d:\apache2\htdocs\cacti/cmd.php again and noticed that I receive normal output at some lines:

Code: Select all

09/14/2005 10:40:03 AM - CMDPHP: Poller[0] Host[86] SNMP: v1: 212.238.228.153, d
sname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.6, output: U
09/14/2005 10:40:03 AM - CMDPHP: Poller[0] Host[86] SNMP: v1: 212.238.228.153, d
sname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.7, output: 2097150024
09/14/2005 10:40:03 AM - CMDPHP: Poller[0] Host[86] SNMP: v1: 212.238.228.153, d
sname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.7, output: 2604339020
09/14/2005 10:40:03 AM - CMDPHP: Poller[0] Host[86] SNMP: v1: 212.238.228.153, d
sname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.8, output: 2097150024
09/14/2005 10:40:04 AM - CMDPHP: Poller[0] Host[86] SNMP: v1: 212.238.228.153, d
sname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.8, output: 2604339020
09/14/2005 10:40:04 AM - CMDPHP: Poller[0] Host[86] SNMP: v1: 212.238.228.153, d
sname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.11, output: 2063992348
09/14/2005 10:40:04 AM - CMDPHP: Poller[0] Host[86] SNMP: v1: 212.238.228.153, d
sname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.11, output: 4083117939
09/14/2005 10:40:04 AM - CMDPHP: Poller[0] Host[86] SNMP: v1: 212.238.228.153, d
sname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.12, output: 0
09/14/2005 10:40:04 AM - CMDPHP: Poller[0] Host[86] SNMP: v1: 212.238.228.153, d
sname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.12, output: 0
09/14/2005 10:40:04 AM - CMDPHP: Poller[0] Host[86] SNMP: v1: 212.238.228.153, d
sname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.13, output: 2064005292
09/14/2005 10:40:04 AM - CMDPHP: Poller[0] Host[86] SNMP: v1: 212.238.228.153, d
sname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.13, output: 4083653448
09/14/2005 10:40:04 AM - CMDPHP: Poller[0] Time: 107.3453 s, Theads: N/A, Hosts:
 63

[BSOD2600]

Ahh, if it's only the traffic interfaces which are returning U, then it sounds like the ports have changed and you need to re-index. Click on the green circle next to snmp - interface for the devices having problems.