cmd.php errors

eddy · Post by **eddy** » Thu Apr 11, 2002 12:23 pm

I have installed cacti on a win2k /apache server. I have succesfully created rrd files but there is no data being collected. when I run cmd.php manually I get these error messages:

C:\Apache\htdocs\cacti>php cmd.php
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)
X-Powered-By: PHP/4.1.2
Content-type: text/html

 
Warning: Unable to jump to row 0 on MySQL result index 9 in C:\Apache
\htdocs\cacti\cmd.php on line 147 
 
Warning: Supplied argument is not a valid MySQL result resource in C:
\Apache\htdocs\cacti\cmd.php on line 150 
 
Warning: Unable to jump to row 0 on MySQL result index 9 in C:\Apache
\htdocs\cacti\cmd.php on line 157 
 
Warning: Unable to jump to row 0 on MySQL result index 21 in C:\Apach
e\htdocs\cacti\cmd.php on line 147 
 
Warning: Supplied argument is not a valid MySQL result resource in C:
\Apache\htdocs\cacti\cmd.php on line 150 
 
Warning: Unable to jump to row 0 on MySQL result index 21 in C:\Apach
e\htdocs\cacti\cmd.php on line 157 
ERROR: Not enough arguments
 
Warning: Unable to jump to row 0 on MySQL result index 33 in C:\Apach
e\htdocs\cacti\cmd.php on line 147 
 
Warning: Supplied argument is not a valid MySQL result resource in C:
\Apache\htdocs\cacti\cmd.php on line 150 
 
Warning: Unable to jump to row 0 on MySQL result index 33 in C:\Apach
e\htdocs\cacti\cmd.php on line 157 
ERROR: Not enough arguments
 
Warning: Unable to jump to row 0 on MySQL result index 45 in C:\Apach
e\htdocs\cacti\cmd.php on line 147 
 
Warning: Supplied argument is not a valid MySQL result resource in C:
\Apache\htdocs\cacti\cmd.php on line 150 
 
Warning: Unable to jump to row 0 on MySQL result index 45 in C:\Apach
e\htdocs\cacti\cmd.php on line 157 
 
Warning: Unable to jump to row 0 on MySQL result index 57 in C:\Apach
e\htdocs\cacti\cmd.php on line 147 
 
Warning: Supplied argument is not a valid MySQL result resource in C:
\Apache\htdocs\cacti\cmd.php on line 150 
 
Warning: Unable to jump to row 0 on MySQL result index 57 in C:\Apach
e\htdocs\cacti\cmd.php on line 157 
 
Warning: Unable to jump to row 0 on MySQL result index 69 in C:\Apach
e\htdocs\cacti\cmd.php on line 147 
 
Warning: Supplied argument is not a valid MySQL result resource in C:
\Apache\htdocs\cacti\cmd.php on line 150 
 
Warning: Unable to jump to row 0 on MySQL result index 69 in C:\Apach
e\htdocs\cacti\cmd.php on line 157 
ERROR: Not enough arguments
 
Warning: Unable to jump to row 0 on MySQL result index 81 in C:\Apach
e\htdocs\cacti\cmd.php on line 147 
 
Warning: Supplied argument is not a valid MySQL result resource in C:
\Apache\htdocs\cacti\cmd.php on line 150 
 
Warning: Unable to jump to row 0 on MySQL result index 81 in C:\Apach
e\htdocs\cacti\cmd.php on line 157 
ERROR: Not enough arguments
 
Warning: Unable to jump to row 0 on MySQL result index 93 in C:\Apach
e\htdocs\cacti\cmd.php on line 147 
 
Warning: Supplied argument is not a valid MySQL result resource in C:
\Apache\htdocs\cacti\cmd.php on line 150 
 
Warning: Unable to jump to row 0 on MySQL result index 93 in C:\Apach
e\htdocs\cacti\cmd.php on line 157 
ERROR: Not enough arguments

Any ideas?

Post by **raX** » Thu Apr 11, 2002 6:53 pm

There is some definate breaking of SQL going on there

Download the following patch so we can narrow it down further:

http://www.raxnet.net/downloads/patches ... md.php.txt

Replace your current 'cmd.php' with the downloaded copy and run 'php cmd.php' from the command line. You should get some additonal useful output. You can either paste that here or e-mail it to me. Hopefully we can track down the cause...

