<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hm... You are right, it seems that syslog-ng tries to connect to the
database that is the default for the specified user in config. However,
I've checked it in syslog-ng source, and syslog-ng uses the same code
for all database types for connecting and passes the name of database
properly and in case of other databases it works, too.<br>
So, it is a bug, but not in syslog-ng but in freetds or libdbi. Report
a bug on it, please, and we will check if we can fix it.<br>
Thanks<br>
<br>
On 2010-12-13 23:04, Shawn Cannon wrote:
<blockquote
cite="mid:AANLkTikoZdfhKZe6is+YzvvSV7wcgTtR_eryUctb510f@mail.gmail.com"
type="cite">The only thing that I did not have selected for the sql
user was to default it to the database I wanted to use. It defaulted
to Master. I changed that and now all is well. Kinda strange to have
an option called database() if it does not use that.<br>
<br>
<span
style="font-size: 13.3px; font-family: Verdana,Arial,Helvetica,sans-serif;">
<div
style="border: 1px solid rgb(229, 229, 229); padding: 0.8em 0.8em 0.3em; background-color: rgb(248, 248, 248);">
<div style="margin: 0pt 0pt 8px;">
<p style="margin: 0pt;">Shawn Cannon</p>
<p style="margin: 0pt;">IT Professional</p>
<p style="margin: 0pt;"><a moz-do-not-send="true" title="My Web Site"
href="http://www.shawncannon.com/" target="_blank">http://www.shawncannon.com</a></p>
<p style="margin: 0pt;"> </p>
</div>
<span style="color: gray;">Contact Me</span> <a
moz-do-not-send="true"
href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a"
style="text-decoration: underline;" target="_blank"><img
moz-do-not-send="true"
style="padding: 0px 0px 5px; vertical-align: middle;"
src="http://images.wisestamp.com/linkedin.png" border="0" height="16"
width="16"></a> <a moz-do-not-send="true"
href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a"
style="text-decoration: underline;" target="_blank"><span
style="color: black;">LinkedIn</span></a> <a moz-do-not-send="true"
href="http://www.facebook.com/rolltidega72"
style="text-decoration: underline;" target="_blank"><img
moz-do-not-send="true"
style="padding: 0px 0px 5px; vertical-align: middle;"
src="http://images.wisestamp.com/facebook.png" border="0" height="16"
width="16"></a> <a moz-do-not-send="true"
href="http://www.facebook.com/rolltidega72"
style="text-decoration: underline;" target="_blank"><span
style="color: black;">Facebook</span></a> <a moz-do-not-send="true"
href="http://twitter.com/rolltidega"
style="text-decoration: underline;" target="_blank"><img
moz-do-not-send="true"
style="padding: 0px 0px 5px; vertical-align: middle;"
src="http://images.wisestamp.com/twitter.png" border="0" height="16"
width="16"></a> <a moz-do-not-send="true"
href="http://twitter.com/rolltidega"
style="text-decoration: underline;" target="_blank"><span
style="color: black;">Twitter</span></a><br>
<span style="font-size: 90%;"><span style="color: gray;">My blog: </span>
<a moz-do-not-send="true" href="http://www.shawncannon.com/?p=19"
target="_blank"><span
style="color: rgb(0, 0, 238); text-decoration: underline;">My thoughts
on VMworld… a week later…</span></a></span><br>
</div>
<img moz-do-not-send="true"
src="http://s.wisestamp.com/pixel.png?p=mozilla&v=2.0.3&t=1285469003981&u=5096061&e=5721"
height="1" width="1"></span><br>
<br>
<br>
<div class="gmail_quote">On Mon, Dec 13, 2010 at 4:29 PM, Zoltán
Pallagi <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:pzolee@balabit.hu">pzolee@balabit.hu</a>></span> wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div text="#000000" bgcolor="#ffffff"> Well, syslog-ng tries to
query the result of "select * from tablename where 0=1;" to check if
the specified table exists. If it didn't return with error, then the
table exists, and syslog-ng will check the columns and alter the table
if needed.<br>
In other cases (the above query returned with any error), syslog-ng
assumes that the specified table does not exist and tries to create it.
As far as I see, this query returned with error in your case, that's
the reason why syslog-ng tries to create it after reaching the next
time_reopen. Also, it seems that syslog-ng has not enough permission to
create this table. Are you sure that the user specified in syslog-ng
conf has the sufficient permissions for this database?<br>
<br>
You have just told me that you tried it with tsql, could you show me
the output of this?<br>
Have you used the same user? I mean you should execute tsql with the
following parameters:<br>
tsql -S rawsql -p 1785 -U user_in_conf -P password_in_conf<br>
<br>
2010.12.13. 20:23 keltezéssel, Shawn Cannon írta:
<div>
<div class="h5">
<blockquote type="cite">OK this is some good info. It looks like
even though I specify the database name, it is someone how using it and
tries to create or check for the tables on the master database. Any
ideas? Here is the info from the capture. Why is is running a SELECT
looking for syslogng instead of the database name?<br>
<br>
<b>....(....SELECT * FROM syslogng WHERE
0=1...K.<...7.........Invalid object name
'syslogng'..RAWSQL\MARTY....................CREATE TABLE syslogng
(datetime varchar(16), host varchar(32), program varchar(32), pid
varchar(8), message varchar(4096))...`.<...L.......4.CREATE TABLE
permission denied in database 'master'..RAWSQL\MARTY............<br>
</b><br>
Here is my destination section from my syslogng config:<br>
<br>
destination d_mssql {<br>
sql(type(mssql) host("rawsql") port("1785")<br>
username("*******") password("*******") database("Database")<br>
table("syslogng")columns("datetime varchar(16)", "host varchar(32)",<br>
"program varchar(32)", "pid varchar(8)", "message varchar(4096)")<br>
values("$R_DATE", "$HOST", "$PROGRAM", "$PID", "$MSGONLY")<br>
indexes("datetime", "host", "program", "pid"));<br>
};<br>
<br>
<br clear="all">
<span
style="font-size: 13.3px; font-family: Verdana,Arial,Helvetica,sans-serif;">
<div
style="border: 1px solid rgb(229, 229, 229); padding: 0.8em 0.8em 0.3em; background-color: rgb(248, 248, 248);">
<div style="margin: 0pt 0pt 8px;">
<p style="margin: 0pt;">Shawn Cannon</p>
<p style="margin: 0pt;">IT Professional</p>
<p style="margin: 0pt;"><a moz-do-not-send="true"
title="My
Web Site" href="http://www.shawncannon.com/"
target="_blank">http://www.shawncannon.com</a></p>
<p style="margin: 0pt;"> </p>
</div>
<span style="color: gray;">Contact Me</span> <a
moz-do-not-send="true"
href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a"
style="text-decoration: underline;" target="_blank"><img
moz-do-not-send="true" src=""
style="padding: 0px 0px 5px; vertical-align: middle;" border="0"
height="16" width="16"></a> <a moz-do-not-send="true"
href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a"
style="text-decoration: underline;" target="_blank"><span
style="color: black;">LinkedIn</span></a> <a moz-do-not-send="true"
href="http://www.facebook.com/rolltidega72"
style="text-decoration: underline;" target="_blank"><img
moz-do-not-send="true" src=""
style="padding: 0px 0px 5px; vertical-align: middle;" border="0"
height="16" width="16"></a> <a moz-do-not-send="true"
href="http://www.facebook.com/rolltidega72"
style="text-decoration: underline;" target="_blank"><span
style="color: black;">Facebook</span></a> <a moz-do-not-send="true"
href="http://twitter.com/rolltidega"
style="text-decoration: underline;" target="_blank"><img
moz-do-not-send="true" src=""
style="padding: 0px 0px 5px; vertical-align: middle;" border="0"
height="16" width="16"></a> <a moz-do-not-send="true"
href="http://twitter.com/rolltidega"
style="text-decoration: underline;" target="_blank"><span
style="color: black;">Twitter</span></a><br>
<span style="font-size: 90%;"><span style="color: gray;">My blog:
</span> <a moz-do-not-send="true"
href="http://www.shawncannon.com/?p=19" target="_blank"><span
style="color: rgb(0, 0, 238); text-decoration: underline;">My thoughts
on VMworld… a week later…</span></a></span><br>
</div>
<img moz-do-not-send="true" src="" height="1" width="1"></span><br>
<br>
<br>
<div class="gmail_quote">On Mon, Dec 13, 2010 at 1:45 PM, Shawn
Cannon <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:shawn@shawncannon.com" target="_blank">shawn@shawncannon.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Would it help if I posted the syntax of my config file?
<div><br>
<br clear="all">
<span
style="font-size: 13.3px; font-family: Verdana,Arial,Helvetica,sans-serif;">
<div
style="border: 1px solid rgb(229, 229, 229); padding: 0.8em 0.8em 0.3em; background-color: rgb(248, 248, 248);">
<div style="margin: 0pt 0pt 8px;">
<p style="margin: 0pt;">Shawn Cannon</p>
<p style="margin: 0pt;">IT Professional</p>
<p style="margin: 0pt;"><a moz-do-not-send="true"
title="My Web Site" href="http://www.shawncannon.com/" target="_blank">http://www.shawncannon.com</a></p>
<p style="margin: 0pt;"> </p>
</div>
<span style="color: gray;">Contact Me</span> <a
moz-do-not-send="true"
href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a"
style="text-decoration: underline;" target="_blank"><img
moz-do-not-send="true" src=""
style="padding: 0px 0px 5px; vertical-align: middle;" border="0"
height="16" width="16"></a> <a moz-do-not-send="true"
href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a"
style="text-decoration: underline;" target="_blank"><span
style="color: black;">LinkedIn</span></a> <a moz-do-not-send="true"
href="http://www.facebook.com/rolltidega72"
style="text-decoration: underline;" target="_blank"><img
moz-do-not-send="true" src=""
style="padding: 0px 0px 5px; vertical-align: middle;" border="0"
height="16" width="16"></a> <a moz-do-not-send="true"
href="http://www.facebook.com/rolltidega72"
style="text-decoration: underline;" target="_blank"><span
style="color: black;">Facebook</span></a> <a moz-do-not-send="true"
href="http://twitter.com/rolltidega"
style="text-decoration: underline;" target="_blank"><img
moz-do-not-send="true" src=""
style="padding: 0px 0px 5px; vertical-align: middle;" border="0"
height="16" width="16"></a> <a moz-do-not-send="true"
href="http://twitter.com/rolltidega"
style="text-decoration: underline;" target="_blank"><span
style="color: black;">Twitter</span></a><br>
<span style="font-size: 90%;"><span style="color: gray;">My
blog: </span> <a moz-do-not-send="true"
href="http://www.shawncannon.com/?p=19" target="_blank"><span
style="color: rgb(0, 0, 238); text-decoration: underline;">My thoughts
on VMworld… a week later…</span></a></span><br>
</div>
<img moz-do-not-send="true" src="" height="1" width="1"></span><br>
<br>
<br>
</div>
<div>
<div>
<div class="gmail_quote">On Mon, Dec 13, 2010 at 1:17 PM,
Matthew Hall <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:mhall@mhcomputing.net" target="_blank">mhall@mhcomputing.net</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>On Mon, Dec 13, 2010 at 12:19:03PM -0500, Shawn Cannon
wrote:<br>
> I meant I ran tsql. :-)<br>
><br>
> Shawn Cannon<br>
><br>
> IT Professional<br>
><br>
</div>
<div>> > OK I installed it ans ran TDS using
sql.hidden.local and the port number<br>
> > and I was able to create the table. I changed my syslogng
config file to<br>
> > this same setting, yet it still gives me an error. I left
the table in the<br>
> > database that was created but even that did not help. Any
ideas?<br>
<br>
</div>
There have been some bugs in the past where syslog-ng was not always<br>
connecting to the database correctly on the proper ports, etc. However<br>
in your case this could only apply if something was also listening on<br>
the default port I would assume, since it seemed like it had connected.<br>
Although as one of the other posters had pointed out there could be an<br>
inaccurate error message as well. Perhaps you could verify it's<br>
connecting properly to the DB using Wireshark?<br>
<br>
Was the tsql / sqsh / etc. based testing performed using the same<br>
machine as the syslog-ng setup is running?<br>
<font color="#888888"><br>
Matthew.<br>
</font>
<div>
<div>______________________________________________________________________________<br>
Member info: <a moz-do-not-send="true"
href="https://lists.balabit.hu/mailman/listinfo/syslog-ng"
target="_blank">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a><br>
Documentation: <a moz-do-not-send="true"
href="http://www.balabit.com/support/documentation/?product=syslog-ng"
target="_blank">http://www.balabit.com/support/documentation/?product=syslog-ng</a><br>
FAQ: <a moz-do-not-send="true"
href="http://www.campin.net/syslog-ng/faq.html" target="_blank">http://www.campin.net/syslog-ng/faq.html</a><br>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
</div>
<br>
<pre><fieldset></fieldset>
______________________________________________________________________________
Member info: <a moz-do-not-send="true"
href="https://lists.balabit.hu/mailman/listinfo/syslog-ng"
target="_blank">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
Documentation: <a moz-do-not-send="true"
href="http://www.balabit.com/support/documentation/?product=syslog-ng"
target="_blank">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a moz-do-not-send="true"
href="http://www.campin.net/syslog-ng/faq.html" target="_blank">http://www.campin.net/syslog-ng/faq.html</a>
</pre>
</blockquote>
<br>
<br>
</div>
</div>
<font color="#888888">
<div>-- <br>
pzolee</div>
</font></div>
</blockquote>
</div>
<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
______________________________________________________________________________
Member info: <a class="moz-txt-link-freetext" href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
Documentation: <a class="moz-txt-link-freetext" href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a class="moz-txt-link-freetext" href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a>
</pre>
</blockquote>
<br>
</body>
</html>