[syslog-ng] Syslog-ng error
Zoltán Pallagi
pzolee at balabit.hu
Thu Jan 20 20:52:21 CET 2011
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 at mhcomputing.net
> <mailto:mhall at 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-guide-admin-en.html/index.html-single.html
>
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20110120/1bee2216/attachment.htm
More information about the syslog-ng
mailing list