Error: Save Failed

[Draz]

I just cleanly installed Cacti 0.8.8a with apt-get on a linux Debian server.
When I add a device i get the error: Error: Save Failed.

There is no field red.

Nothing else. In /var/log/cacti/cacti.log I got allot of poller errors: "Maximum runtime of 298 seconds exceeded. ......." (every 5 mins).

Can anyone help me find out whats the problem. I looked at allot of pages, and forums, but didnt found a solution.

[Draz]

Technical Support
General Information
Date Sat, 04 May 2013 16:27:29 +0200
Cacti Version 0.8.8a
Cacti OS unix
SNMP Version NET-SNMP version: 5.4.3
RRDTool Version RRDTool 1.4.x
Hosts 1
Graphs 5
Data Sources Script/Command: 5
SNMP: 1
Total: 6
Poller Information
Interval 60
Type cmd.php
Items No items to poll
Concurrent Processes 1
Max Threads 1
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:0.1052 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
PHP Information
PHP Version 5.3.3-7+squeeze15
PHP OS Linux
PHP uname Linux debian 2.6.32-5-686 #1 SMP Mon Feb 25 01:04:36 UTC 2013 i686
PHP SNMP Installed
max_execution_time 30
memory_limit 128M

[mooneyn]

Sounds like a database permissions or connection issue.

Try adding the device from the command line with php -q add_device.php and see what error that gives.

Try re-creating the database from the .sql file

Check permissions of your RRA files

Just kill off any poller processes that are still running with the kill on the command line.

[Draz]

tryed to locate add_device.php on console. didnt find any.
Same for cacti.sql

Permissions for RRA files:
drwxr--xr-x 2 root www-data rra
-rw-r--r-- 1 roo roo rra.php

[Draz]

This comes out of the log when i add a device:

05/06/2013 06:53:42 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_settings' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_settings' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"
05/06/2013 06:53:42 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'valid_host_fields' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'valid_host_fields' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"
05/06/2013 06:53:42 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_form' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_form' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

[mooneyn]

disable/uninstall all your plugins perhaps.

[Draz]

Fixed it. Droped the cacti db and inserted cacti.sql

Now it works. Next problem is that i cant get any graph's. They are in the list, but graph's dont show. Anyone an idea?

[mooneyn]

Confirm your poller is running (by checking cacti logs & crontab).

Make sure user roo can write to the rra folder, and owns all the rra files in there. In my system its /usr/local/share/cacti/rra/

Try su'ing to the user that the poller run as and writing a file in the rra directory or using one of the rrdtool commands on an existing rra.