[syslog-ng] [Bug 23] MySQL default configuration causes error on 'pid' column

[bugzilla at bugzilla.balabit.com]

https://bugzilla.balabit.com/show_bug.cgi?id=23


Balazs Scheidler <bazsi at balabit.hu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |RESOLVED
         Resolution|                            |FIXED




--- Comment #9 from Balazs Scheidler <bazsi at balabit.hu>  2009-04-30 10:38:17 ---
I have committed this patch in syslog-ng 3.0  to implement support for NULL values, it basically allows you to specify a "NULL" value and in case
the expanded string for a column matches the null string, it will insert a NULL column

Together with support for "default values" this can achieve what you want. 

E.g. use this for your value template:

${PID:- at NULL@}

and use @NULL@ as your NULL value, this means you get a NULL in that column, provided PID is unset.

commit 10c11e65fcf02aca60b05d265be694d771fa57ad
Author: Balazs Scheidler <bazsi at balabit.hu>
Date:   Tue Apr 14 13:16:04 2009 +0200

    [afsql] implemented NULL value support

    Reported-By: Liam Kirsher


-- 
Configure bugmail: https://bugzilla.balabit.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.