Bug 432738 - enhancement request: rsyslog-postgresql
enhancement request: rsyslog-postgresql
Product: Fedora
Classification: Fedora
Component: rsyslog (Show other bugs)
All Linux
low Severity low
: ---
: ---
Assigned To: Peter Vrabec
Fedora Extras Quality Assurance
Depends On:
  Show dependency treegraph
Reported: 2008-02-13 22:02 EST by Fran Taylor
Modified: 2008-02-21 11:19 EST (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2008-02-21 11:19:50 EST
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)
SELinux policy change for rsyslog (182 bytes, text/plain)
2008-02-16 12:27 EST, Fran Taylor
no flags Details

  None (edit)
Description Fran Taylor 2008-02-13 22:02:27 EST
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.
Comment 1 Peter Vrabec 2008-02-14 07:53:56 EST
Hi Fran, this is nice coincidence I have just built rsyslog-2.0.2-1 with 
PostgresSQL support. :) Could you try it please.
Comment 2 Fran Taylor 2008-02-16 12:27:54 EST
Created attachment 295077 [details]
SELinux policy change for rsyslog
Comment 3 Fran Taylor 2008-02-16 12:33:19 EST
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.
Comment 4 Fran Taylor 2008-02-17 01:31:11 EST
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. 
Comment 5 Peter Vrabec 2008-02-18 07:50:52 EST
thnx. Fran, 
.sql file - will be fixed in next release,
selinux policy - I'm gonna contact dwalsh@redhat.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.
Comment 6 Daniel Walsh 2008-02-18 09:28:25 EST
Fixed in selinux-policy-3.2.8-1.fc9

Also added 


So you could set it up without using network.

Note You need to log in before you can comment on or make changes to this bug.