[syslog-ng] Microsoft SQL connect issue

[Shawn Cannon]

I meant I ran tsql.  :-)

Shawn Cannon

IT Professional

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>
My blog: My thoughts on VMworld… a week later…<http://www.shawncannon.com/?p=19>



On Mon, Dec 13, 2010 at 12:12 PM, Shawn Cannon <shawn at shawncannon.com>wrote:

> 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?
>
>
> Shawn Cannon
>
> IT Professional
>
> 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>
> My blog: My thoughts on VMworld… a week later…<http://www.shawncannon.com/?p=19>
>
>
>
> On Mon, Dec 13, 2010 at 11:36 AM, Zoltán Pallagi <pzolee at balabit.hu>wrote:
>
>>  Hi,
>>
>> First of all, I don't think that "host='sql.hidden.local\instance'" will
>> work, but I've never tried it yet.
>> Secondly, there is a known bug in syslog-ng, it does not show the received
>> error message from freetds that's why you don't see any real error message.
>>
>> If you want to try it manually, you should install freetds on your
>> computer (e.g.: apt-get install freetds on Ubuntu), than you can connect to
>> mssql database using "tsql" command.
>> Just execute the following commands after connecting mssql database with
>> tsql command:
>> CREATE TABLE syslogng (datetime varchar(16), host varchar(32), program
>> varchar(32), pid varchar(8), message varchar(4096));
>> go
>>
>> If it works, the problem is the host\instance form. If it doesn't, freetds
>> will give you a proper error message about the reason of the problem.
>>
>>
>> 2010.12.13. 16:43 keltezéssel, Shawn Cannon írta:
>>
>> When a Microsoft SQL connection is attempted, I get the following errors.
>> I am trying to connect to a names instance of MS SQL over TCP 1785.  Any
>> ideas?  Thanks....
>>
>> Dec 13 10:33:23 syslog01 syslog-ng[27963]: Error running SQL query;
>> type='freetds', host='sql.hidden.local\instance', port='1785', user='user',
>> database='syslog', error='', query='CREATE TABLE syslogng (datetime
>> varchar(16), host varchar(32), program varchar(32), pid varchar(8), message
>> varchar(4096))'
>> Dec 13 10:33:23 syslog01 syslog-ng[27963]: Error creating table, giving
>> up; table='syslogng'
>> Dec 13 10:33:23 syslog01 syslog-ng[27963]: Error checking table,
>> disconnecting from database, trying again shortly; time_reopen='60'
>>
>>   Shawn Cannon
>>
>> IT Professional
>>
>> 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>
>> My blog: My thoughts on VMworld… a week later…<http://www.shawncannon.com/?p=19>
>>
>>
>> ______________________________________________________________________________
>> 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/20101213/0485b5f2/attachment.htm