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?
On Mon, Dec 13, 2010 at 11:36 AM, Zoltán Pallagi <pzolee@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'
