[RGSPAM] RE: [RGSPAM] RE: [RGSPAM] RE: [Snort-users] Snort Beta v2.6

Jason Brvenik jasonb at ...1935...
Tue Mar 21 06:16:10 EST 2006


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 at ...1935...] 
>Sent: Monday, March 20, 2006 9:10 PM
>To: Ron Jenkins
>Cc: snort-users at 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'/
>>





More information about the Snort-users mailing list