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'/
/database: mysql_error: Unknown column 'sig_gid' in 'field list'/
/SQL=INSERT INTO signature
(sig_name,sig_class_id,sig_priority,sig_rev,sig_sid,sig_gid) VALUES
('MISC MS Terminal server request',1,3,13,1448,1)/
/database: mysql_error: Unknown column 'sig_gid' in 'where clause'/
/database: Problem inserting a new signature 'MISC MS Terminal server
request'/
/database: mysql_error: Duplicate entry '0-1' for key 1/
/SQL=INSERT INTO sig_reference (sig_id, ref_seq, ref_id) VALUES (0, 1,
3)/
/database: mysql_error: Duplicate entry '0-2' for key 1/
/SQL=INSERT INTO sig_reference (sig_id, ref_seq, ref_id) VALUES (0, 2,
1284)/
/database: mysql_error: Duplicate entry '0-3' for key 1/
/SQL=INSERT INTO sig_reference (sig_id, ref_seq, ref_id) VALUES (0, 3,
1)/
/database: mysql_error: Duplicate entry '0-4' for key 1/
/SQL=INSERT INTO sig_reference (sig_id, ref_seq, ref_id) VALUES (0, 4,
2)/
/database: mysql_error: Unknown column 'sig_gid' in 'where clause'/
/database: mysql_error: Unknown column 'sig_gid' in 'field list'/
/SQL=INSERT INTO signature
(sig_name,sig_class_id,sig_priority,sig_rev,sig_sid,sig_gid) VALUES
('BLEEDING-EDGE POLICY MSN status change',10,1,2,2002192,1)/
/database: mysql_error: Unknown column 'sig_gid' in 'where clause'/
/database: Problem inserting a new signature 'BLEEDING-EDGE POLICY MSN
status change'/
/database: mysql_error: Unknown column 'sig_gid' in 'where clause'/
/database: mysql_error: Unknown column 'sig_gid' in 'field list'/
/SQL=INSERT INTO signature
(sig_name,sig_class_id,sig_priority,sig_rev,sig_sid,sig_gid) VALUES
('BLEEDING-EDGE POLICY MSN status change',10,1,2,2002192,1)/
/database: mysql_error: Unknown column 'sig_gid' in 'where clause'/
/database: Problem inserting a new signature 'BLEEDING-EDGE POLICY MSN
status change'/
/ /
Thanks...
-------------------------------------------------------
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_______________________________________________
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
