<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
code
{mso-style-priority:99;
font-family:"Courier New";}
span.EmailStyle18
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><div style='mso-element:para-border-div;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='orphans: 2;text-align:start;widows: 2;-webkit-text-size-adjust: auto;-webkit-text-stroke-width: 0px;word-spacing:0px'><br><o:p></o:p></span></p></div><div style='mso-element:para-border-div;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 class=apple-converted-space> </span><a href="http://kb.monitorware.com/"><span style='color:#105289;text-decoration:none'>SELECT ALL</span></a><o:p></o:p></span></b></p></div><div style='mso-element:para-border-div;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">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'><o:p></o:p></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;<o:p></o:p></span></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";color:#333333;background:#E1EBF2'><o:p> </o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>James McDonald<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>System Administrator<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>RHCSA, Security+<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><a href="mailto:jmcdonald@lce.com">jmcdonald@lce.com</a><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>