[syslog-ng] Microsoft SQL connect issue

[Shawn Cannon]

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/8250b64b/attachment-0001.htm