On Mon, Dec 29, 2014 at 11:30 AM, Fred974 <[email protected]> wrote: > 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? >
No clue, is there a README or something that mentions the agent table? > 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.
