Snort mailing list archives
Re: schema version 104
From: "Hugo Ferr" <snortgrp () hotmail com>
Date: Fri, 31 May 2002 11:58:53 -0400
thanks ----- Original Message ----- From: <roman () danyliw com> To: "Hugo Ferr" <snortgrp () hotmail com> Cc: <snort-users () lists sourceforge net> Sent: Friday, May 31, 2002 11:40 AM Subject: Re: [Snort-users] schema version 104
create_mysql is the DDL script that will create the entire database from
scratch. The
below SQL statements merely update the schema created by create_mysql. RomanSorry for dummy question but what is the difference between running create_mysql and doing: INSERT INTO schema (vseq, ctime) VALUES ('105', now()); DELETE FROM schema WHERE vseq = '104'; ????? thx. ----- Original Message ----- From: <roman () danyliw com> To: "Hugo Ferr" <snortgrp () hotmail com> Cc: <snort-users () lists sourceforge net> Sent: Friday, May 31, 2002 10:09 AM Subject: Re: [Snort-users] schema version 104- create_mysql comes from the snort tar ball - v105 of the DB schema really only affects Oracle users. Hence, forMySQL, there is nodifference between 104 and 105. The warning about the "database is
using
an older version.." message can be safely ignored. - In order to upgrade the mysql schema, run the SQL you indicated
below.
INSERT INTO schema (vseq, ctime) VALUES ('105', now()); DELETE FROM schema WHERE vseq = '104';cheers, RomanUpgraded to 1.8.6, when snorts starts it says: database: schema version = 104 database: The database is using an older version of the DB schema In the snort 1.8.3 distro there was a directory 'scripts' that had a mysql_install_db script that was used to initialize mysql databases
and
probably upgrade the db schema (I may be wrong about that). It is nolongerin 1.8.6 distro (btw, anyone knows why?) FAQ says: You are using an older database schema, and should update it by
running
thecreate scripts from the /contrib directory of the source tarball. Should I run ./create_mysql frim here? This the solution to change the vseq number but it looks like aworkaroundfor me, not a real thing: INSERT INTO schema (vseq, ctime) VALUES ('105', now()); DELETE FROM schema WHERE vseq = '104'; Pls advise on what should I do, I don't want to scre up productionmachinemy doing things I'm not really sure of. Thanks.--------------------------------------------- This message was sent using Voicenet WebMail. http://www.voicenet.com/webmail/--------------------------------------------- This message was sent using Voicenet WebMail. http://www.voicenet.com/webmail/
_______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users
Current thread:
- schema version 104 Hugo Ferr (May 30)
- <Possible follow-ups>
- Re: schema version 104 roman (May 31)
- Re: schema version 104 Hugo Ferr (May 31)
- Re: schema version 104 roman (May 31)
- Re: schema version 104 Hugo Ferr (May 31)