[syslog-ng] Syslog-NG/Log Analyzer

[sagar naravane]

If the apache (hosting .php) and mysql reside on same machine.. try with
"localhost" rather than the fqdn :)

Saggu

On Tue, Sep 11, 2012 at 10:43 AM, sagar naravane
<sagar.naravane at gmail.com>wrote:

> 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
>



-- 
Regards,

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