Fresh installation of Cacti (1.2.10), fresh installation of syslog plugin
#service rsyslog status
● rsyslog.service - System Logging Service
Loaded: loaded (/lib/systemd/system/rsyslog.service; enabled; vendor preset: enabled)
Active: active (running) since Tue 2020-04-21 15:52:39 MSK; 1min 18s ago
Docs: man:rsyslogd(8)
http://www.rsyslog.com/doc/
Main PID: 5282 (rsyslogd)
Tasks: 5 (limit: 4660)
CGroup: /system.slice/rsyslog.service
└─5282 /usr/sbin/rsyslogd -n
Apr 21 15:53:23 cacti rsyslogd[5282]: ommysql: db error (1054): Unknown column 'date' in 'field list' [v8.32.0]
Apr 21 15:53:23 cacti rsyslogd[5282]: The error statement was: INSERT INTO syslog_incoming(facility_id, priority_id, program, date, time, host, message) values (5, 3, 'rsyslogd', '20200421155323', '20200421155323', 'cacti', TRIM(' The e
Apr 21 15:53:23 cacti rsyslogd[5282]: action 'action 8' (module 'ommysql') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2218 ]
Apr 21 15:53:23 cacti rsyslogd[5282]: ommysql: db error (1054): Unknown column 'date' in 'field list' [v8.32.0]
Apr 21 15:53:23 cacti rsyslogd[5282]: The error statement was: INSERT INTO syslog_incoming(facility_id, priority_id, program, date, time, host, message) values (5, 3, 'rsyslogd', '20200421155323', '20200421155323', 'cacti', TRIM(' actio
Apr 21 15:53:23 cacti rsyslogd[5282]: action 'action 8' (module 'ommysql') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2218 ]
Apr 21 15:53:23 cacti rsyslogd[5282]: ommysql: db error (1054): Unknown column 'date' in 'field list' [v8.32.0]
Apr 21 15:53:23 cacti rsyslogd[5282]: The error statement was: INSERT INTO syslog_incoming(facility_id, priority_id, program, date, time, host, message) values (5, 3, 'rsyslogd', '20200421155323', '20200421155323', 'cacti', TRIM(' ommys
Apr 21 15:53:23 cacti rsyslogd[5282]: action 'action 8' (module 'ommysql') message lost, could not be processed. Check for additional error messages before this one. [v8.32.0 try http://www.rsyslog.com/e/2218 ]
Apr 21 15:53:23 cacti rsyslogd[5282]: ommysql: db error (1054): Unknown column 'date' in 'field list' [v8.32.0]
Looks like a cacti database was not prepared for syslog
Syslog tables are created automatically when you create the cacti database, or do they need to be specially created somehow?
Syslog database
Moderators: Developers, Moderators
- TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Re: Syslog database
You violated two rules. You hijacked another syslog thread, and by posting this, you double posted.
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Who is online
Users browsing this forum: No registered users and 1 guest