Hi Dan, Its one of those items that sometimes slips the net. An upgrade SQL script between releases, if required, would be a great addition. Keep up the excellent work. -- Thanks, Phil
----- Original Message ----- > On Tue, Jul 26, 2011 at 4:10 PM, --[ UxBoD ]-- <[email protected]> > wrote: > > Cheers Dan, disappointed not mentioned anywhere. To fix but still > > checking other tables I ran: > > > > I think these types of changes should be publicized a lot more than > they have been. It's something we'll work on in the future. > > Thanks for the instructions. Hopefully they can help anyone else > having issues. > > > mysql > > use ossec > > alter table alert add (alertid tinytext default null); > > alter table data add (timestamp timestamp); > > create index time on data (timestamp); > > -- > > Thanks, Phil > > > > ----- Original Message ----- > >> 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] > >> >> > >> > > >> > > >
