Re: schema version 104

[roman () danyliw com]

- 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,
Roman

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