[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