Hi, we have already encountered this problem a few weeks ago. See the following thread: [syslog-ng] Microsoft SQL connect issue My summary from this thread: "Hm... You are right, it seems that syslog-ng tries to connect to the database that is the default for the specified user in config. However, I've checked it in syslog-ng source, and syslog-ng uses the same code for all database types for connecting and passes the name of database properly and in case of other databases it works, too. So, it is a bug, but not in syslog-ng but in freetds or libdbi. Report a bug on it, please, and we will check if we can fix it" 2011.01.20. 19:46 keltezéssel, Shawn Cannon írta:
Thanks. It ended up that I needed to make the SQL user default to that database, even though I already have the database specified in the config file. No big deal, just annoying that it seems to ignore the database setting.
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>
On Thu, Jan 20, 2011 at 1:35 PM, Matthew Hall <mhall@mhcomputing.net <mailto:mhall@mhcomputing.net>> wrote:
On Thu, Jan 20, 2011 at 12:39:37PM -0500, Shawn Cannon wrote: > 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
There is a dont-create-tables option in newer syslog-ngs which will fix this one.
dont-create-tables: Enable this flag to prevent syslog-ng OSE from creating non-existing database tables automatically. The syslog-ng OSE application typically has to create tables if you use macros in the table names. Available in syslog-ng OSE version 3.2 and later.
http://www.balabit.com/sites/default/files/documents/syslog-ng-ose-v3.2-guid...
HTH, Matthew. ______________________________________________________________________________ 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
______________________________________________________________________________ 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
-- pzolee