Re: Snort v2.6.0

["Jeff Dell" <jdell () activeworx com>]

ALTER TABLE signature ADD sig_gid INT UNSIGNED;

DELETE FROM `schema` WHERE vseq = '106';

INSERT INTO `schema` (vseq, ctime) VALUES ('107', now());

Cheers,

Jeff


  _____  

From: snort-users-bounces () lists sourceforge net
[mailto:snort-users-bounces () lists sourceforge net] On Behalf Of Ron Jenkins
Sent: Wednesday, June 28, 2006 2:43 PM
To: snort-users () lists sourceforge net
Subject: [Snort-users] Snort v2.6.0



Just updated to v2.6.0 and are seeing the below errors:

 

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 ('VIRUS
OUTBOUND bad file attachment',7,2,8,721,1)

 

That is required to extend the MySQL database to resolve this?

 

Thanks.

 

Ron Jenkins (SnortCP, MCNE, CNE6, MCP, CCNA, CCEA)
Senior Architect
Data Integrity, LLC
"We Integrate People with Solutions"
1724 Dallas Drive
Suite 11
Baton Rouge, La 70806
Office. 225.927.8030
Fax. 225.927.8033
Cell225.931.1632

Email. rjenkins () dibr net
Web. http://www.dibr.net

(Aanval Reseller and Technology Partner)

http://www.aanval.com/tour/dibr

 

Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&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