Problem running cacti on OpenSuse 10.2

[obrueck]

Hi,

i did install cacti (0.8.6h) and rrdtool (1.2.15) using ysat2, so it did install all depencies also.
With the docu i could get the frontend running.
Some things seam to be customized allready, log path is /var/log/cacti no matter what i enter into the config. The rrd files directory is /var/lib/cacti.
It created all the directorys using wwwrun as default user plus a cron file using wwwrun as user to run the poller.php.
If i try now to create just the load average and memory usage graphs it does not create the rrds nor does it get some data out of the perl scripts?!
This is a part of cacti.log:
05/23/2008 03:25:02 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
05/23/2008 03:25:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
05/23/2008 03:25:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/usr/share/cacti')"
05/23/2008 03:25:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
05/23/2008 03:25:02 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /usr/share/cacti/cmd.php 0 1]
05/23/2008 03:25:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
05/23/2008 03:25:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
05/23/2008 03:25:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
05/23/2008 03:25:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
05/23/2008 03:25:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"

I also get this error:
RRDTool Says:

ERROR: opening '/var/lib/cacti/localhost_load_1min_25.rrd': No such file or directory

when ich check the graph.
I can execute the comment shown in debug for the datasource manually, it works to create the rrd.
But than it still fails to fill data in by the poller!?
There is no execution of the scripts to get the data.
If i run the cmd.php it gives the following output:
/usr/share/cacti # php cmd.php
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Host[1] SNMP: Device does not require SNMP
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Host[1] No host availability check possible for '127.0.0.1'.
sh: /perl: No such file or directory
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Host[1] DS[24] WARNING: Result from CMD not valid. Partial Result:
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Host[1] DS[24] CMD: perl /usr/share/cacti/scripts/linux_memory.pl SwapFree:, output: U
sh: /perl: No such file or directory
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Host[1] DS[23] WARNING: Result from CMD not valid. Partial Result:
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Host[1] DS[23] CMD: perl /usr/share/cacti/scripts/linux_memory.pl MemFree:, output: U
sh: /perl: No such file or directory
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Host[1] DS[25] WARNING: Result from CMD not valid. Partial Result:
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Host[1] DS[25] CMD: perl /usr/share/cacti/scripts/loadavg_multi.pl, output: U
sh: /perl: No such file or directory
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Host[1] DS[26] WARNING: Result from CMD not valid. Partial Result:
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Host[1] DS[26] CMD: perl /usr/share/cacti/scripts/unix_users.pl , output: U
sh: /perl: No such file or directory
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Host[1] DS[27] WARNING: Result from CMD not valid. Partial Result:
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Host[1] DS[27] CMD: perl /usr/share/cacti/scripts/unix_processes.pl, output: U
05/23/2008 03:49:49 PM - CMDPHP: Poller[0] Time: 0.0508 s, Theads: N/A, Hosts: 1

Whats

Thanks

Olaf

[obrueck]

Hi again,

after waiting some time i found in the cacti.log the following:

05/23/2008 03:27:30 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=25"

05/23/2008 03:27:30 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_data.rrd_step, rra.x_files_factor, rra.steps, rra.rows, rra_cf.consolidation_function_id, (rra.rows*rra.steps) as rra_order from data_template_data left join data_template_data_rra on (data_template_data.id=data_template_data_rra.data_template_data_id) left join rra on (data_template_data_rra.rra_id=rra.id) left join rra_cf on (rra.id=rra_cf.rra_id) where data_template_data.local_data_id=25 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"
05/23/2008 03:27:30 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_rrd.id, data_template_rrd.rrd_heartbeat, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_type_id from data_template_rrd where data_template_rrd.local_data_id=25"
05/23/2008 03:27:30 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=122"

05/23/2008 03:27:30 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=123"

05/23/2008 03:27:30 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=124"

05/23/2008 03:27:30 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool create /var/lib/cacti/localhost_load_1min_25.rrd --step 300 DS:load_1min:GAUGE:600:0:500 DS:load_5min:GAUGE:600:0:500 DS:load_15min:GAUGE:600:0:500 RRA:AVERAGE:0.5:1:600 RRA:AVERAGE:0.5:6:700 RRA:AVERAGE:0.5:24:775 RRA:AVERAGE:0.5:288:797 RRA:MAX:0.5:1:600 RRA:MAX:0.5:6:700 RRA:MAX:0.5:24:775 RRA:MAX:0.5:288:797
05/23/2008 03:27:30 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/lib/cacti/localhost_load_1min_25.rrd --template N:U

But the rrd is not created?
If i create the rrd as cactiuser with this command, i get the rrd created.
But still no data is put in?!

Thanks

Olaf

[obrueck]

Hi again...

finaly i found the problem on my setup.
Its safe_mode! It must be off if the files are not under the wwwroot directory, as for me.
What was new for me is that there exists a cli php.ini also!
After i switched this it worked.

Hope this helps maybe someone else

CU
Olaf

[mpires]

Hi, were to i make that change you are refer.

I have the same log that you info as you, but were do i turn off safe_mode.


Regards,

[mpires]

forget is in PHP.ini...



but don't solve my problem cos was already off

cheers

[obrueck]

Hi,

check /etc/php5/cli/php.ini, or similar directory on your system,
this was the file i needed to add safe_mode=off

CU

[mpires]

Hi i have locate the file, and was already off.

Now i have fix the problem i can see graphs from all hosts.

I don't know but after read 10000 plus posts i have:

Edit /etc/crontab and add the following line:
*/5 * * * * www-data php /usr/share/cacti/poller.php > /dev/null 2>&1

End now all works ok

But tks for the help