<!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="#0050d0">
<font size="-1"><font face="Helvetica, Arial, sans-serif">It will only
try to create the table if it thinks it doesnt already exist. It
determines if it exists by doing `select * from <table> where
0=1`. You must be able to perform this query using the same credentials
syslog-ng is using. It doesnt matter that it wont return any rows, it
just cant generate an error.<br>
<br>
-Patrick<br>
</font></font><br>
Sent: Thu Jan 20 2011 10:39:37 GMT-0700 (Mountain Standard Time)<br>
From: Shawn Cannon <a class="moz-txt-link-rfc2396E" href="mailto:shawn@shawncannon.com"><shawn@shawncannon.com></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: [syslog-ng] Syslog-ng error
<blockquote
cite="mid:AANLkTindd_6+n3EfK6FJoBxm4+qkLS=MKQBGZv=AWyWO@mail.gmail.com"
type="cite">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?<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"
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>
<pre wrap="">
<hr size="4" width="90%">
______________________________________________________________________________
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>
</body>
</html>