after upgrading from ossec 2.6 i noticed the following error... OSSEC HIDS v2.5.1 Stopped Starting OSSEC HIDS v2.6 (by Trend Micro Inc.)... OSSEC analysisd: Testing rules failed. Configuration error. Exiting. Started ossec-csyslogd... Started ossec-agentlessd... Started ossec-maild... Started ossec-execd... Started ossec-analysisd... Started ossec-logcollector... Started ossec-remoted... Started ossec-syscheckd... Started ossec-monitord... Completed.
On Tue, Jul 26, 2011 at 3:23 PM, dan (ddp) <[email protected]> wrote: > It (the mysql schema) appears to have changed: > https://bitbucket.org/dcid/ossec-hids/diff/src/os_dbd/mysql.schema?diff2=6e752b612937&diff1=071c2fa74389 > > I don't think the postgresql one has changed, but I don't know if it > works either. > > On Tue, Jul 26, 2011 at 12:13 PM, --[ UxBoD ]-- <[email protected]> wrote: >> Has the database schema for 2.6 change from 2.5 as I am now seeing: >> >> 2011/07/26 17:10:16 ossec-dbd(5203): ERROR: Error executing query 'INSERT >> INTO >> alert(id,server_id,rule_id,timestamp,location_id,src_ip,src_port,dst_ip,dst_port,alertid) >> VALUES ('95043', '1', '502','1311696616', '1', '0', '6080', '0', '32758', >> '1311696614.2290190')'. Error: 'Unknown column 'alertid' in 'field list''. >> >> when I start OSSEC! :( >> -- >> Thanks, Phil >> >> ----- Original Message ----- >>> Hi lists, >>> >>> We are very happy to announce the availability of OSSEC version 2.6. >>> >>> This has been a long release cycle, but it is here now with some good >>> new features and very stable (thanks to our beta users). >>> Our manual for the new version is also live at >>> http://www.ossec.net/doc/ . >>> >>> Release notes + new features + contributor list: >>> http://www.ossec.net/main/ossec-v2-6-released >>> >>> You can download the new version from: >>> http://www.ossec.net/main/downloads/ >>> >>> >>> *The GPG key was changed as well. So make sure to download the new >>> one >>> before verifying the package. >>> >>> >>> Thanks! >>> Daniel B. Cid (in name of the OSSEC + Trend team) >>> [email protected] >>> >> > -- Gallia est omnes divisa in partes tres. LIT(All Gaul is divided into three parts) Divide a problem into parts, understand each on its own terms, and plan your campaign Julius Caesar . GoogleVoice (614) 489-9522
