Cacti

unless I missed something or didnt read the docs properly I was getting Warning: Supplied argument is not a valid MySQL result resource in <file> on line <x>? which from the mysql site said it was probably that the sql statement was returning a result of 0 and not completing. I didnt go into detail ...

having a lovelly conversation with myself here. After hitting the PFY for playing around and not remembering what he did to break it in the 1st place, I have now figured out why I was getting the previous errors: I was running version 0.6.7 and when I reinstalled it was version 0.6.8a which I found ...

on 0.8 Im getting this

Notice: Undefined index: sess_user_id in /export/www/cacti2.telecom1.com/graph_view.php on line 91

After that problem where it all stopped working I upgraded to mysql 4.0.12 and php to 4.3.0, I also deleted all my previous version of cacti and re-installed all the php files and copied the config.php and all the rra files to their places. Same compilation options as before with 4.2.3 Now all the s...

Hi Ive just run into a weird problem. Ive had my graphs running for a while now (probably about 150 graphs) until today when it has suddenly just stopped working! rrd.log is ticking over very slowly, no output when I run cmd.php form cmdline. I just tried upgrading php to 4.3.1 from 4.2.3 with no lu...

I had the same problem, and tried many things to try and solve it except going into the code to poke around due to time constraints. I eventually just checked the box to not use cacti authentication and all was fine after that, so I created my own login screen for cacti.

I had the same problem, and tried many things to try and solve it except going into the code to poke around due to time constraints. I eventually just checked the box to not use cacti authentication and all was fine after that, so I created my own login screen for cacti.

yeah
My HOME in /etc/cron was set to /
so when the script was calling on lynx to get the values lynx was trying to write a tmp file to /

Changed my HOME in /etc/crontab to /tmp and all works great now

err

Just add this to just before the end

mysql_close($link);

try this create this to check whether you php and mysql is actually working outside of cacti (bet you it doenst :) ) <?php /* Connecting, selecting database */ $link = mysql_connect("localhost", "username", "password") or die("Could not connect"); print "...

did you try and locate mysql.sock to see where it actually is?

Then create a file with this in to check <? phpinfo() ?> and access that from your browser. This will show you what its compiled with/where its looking for mysql.sock etc do a locate mysql.sock - if it doesnt exist then are you sure that mysql is running? Did you mean you compiled with mysql or msql ?

looks like you havent compiled php with mysql support for your server.
You'll probably find you mysql.sock in

/var/lib/mysql/mysql.sock
if you installed mysql from RPM
the generic mysql suuport for php looks for it in /tmp

recompile php and be sure to add --with-mysql to your configure command

Now it works fine from the cmd line but returns a value of -1 when run from cron???

found the problem crap was going in after values added this to script #!/usr/local/bin/perl #PATH=$PATH:/usr/bin:/usr/local/bin:/usr/sbin:/bin:/sbin #export PATH $ret = `lynx -dump http://weather.noaa.gov/weather/current/EGLC.html | grep Temperature | sed 's/[a-z|A-Z|()]//g' | sed -e '2,3d' | awk '\...