[syslog-ng] Syslog-NG/Log Analyzer

[sagar naravane]

Shouldn't  'FQDN_for_mysql_server.com'  be IP/Hostname of the server
initiating connection and not the mysql server itself ?


Saggu

On Mon, Sep 10, 2012 at 10:54 PM, James McDonald <jmcdonald at lce.com> wrote:

> 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: Connection to
> the database server failed.  Access denied for user 'syslog'@'FQDN_for_mysql_server.com'
> (using password: YES).
>
> Here is the output of the grants for the 'syslog' user:
>
> ****
>
> *CODE: SELECT ALL <http://kb.monitorware.com/>*
>
> mysql> show grants for 'syslog'@'FQDN_for_mysql_server.com';
>
> +------------------------------------------------------------------------------------+
> | Grants for syslog at FQDN_for_mysql_server.com
>     |
>
> +------------------------------------------------------------------------------------+
> | GRANT USAGE ON *.* TO 'syslog'@'FQDN_for_mysql_server.com'
>    |
> | GRANT ALL PRIVILEGES ON `Syslog`.* TO 'syslog'@'FQDN_for_mysql_server.com'
> |
>
> +------------------------------------------------------------------------------------+
> 2 rows in set (0.00 sec)****
>
>
>
> And here is what my config.php looks like:
>
> $CFG['DefaultSourceID'] = 'Source1';
>
> $CFG['Sources']['Source1']['ID'] = 'Source1';
> $CFG['Sources']['Source1']['Name'] = 'Syslog';
> $CFG['Sources']['Source1']['ViewID'] = 'SYSLOG';
> $CFG['Sources']['Source1']['SourceType'] = SOURCE_DB;
> $CFG['Sources']['Source1']['DBTableType'] = 'syslogng';
> $CFG['Sources']['Source1']['DBType'] = DB_MYSQL;
> $CFG['Sources']['Source1']['DBServer'] = 'ustc-mysql';
> $CFG['Sources']['Source1']['DBName'] = 'Syslog';
> $CFG['Sources']['Source1']['DBUser'] = 'syslog';
> $CFG['Sources']['Source1']['DBPassword'] = 'pTRl819ELI0viRmXaEUO';
> $CFG['Sources']['Source1']['DBTableName'] = 'SystemEvents';
> $CFG['Sources']['Source1']['DBEnableRowCounting'] = false;****
>
> ** **
>
> ** **
>
> Thanks,****
>
> James McDonald****
>
> System Administrator****
>
> RHCSA, Security+****
>
> jmcdonald at lce.com****
>
> ** **
>
>
> ______________________________________________________________________________
> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Documentation:
> http://www.balabit.com/support/documentation/?product=syslog-ng
> FAQ: http://www.balabit.com/wiki/syslog-ng-faq
>
>
>


-- 
Regards,

Sagar Naravane
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20120911/e6c00031/attachment-0001.htm