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@shawncannon.com> To: Syslog-ng users' and developers' mailing list <syslog-ng@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