Shouldn't 
<span style="color:rgb(46,139,87);font-family:monospace;font-size:12px;line-height:18.200000762939453px;background-color:rgb(255,255,255)">&#39;FQDN_for_mysql_</span><span style="color:rgb(46,139,87);font-family:monospace;font-size:12px;line-height:18.200000762939453px;background-color:rgb(255,255,255)"><a href="http://server.com">server.com</a>&#39;</span>  be IP/Hostname of the server initiating connection and not the mysql server itself ?<div>
<br></div><div><br></div><div>Saggu<br><br><div class="gmail_quote">On Mon, Sep 10, 2012 at 10:54 PM, James McDonald <span dir="ltr">&lt;<a href="mailto:jmcdonald@lce.com" target="_blank">jmcdonald@lce.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div><div style="border:solid #c9d2d8 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt;background:white">
<p class="MsoNormal" style="line-height:13.65pt;background:white;border:none;padding:0in"><span style="font-size:10.0pt;font-family:&quot;Trebuchet MS&quot;,&quot;sans-serif&quot;;color:#333333;background:#e1ebf2">I finally got my syslog-ng servers to pass logs to the MySQL db, but was having some problems getting LogAnalzyer to access the db. I re-installed Log Analyzer but now I am getting an access denied error: </span><span style="font-size:10.0pt;font-family:&quot;Trebuchet MS&quot;,&quot;sans-serif&quot;;color:red;background:#e1ebf2">Connection to the database server failed.  Access denied for user &#39;syslog&#39;@&#39;FQDN_for_mysql_server.com&#39; (using password: YES).</span><span style="font-size:10.0pt;font-family:&quot;Trebuchet MS&quot;,&quot;sans-serif&quot;;color:#333333"><br>
<br><span style="background:#e1ebf2">Here is the output of the grants for the &#39;syslog&#39; user:</span><br style="text-align:start;word-spacing:0px"><br><u></u><u></u></span></p></div><div style="border:solid #c9d2d8 1.0pt;border-bottom:solid #cccccc 1.0pt;padding:2.0pt 2.0pt 0in 2.0pt;background:white">
<p class="MsoNormal" style="line-height:13.65pt;background:white;border:none;padding:0in"><b><span style="font-size:8.0pt;font-family:&quot;Trebuchet MS&quot;,&quot;sans-serif&quot;;color:#333333;text-transform:uppercase">CODE:<span> </span><a href="http://kb.monitorware.com/" target="_blank"><span style="color:#105289;text-decoration:none">SELECT ALL</span></a><u></u><u></u></span></b></p>
</div><div style="border:solid #c9d2d8 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt;background:white;margin-left:.5in;margin-right:0in"><p class="MsoNormal" style="line-height:13.65pt;background:white;border:none;padding:0in"><code><span style="font-size:9.0pt;color:seagreen">mysql&gt; show grants for &#39;syslog&#39;@&#39;FQDN_for_mysql_server.com&#39;;</span></code><span style="font-size:9.0pt;font-family:&quot;Courier New&quot;;color:seagreen"><br>
<code>+------------------------------------------------------------------------------------+</code><br><code>| Grants for <a href="mailto:syslog@FQDN_for_mysql_server.com" target="_blank">syslog@FQDN_for_mysql_server.com</a>                                |</code><br>
<code>+------------------------------------------------------------------------------------+</code><br><code>| GRANT USAGE ON *.* TO &#39;syslog&#39;@&#39;FQDN_for_mysql_server.com&#39;                 |</code><br><code>| GRANT ALL PRIVILEGES ON `Syslog`.* TO &#39;syslog&#39;@&#39;FQDN_for_mysql_server.com&#39; |</code><br>
<code>+------------------------------------------------------------------------------------+</code><br><code>2 rows in set (0.00 sec)</code></span><span style="font-size:10.0pt;font-family:&quot;Trebuchet MS&quot;,&quot;sans-serif&quot;;color:#333333"><u></u><u></u></span></p>
</div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Trebuchet MS&quot;,&quot;sans-serif&quot;;color:#333333"><br><br><span style="background:#e1ebf2">And here is what my config.php looks like:</span><br>
<br><span style="background:#e1ebf2">$CFG[&#39;DefaultSourceID&#39;] = &#39;Source1&#39;;</span><br><br><span style="background:#e1ebf2">$CFG[&#39;Sources&#39;][&#39;Source1&#39;][&#39;ID&#39;] = &#39;Source1&#39;;</span><br>
<span style="background:#e1ebf2">$CFG[&#39;Sources&#39;][&#39;Source1&#39;][&#39;Name&#39;] = &#39;Syslog&#39;;</span><br><span style="background:#e1ebf2">$CFG[&#39;Sources&#39;][&#39;Source1&#39;][&#39;ViewID&#39;] = &#39;SYSLOG&#39;;</span><br>
<span style="background:#e1ebf2">$CFG[&#39;Sources&#39;][&#39;Source1&#39;][&#39;SourceType&#39;] = SOURCE_DB;</span><br><span style="background:#e1ebf2">$CFG[&#39;Sources&#39;][&#39;Source1&#39;][&#39;DBTableType&#39;] = &#39;syslogng&#39;;</span><br>
<span style="background:#e1ebf2">$CFG[&#39;Sources&#39;][&#39;Source1&#39;][&#39;DBType&#39;] = DB_MYSQL;</span><br><span style="background:#e1ebf2">$CFG[&#39;Sources&#39;][&#39;Source1&#39;][&#39;DBServer&#39;] = &#39;ustc-mysql&#39;;</span><br>
<span style="background:#e1ebf2">$CFG[&#39;Sources&#39;][&#39;Source1&#39;][&#39;DBName&#39;] = &#39;Syslog&#39;;</span><br><span style="background:#e1ebf2">$CFG[&#39;Sources&#39;][&#39;Source1&#39;][&#39;DBUser&#39;] = &#39;syslog&#39;;</span><br>
<span style="background:#e1ebf2">$CFG[&#39;Sources&#39;][&#39;Source1&#39;][&#39;DBPassword&#39;] = &#39;pTRl819ELI0viRmXaEUO&#39;;</span><br><span style="background:#e1ebf2">$CFG[&#39;Sources&#39;][&#39;Source1&#39;][&#39;DBTableName&#39;] = &#39;SystemEvents&#39;;</span><br>
<span style="background:#e1ebf2">$CFG[&#39;Sources&#39;][&#39;Source1&#39;][&#39;DBEnableRowCounting&#39;] = false;<u></u><u></u></span></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Trebuchet MS&quot;,&quot;sans-serif&quot;;color:#333333;background:#e1ebf2"><u></u> <u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">Thanks,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">James McDonald<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">System Administrator<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">RHCSA, Security+<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,&quot;sans-serif&quot;"><a href="mailto:jmcdonald@lce.com" target="_blank">jmcdonald@lce.com</a><u></u><u></u></span></p><p class="MsoNormal"><u></u> <u></u></p>
</div></div><br>______________________________________________________________________________<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.balabit.com/wiki/syslog-ng-faq" target="_blank">http://www.balabit.com/wiki/syslog-ng-faq</a><br>
<br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Regards,<br><br>Sagar Naravane<br>
</div>