Logging Updates but no graphs

Guest · Post by **Guest** » Wed Jan 16, 2002 7:09 pm

I added a couple of SNMP hosts and then clicked on their interfaces and said Make Graphs... the logs update but I can't seem to get any graphs. In fact, no sample graphs either except for System Processes and Logged In Users.

Post by **raX** » Wed Jan 16, 2002 8:11 pm

The first thing to try is make sure the user 'cmd.php' is running as has write access to the 'rra/' directory, located under cacti's directory.

Also you may want to check and see if there are any files in that directory already?

If the permissions are ok, try executing some of the 'create' commands from the log at the command line and seeing what rrdtool spits back. Prefferably run the commands as the user that 'cmd.php' runs as to get more accurate results.

See that helps at all,
-Ian

Guest · Post by **Guest** » Thu Jan 17, 2002 4:35 am

I seem to have a similar problem.
The sample graphs are not visible, nor a new rrd files being created. I do however get MySQL errors.

When I try to use a 'source' link for a graph, I get the following msg:

'Warning: Supplied argument is not a valid MySQL result resource in /usr/local/apache/htdocs/cacti/include/cmd_functions.php'

I have checked file perms and verfied my MySQL (v3.22.32) user/pass work (command line and via PHP script - v4.1.1).

I am using RH 7.2 - nobody (web server user) has it's shell set to 'nologin', but running the script as another user (with valid shell) still produces the same results.

SNMP seems to be working, as does the 'cron output'

Any ideas?

Guest · Post by **Guest** » Thu Jan 17, 2002 4:57 am

In addition to the last post, the full error was: 'Warning: Supplied argument is not a valid MySQL result resource in /usr/local/apache/htdocs/cacti/include/cmd_functions.php on line 308'

Guest · Post by **Guest** » Thu Jan 17, 2002 1:08 pm

Looks like data is not being collected, even though permissions are ok:

01/17/2002 11:19 AM - CMD: /usr/local/bin/rrdtool update /usr/sites/noc/cacti/rra/system_loadavg_5.rrd N:1.55

01/17/2002 11:19 AM - null data output for dsname traf_pos4in

Does the DS name have to be free of '_'?

Post by **raX** » Thu Jan 17, 2002 2:44 pm

One thing that I need to know is are you using a fresh cacti 0.6.3 installation, or did you upgrade from a previous version?

Also, I know you can use the '_' character in data source names, since I do it all of the time.

Guest · Post by **Guest** » Fri Jan 18, 2002 6:33 am

Hi,

i have had the same problem with my really fresh install of cacti 0.6.3.

I had to modify the "Data Input"-Config of "Get SNMP Network Data" by providing the complete path to my php executable (e.g. /opt/apache/bin/php) since it is not in my regular path.

Now everything works, great programm !

Post by **raX** » Fri Jan 18, 2002 10:21 pm

Probably a good idea; I'll make sure to include a 'php binary' path setting in the next version.

-Ian

Guest · Post by **Guest** » Tue Jan 22, 2002 10:04 am

Hi there,

i got the same problem both the log and rra dir are writeable by the www-user.
but when om running the cronjob i get these errors:

b>Warning: Supplied argument is not a valid MySQL result resource in include/cmd_functions.php on line 94 

i run the latest cacti,mysqld Ver 3.22.32

should i see any graphs in the standardinstallation ?

otherwise i can add snmp-objects and browse the site...

Post by **raX** » Tue Jan 22, 2002 6:00 pm

Here's the good news: I found the source of your problem. I downloaded and complied MySQL 3.22.32, and ran the query that was failing for you. Here's what I got:

ERROR 1064: You have an error in your SQL syntax near '(r.rows*r.steps)' at line 15

Guess you learn something every day. Apparently my sort method relies on this feature:

* ORDER BY and GROUP BY can be done on functions.

Which was introduced in version 3.23.2.

Now the (sort of) bad news: Not sure how I am going to redo this query. A while back I fixed a major bug that was causing major .rra problems by adding the line that is causing problems now. This is because rrdtool expects those two columns in order or the data will not be inputted correctly. Doing an 'order by r.rows, r.steps' will not work either because rrdtool wants the data from BOTH of those rows in order, not just one then the other.

Regardless, I will do my best to fix this without breaking anything else. I will also keep my installation of 3.22.32 handy for future testing. Also, I assume if it is not a problem, you could upgrade your version of MySQL to <= 3.23.2.

Hope this proves useful,
-Ian

Post by **raX** » Tue Jan 22, 2002 6:26 pm

OK, more good news, got the problem fixed. Download:

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

And replace your 'include/cmd_functions.php' file with it.

Hopefully this does the trick,
-Ian

Guest · Post by **Guest** » Wed Jan 23, 2002 3:11 am

cool, now it works great !
nice job and thanks again , cacti here i come

Cacti

Logging Updates but no graphs

Who is online