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.
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.
