<!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 bgcolor="#ffffff" text="#0050d0">
<br>
<br>
Sent: Thu Jan 20 2011 11:35:41 GMT-0700 (Mountain Standard Time)<br>
From: Matthew Hall <a class="moz-txt-link-rfc2396E" href="mailto:mhall@mhcomputing.net"><mhall@mhcomputing.net></a><br>
To: Syslog-ng users' and developers' mailing list
<a class="moz-txt-link-rfc2396E" href="mailto:syslog-ng@lists.balabit.hu"><syslog-ng@lists.balabit.hu></a> <br>
Subject: Re: [syslog-ng] Syslog-ng error
<blockquote cite="mid:20110120183541.GA8767@mhcomputing.net" type="cite">
<pre wrap="">On Thu, Jan 20, 2011 at 12:39:37PM -0500, Shawn Cannon wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I am trying to setup a second syslog-ng server that will be part of a load
balanced cluster. When the 2nd server tries to connect to my mssql
database, it tries to run the CREATE TABLE commands which fails because the
table already exists since the first syslog-ng server already created them.
How do I tell the 2nd server not to try the CREATE TABLE stuff so it will
start working?
Shawn Cannon
IT Professional
<a class="moz-txt-link-freetext" href="http://www.shawncannon.com">http://www.shawncannon.com</a>
</pre>
</blockquote>
<pre wrap=""><!---->
There is a dont-create-tables option in newer syslog-ngs which will fix
this one.
</pre>
</blockquote>
The big problem with this solution is that if the table check failed,
then inserting it will also fail. The only case this would solve is if
the user doesnt have select perms, but does have insert perms.<br>
<br>
-Patrick<br>
</body>
</html>