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