Help! No graphs and poller issue

[amaze_sun]

Hello

I am testing cacti on win2003 server, and my server is formed like this

appserv-win32-2.5.9
cacti-0.8.7e
cacti-spine-0.8.7e
rrdtool-1.2.10-win32-perl58
net-snmp-5.4.0-1.win32.exe

after configuring the cacti server , I can't get the rrd file, and received a lot of errors like this. would you please help me to check why it is.

[amaze_sun]

Log File [Total Lines: 132 - All Items Shown]
08/04/2009 08:04:03 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=4 order by graph_templates_item.sequence"
08/04/2009 08:04:03 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=3 order by graph_templates_item.sequence"
08/04/2009 08:04:03 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=2 order by graph_templates_item.sequence"
08/04/2009 08:04:03 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=1 order by graph_templates_item.sequence"

[BSOD2600]

How did you set up cacti? Sql error 1054 is unknown column, which makes me think you didn't import the cacti.sql file properly.

[amaze_sun]

yes, i check my sql configuration again, and found a little fault, i should import mysql.sql in mysql style rather than none.
then the error log disappeared, thanks a lot!
however i still cant't get rra, and then i change my rra directory into writable, and nothing happens ,hehe

[amaze_sun]

8/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_verbosity'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from settings where name='log_verbosity'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='poller_header'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from settings where name='poller_header'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_export'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from settings where name='log_export'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_graph'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from settings where name='log_graph'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_snmp'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from settings where name='log_snmp'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_destination'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from settings where name='log_destination'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='logging_header'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from settings where name='logging_header'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select username from user_auth where id=1"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select id from user_auth where username='guest'"
08/05/2009 01:44:55 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select cacti from version"

[amaze_sun]

08/05/2009 01:35:26 AM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=1249349718 --end=1249436118 --title="159.226.58.254 - Traffic - Fa2/32" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2009/08/04 01\:35\:18 To 2009/08/05 01\:35\:18\c" COMMENT:" \n" --vertical-label="bits per second" --slope-mode --font TITLE:12: --font AXIS:8: --font LEGEND:10: --font UNIT:8: DEF:a="C\:/AppServ/www/cacti/rra/2/11.rrd":traffic_in:AVERAGE DEF:b="C\:/AppServ/www/cacti/rra/2/11.rrd":traffic_out:AVERAGE CDEF:cdefa=a,8,* CDEF:cdefe=b,8,* AREA:cdefa#00CF00FF:"Inbound" GPRINT:cdefa:LAST:" Current\:%8.2lf %s" GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" LINE1:cdefe#002A97FF:"Outbound" GPRINT:cdefe:LAST:"Current\:%8.2lf %s" GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s\n"

[amaze_sun]

08/05/2009 01:35:20 AM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=1249349718 --end=1249436118 --title="159.226.58.254 - Traffic - Gi4/2" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2009/08/04 01\:35\:18 To 2009/08/05 01\:35\:18\c" COMMENT:" \n" --vertical-label="bits per second" --slope-mode --font TITLE:12: --font AXIS:8: --font LEGEND:10: --font UNIT:8: DEF:a="C\:/AppServ/www/cacti/rra/2/13.rrd":traffic_in:AVERAGE DEF:b="C\:/AppServ/www/cacti/rra/2/13.rrd":traffic_out:AVERAGE CDEF:cdefa=a,8,* CDEF:cdefe=b,8,* AREA:cdefa#00CF00FF:"Inbound" GPRINT:cdefa:LAST:" Current\:%8.2lf %s" GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" LINE1:cdefe#002A97FF:"Outbound" GPRINT:cdefe:LAST:"Current\:%8.2lf %s" GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s\n"

[BSOD2600]

Those graph commands really arent that useful.

Read http://forums.cacti.net/viewtopic.php?t=11747

[amaze_sun]

I reinstalled cygwin, and deleted all *.dll in rrdtool. and then reset my server. finally i received my rra file , and i have got the pics and i m waiting for the lines in it

[amaze_sun]

an hour passed , no lines. i shall change to cmd.php instead of spine

[amaze_sun]

08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[32] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.56, output: U
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[32] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[32] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.56, output: U
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[32] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[31] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.55, output: U
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[31] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[31] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.55, output: U
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[31] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[30] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.54, output: U
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[30] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[30] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.54, output: U
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[30] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[29] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.53, output: 255834407
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[29] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.53, output: 1056458580
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[28] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.52, output: 87191123
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[28] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.52, output: 2100915295
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[27] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.51, output: 637051344
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[27] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.51, output: 3999218838
08/05/2009 05:41:46 AM - CMDPHP: Poller[0] Host[2] DS[26] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.50, output: 0
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[26] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.50, output: 0
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[25] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.49, output: 0
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[25] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.49, output: 0
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[24] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.48, output: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[24] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[24] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.48, output: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[24] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[23] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.47, output: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[23] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[23] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.47, output: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[23] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[22] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.46, output: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[22] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[22] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.46, output: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[22] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[21] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.45, output: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[21] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[21] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.45, output: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[21] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[20] SNMP: v2: 159.226.58.254, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.44, output: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[20] WARNING: Result from SNMP not valid. Partial Result: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[20] SNMP: v2: 159.226.58.254, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.44, output: U
08/05/2009 05:41:45 AM - CMDPHP: Poller[0] Host[2] DS[20] WARNING: Result from SNMP not valid. Partial Result: U

[BSOD2600]

Looks like the vast majority of those devices don't support a) snmp or b) traffic OID. manually verify its functional by snmpwalking the OID which cacti is failing.