<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hi,<br>
<br>
we have already encountered this problem a few weeks ago. See the
following thread: [syslog-ng] Microsoft SQL connect issue<br>
<br>
My summary from this thread:<br>
"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>
<br>
2011.01.20. 19:46 keltezéssel, Shawn Cannon írta:
<blockquote
cite="mid:AANLkTim_o+RE4rgsSKtbYc7Wx5YM4j5yYNCu-RVm6DNV@mail.gmail.com"
type="cite">Thanks. It ended up that I needed to make the SQL
user default to that database, even though I already have the
database specified in the config file. No big deal, just annoying
that it seems to ignore the database setting.<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);
background-color: rgb(248, 248, 248); padding: 0.8em 0.8em
0.3em;">
<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" width="16"
border="0" height="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" width="16"
border="0" height="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" width="16"
border="0" height="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><span
style="font-size: 90%;"><span style="color: gray;"></span></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"
width="1" height="1"></span><br>
<br>
<br>
<div class="gmail_quote">On Thu, Jan 20, 2011 at 1:35 PM, Matthew
Hall <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:mhall@mhcomputing.net">mhall@mhcomputing.net</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div class="im"><br>
On Thu, Jan 20, 2011 at 12:39:37PM -0500, Shawn Cannon
wrote:<br>
> I am trying to setup a second syslog-ng server that
will be part of a load<br>
> balanced cluster. When the 2nd server tries to connect
to my mssql<br>
> database, it tries to run the CREATE TABLE commands
which fails because the<br>
> table already exists since the first syslog-ng server
already created them.<br>
> How do I tell the 2nd server not to try the CREATE
TABLE stuff so it will<br>
> start working?<br>
><br>
> Shawn Cannon<br>
><br>
> IT Professional<br>
><br>
> <a moz-do-not-send="true"
href="http://www.shawncannon.com" target="_blank">http://www.shawncannon.com</a><br>
<br>
</div>
There is a dont-create-tables option in newer syslog-ngs which
will fix<br>
this one.<br>
<br>
dont-create-tables: Enable this flag to prevent syslog-ng OSE
from<br>
creating non-existing database tables automatically. The
syslog-ng OSE<br>
application typically has to create tables if you use macros
in the<br>
table names. Available in syslog-ng OSE version 3.2 and later.<br>
<br>
<a moz-do-not-send="true"
href="http://www.balabit.com/sites/default/files/documents/syslog-ng-ose-v3.2-guide-admin-en.html/index.html-single.html"
target="_blank">http://www.balabit.com/sites/default/files/documents/syslog-ng-ose-v3.2-guide-admin-en.html/index.html-single.html</a><br>
<br>
HTH,<br>
<font color="#888888">Matthew.<br>
</font>
<div>
<div class="h5">______________________________________________________________________________<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>
<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>
<br>
<div class="moz-signature">-- <br>
pzolee</div>
</body>
</html>