syslog-ng-users December 2010 archive
Main Archive Page > Month Archives  > syslog-ng-users archives
syslog-ng-users: Re: [syslog-ng] Microsoft SQL connect issue

Re: [syslog-ng] Microsoft SQL connect issue

From: Shawn Cannon <shawn_at_nospam>
Date: Mon Dec 13 2010 - 19:15:18 GMT
To: "Syslog-ng users' and developers' mailing list" <syslog-ng@lists.balabit.hu>

Yes it was the same machine. I will load wireshark and see.

Shawn Cannon | NW Systems Administrator, Sr.
SSCP, MCITP, VCP3/4, EMCISA
Gladiator Technology, A ProfitStarsĀ® Solution
11395 Old Roswell Rd | Alpharetta, GA 30009
Office: (877) GLADTECH x458190 | Fax: (678) 461-4625
Direct: (678) 242-4902 | Mobile: (678) 689-3700
http://www.gladiatortechnology.com

-----Original message-----
From: Matthew Hall <mhall@mhcomputing.net>
To: Syslog-ng users' and developers' mailing list <syslog-ng@lists.balabit.hu>
Sent: Mon, Dec 13, 2010 18:17:38 GMT+00:00
Subject: Re: [syslog-ng] Microsoft SQL connect issue

On Mon, Dec 13, 2010 at 12:19:03PM -0500, Shawn Cannon wrote:
> I meant I ran tsql. :-)
>
> Shawn Cannon
>
> IT Professional
>
> > OK I installed it ans ran TDS using sql.hidden.local and the port number
> > and I was able to create the table. I changed my syslogng config file to
> > this same setting, yet it still gives me an error. I left the table in the
> > database that was created but even that did not help. Any ideas?

There have been some bugs in the past where syslog-ng was not always
connecting to the database correctly on the proper ports, etc. However
in your case this could only apply if something was also listening on
the default port I would assume, since it seemed like it had connected.
Although as one of the other posters had pointed out there could be an
inaccurate error message as well. Perhaps you could verify it's
connecting properly to the DB using Wireshark?

Was the tsql / sqsh / etc. based testing performed using the same
machine as the syslog-ng setup is running?

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