[syslog-ng] Syslog-ng error

Patrick H. syslogng at feystorm.net
Thu Jan 20 18:49:02 CET 2011


It will only try to create the table if it thinks it doesnt already 
exist. It determines if it exists by doing `select * from <table> where 
0=1`. You must be able to perform this query using the same credentials 
syslog-ng is using. It doesnt matter that it wont return any rows, it 
just cant generate an error.

-Patrick

Sent: Thu Jan 20 2011 10:39:37 GMT-0700 (Mountain Standard Time)
From: Shawn Cannon <shawn at shawncannon.com>
To: Syslog-ng users' and developers' mailing list 
<syslog-ng at lists.balabit.hu>
Subject: [syslog-ng] Syslog-ng error
> I am trying to setup a second syslog-ng server that will be part of a 
> load balanced cluster.  When the 2nd server tries to connect to my 
> mssql database, it tries to run the CREATE TABLE commands which fails 
> because the table already exists since the first syslog-ng server 
> already created them. How do I tell the 2nd server not to try the 
> CREATE TABLE stuff so it will start working?
>
> Shawn Cannon
>
> IT Professional
>
> http://www.shawncannon.com <http://www.shawncannon.com/>
>
>  
>
> Contact Me <http://www.linkedin.com/pub/shawn-cannon/5/84/81a> 
> LinkedIn <http://www.linkedin.com/pub/shawn-cannon/5/84/81a> 
> <http://www.facebook.com/rolltidega72> Facebook 
> <http://www.facebook.com/rolltidega72> <http://twitter.com/rolltidega> 
> Twitter <http://twitter.com/rolltidega>
> My blog: My thoughts on VMworld… a week later… 
> <http://www.shawncannon.com/?p=19>
>
> ------------------------------------------------------------------------
>
> ______________________________________________________________________________
> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng
> FAQ: http://www.campin.net/syslog-ng/faq.html
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20110120/714dee36/attachment-0001.htm 


More information about the syslog-ng mailing list