Re: [rsyslog] RSysLog-Doc Project

2014-02-05 Thread Radu Gheorghe
Wow, James, that looks really nice. And thanks Rainer for putting it on the website. Will make sure to send PRs whenever I'm using something un/less-documented. 2014-02-03 12:54 GMT+00:00 Boylan, James : > Hey Everyone - > > I have the initial version for all branches (v5-stable, v7-stable, > v

Re: [rsyslog] Rsyslogd + MySQL

2014-02-05 Thread Jacob Steinberger
Threw it in debug an I'm seeing the SQL errors. I'm guessing this is an rsyslog log problem then - errors are very infrequently written to syslog.*, even though they are occurring multiple times a second in the debug log. That behavior basically led me to believe I'm getting ~2 SQL errors per

Re: [rsyslog] Rsyslogd + MySQL

2014-02-05 Thread David Lang
check and see if there are any errors happening. If it's getting an error inserting that row, it will keep retrying (unless it's an error that the module can tell is data related) David Lang On Wed, 5 Feb 2014, Jacob Steinberger wrote: After reviewing more of the SQL logs ... it's seems mo

Re: [rsyslog] Rsyslogd + MySQL

2014-02-05 Thread Jacob Steinberger
After reviewing more of the SQL logs ... it's seems more than just a little odd. On a cycle, rsyslogd writes maybe 100 rows to the database as a single connection. After that connect/insert 100/disconnect, it goes into a cycle connecting/inserting 1 row/disconnecting - but it's the same SQL f

[rsyslog] Rsyslogd + MySQL

2014-02-05 Thread Jacob Steinberger
I have Rsyslogd configured to send data to MySQL and I've found that only about a third of the records (or less) are actually making it to MySQL. What's odd, is I can write all the SQL out to a file (generated via a template in rsyslog) and all the SQL inserts are there - including the ones t

Re: [rsyslog] rsyslog-7.4.9 ompgsql libpq threads problem

2014-02-05 Thread ecze
Another patch ( not yet tested ) without useless PG connect.. -patch-- diff --git a/plugins/ompgsql/ompgsql.c b/plugins/ompgsql/ompgsql.c index 11f346f..e236234 100644 --- a/plugins/ompgsql/ompgsql.c +++ b/plugins/ompgsql/ompgsql.c

Re: [rsyslog] rsyslog-7.4.9 ompgsql libpq threads problem[PATCH]

2014-02-05 Thread ecze
Little remark To be honest, I don't see any advantage to init the PG connection during the instance creation. We could just suppress the call to initPgSQL and keep in this patch the test part in the BeginTransaction to init the connection if the handle is NULL. Alain ecze wrote > Purpose

Re: [rsyslog] name games...

2014-02-05 Thread Radu Gheorghe
Xuri, Mike, thanks a lot for your thoughts. Besides being funny, it's nice to know that maybe I'm not crazy in having similar thoughts to you guys. Or at least I'm not a special kind of crazy :D ___ rsyslog mailing list http://lists.adiscon.net/mailman/l

Re: [rsyslog] rsyslog-7.4.9 ompgsql libpq threads problem[PATCH]

2014-02-05 Thread ecze
Purpose of a patch for Stable Release 7.4.9 : diff -Nru ompgsql.c /new/ompgsql.c --- ompgsql.c 2014-01-21 13:14:21.0 +0100 +++ /new/ompgsql.c2014-02-05 12:01:51.557026475 +0100 @@ -262,8 +262,13 @@ BEGINbeginTransaction CODESTARTbeginTransaction +if ( pData->f_hpgsql == NULL