SYSLOG TROUBLE AFTER PERFORM UPGRADE TO 0.8.7i

[aocampo]

Hi to all!

My syslog plugin doesn't work after perform the upgrade from 0.8.7h and Spine 0.8.7h to 0.8.7i and Spine 0.8.7i (following the usual upgrade procedure) . It seems a SQL trouble, because the syslog messages are present in the expected path.

There are the following errors in my log:

Code: Select all

12/20/2011 04:56:18 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISTINCT id,title,contentfile FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='FRONT' AND (userid=1 OR userid=0) AND disabled='' ORDER BY sortorder, id"
12/20/2011 04:56:18 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISTINCT id,title,contentfile FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='FRONTTOP' AND (userid=1 OR userid=0) AND disabled='' ORDER BY sortorder, id" 

In addition, I can't see the old graph data.

I have installed the following plugins:

Code: Select all

Cycle	2.2
Dsstats	1.4
Monitor	1.2
Mactrack	2.9
Settings	0.7
Weathermap	0.97a
Rrdclean	0.41
Spikekill	1.3
Superlinks	1.4
Syslog	1.22
Thold	0.4.9

Thanks for your help!

[rony]

Moved to Plugin Arch forum.

The SQL errors that are in the log seem to be an issue with Superlinks.

I have you tried disabling Superlinks?

[TheWitness]

It appears that your SuperLinks plugin is missing a column or two. What version are you running? Did you upgrade it?

[aocampo]

Moved to Plugin Arch forum.

The SQL errors that are in the log seem to be an issue with Superlinks.

I have you tried disabling Superlinks?

Hi rony, I tried disabling SuperLinks, but I got these error messages:

Code: Select all

12/21/2011 05:16:54 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT priority_id, priority FROM `cacti`.`syslog_priorities`"
12/21/2011 05:16:54 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT facility_id, facility FROM `cacti`.`syslog_facilities`"
12/21/2011 05:16:54 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT host_id, host FROM `cacti`.`syslog_hosts`"
12/21/2011 05:16:54 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT count(*) FROM `cacti`.`syslog` WHERE logtime BETWEEN '2011-11-21 17:16' AND '2011-12-21 17:16'"
12/21/2011 05:16:54 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM `cacti`.`syslog_hosts` ORDER BY host"
12/21/2011 05:16:54 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT f.facility_id, f.facility FROM `cacti`.`syslog_host_facilities` AS fh INNER JOIN `cacti`.`syslog_facilities` AS f ON f.facility_id=fh.facility_id ORDER BY facility"
12/21/2011 05:16:54 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT *, 'main' AS mtype FROM `cacti`.`syslog` WHERE logtime BETWEEN '2011-11-21 17:16' AND '2011-12-21 17:16' ORDER BY logtime DESC LIMIT 0,30"
12/21/2011 05:16:34 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT priority_id, priority FROM `cacti`.`syslog_priorities`"
12/21/2011 05:16:34 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT facility_id, facility FROM `cacti`.`syslog_facilities`"
12/21/2011 05:16:34 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT host_id, host FROM `cacti`.`syslog_hosts`"
12/21/2011 05:16:34 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT count(*) FROM `cacti`.`syslog` WHERE logtime BETWEEN '2011-11-21 17:16' AND '2011-12-21 17:16'"
12/21/2011 05:16:34 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM `cacti`.`syslog_hosts` ORDER BY host"
12/21/2011 05:16:34 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT f.facility_id, f.facility FROM `cacti`.`syslog_host_facilities` AS fh INNER JOIN `cacti`.`syslog_facilities` AS f ON f.facility_id=fh.facility_id ORDER BY facility"
12/21/2011 05:16:34 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT *, 'main' AS mtype FROM `cacti`.`syslog` WHERE logtime BETWEEN '2011-11-21 17:16' AND '2011-12-21 17:16' ORDER BY logtime DESC LIMIT 0,30"

It appears that your SuperLinks plugin is missing a column or two. What version are you running? Did you upgrade it?

I'm running the 1.4 version. I have upgraded from 0.7 version.

[TheWitness]

The question is, relative to your Syslog plugin is where are the 'Syslog' tables located? If they are in a foreign database, you have to properly setup the config.php in the syslog plugin directory and then 're-upgrade' the plugin. It's easier said than done to do that. Let us know how it goes.

[aocampo]

The question is, relative to your Syslog plugin is where are the 'Syslog' tables located? If they are in a foreign database, you have to properly setup the config.php in the syslog plugin directory and then 're-upgrade' the plugin. It's easier said than done to do that. Let us know how it goes.

I had forgotten . With that configuration, my syslog plugin works!

However, I still get these error messages:

Code: Select all

12/23/2011 09:21:09 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISTINCT id, title, imagecache FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='TAB' AND (userid=1 OR userid=0) AND disabled='' ORDER BY sortorder, id"
12/23/2011 09:21:08 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISTINCT id, title, imagecache FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='TAB' AND (userid=1 OR userid=0) AND disabled='' ORDER BY sortorder, id"
12/23/2011 09:21:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISTINCT id,title,contentfile FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='FRONT' AND (userid=1 OR userid=0) AND disabled='' ORDER BY sortorder, id"
12/23/2011 09:21:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISTINCT id,title,contentfile FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='FRONTTOP' AND (userid=1 OR userid=0) AND disabled='' ORDER BY sortorder, id" 

[TheWitness]

Uninstall and re-install Superlinks. Make sure you record your pages first.

[aocampo]

Uninstall and re-install Superlinks. Make sure you record your pages first.

I get the same errors Could you give me another advice?

[TheWitness]

Remove the superlinks tables then. After that install the latest.

[aocampo]

Remove the superlinks tables then. After that install the latest.

You rock! My problem was solved!