Syslog Plugin Install Broken - Solved

[beerygaz]

I'm trying to install the syslog plugin. From what I can see, if I use the cacti database, it only creates one table "syslog" and not all the other tables required for logging. If I create my own database using the syslog.sql file provided, there's no SQL script to create the syslog_hosts table that seems to be needed:
03/18/2015 08:32:35 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM `syslog-cacti`.`syslog_hosts` OR
DER BY host"
I have a database called syslog-cacti, with the following tables (created by the suppled script)
mysql> show tables;
+------------------------+
| Tables_in_syslog-cacti |
+------------------------+
| syslog |
| syslog_alert |
| syslog_incoming |
| syslog_remove |
| syslog_reports |
+------------------------+

So - where is the syslog_hosts table? And can someone give me the definition so I can manually create it? And should this really all be necessary just ot get a plugin to work?

-- Edit --
Removing the plugin, the reinstalling it triggered an "upgrade" which then created all the necessary tables. This solved the problem.

[katal2hod]

I'm trying to install the syslog plugin. From what I can see, if I use the cacti database, it only creates one table "syslog" and not all the other tables required for logging. If I create my own database using the syslog.sql file provided, there's no SQL script to create the syslog_hosts table that seems to be needed:
03/18/2015 08:32:35 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM `syslog-cacti`.`syslog_hosts` OR
DER BY host"
I have a database called syslog-cacti, with the following tables (created by the suppled script)
mysql> show tables;
+------------------------+
| Tables_in_syslog-cacti |
+------------------------+
| syslog |
| syslog_alert |
| syslog_incoming |
| syslog_remove |
| syslog_reports |
+------------------------+

So - where is the syslog_hosts table? And can someone give me the definition so I can manually create it? And should this really all be necessary just ot get a plugin to work?

-- Edit --
Removing the plugin, the reinstalling it triggered an "upgrade" which then created all the necessary tables. This solved the problem.

did you use cacti database or separate db?

thanks

[beerygaz]

I tried the cacti db but that just created a single database called "syslog" so I switched to an external db.

[Eol]

Actually I got the opposite problem where it never created the syslog table but made the rest on a fresh install using "internal":

05/18/2015 11:20:13 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"INSERT INTO `cacti`.`syslog` (logtime, priority_id, facility_id, host_id, message) SELECT TIMESTAMP(`date`, `time`), priority_id, facility_id, host_id, message FROM (SELECT date, time, priority_id, facility_id, host_id, message FROM syslog_incoming AS si INNER JOIN syslog_facilities AS sf ON sf.facility=si.facility INNER JOIN syslog_priorities AS sp ON sp.priority=si.priority INNER JOIN syslog_hosts AS sh ON sh.host=si.host WHERE status=122) AS merge'
05/18/2015 11:20:13 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM `cacti`.`syslog_removed` WHERE logtime < '2014-05-18''
05/18/2015 11:20:13 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM `cacti`.`syslog` WHERE logtime < '2014-05-18''
05/18/2015 11:20:13 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1146', SQL:"SHOW CREATE TABLE `cacti`.`syslog`"

mysql> show tables;

| superlinks_pages |
| syslog_alert |
| syslog_facilities |
| syslog_host_facilities |
| syslog_hosts |
| syslog_incoming |
| syslog_logs |
| syslog_priorities |
| syslog_remove |
| syslog_reports |
| syslog_statistics |
| thold_data

Do I need to manually import and create the syslog table?

I'm also bothered by "syslog_removed" .. that table also isn't listed

EDIT: OK manually creating the syslog table created the Syslog Upgrade Advisor dialogue

EDIT #2:

Well that also failed as "upgrade" button kicks a 404 error:

http://a.b.c.d/cacti/plugins/syslog/plu ... ll=Upgrade

The requested URL /cacti/plugins/syslog/plugins.php was not found on this server.

EDIT #3: Ja something def screwy, anybody I click "plugin management" in the console now I get the syslog upgrade screen. Going to just manually clean everything syslog related out of the database and then manually do the syslog.sql and see what happens. 0.8.8c