[syslog-ng]syslog-ng truncating pipe template output

Nate Campi syslog-ng@lists.balabit.hu
Sat, 20 Nov 2004 08:48:39 -0800


On Fri, Nov 19, 2004 at 06:42:09PM +0100, James Masson wrote:
> I've been trying to figure out an obscure problem with syslog-ng
> importing to a mysql database.
> 
> I have various types of network devices feeding syslog-ng on local3
> through local6. I can import from Cisco, UNIX servers, Windows - but not
> Netscreen firewalls!
> 
> Each device type gets it's own mysql database. The mysql INSERT INTO
> statements for the Netscreen logs are truncated and hence fail to import
> because the mysql syntax is not correct.

Could you paste your entire config? Is your destination line in your
config file a single line or broken up as in the email message, and if
so is it broken up *exactly* as in the email message? I only ask because
in the template I see a newline in the MSG macro like this:

'$MSG
'
-- 
Nate

Without C, We would only have Pasal, Basi, and obol