Can't access MySQL db from Log Analyzer

Everything which is related to the installation of phpLogCon.

Google Ads

Can't access MySQL db from Log Analyzer

Postby lce411 » Mon Sep 10, 2012 4:06 pm

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: Access denied for user 'syslog'@'' (using password: YES).

Here is the output of the grants for the 'syslog' user:
Code: Select all
mysql> show grants for 'syslog'@'';
| Grants for                                |
| GRANT USAGE ON *.* TO 'syslog'@''                 |
| GRANT ALL PRIVILEGES ON `Syslog`.* TO 'syslog'@'' |
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;

To say I'm a novice at MySQL would be over-stating the obvious. I've done the best I can with web searches, but I cannot get Log Ananlyzer to access this MySQL db. Can someone with the willingness and patience to help me out respond to this? My last question posted here got zero responses and prompted the re-install.
Posts: 6
Joined: Fri Aug 24, 2012 2:12 pm

Urgent Question?

  • Pulling out your Hair?
  • Wasting Time and Money?
  • Deadline Approaching?

Re: Can't access MySQL db from Log Analyzer

Postby alorbach » Tue Sep 18, 2012 8:29 am

According to the error message, either the username/password is wrong, or the user "syslog" has insufficient rights, or is not allowed to login.

best regards,
Site Admin
Posts: 1627
Joined: Thu Feb 13, 2003 11:55 am

Re: Can't access MySQL db from Log Analyzer

Postby frisk896 » Mon Jun 24, 2013 3:56 pm

1. Installing loganalyzer without mysql? I’m not sure about that. MySQL used to store syslog messages from your machine into database, and Loganalyzer is a web interface likes a GUI to display a syslog messages.

2. Mmhhh.. you’re unable to view http://ipaddress/Rsyslog/ page? It seems there’s a problem on your php.ini configuration, Access To MySQL what a web server are you use for? it means your web server cannot reads a php files from your doc root directory.

3. This questions are related with question no.2. i think your configuration was correct.
Posts: 1
Joined: Mon Jun 24, 2013 3:14 pm

Google Ads

Return to Installation

Who is online

Users browsing this forum: No registered users and 0 guests