[syslog-ng] Microsoft SQL connect issue
mhall at mhcomputing.net
Mon Dec 13 21:28:08 CET 2010
On Mon, Dec 13, 2010 at 02:23:18PM -0500, Shawn Cannon wrote:
> OK this is some good info. It looks like even though I specify the database
> name, it is someone how using it and tries to create or check for the tables
> on the master database. Any ideas? Here is the info from the capture. Why
> is is running a SELECT looking for syslogng instead of the database name?
For this we will probably need help from the syslog-ng team proper. It
could take a couple of days since they are in Europe / CET Zone.
Meanwhile, please read over this chapter from the manual to see if you
can work around the problem somehow:
3.6. Configuring Microsoft SQL Server to accept logs from syslog-ng
There have been some glitches in the support for DB configuration
before. Such as port numbers being ignored and hard coded to defaults by
mistake. This happens because libdbi is a third party library that's not
part of the core code.
More information about the syslog-ng