name | mode | size |
---|---|---|
.. | ||
index.html | 100644 | 0 kb |
index.md | 100644 | 0 kb |
* Introduction
This is a minimal implementation of a syslog-like protocol that is
tested against a minimal syslog daemon included with Gentoo, rsyslogd
and OpenWRT's log daemon. This also includes a command line program
that listens for incoming syslog connections, pretty prints them and
then saves them to an sqlite db in /tmp/logs.db.
By default, this client includes the ability to recognize dnsmasq's log
entries and record them to their own tables.
The db needs to be precreated with this schema:
#+BEGIN_SRC SQL
create table messages (severity int, facility int, tag text, pid int, message text, host text, ts datetime default current_timestamp);
create table dns_query (query_type text, request text, requester text, added text default current_timestamp);
create table dns_reply (query text, reply text, added datetime default current_timestamp);
create table untagged (ts datetime default current_timestamp, data text);
#+END_SRC
* TODO
- other db backends
- customizable db paths
- batch db updates
- improve filtering command line options
- TUI / CLIM ui
- Add automagic db schema initialization