[rsyslog] Is rsyslog 1.17.5 RPM MySQL capable?

[Michael Mansour]

Hi Rainer,

Thanks for your quick response.

> > Hi,
> > 
> > I went here:
> > 
> > http://people.redhat.com/pvrabec/rpms/rsyslog/
> > 
> > and grabbed the rsyslog-1.17.5-1.src.rpm RPM, I then rebuilt it and
> > installed
> > it onto an SL4.5 server (RHEL 4 U5).
> > 
> > I then setup a MySQL database, and setup the /etc/rsyslog.conf file to
> > output
> > to that database based on the instructions here:
> > 
> > http://www.rsyslog.com/module-Static_Docs-view-f-
> > rsyslog_mysql.html.phtml
> > 
> > After all that, I setup phpLogCon.
> > 
> > After all that, I see no entries getting logged into the MySQL
> database
> > by
> > rsyslog. I've checked every step from the beginning and can only come
> > to the
> > assumption that the rsyslog RPM above is not compiled with MySQL
> > support??
> > 
> > Is this assumption valid and if so, why didn't the Red Hat person also
> > make a
> > mysql one?
> 
> Yes, I think so. I remember there was some discussion around this. I'll
> try to find you the bugzilla ticket where this was discussed.

Ok.

> > I'm guessing now I need to install from tarball? (I'd prefer RPM which
> > is why
> > I started there first).
> 
> I am not much into the RPM thing ;) If you have the source available
> inside the RPM try, you can eventually do a
> 
> ./configure --enable-mysql

Hmmm.. I'll try this. But I have tried to compile from sources and keep
getting the error:

make: warning:  Clock skew detected.  Your build may be incomplete.
make: Warning: File `.deps/syslog.Po' has modification time 40 s in the future
make  all-am
make[1]: Entering directory
`/mnt/software/elephant/Software/rsyslog/rsyslog-1.18.0'
make[1]: Warning: File `.deps/syslog.Po' has modification time 40 s in the future
make[1]: Nothing to be done for `all-am'.
make[1]: warning:  Clock skew detected.  Your build may be incomplete.
make[1]: Leaving directory
`/mnt/software/elephant/Software/rsyslog/rsyslog-1.18.0'
make: warning:  Clock skew detected.  Your build may be incomplete.

I've tried that with the 1.17.5 and 1.18.0 (as above) both give the same problem.

> > Any way I can see what the /sbin/rsyslog binary is compiled with?
> 
> rsyslog -v
> 
> will show the compile-time settings.

Ok, this is what I see:

# rsyslogd -v
rsyslogd 1.17.5, compiled with:
        FEATURE_PTHREADS (dual-threading)
        FEATURE_REGEXP
        FEATURE_LARGEFILE
        FEATURE_NETZIP (syslog message compression)
        SYSLOG_INET (Internet/remote support)

See http://www.rsyslog.com for more information.

Hmm.. this doesn't seem to show MySQL??

The 1.18.0 binary I created above with the "skew problem" make shows:

# ./rsyslogd -v
rsyslogd 1.18.0, compiled with:
        FEATURE_PTHREADS (dual-threading)
        FEATURE_REGEXP
        FEATURE_DB
        FEATURE_LARGEFILE
        FEATURE_NETZIP (syslog message compression)
        SYSLOG_INET (Internet/remote support)

See http://www.rsyslog.com for more information.

Hmm.. both don't seem to mention MySQL and I know with 1.18.0 I used the
"./configure --enable-mysql" as it showed this after the configure:

****************************************************
rsyslog will be compiled with the followig settings:

Multithreading support enabled:         yes
Klogd functionality enabled:            yes
Regular expressions support enabled:    yes
Zlib compression support enabled:       yes
MySql support enabled:                  yes
Large file support enabled:             yes
Networking support enabled:             yes
Debug mode enabled:                     no


> This for now, will follow-up soon.

Thanks Rainer.

Michael.

> Rainer
> > 
> > Thanks.
> > 
> > Michael.
> > 
> > _______________________________________________
> > rsyslog mailing list
> > http://lists.adiscon.net/mailman/listinfo/rsyslog
> _______________________________________________
> rsyslog mailing list
> http://lists.adiscon.net/mailman/listinfo/rsyslog
------- End of Original Message -------