No Graphs on new installation

bitnoise · Post by **bitnoise** » Fri Mar 07, 2008 7:21 am

Hello,

I have already been looking at a lot of forums, but I can't seem to find the solution:

03/07/2008 01:13:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=4"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=4"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'draw_navigation_text'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header_tabs'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header_tabs'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_head'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'page_title'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'top_header'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='4' and user_auth_realm.realm_id='15'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_alternate_realms'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'auth_alternate_realms'"
03/07/2008 01:13:31 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
03/07/2008 01:13:30 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
03/07/2008 01:13:30 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_form'"
03/07/2008 01:13:30 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
03/07/2008 01:13:30 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'valid_host_fields'"
03/07/2008 01:13:30 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
03/07/2008 01:13:30 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_settings'"
03/07/2008 01:13:30 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
03/07/2008 01:13:30 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
03/07/2008 01:13:30 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "REPLACE INTO settings (name, value) VALUES ('url_path', 'cti/')"
03/07/2008 01:13:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=4"
03/07/2008 01:13:10 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
03/07/2008 01:13:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
03/07/2008 01:13:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=4"

My "View Cacti Log" shows the above messages. In my cacti, I can create objects, add graphs, but nothing happens..
When I put debugging mode on, it appears like this:

Code: Select all

 RRDTool Command:

/usr/local/rrdtool-1.2.27/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="SERVER - Memory Usage" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="kilobytes" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/usr/local/cacti/rra/SERVER_mem_buffers_15.rrd":mem_buffers:AVERAGE \
DEF:b="/usr/local/cacti/rra/SERVER_mem_swap_16.rrd":mem_swap:AVERAGE \
CDEF:cdefa=a,1024,* \
CDEF:cdefe=b,1024,* \
AREA:cdefa#FF4105FF:"Free"  \
GPRINT:cdefa:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n"  \
AREA:cdefe#FFC73BFF:"Swap":STACK \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s" 

RRDTool Says:

ERROR: opening '/usr/local/cacti/rra/SERVER_mem_buffers_15.rrd': No such file or directory


or..

ERROR: opening '/usr/local/cacti/rra/SERVER_proc_19.rrd': No such file or directory

The issue is not fixed to mem_buffers only, I get this with all the graphs I try to make.

Any help would be gladly appreceated.

Thanks
Danny

bitnoise · Post by **bitnoise** » Fri Mar 07, 2008 9:58 am

Hey Guyz,

I already saw a lot of reads, but no replies yet.. can't blame you.. but I couldn't wait.. Since everything was running in a VM, I just restored back to a state before the cacti installation and I guess I'll just redo it.. without the plugins..

I'll keep you posted if the problem re-occurs.

Grtz
Danny

hammerwalk · Post by **hammerwalk** » Sat Mar 08, 2008 1:16 am

Hopefully this is the right area to get this solved.

I have recently installed Cacti on Mandriva 2008.

The web interface to Cacti runs as expected, and I can add devices and create graphs, but they show no data.

I have looked at the cacti.log and it is completely empty. I have put the polling into debug mode and still no addition to the log file.

However, if i check the log for httpd i get this...

( /var/www/html/cacti/log )
# tail /var/log/httpd/error_log
ERROR: opening '/var/www/html/cacti/rra/web_server_cpu_nice_11.rrd': No such file or directory
ERROR: opening '/var/www/html/cacti/rra/web_server_cpu_system_12.rrd': No such file or directory
ERROR: opening '/var/www/html/cacti/rra/web_server_cpu_system_12.rrd': No such file or directory
ERROR: opening '/var/www/html/cacti/rra/web_server_cpu_user_13.rrd': No such file or directory
ERROR: opening '/var/www/html/cacti/rra/web_server_cpu_nice_11.rrd': No such file or directory
ERROR: opening '/var/www/html/cacti/rra/web_server_cpu_system_12.rrd': No such file or directory
ERROR: opening '/var/www/html/cacti/rra/web_server_cpu_system_12.rrd': No such file or directory
ERROR: opening '/var/www/html/cacti/rra/web_server_cpu_user_13.rrd': No such file or directory
ERROR: opening '/var/www/html/cacti/rra/web_server_cpu_nice_11.rrd': No such file or directory
ERROR: opening '/var/www/html/cacti/rra/web_server_cpu_system_12.rrd': No such file or directory

please assist.

thanks

bitnoise · Post by **bitnoise** » Sat Mar 08, 2008 5:07 am

Well.. in my case I had the impression it was a rights issue.. so the cactiuser couldnt write to the folder...

Have you tried going into your cacti root and doing this:

php cmd.php

?

hammerwalk · Post by **hammerwalk** » Sat Mar 08, 2008 1:04 pm

yeah, both root and cactiuser can execute...

-=(( cactiuser = Samba ))=-
( /var/www/html/cacti )
$ php cmd.php
X-Powered-By: PHP/5.2.1
Content-type: text/html

is that a normal response?

bitnoise · Post by **bitnoise** » Sat Mar 08, 2008 1:07 pm

Don't think so... I get something like

Code: Select all

