[ossec-list] mysql connect

2011-10-20 Thread Kat
Hmm, if you can do

mysql -u ossecuser -p
and login to mysql

then why can't ossec connect with the same info?
ossec-dbd(5202): ERROR: Error connecting to database

??


Re: [ossec-list] mysql connect

2011-10-20 Thread dan (ddp)
On Thu, Oct 20, 2011 at 10:36 AM, Kat uncommon...@gmail.com wrote:
 Hmm, if you can do

 mysql -u ossecuser -p
 and login to mysql

 then why can't ossec connect with the same info?
 ossec-dbd(5202): ERROR: Error connecting to database

 ??

Your config is wrong.
Make sure mysql is listening to the correct IP and port, and make sure
the correct IP and port are in the ossec.conf. Also make sure the
ossecuser has permission to connect from that host/IP in the mysql
database.
Mysql also has logging capabilities that may help indicate where the issue is.