On Mon, Dec 29, 2014 at 10:15 AM, Fred974 <[email protected]> wrote: > This the result of > SHOW TABLE STATUS FROM OSSEC; > +----------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+ > | Name | Engine | Version | Row_format | Rows | > Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | > Auto_increment | Create_time | Update_time | Check_time | Collation > | Checksum | Create_options | Comment | > +----------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+ > | agent | InnoDB | 10 | Compact | 0 | > 0 | 16384 | 0 | 0 | 0 | > 1 | 2014-11-26 13:15:10 | NULL | NULL | utf8_general_ci | > NULL | | | > | alert | InnoDB | 10 | Compact | 197 | > 83 | 16384 | 0 | 49152 | 0 | > NULL | 2014-11-26 13:15:10 | NULL | NULL | utf8_general_ci | > NULL | | | > | category | InnoDB | 10 | Compact | 130 | > 126 | 16384 | 0 | 32768 | 0 | > 131 | 2014-11-26 13:15:10 | NULL | NULL | utf8_general_ci | > NULL | | | > | data | InnoDB | 10 | Compact | 0 | > 0 | 16384 | 0 | 16384 | 0 | > NULL | 2014-11-26 13:15:10 | NULL | NULL | utf8_general_ci | > NULL | | | > | location | InnoDB | 10 | Compact | 12 | > 1365 | 16384 | 0 | 0 | 0 | > 15 | 2014-11-26 13:15:10 | NULL | NULL | utf8_general_ci | > NULL | | | > | server | InnoDB | 10 | Compact | 0 | > 0 | 16384 | 0 | 16384 | 0 | > 2 | 2014-11-26 15:08:26 | NULL | NULL | utf8_general_ci | > NULL | | | > | signature | InnoDB | 10 | Compact | 952 | > 103 | 98304 | 0 | 49152 | 0 | > 953 | 2014-11-26 13:15:10 | NULL | NULL | utf8_general_ci | > NULL | | | > | signature_category_mapping | InnoDB | 10 | Compact | 2134 | > 46 | 98304 | 0 | 0 | 0 | > 2135 | 2014-11-26 13:15:10 | NULL | NULL | utf8_general_ci | > NULL | | | > +----------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+ > 8 rows in set (0.00 sec) > > I can see that I have data in some tables but not all of them. >
Ok, find out which table analogi is trying to read from and see if that one is empty. > I'm not sure why > > Fred > > > > On Monday, 29 December 2014 14:15:10 UTC, Fred974 wrote: >> >> Hi, >> >> I have successfully installed ossec on my server but when accessing the >> AnaLogi web interface, I get the following message: >> >> Test 4 - Is there any data in your database? - no! >> Fix - Ensure agents are logging data. >> >> Could someone please help me in solving this issue. >> From another post here I have been told that the agent table is currently >> unused.. >> >> Could this be the reason why I get the error message? >> >> Thank you >> >> Fred > > -- > > --- > You received this message because you are subscribed to the Google Groups > "ossec-list" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- --- You received this message because you are subscribed to the Google Groups "ossec-list" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
