if(mysql_query("SELECT 1 from agent", $db_ossec)
&& mysql_query("SELECT 1 from alert", $db_ossec)
&& mysql_query("SELECT 1 from category", $db_ossec)
&& mysql_query("SELECT 1 from data", $db_ossec)
&& mysql_query("SELECT 1 from location", $db_ossec)
&& mysql_query("SELECT 1 from server", $db_ossec)
&& mysql_query("SELECT 1 from signature", $db_ossec)
&& mysql_query("SELECT 1 from signature_category_mapping", $db_ossec)){
$databaseschema="yes";
}else{
$problem=1;
$databaseschema="no!<br/>";
$databaseschema.=" Fix -
Import the MySQL schema that comes with OSSEC";
}
if(checktable('alert') && checktable('data') && checktable('location')
&& checktable('signature')){
$anydata="yes";
}else{
$problem=1;
$anydata="no!<br/>";
$anydata.=" Fix - Ensure
agents are logging data.";
}
if($problem==0){
$nochartdata.="<div>No data found, but everything checks out ok.
Try broadening your search parameters.</div>";
}else{
$nochartdata="
<div style='font-size:24px; color:red;font-family:
Helvetica,Arial,sans-serif;'>No Chart Data Found</div>
<div style='padding-bottom:10px;'>There is no data available for
this query, running diagnostics...</div>
<div>Test 1 - Can PHP detect MySQL module? - ".$sqlmodule."</div>
<div>Test 2 - Can PHP connect to your MySQL? - ".$mysqlconnect.
"</div>
<div>Test 3 - Does your database have correct schema? - ".
$databaseschema."</div>
<div>Test 4 - Is there any data in your database? - ".$anydata.
"</div>";
}
The problem that I have is right here...Test 4.
if no data is log in the agent table, how do I get by this problem?
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.
