rsyslog 2.0 supports postgresql
it would be very simple to add an rpm with postgres support
I am working on one but there are SELinux issues that I am still working on.
It would be very nice if this were an official package.
Hi Fran, this is nice coincidence I have just built rsyslog-2.0.2-1 with
PostgresSQL support. :) Could you try it please.
Created attachment 295077 [details]
SELinux policy change for rsyslog
I have installed rsyslog-2.0.2-1 and it seems to be missing two items: the .sql
file necessary to initialize the database (contained in the distribution) and a
SELinux policy change to allow rsyslog to open a socket connection on the
postgres port (I think this is missing for the mysql version as well). I have
attached my solution to the latter issue, I don't know how such things are
solved in general in these cases.
I installed your package on my Fedora 8 machine, and it has slowed to a crawl
processing two SELinux failure messages:
SELinux prevented rsyslogd from rerading from the urandom device.
SELinux is preventing rsyslogd (syslogd_t) "getattr" to /etc/krb5.conf
My rsyslog-postgresql doesn't have these problems. To make it, I just copied
and pasted stuff in the spec file in the obvious manner. With the addition of
the SELinux policy change I attached, it works fine.
.sql file - will be fixed in next release,
selinux policy - I'm gonna contact email@example.com,
but I can't reproduce selinux problem from comment #4. rsyslog is built
without GSSAPI support, so it shouldn't do anything with krb5.conf.
Fixed in selinux-policy-3.2.8-1.fc9
So you could set it up without using network.