[syslog-ng] Syslog-ng error

Balazs Scheidler bazsi at balabit.hu
Mon Jan 24 12:08:24 CET 2011


On Thu, 2011-01-20 at 13:33 -0800, Matthew Hall wrote:
> 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.

auto-incrementing IDs should certainly be possible, although storage
engine and tablespace ain't.

can you paste a complete CREATE TABLE command that should be possible
with automatic creation? I'm not that much into various SQL
implementations to see where things should go.

Thanks.

> 
> 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.


-- 
Bazsi



More information about the syslog-ng mailing list