[Snort-devel] [ snort-Bugs-488742 ] snort-current spo_database.c's bug

noreply at ...12... noreply at ...12...
Sat Jan 12 18:39:07 EST 2002


Bugs item #488742, was opened at 2001-12-03 22:17
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=103357&aid=488742&group_id=3357

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Jed Pickel (jpickel)
Summary: snort-current spo_database.c's bug  

Initial Comment:
line 713: 
 snprintf(tmp2, MAX_QUERY_LENGTH, "'%s'", msg);
 line 742:
       snprintf(insert0, MAX_QUERY_LENGTH,
                  "INSERT INTO signature (%s) VALUES (%
s)",
                  tmp1, tmp2);

         Insert(insert0,data);

  If  msg is null,the var temp2 is '',mssql consider 
it as blank ,but oracle consider it as null,so when 
the program insert data into table 'signature'in 
oracle database ,an error will occur 
(thefield 'sig_name' in table'signature' can't be 
null).

----------------------------------------------------------------------

Comment By: Roman Danyliw (danyliw)
Date: 2002-01-12 11:26

Message:
Logged In: YES 
user_id=136911

This would be addressed better in the database schema, since
we need to support blank 'msg' rule options.

Apply the following DML against the snort database.  It 
will drop the NOT NULL requirement on the sig_name field in
the signature table.

ALTER TABLE signature DROP CONSTRAINT sig_name NOT NULL;

Roman

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=103357&aid=488742&group_id=3357




More information about the Snort-devel mailing list