If the apache (hosting .php) and mysql reside on same machine.. try with "localhost" rather than the fqdn :)<div><br></div><div>Saggu<br><br><div class="gmail_quote">On Tue, Sep 11, 2012 at 10:43 AM, sagar naravane <span dir="ltr"><<a href="mailto:sagar.naravane@gmail.com" target="_blank">sagar.naravane@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Shouldn't
<span style="line-height:18.200000762939453px;color:rgb(46,139,87);font-size:12px;font-family:monospace">'FQDN_for_mysql_</span><span style="line-height:18.200000762939453px;color:rgb(46,139,87);font-size:12px;font-family:monospace"><a href="http://server.com" target="_blank">server.com</a>'</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"><div><div class="h5">On Mon, Sep 10, 2012 at 10:54 PM, James McDonald <span dir="ltr"><<a href="mailto:jmcdonald@lce.com" target="_blank">jmcdonald@lce.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><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:"Trebuchet MS","sans-serif";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:"Trebuchet MS","sans-serif";color:red;background:#e1ebf2">Connection to the database server failed. Access denied for user 'syslog'@'FQDN_for_mysql_server.com' (using password: YES).</span><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";color:#333333"><br>
<br><span style="background:#e1ebf2">Here is the output of the grants for the 'syslog' 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:"Trebuchet MS","sans-serif";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> show grants for 'syslog'@'FQDN_for_mysql_server.com';</span></code><span style="font-size:9.0pt;font-family:"Courier New";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 'syslog'@'FQDN_for_mysql_server.com' |</code><br><code>| GRANT ALL PRIVILEGES ON `Syslog`.* TO 'syslog'@'FQDN_for_mysql_server.com' |</code><br>
<code>+------------------------------------------------------------------------------------+</code><br><code>2 rows in set (0.00 sec)</code></span><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";color:#333333"><u></u><u></u></span></p>
</div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";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['DefaultSourceID'] = 'Source1';</span><br><br><span style="background:#e1ebf2">$CFG['Sources']['Source1']['ID'] = 'Source1';</span><br>
<span style="background:#e1ebf2">$CFG['Sources']['Source1']['Name'] = 'Syslog';</span><br><span style="background:#e1ebf2">$CFG['Sources']['Source1']['ViewID'] = 'SYSLOG';</span><br>
<span style="background:#e1ebf2">$CFG['Sources']['Source1']['SourceType'] = SOURCE_DB;</span><br><span style="background:#e1ebf2">$CFG['Sources']['Source1']['DBTableType'] = 'syslogng';</span><br>
<span style="background:#e1ebf2">$CFG['Sources']['Source1']['DBType'] = DB_MYSQL;</span><br><span style="background:#e1ebf2">$CFG['Sources']['Source1']['DBServer'] = 'ustc-mysql';</span><br>
<span style="background:#e1ebf2">$CFG['Sources']['Source1']['DBName'] = 'Syslog';</span><br><span style="background:#e1ebf2">$CFG['Sources']['Source1']['DBUser'] = 'syslog';</span><br>
<span style="background:#e1ebf2">$CFG['Sources']['Source1']['DBPassword'] = 'pTRl819ELI0viRmXaEUO';</span><br><span style="background:#e1ebf2">$CFG['Sources']['Source1']['DBTableName'] = 'SystemEvents';</span><br>
<span style="background:#e1ebf2">$CFG['Sources']['Source1']['DBEnableRowCounting'] = false;<u></u><u></u></span></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";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:"Arial","sans-serif"">Thanks,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">James McDonald<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">System Administrator<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">RHCSA, Security+<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""><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></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.balabit.com/wiki/syslog-ng-faq" target="_blank">http://www.balabit.com/wiki/syslog-ng-faq</a><br>
<br>
<br></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br>Regards,<br><br>Sagar Naravane<br>
</font></span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Regards,<br><br>Sagar Naravane<br>
</div>