[solved] Graphs not displaying comes as red crossess.

navjotthen · Joined: 01 Sep 2008 Posts: 22

Hi software versions i have been using is :
cacti-0.8.7b
mysql-5.0.37-win32.zip
php5.2.6-win32.zip
rrd tool 1.2.x and error i am getting while creating graphs are as follows:

d:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
LINE1:#00FF00FF:"Drive Utilisation" \
GPRINT::AVERAGE:"%8.2lf %s"
RRDTool Says:

ERROR: parameter '#00FF00FF' does not represent a number in line LINE1:#00FF00FF:Drive Utilisation

Had a look in Cacti.log and got this error:

09/04/2008 03:26:08 PM - WEBUI: Cacti Log Cleared from Web Management Interface
09/04/2008 03:26:52 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/04/2008 03:27:05 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/04/2008 03:27:06 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/04/2008 03:27:07 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/04/2008 03:27:08 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/04/2008 03:27:13 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/04/2008 03:29:59 PM - AUTH LOGIN: User 'admin' Authenticated
09/04/2008 03:30:04 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/04/2008 03:30:32 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/04/2008 04:02:57 PM - AUTH LOGIN: User 'admin' Authenticated
09/05/2008 09:20:46 AM - AUTH LOGIN: User 'admin' Authenticated
09/05/2008 09:36:06 AM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/05/2008 12:59:47 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/05/2008 03:00:48 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/05/2008 03:00:54 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/05/2008 03:07:38 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/05/2008 03:09:38 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/05/2008 03:11:09 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/05/2008 03:11:15 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/05/2008 03:11:16 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/05/2008 03:11:17 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/05/2008 03:19:45 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/05/2008 03:44:04 PM - AUTH LOGIN: User 'admin' Authenticated
09/05/2008 03:49:43 PM - AUTH LOGIN: User 'admin' Authenticated
09/05/2008 04:35:06 PM - AUTH LOGIN: User 'admin' Authenticated
09/05/2008 04:35:09 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/08/2008 09:08:37 AM - AUTH LOGIN: User 'admin' Authenticated
09/08/2008 09:19:46 AM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/08/2008 09:26:18 AM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/08/2008 09:26:28 AM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/08/2008 09:26:36 AM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/08/2008 09:32:38 AM - AUTH LOGIN: User 'admin' Authenticated
09/08/2008 09:44:01 AM - AUTH LOGIN: User 'admin' Authenticated
09/08/2008 10:07:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id= and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')"
09/08/2008 11:39:00 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
09/08/2008 11:39:08 AM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/08/2008 11:39:13 AM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
09/08/2008 11:45:19 AM - AUTH LOGIN: User 'admin' Authenticated

Please help!!!!!!!!!!

BSOD2600 · Posted: Sun Sep 07, 2008 7:27 pm Post subject:

sooo, several things.

1) what version/build of rrdtool did you install? Make sure its the W32 version instead of NW or cygwin.

2) Make sure rrdtool 1.2 is selected in cacti's settings.

3) You see that socket error in the cacti log file? Looks like you didn't properly follow my installation guide an configure PHP correctly. Do so.

navjotthen · Joined: 01 Sep 2008 Posts: 22

Hi there,

rrdtool-1.2.27-1-w32.zip is the one i am using....
with the PHP i have followed steps from installation guide on this qwebsite still no luck. I removed everything and build everything from scratch but no success. This time i can not create data source and get error:

Notice: Undefined index: Hostname in D:\wwwroot\cacti\lib\utility.php on line 243

Warning: Cannot modify header information - headers already sent by (output started at D:\wwwroot\cacti\lib\utility.php:243) in D:\wwwroot\cacti\data_sources.php on line 294

any ideas?

Note: i have read your php installation guide 20 times now and i am sure i have followed all the steps.

thanks

navjotthen · Joined: 01 Sep 2008 Posts: 22

one more thing i have had a look correct version of rrd is selected in cacti settings..

navjotthen · Joined: 01 Sep 2008 Posts: 22

one more thing i have had a look correct version of rrd is selected in cacti settings..

BSOD2600 · Posted: Mon Sep 08, 2008 12:34 am Post subject:

Still sounds like NTFS permissions issues.

Get properties on your \wwwroot\cacti\ folder. Add the IUSR_ and IIS_WPG accounts. click on advanced and make sure to check 'replace permissions on child objects...'. Those undefined headers, indexes, etc are a sure sign of that -- unless you've already modified cacti's files with mods, etc.

navjotthen · Joined: 01 Sep 2008 Posts: 22

Just to make life easier i removed everything(all the reg files etc) started from Scratch.

I reinstalled Apache. mysql, php and cacti same version as i told you earlier and still same error. I have followd the install guide under your signature and etc stilll no success...

Please advise anything else i can try?

navjotthen · Joined: 01 Sep 2008 Posts: 22

Hi,
Finally i managed to fix the problem under Data Input Methods, i created a method with hostname in it, but under input methods i used Hostname.

Note: the difference is capital H changed it to smalll h and worked fine, no more of PHP errors so to summarize this Inout fields under Imput Methods are case sensitive.
Hope this make sense.

BSOD2600 · Posted: Tue Sep 09, 2008 9:55 pm Post subject:

A case change shouldn't make any different... but I guess its fixed so good.