-Ian

Guest · Post by **Guest** » Fri Apr 12, 2002 4:15 am

The first part of the errors have to do with your PHP.INI file. Make sure it has something like this (your config might vary):

extension_dir="C:\php\extensions\"

eddy · Post by **eddy** » Mon Apr 22, 2002 1:10 pm

sorry to take so long to get back to you on this my "real" job got in the way.

When i run php cmd.php now i get these errors:

C:\Apache\htdocs\cacti>php cmd.php
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)
X-Powered-By: PHP/4.1.2
Content-type: text\html

select
id
from src_fields
where dataname="octets"
and srcid=11
and inputoutput="out"
 
Warning: Unable to jump to row 0 on MySQL result index 9 in C:\Apache
\htdocs\cacti\cmd.php on line 153 
 
Warning: Supplied argument is not a valid MySQL result resource in C:
\Apache\htdocs\cacti\cmd.php on line 156 
 
Warning: Unable to jump to row 0 on MySQL result index 9 in C:\Apache
\htdocs\cacti\cmd.php on line 163 
ERROR: Not enough arguments

select
id
from src_fields
where dataname="octets"
and srcid=11
and inputoutput="out"
 
Warning: Unable to jump to row 0 on MySQL result index 21 in C:\Apach
e\htdocs\cacti\cmd.php on line 153 
 
Warning: Supplied argument is not a valid MySQL result resource in C:
\Apache\htdocs\cacti\cmd.php on line 156 
 
Warning: Unable to jump to row 0 on MySQL result index 21 in C:\Apach
e\htdocs\cacti\cmd.php on line 163 
ERROR: Not enough arguments

eddy

Guest · Post by **Guest** » Mon Apr 22, 2002 1:26 pm

Did you copy the mibs directory in C:\php to C:\usr\mibs ?

eddy · Post by **eddy** » Wed Apr 24, 2002 6:43 am

i created a \usr\mibs directory and copied the mibs into it. the has eliminated the can't find mib-module errors.

eddy · Post by **eddy** » Wed Apr 24, 2002 8:35 am

I have applied the patch and created the mib directory. Thanks.
However i have used get snmp network to create serveral data sources and to create the graphs. and that "seem" to work just as expected but the rrd files are never updated and cron output shows all blanks. I ran cmd.php from a command prompt and this was the output along with the results of running rrdtool manually as well.

C:\Apache\htdocs\cacti>php cmd.php
X-Powered-By: PHP/4.2.0
Content-type: text/html

select
id
from src_fields
where dataname="octets"
and srcid=11
and inputoutput="out"

select
id
from src_fields
where dataname="octets"
and srcid=11
and inputoutput="out"

select
id
from src_fields
where dataname="octets"
and srcid=11
and inputoutput="out"

select
id
from src_fields
where dataname="octets"
and srcid=11
and inputoutput="out"

select
id
from src_fields
where dataname="octets"
and srcid=11
and inputoutput="out"

select
id
from src_fields
where dataname="octets"
and srcid=11
and inputoutput="out"

C:\Apache\htdocs\cacti>cd\

C:\>c:/rrdtool/rrdtool.exe update c:/apache/htdocs/cacti/rra/traf_10_249_2_11_2_
in.rrd --template traf_10_249_2_11_2_ N:270622681

Thanks for all the help.

Post by **raX** » Wed Apr 24, 2002 4:54 pm

The output of the patch really does not say much...except that you are using the "Get SNMP Network Data" script. By the looks of your 'update' command, I can see that SNMP does appear to be working ok. I also noticed that you did not receive any output when executing the 'update' command. This is also good.

At this point, you want to make sure that 'php cmd.php' is scheduled to run every 5 minutes properly and that the user it runs as has write access to 'rra/' directory. Does your log file get updated as well?

-Ian

eddy · Post by **eddy** » Wed Apr 24, 2002 7:01 pm

I found the problem. once I had created the \user\mib directory and applied the patch i found that i had to install ucd-snmp and update cacti setup accordingly. also there was an error in the setup of my scheduled task. Now everything is great!! Thanks very much.

Cacti

cmd.php errors

cmd.php errors

Who is online