[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





--- Comment #5 from Balazs Scheidler <bazsi at balabit.hu>  2008-09-25 11:30:15 ---
I'm not sure that zero length string equals to a NULL value. And currently the template() formatting in syslog-ng cannot return anything but an empty string.

in text-based fields the empty strings should be '' instead of NULL.

So the solution would be to use ${PID:-0} in the default template.

This patch fixes this (git.balabit.hu):

commit 2d5a4343db577c395e947be08dae7db48b9e1ea2
Author: Balazs Scheidler <bazsi at balabit.hu>
Date:   Thu Sep 25 11:28:22 2008 +0200

    change the default value of the PID column in the default SQL config (fixes: pub#23)

        The default type for the PID column is numeric, which will not be
        able to process empty strings. Use ${PID:-0} as the default value, thus
        substituting 0 if the PID is unset.


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