[syslog-ng] Microsoft SQL connect issue

[Shawn Cannon]

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 at mhcomputing.net>
To: Syslog-ng users' and developers' mailing list <syslog-ng at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20101213/2e0e4a0c/attachment.htm