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.