Problem with Poller[0] DEBUG: SQL Assoc

[tokenpul]

Hi,

I have a problem with this:

02/09/2006 04:40:18 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
02/09/2006 04:40:18 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
02/09/2006 04:40:17 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
02/09/2006 04:40:17 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
02/09/2006 04:40:17 PM - CMDPHP: Poller[0] DEBUG: 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'"
02/09/2006 04:40:17 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
02/09/2006 04:40:17 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
02/09/2006 04:40:16 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
02/09/2006 04:40:16 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
02/09/2006 04:40:16 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and


it is from Cacti Log File


I haven't any GRAPHS, my configuration is:

- Windows 2000
- apache_2.0.55-win32-x86-no_ssl
- cacti-0.8.6h
- mysql-essential-4.1.16-win32
- php-5.1.2-Win32
- rrdtool-cygwin-1.2.4

please - help me

thx

Martin

[BSOD2600]

I don't see a problem with that cacti.log output.

1) Do graphs work when you're logged on as an admin?
2) Are the rrd files being updated?
3) When you have cacti logging set to debug, do you see the scripts/snmp quries returning valid data?

[tokenpul]

1>No, graphs dont work when I logged as an admin
2>Yes, now I have rrdtool-cygwin-1.2.9
3> I'v got something like that:

02/10/2006 01:47:17 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=-2678400 --end=-7200 --title="Puławy - Traffic - Se0/1/0" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="bits per second" --slope-mode DEF:a="C\:/Apache2/htdocs/cacti/rra/puawy_traffic_in_9.rrd":traffic_in:AVERAGE DEF:b="C\:/Apache2/htdocs/cacti/rra/puawy_traffic_in_9.rrd":traffic_out:AVERAGE CDEF:cdefa=a,8,* CDEF:cdefe=b,8,* AREA:cdefa#00CF00:"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#002A97:"Outbound" GPRINT:cdefe:LAST:"Current\:%8.2lf %s" GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s"


any idea ??

[BSOD2600]

You posted a graph command, not a Cacti query returning data.

Please turn off Web SNMP Messages, Web RRD Graph Syntax, and Graph Export Messages. Then, turn the polling level in cacti to debug (Settings | Polling level) for one cycle, wait for Cacti to run, and paste the output of the actual log file (<webroot>/cacti/log/cacti.log). Post this as a quote or an upload an attachment.

[tokenpul]

ok, I got something like that in my cacti.log

and my coniguration:

- rrdtool-cygwin-1.2.12 (c:\rrdtool)
- mysql-essential-4.1.16-win32 ( c:\mysql )
- php-5.1.2-Win32 ( c:\php )
- apache_2.0.55-win32-x86-no_ssl ( c:\apache2 )
- cacti-0.8.6h ( c:\apache2\htdocs\cacti )
- net-snmp-5.1.2-1.win32 ( c:\net-snmp )
- cacti-cactid-0.8.6g (c:\cactid )

I didn't see any graphs

please help

[BSOD2600]

Your output is still meaningless. Do you run poller.php ? Try manually running that from the command prompt. What is the output?

The output that is debug info is something like this:

04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[10] SNMP: v2: ggeuxp10.gemenos.eur.gemplus.com, dsname: cpu_nice, oid: .1.3.6.1.4.1.2021.11.51.0, value: 10159988
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (220,'cpu_nice','2005-04-11 10:27:37','10159988')
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[10] SNMP: v2: ggeuxp10.gemenos.eur.gemplus.com, dsname: cpu_system, oid: .1.3.6.1.4.1.2021.11.52.0, value: 84975267
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (221,'cpu_system','2005-04-11 10:27:37','84975267')
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[10] SNMP: v2: ggeuxp10.gemenos.eur.gemplus.com, dsname: cpu_user, oid: .1.3.6.1.4.1.2021.11.50.0, value: 65411854
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (222,'cpu_user','2005-04-11 10:27:37','65411854')
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[10] DEBUG: The POPEN returned the following File Descriptor 18
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 4
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: In Poller, About to Start Polling of Host
04/11/2005 10:27:39 AM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: Valid Thread to be Created
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 3
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[58] SNMP Result: Host responded to SNMP
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: update host set status='3',status_event_count='0', status_fail_date='0000-00-00 00:00:00',status_rec_date='0000-00-00 00:00:00',status_last_error='',min_time='1.094100',max_time='77.214000',cur_time='1.875880',avg_time='20.586783',total_polls='4',failed_polls='0',availability='100.0000' where id='58'

04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: In Poller, About to Start Polling of Host
04/11/2005 10:27:39 AM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: Valid Thread to be Created
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 5
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[11] SNMP Result: Host responded to SNMP
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: update host set status='3',status_event_count='0', status_fail_date='0000-00-00 00:00:00',status_rec_date='0000-00-00 00:00:00',status_last_error='',min_time='1.388070',max_time='2.273080',cur_time='1.561880',avg_time='1.677600',total_polls='5',failed_polls='0',availability='100.0000' where id='11'

04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[11] SNMP: v2: ggeuxp11.gemenos.eur.gemplus.com, dsname: cpu_nice, oid: .1.3.6.1.4.1.2021.11.51.0, value: 24052843
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (245,'cpu_nice','2005-04-11 10:27:37','24052843')
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[11] SNMP: v2: ggeuxp11.gemenos.eur.gemplus.com, dsname: cpu_system, oid: .1.3.6.1.4.1.2021.11.52.0, value: 48544937
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (246,'cpu_system','2005-04-11 10:27:37','48544937')
04/11/2005 10:27:39 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.0.49/bin/rrdtool update /pkg/cacti/rra/ggeuxde4_cpu_nice_10.rrd --template cpu_nice 1113208057:1841996
04/11/2005 10:27:39 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.0.49/bin/rrdtool update /pkg/cacti/rra/ggeuxde4_cpu_system_11.rrd --template cpu_system 1113208057:7889025
04/11/2005 10:27:39 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.0.49/bin/rrdtool update /pkg/cacti/rra/ggeuxde7_cpu_nice_169.rrd --template cpu_nice 1113208057:10141414
04/11/2005 10:27:39 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool-1.0.49/bin/rrdtool update /pkg/cacti/rra/ggeuxde7_cpu_system_170.rrd --template cpu_system 1113208057:165334747

Try running this: mysql -u root -p cacti
>truncate table poller_output;
>quit

[tokenpul]

ok, now I have graphs, but I havn't any Description on Graphs, like
- Inbound Traffic rate
- Inbound Utilization
- date, hour

nothing

what should I do ??

[BSOD2600]

Post a pic what you're talking about.

[tokenpul]

This is a simple graph from my network, there is no date, hour or how many MB/s

What should I do to made this. ??

on the second graph You can see a lot of information:
-bytes per second
-Inbound
-Outbound
- time and date
- etc.

How to do this?

[BSOD2600]

1) Make sure you have the proper RRDTool version selected in cacti
2) Make sure you have a valid font set in the rrdtool default font path.
3) If all above are set and you sometimes see text, but other times to not, then you are experiancing a known rrdtool bug.