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><strong>....(....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>
</strong><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); 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 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 href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a" style="text-decoration: underline;" target="_blank"><img style="padding: 0px 0px 5px; vertical-align: middle;" src="http://images.wisestamp.com/linkedin.png" border="0" height="16" width="16"></a> <a 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 href="http://www.facebook.com/rolltidega72" style="text-decoration: underline;" target="_blank"><img style="padding: 0px 0px 5px; vertical-align: middle;" src="http://images.wisestamp.com/facebook.png" border="0" height="16" width="16"></a> <a href="http://www.facebook.com/rolltidega72" style="text-decoration: underline;" target="_blank"><span style="color: black;">Facebook</span></a> <a href="http://twitter.com/rolltidega" style="text-decoration: underline;" target="_blank"><img style="padding: 0px 0px 5px; vertical-align: middle;" src="http://images.wisestamp.com/twitter.png" border="0" height="16" width="16"></a> <a 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 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 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 1:45 PM, Shawn Cannon <span dir="ltr"><<a href="mailto:shawn@shawncannon.com">shawn@shawncannon.com</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;">
Would it help if I posted the syntax of my config file?<div class="im"><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 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 href="http://www.linkedin.com/pub/shawn-cannon/5/84/81a" style="text-decoration: underline;" target="_blank"><img style="padding: 0px 0px 5px; vertical-align: middle;" src="http://images.wisestamp.com/linkedin.png" border="0" height="16" width="16"></a> <a 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 href="http://www.facebook.com/rolltidega72" style="text-decoration: underline;" target="_blank"><img style="padding: 0px 0px 5px; vertical-align: middle;" src="http://images.wisestamp.com/facebook.png" border="0" height="16" width="16"></a> <a href="http://www.facebook.com/rolltidega72" style="text-decoration: underline;" target="_blank"><span style="color: black;">Facebook</span></a> <a href="http://twitter.com/rolltidega" style="text-decoration: underline;" target="_blank"><img style="padding: 0px 0px 5px; vertical-align: middle;" src="http://images.wisestamp.com/twitter.png" border="0" height="16" width="16"></a> <a 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 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 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><div><div></div><div class="h5"><div class="gmail_quote">On Mon, Dec 13, 2010 at 1:17 PM, Matthew Hall <span dir="ltr"><<a href="mailto:mhall@mhcomputing.net" target="_blank">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>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></div><div>______________________________________________________________________________<br>
Member info: <a href="https://lists.balabit.hu/mailman/listinfo/syslog-ng" target="_blank">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a><br>
Documentation: <a 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 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>