Re: [ossec-list] Setting up log in mysql databases ? getting some error

[dan (ddp)]

On Dec 18, 2012 1:30 PM, "Dhinakaran G" <dhinak...@capillarytech.com> wrote:
>
> after i finish the all stuff:I am getting this errror. 
>
> root@capillary:/home/capillary/ossec-hids-2.7# /var/ossec/bin/ossec-control start
>
> Starting OSSEC HIDS v2.7 (by Trend Micro Inc.)...
>
> 2012/12/18 23:54:05 ossec-dbd(5207): ERROR: OSSEC not compiled with support for 'mysql'.
>

Recompile with mysql support.

> 2012/12/18 23:54:05 ossec-dbd(1202): ERROR: Configuration error at '/var/ossec/etc/ossec.conf'. Exiting.
>
> root@capillary:/home/capillary/ossec-hids-2.7# 
>
>
> ===========================
> This db entry i put in the ossec.conf file. 
>
> <database_output>
>     <hostname>localhost</hostname>
>     <username>ossec</username>
>     <password>root</password>
>     <database>ossec</database>
>     <type>mysql</type>
>   </database_output>
>
> =========================
>
> how to resolve this.
>
>
>

[dan (ddp)]

On Dec 18, 2012 3:09 PM, "Dhinakaran G" <dhinak...@capillarytech.com> wrote:
>
> How to recompile ?
>

How did you compile it the first time?

cd src
make setdb
cd ..
./install.sh

There might be a change you have to make to a Makefile because ubuntu is odd. It's in the list archives.

[vanhien771354]

Vào 01:29:40 UTC+7 Thứ tư, ngày 19 tháng mười hai năm 2012, Dhinakaran G đã viết:

after i finish the all stuff:I am getting this errror. 

root@capillary:/home/capillary/ossec-hids-2.7# /var/ossec/bin/ossec-control start

Starting OSSEC HIDS v2.7 (by Trend Micro Inc.)...

2012/12/18 23:54:05 ossec-dbd(5207): ERROR: OSSEC not compiled with support for 'mysql'.

2012/12/18 23:54:05 ossec-dbd(1202): ERROR: Configuration error at '/var/ossec/etc/ossec.conf'. Exiting.

root@capillary:/home/capillary/ossec-hids-2.7# 

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

This db entry i put in the ossec.conf file. 

<database_output>

    <hostname>localhost</hostname>

    <username>ossec</username>

    <password>root</password>

    <database>ossec</database>

    <type>mysql</type>

  </database_output>

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

Before enable database support u should do

# service mysqld start

# chkconfig mysqld on

then check OSSEC compiler database logging 

# /var/ossec/bin/ossec-dbd -V

OSSEC HIDS v2.6 - Trend Micro Inc.
Compiled with MySQL support

If OSSEC say "Compiled without any Database support".  You must reinstall OSSEC.

then I follow https://groups.google.com/forum/#!msg/ossec-list/z6cXq1iZYTo/2aPGtkBdc4sJ to do config MySQL.