[syslog-ng] Microsoft SQL connect issue

[Zoltán Pallagi]

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 <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/c10903f9/attachment.htm