Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu May 25, 2017 1:53 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: syslog.sql file do not create "syslog" table
PostPosted: Sun May 14, 2017 12:27 pm 
Offline

Joined: Thu Jun 09, 2016 2:11 am
Posts: 5
Hello,
I have installed newest syslog 2.1 plugin from github projest page: https://github.com/Cacti/plugin_syslog and also imported syslog.sql file into database from there.
But there is an error on my Clog I think that some of tables weren't created during import .sql file
Could anyone give me information if after syslog.sql import do you have in syslog database, table with the same mean "syslog"?

here is error:
Code:
2017-05-14 19:22:16 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog.php: 94 syslog_messages)(/plugins/syslog/syslog.php: 1369 syslog_db_fetch_cell)(/plugins/syslog/database.php: 72 db_fetch_cell)(/lib/database.php: 208 db_fetch_cell_prepared)(/lib/database.php: 255 cacti_debug_backtrace) 
2017-05-14 19:22:16 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog.php: 94 syslog_messages)(/plugins/syslog/syslog.php: 1354 get_syslog_messages)(/plugins/syslog/syslog.php: 823 syslog_db_fetch_assoc)(/plugins/syslog/database.php: 101 db_fetch_assoc)(/lib/database.php: 335 db_fetch_assoc_prepared)(/lib/database.php: 376 cacti_debug_backtrace) 
2017-05-14 19:22:16 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'syslog.syslog' doesn't exist
2017-05-14 19:22:16 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:"(SELECT syslog.*, syslog_programs.program, 'main' AS mtype FROM `syslog`.`syslog` AS syslog LEFT JOIN `syslog`.`syslog_programs` ON syslog.program_id=syslog_programs.program_id WHERE logtime BETWEEN '2017-05-14 18:52' AND '2017-05-14 19:22' ) UNION (SELECT syslog.*, syslog_programs.program, 'remove' AS mtype FROM `syslog`.`syslog_removed` AS syslog LEFT JOIN `syslog`.`syslog_programs` ON syslog.program_id=syslog_programs.program_id WHERE logtime BETWEEN '2017-05-14 18:52' AND '2017-05-14 19:22') ORDER BY logtime DESC LIMIT 0,30" 


or maybe anyone coul send me corrected syslog.slq file to import it again?


Top
 Profile  
 
 Post subject: Re: syslog.sql file do not create "syslog" table
PostPosted: Fri May 19, 2017 10:56 am 
Offline

Joined: Wed Oct 10, 2012 12:32 pm
Posts: 6
Hi,
I don't know why, but when i installed syslog 2.1 the tables were created automaticaly but they were diferent as was explaned into syslog.sql.
So I deleted all tables and i was adding one by one from syslog.sql. Now the tables on mysql are the same as syslog.sql.
I had only one problem whit this procedure, datetime NOT NULL DEFAULT '0000-00-00 00:00:00' is not supported into my mysql version, so i had to be re-write it as datetime NOT NULL DEFAULT '1970-01-01 00:00:01'

regards.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: Google Adsense [Bot] and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group