Re: [Snort-users] Snort v2.6.0

permalink · #1 (**permalink**) 06-28-2006

This is a multi-part message in MIME format.

--===============0592861025==
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_033A_01C69ACC.E8F2CCF0"

This is a multi-part message in MIME format.

------=_NextPart_000_033A_01C69ACC.E8F2CCF0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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_si d,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

------=_NextPart_000_033A_01C69ACC.E8F2CCF0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word" xmlns:st1 =3D=20
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2912" name=3DGENERATOR><o:SmartTagType =
name=3D"City"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"place"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"Street"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"address"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"stockticker"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"phone"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype>
<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in =
1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US vLink=3Dpurple link=3Dblue>
<DIV dir=3Dltr align=3Dleft>
ALTER TABLE signature ADD sig_gid INT UNSIGNED;
DELETE FROM `schema` WHERE vseq =3D '106';
INSERT INTO `schema` (vseq, ctime) VALUES ('107', now());
Cheers,
Jeff</DIV> 
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid; MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
From:=20
snort-users-bounces@lists.sourceforge.net=20
[mailto:snort-users-bounces@lists.sourceforge.net] On Behalf Of =
Ron=20
Jenkins Sent: Wednesday, June 28, 2006 2:43 PM To: =

snort-users@lists.sourceforge.net Subject: [Snort-users] =
Snort=20
v2.6.0 </DIV>
<DIV></DIV>
<DIV class=3DSection1>
<SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Just updated to v2.6.0 =
and are=20
seeing the below errors:<o:p></o:p>
<SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p>
<SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: =
Arial">database:=20
mysql_error: Unknown column 'sig_gid' in 'where=20
clause'<o:p></o:p>
<SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: =
Arial">database:=20
mysql_error: Unknown column 'sig_gid' in 'field=20
list'<o:p></o:p>
<SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: =
Arial">SQL=3DINSERT=20
INTO signature =
(sig_name,sig_class_id,sig_priority,sig_rev,sig_si d,sig_gid)=20
VALUES ('VIRUS OUTBOUND bad file=20
attachment',7,2,8,721,1)<o:p></o:p>
<SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p>
<SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">That is required to =
extend the=20
MySQL database to resolve this?<o:p></o:p>
<SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p>
<SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">Thanks…<o:p></o:p>
<SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p>
<SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">Ron =
Jenkins=20
(SnortCP, MCNE, <st1:stockticker w:st=3D"on">CNE</st1:stockticker>6, =
MCP, CCNA,=20
CCEA) Senior Architect <SPAN=20
style=3D"COLOR: blue; FONT-FAMILY: Arial">Data Integrity, =
LLC<FONT=20
face=3DArial color=3Dblack size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"> "We =
Integrate=20
People with Solutions" <st1:Street w:st=3D"on"><st1:address =
w:st=3D"on">1724=20
Dallas Drive</st1:address></st1:Street> <st1:address =
w:st=3D"on"><st1:Street=20
w:st=3D"on">Suite</st1:Street> 11</st1:address> <st1:place=20
w:st=3D"on"><st1:City w:st=3D"on">Baton Rouge</st1:City></st1:place>, =
La=20
70806 Office. <st1:phone w:st=3D"on" o:ls=3D"trans"=20
phonenumber=3D"$6927$$$">225.927.8030</st1:phone> Fax. <st1:phone =
w:st=3D"on"=20
o:ls=3D"trans"=20
=
phonenumber=3D"$6927$$$">225.927.8033</st1:phone> Cell225.931.1632</SP=
AN><o:p></o:p>
<SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">Email.=20
rjenkins@dibr.net Web. <A=20
=
href=3D"http://www.dibr.net">http://www.dibr.net</A><o:p></o:p></F=
ONT>
<SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">(Aanval =
Reseller and=20
Technology Partner)<o:p></o:p>
<SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><A=20
=
href=3D"http://www.aanval.com/tour/dibr">http://www.aanval.com/tour/dibr<=
/A><FONT=20
face=3DArial color=3Dblack size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: =
Arial"><o:p></o:p>
<SPAN=20
style=3D"FONT-SIZE: =
12pt"><o:p> </o:p></DIV></BLOCKQUOTE></BODY></HTML=
>

------=_NextPart_000_033A_01C69ACC.E8F2CCF0--

--===============0592861025==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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=...057&dat=121642

--===============0592861025==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Snort-users mailing list
Snort-users@lists.sourceforge.net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/...fo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.p...st=snort-users
--===============0592861025==--

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode