[syslog-ng] Syslog-ng error

[Patrick H.]

Sent: Thu Jan 20 2011 14:33:16 GMT-0700 (Mountain Standard Time)
From: Matthew Hall <mhall at mhcomputing.net>
To: Syslog-ng users' and developers' mailing list 
<syslog-ng at lists.balabit.hu>
Subject: Re: [syslog-ng] Syslog-ng error
> On Thu, Jan 20, 2011 at 12:26:10PM -0700, Patrick H. wrote:
>   
>> The big problem with this solution is that if the table check failed, 
>> then inserting it will also fail. The only case this would solve is if 
>> the user doesnt have select perms, but does have insert perms.
>>
>> -Patrick
>>     
>
> Indeed it could be a problem but so is leaving it enabled in many cases. 
> Personally I find the auto-creation mostly useless and try to avoid it.
>
> Because it won't take care of cases like special auto-incrementing ID 
> columns, storage engine, tablespace, and other special stuff.
>
> So I would generally recommend making a proper table, and backing up its 
> schema, and storing this with a backup of the syslog-ng configuration.
>
> Matthew.
>   
So, make sure the table already exists and there isnt a problem :-P

-Patrick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20110120/0b4c4dd5/attachment-0001.htm