RE: Update schema

["East, Bill" <eastb () PFFCU org>]

Thanks for the tip. I wound up wiping the DB and re-running the create_mysql
script which did what I wanted, which was to fix the url references. But I
can modify the archive DB this way.

-- 
be - MOS



Isn't air travel wonderful?  Breakfast in London, dinner in New York,
luggage in Brazil.


> -----Original Message-----
> From: roman () danyliw com [mailto:roman () danyliw com]
> Sent: Friday, October 19, 2001 9:24 PM
> To: East, Bill
> Cc: snort-users () lists sourceforge net
> Subject: Re: [Snort-users] Update schema
>
>
> If you have a v103 database, the only steps you need to take 
> to upgrade to
> v104 are as follows:
>
> mysql> DELETE FROM schema WHERE vseq = 103;
> mysql> INSERT INTO schema (vseq, ctime) VALUES (104, now());
> mysql> ALTER TABLE reference MODIFY ref_tag VARCHAR(100) NOT NULL;
>
> Roman
>
> On Thu, 18 Oct 2001, East, Bill wrote:
>
> > I simply must be dim.
> >
> > Running snort 1.8.1, ACID v0.9.6b16. ACID shows schema 
> version 1.03. I
> > downloaded the latest and extracted the create_mysql 
> script. Entered mysql,
> > USEd the proper database, and SOURCEd the script. It ran, 
> and I can do a
> > SELECT * from schema to get
> >
> > +------+---------------------+
> > | vseq | ctime               |
> > +------+---------------------+
> > |  103 | 2001-09-20 14:18:21 |
> > |  104 | 2001-10-18 16:13:44 |
> >
> > But ACID stays with schema 103, even after killing and 
> restarting mysql and
> > snort. Was there magic that I needed to do prior to the 
> update? Do I need a
> > later version of snort? Am I missing something painfully 
> obvious? Are all
> > Vulcans as snippy as T'Pol? I give up.
>
>
>
> ---------------------------------------------
> This message was sent using Voicenet WebMail.
>       http://www.voicenet.com/webmail/

_______________________________________________
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