Plugin Management (Cacti Version: 0.8.7g, Plugin Architecture Version: 2.9)
FATAL: Database or Table does not exist
Can anyone point me in the right direction I checked & double check and the tables are there in the Cacti database.
Another issue I have is under user management lets say I select the user admin & then graphs permission the add graph, add hosts, add graph template & add tree drop box are empty, any ideas on why this is happening.
Regards,
GeoStigma
I'm also seeing the below in the cacti.log.
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 = 'poller_output' 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 = 'poller_output' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"
05/06/2011 09:47:34 AM - 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 = 'poller_on_demand' 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 = 'poller_on_demand' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"
05/06/2011 09:47:34 AM - 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 = 'poller_output' 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 = 'poller_output' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"
05/06/2011 09:47:34 AM - 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 = 'poller_on_demand' 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 = 'poller_on_demand' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"
05/06/2011 09:47:34 AM - 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 = 'poller_output' 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 = 'poller_output' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"
05/06/2011 09:47:34 AM - CMDPHP:
cat pa.sql | grep "CREATE TABLE" | cut -d" " -f1,2,3
CREATE TABLE `plugin_config`
CREATE TABLE `plugin_hooks`
CREATE TABLE `plugin_realms`
CREATE TABLE `plugin_db_changes`