Re: [RGSPAM] RE: [RGSPAM] RE: [RGSPAM] RE: Snort Beta v2.6

[Jason Brvenik <jasonb () sourcefire com>]

mysql> ALTER TABLE signature ADD sig_gid INT UNSIGNED;

or mysql -u<username> -p<password> <dbname> -e "ALTER TABLE signature
ADD sig_gid INT UNSIGNED;"

Ron Jenkins wrote:

> How do you update the existing (v2.4.4) snort database to the one that
> version v2.6 supports?
>
> Thanks...
>
> -----Original Message-----
> From: Jason Brvenik [mailto:jasonb () sourcefire com] 
> Sent: Monday, March 20, 2006 9:10 PM
> To: Ron Jenkins
> Cc: snort-users () lists sourceforge net
> Subject: Re: [RGSPAM] RE: [RGSPAM] RE: [Snort-users] Snort Beta v2.6
>
> The updated schema. From the RELEASE.NOTES file
>
>    * Logging of Generator ID to MySQL database.  Updated database
>      schema to add this field.  Requires update to BASE.  See
>      http://sourceforge.net/projects/secureideas for the latest.
>
>
> Ron Jenkins wrote:
>
>  
>
> > I'm sorry to be a pain, but now I am getting the below MySQL errors
> > with v2.6.  Version 2.4.4 works fine.
> >
> >
> >
> > /database: mysql_error: Unknown column 'sig_gid' in 'where clause'/



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
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