Snort mailing list archives
Re: schema version 104
From: "Hugo Ferr" <snortgrp () hotmail com>
Date: Fri, 31 May 2002 10:44:04 -0400
Sorry 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, for
MySQL, there is no
difference 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 no
longer
in 1.8.6 distro (btw, anyone knows why?) FAQ says: You are using an older database schema, and should update it by running
the
create 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 a
workaround
for 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 production
machine
my doing things I'm not really sure of. Thanks.--------------------------------------------- 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)