rsyslog server with apache and loganalyzer giving error

ganesh24pal@gmail.com · 01-25-2015, 01:31 AM

Hi Team,

We had tried to rsyslog server with apache and loganalyzer, But while configuring at last its giving error to me .

We had installed CentOS 6.4, Apache2, PHP and loganalyzer-3.4.2.tar.gz

And Use :- Following Reference link.

http://itmanager.blogs.com/notes/201...b8d0c7dc47970c

=============================================================
Critical Error occured

Errordetails:
Failed to establish a connection to the configured MYSQL Server.
LogAnalyzer is not able to initialize the user system.

Extra Error Details:
mysql_connect(): Access denied for user 'loganalyzer1'@'localhost' (using password: YES)

==============================================================

I am trying myself

TB0ne · 01-25-2015, 10:36 AM

Quote:

Originally Posted by ganesh24pal@gmail.com

Hi Team,
We had tried to rsyslog server with apache and loganalyzer, But while configuring at last its giving error to me. We had installed CentOS 6.4, Apache2, PHP and loganalyzer-3.4.2.tar.gz

And Use :- Following Reference link.

=============================================================
Critical Error occured

Errordetails:
Failed to establish a connection to the configured MYSQL Server.
LogAnalyzer is not able to initialize the user system.

Extra Error Details:
mysql_connect(): Access denied for user 'loganalyzer1'@'localhost' (using password: YES)

==============================================================
I am trying myself

Did you read and/or understand the error message??? It VERY CLEARLY tells you what's wrong. Either you didn't configure the MySQL user correctly, didn't grant the correct privileges, or the MySQL database on localhost isn't running.

The VERY OBVIOUS things to check are:

Is MySQL running on localhost?
Can you type in "mysql" on your localhost system, and get attached?
Can you then log in as the user/password you configured?
If so, can you then attach to the database you created?

If any of those things fail, then you need to fix them. Could be a simple matter of selinux running on your system. But the error is VERY clear, as are the steps in trying to resolve it.