03/08/2008 07:06:14 PM - CMDPHP: Poller[0] Host[1] PING: Host is alive
03/08/2008 07:06:14 PM - CMDPHP: Poller[0] Host[1] DS[3] CMD: perl /var/www/html/cacti/scripts/linux_memory.pl MemFree:, output: 13608
03/08/2008 07:06:14 PM - CMDPHP: Poller[0] Host[1] DS[4] CMD: perl /var/www/html/cacti/scripts/linux_memory.pl SwapFree:, output: 1048472
03/08/2008 07:06:14 PM - CMDPHP: Poller[0] Host[1] DS[5] CMD: perl /var/www/html/cacti/scripts/loadavg_multi.pl, output: 1min:0.02 5min:0.01 10min:0.00
03/08/2008 07:06:14 PM - CMDPHP: Poller[0] Host[1] DS[6] CMD: perl /var/www/html/cacti/scripts/unix_users.pl , output: 2
03/08/2008 07:06:14 PM - CMDPHP: Poller[0] Host[1] DS[7] CMD: perl /var/www/html/cacti/scripts/unix_processes.pl, output: 149
03/08/2008 07:06:14 PM - CMDPHP: Poller[0] Host[1] DS[8] CMD: perl /var/www/html/cacti/scripts/query_unix_partitions.pl  get available /dev/mapper/VolGroup00-LogVol00, output: 17111328
03/08/2008 07:06:14 PM - CMDPHP: Poller[0] Host[1] DS[8] CMD: perl /var/www/html/cacti/scripts/query_unix_partitions.pl  get used /dev/mapper/VolGroup00-LogVol00, output: 4924380
03/08/2008 07:06:14 PM - CMDPHP: Poller[0] Host[1] DS[9] CMD: perl /var/www/html/cacti/scripts/query_unix_partitions.pl  get available /dev/sda1, output: 72388
03/08/2008 07:06:14 PM - CMDPHP: Poller[0] Host[1] DS[9] CMD: perl /var/www/html/cacti/scripts/query_unix_partitions.pl  get used /dev/sda1, output: 23479
03/08/2008 07:06:15 PM - CMDPHP: Poller[0] Host[2] SNMP: Host did not respond to SNMP
03/08/2008 07:06:15 PM - CMDPHP: Poller[0] Host[3] SNMP: Host responded to SNMP
03/08/2008 07:06:15 PM - CMDPHP: Poller[0] Host[3] RECACHE: Processing 4 items in the auto reindex cache for 'SERVERIP'.
03/08/2008 07:06:15 PM - CMDPHP: Poller[0] Host[3] DS[12] SNMP: v1: SERVERIP, dsname: users, oid: .1.3.6.1.2.1.25.1.5.0, output: 3
03/08/2008 07:06:15 PM - CMDPHP: Poller[0] Host[3] DS[13] SNMP: v1: SERVERIP, dsname: proc, oid: .1.3.6.1.2.1.25.1.6.0, output: 67
03/08/2008 07:06:15 PM - CMDPHP: Poller[0] Time: 1.2327 s, Theads: N/A, Hosts: 3

Maybe someone with some more experience can explain..?

hammerwalk · Post by **hammerwalk** » Sat Mar 08, 2008 1:11 pm

i dont quite understand exactly how php and the poller work as I am a but new to this. But I am for sure that my php works as I have 3 other pages that all run php such as, egroupware, phpbb2 forum, and gallery2.

does any one know what the cmd.php calls upon to get a resopnse like bitnoise's ?

bitnoise · Post by **bitnoise** » Sat Mar 08, 2008 1:17 pm

In my opinion ... the php calls a perl script, that executes the graphs you want

CMD: perl /var/www/html/cacti/scripts/linux_memory.pl
as you see here..

I suppose you did create a graphing option for, for example, your localhost...

so go check your cacti root for /scripts/...... .pl
and try executing it with perl ..

hammerwalk · Post by **hammerwalk** » Sat Mar 08, 2008 1:23 pm

perhaps i am missing a perl package....

-=(( cactiuser = Samba ))=-
( /var/www/html/cacti/scripts )
$ perl linux_memory.pl
Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.

hammerwalk · Post by **hammerwalk** » Sat Mar 08, 2008 1:29 pm

-=(( cactiuser = Samba ))=-
( /var/www/html/cacti/scripts )
$ perl loadavg_multi.pl
1min:1.02 5min:0.97 10min:0.86

that one works

bitnoise · Post by **bitnoise** » Sat Mar 08, 2008 1:35 pm

have you checked the error logs already?

Configuration > Poller Specific Logging: Debug. Turn on as much logging as you can...

and verify the logging then under System Utilities > View Cacti Log File

hammerwalk · Post by **hammerwalk** » Sat Mar 08, 2008 1:45 pm

yeah I have Debug turned on with all the options to log and the log file is completely empty. only my httpd/error_log has anything in it.

The only thing I can think of is the installation process. I had to by pass the Configure PHP on the install manual because when I would replace what i had in my php.ini file to extension_dir = /etc/php.d all of my php stuff would crash and Cacti would not even finish installing.

After I restored my php.ini file and ignored that part of the isnstallation, everything worked great up until now. Would that php.ini file have anything to do with this? I dont assume it would because all of my other php stuff works fine.

hammerwalk · Post by **hammerwalk** » Sat Mar 08, 2008 8:52 pm

there has to be a problem with how the poll.php and snmp work. I have gotten snmp configured to the best of my knowledge but I still only get a link for the graph but no actual graph.

hammerwalk · Post by **hammerwalk** » Sat Mar 08, 2008 9:24 pm

well, if anyone knows for sure what to do, and want me to run tests without having to wait for hours or days to get a response, please join irc://www.hammerwalk.org/Cacti and I will be there to run what ever test is needed. I have boiled this down to the way Cacti polls, at least thats what I am thinking.

Post by **gandalf** » Sun Mar 09, 2008 7:06 am

You've configured the crontab to run the poller every 5 Minutes?
You've changed permissions on ./log and ./rra so each file can be written by the user running the poller?
Reinhard

No Graphs on new installation

No Graphs on new installation

Who is online