cmd.php

[dischide]

Have cacti up and running except I am not getting any graphs.

I have tried to run:
#php cmd.php

I am getting the following errors:

PHP Warning: Unknown(): Unable to load dynamic library './mysql.so' - ./mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
command: perl /var/www/html/cacti/cacti-0.8.3a/scripts/linux_memory.pl MemFree:, output: 43352
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
command: perl /var/www/html/cacti/cacti-0.8.3a/scripts/linux_memory.pl SwapFree:, output: 1048552
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
MUTLI command: perl /var/www/html/cacti/cacti-0.8.3a/scripts/loadavg_multi.pl, output: 1min:0.28 5min:0.12 10min:0.17
MULTI expansion: found fieldid: 17, found rrdname: load_1min, value: 0.28
MULTI expansion: found fieldid: 18, found rrdname: load_5min, value: 0.12
MULTI expansion: found fieldid: 19, found rrdname: load_15min, value: 0.17
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
command: perl /var/www/html/cacti/cacti-0.8.3a/scripts/unix_users.pl, output: 3
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
command: perl /var/www/html/cacti/cacti-0.8.3a/scripts/unix_processes.pl, output: 84
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
update /var/www/html/cacti/cacti-0.8.3a/rra/localhost_mem_buffers_3.rrd --template mem_buffers N:43352
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
update /var/www/html/cacti/cacti-0.8.3a/rra/localhost_mem_swap_4.rrd --template mem_swap N:1048552
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
update /var/www/html/cacti/cacti-0.8.3a/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min N:0.28:0.12:0.17
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
update /var/www/html/cacti/cacti-0.8.3a/rra/localhost_users_6.rrd --template users N:3
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
update /var/www/html/cacti/cacti-0.8.3a/rra/localhost_proc_7.rrd --template proc N:84
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
time: 1

To test some of the errors I did the folllowing command:
# chmod -R ugo+rw /var/www/http/cacti

I enabled mysql.so in the php.ini - but I cannot find mysql.so anywhere on my machine.
Does anyone know where I would install this from: php, mysql, apache, or perl? I am not sure ... I didn't want to install it from an rpm because I am using .tar for everything else.

Apache 2.0.47
MySql - standard - 4.0.15
Php - 4.3.3
Perl

RRdtool
and Net-snmp

Thank you

[jgleason24601]

I'm getting graphs OK. Whenever I try to run a php script from the command line I get this error:

PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php/extensions/mysql.so' - /usr/lib/php/extensions/mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0

Any help would be apreciated.

Running on Mandrake 9.1

[jgleason24601]

Well, after reading the comment in my php.ini file about extensions I was able to resolve my problem.

Mandrake 9.1 (not sure about any others):

php.ini located at /etc/php.ini should NOT remove the semicolon from in front of the msql.so extension!!

You should have a file similar to "34_mysql.ini" located in /etc/php
It should contain one line - extension = msql.so

[dischide]

Unfortunately, I could not find the file you are talking about. I am running Red Hat 9.0. I do not have the mysql.so any where on my machine. I think that I need this lib.

If I installed php, apache, and mysql from the tarballs would I be able to install the php-mysql from an rpm or would that mess up my system?

If I installed php, apache, and mysql shouldn't I already have mysql.so on my machine?

[jgleason24601]

Hey dischide, I don't know what to tell you. You should have msql.so somewhere on your system. If you are certain it isn't then you probably do need to install the php-mysql. My only experience is with Mandrake and using "urpmi" so I can't be of much more help.

[dischide]

I have figure out how to get the mysql.so. When I confiigure php I need to configure it with the option --with-mysql=shared.

i.e. (# ./configure --with-snmp --with-mysql=shared --with-apxs2=/usr/local/apache2/bin/apxs)

Then I needed to copy the module mysql.so to another directoy after runing the make and make install but before running the make clean. The make cleans deletes this this lib.

However I am still getting these errors when I try running #php cmd.php

command: perl /var/www/html/cacti/cacti-0.8.3a/scripts/linux_memory.pl MemFree:, output: 42992
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
command: perl /var/www/html/cacti/cacti-0.8.3a/scripts/linux_memory.pl SwapFree:, output: 1041248
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
MUTLI command: perl /var/www/html/cacti/cacti-0.8.3a/scripts/loadavg_multi.pl, output: 1min:0.06 5min:0.19 10min:0.29
MULTI expansion: found fieldid: 17, found rrdname: load_1min, value: 0.06
MULTI expansion: found fieldid: 18, found rrdname: load_5min, value: 0.19
MULTI expansion: found fieldid: 19, found rrdname: load_15min, value: 0.29
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
command: perl /var/www/html/cacti/cacti-0.8.3a/scripts/unix_users.pl, output: 4
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
command: perl /var/www/html/cacti/cacti-0.8.3a/scripts/unix_processes.pl, output: 77
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
update /var/www/html/cacti/cacti-0.8.3a/rra/localhost_mem_buffers_3.rrd --template mem_buffers N:42992
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
update /var/www/html/cacti/cacti-0.8.3a/rra/localhost_mem_swap_4.rrd --template mem_swap N:1041248
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
update /var/www/html/cacti/cacti-0.8.3a/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min N:0.06:0.19:0.29
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
update /var/www/html/cacti/cacti-0.8.3a/rra/localhost_users_6.rrd --template users N:4
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory
update /var/www/html/cacti/cacti-0.8.3a/rra/localhost_proc_7.rrd --template proc N:77
sh: line 1: /usr/local/rrdtool-1.0.45/bin: is a directory

Does anyone have anythoughts? I appreciate everyones help; thank you.

[dischide]

After reading through these forums I think that I have my graphs working. My next move was putting the path to the rrdtool binary <- including the actual binary in the path. I was putting the path to it but not including it.

This is what it is for me./ usr/local/rrdtool-1.0.45/bin/rrdtool <- Where rrdtool at the end is the binary.

Thank you all for your help. I hope this helps someone that has been having the same problem.

By the way this is a great tool! Thank you for such a wonderful tool.