Information: Forum is in read-only mode
For details and other support options see https://www.adiscon.com/news/support-forum-set-to-read-only-mode/

Can't access MySQL db from Log Analyzer

Everything which is related to the installation of phpLogCon.

Moderator: alorbach

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'@'FQDN_for_mysql_server.com' (using password: YES).

Here is the output of the grants for the 'syslog' user:
Code: Select all
mysql> show grants for 'syslog'@'FQDN_for_mysql_server.com';
+------------------------------------------------------------------------------------+
| Grants for syslog@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;

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.
lce411
New
 
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,
Andre
alorbach
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.
frisk896
New
 
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

cron