rnd_syslog

Downloads random RFC-Files from the IETF-Webpage (https://tools.ietf.org/) to generate/simulate some pseudo random "syslog"-Entries. Currently it don't uses the syslog-API directly, it just writes the generated messages to a MySQL/MariaDB-Database. The purpose of this applicatation is to develop/test syslog Frontend which uses as backend a database.

Some example of such (Web-)Frontends:

• LogAnalyzer (https://loganalyzer.adiscon.com/download/)
• WebSysLog (https://github.com/SnipeLike/WebSysLog)

SQL

Create DB and TABLE

create database syslog;
create table syslog.syslog (
 id int(10) AUTO_INCREMENT PRIMARY KEY,
 timestamp datetime,
 host varchar(60),
 tag varchar(60),
 level smallint(6),
 msg text
) ENGINE MyISAM;

Add syslog-User

create user syslog.'%' identified by '7f1$GRQ;MMGfhNXyElm';
grant UPDATE,SELECT,INSERT,DELETE on syslog.* to syslog;
flush privileges;