RE: snort and ODBC

[Jonathan_Hays () tax state ny us]

No worries. After beating my brain against this ODBC/MSSQL solution for a 
week and a half I gave up and am happily ensconced in a Linux/MySQL 
solution. At this point, wild horses wouldn't drag me back to a Microsoft 
SQL database.

Thanks for the ressponse,

Jonathan Hays
NYSDTF Network Security




"McCash, John" <John.McCash () andrew com> 
05/27/2005 10:31 AM

To
<Jonathan_Hays () tax state ny us>, "Chris Reid" 
<chris.reid () codecraftconsultants com>, <snort-users () lists sourceforge net>
cc

Subject
RE: snort and ODBC






Jonathan,
            My really bad? Your email came just before I left for the SANS 
conference, and what with all of the preparation, recovery, and our many 
current (understaffed) initiatives, I?m still digging out. The short 
answer is no. The code is out there, and the guy who wrote the original 
patch says it?s an easy fix. In fact, at one point, the developer (Hi 
Chris!) had put together a preliminary official patch. Unfortunately it 
didn?t work. I had mediated email between the two, but Chris has been busy 
with other things, and I haven?t heard from him since December of 04.
 
Chris,
            Any hope here? Any at all? Please?? Pretty Please?? I?ve been 
really really patient?
                        John McCash
 

From: Jonathan_Hays () tax state ny us [mailto:Jonathan_Hays () tax state ny us] 

Sent: Monday, March 28, 2005 11:11 AM
To: McCash, John
Subject: snort and ODBC
 

Hi John, 

I saw your post on Neohapsis and since I'm going through a similar 
experience (Snort currently working with MySQL, boss wants MS SQL) I'm 
wondering whether this got fixed. I'm trying to connect under Linux 
running Snort 2.3.2 but get the same error reported by Paul (see below). 

Thanks, 

Jonathan Hays
NYSDTF Network Security


= = = = = 
 
LOCATION: Neohapsis / Archives / Snort Discuss / Message Index / Message 
#0165   
  
RE: [Snort-users] Snort 2.2.0, MS-SQL Server 2000, ODBC 

From: McCash, John (John.McCashandrew.com) 
Date: Thu Sep 09 2004 - 11:57:35 CDT 

Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] 

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


Hi Paul, 
        Ahh! A subject near and dear to my heart! This is currently 
being worked on, I just believe it's not being treated as a priority. 
There was a patch posted to one of the lists last November for 
snort-2.0.2, to make it work with unixodbc and freetds (which you're 
going to need), however it can't be applied to the current version. 
Through various cajoling, prodding, and outright begging, I got the 
current database output plugin developer Chris Reid (Hi Chris! Are you 
out there? See there's more interest in this than just me!) to work on 
including it. Unfortunately, his first cut at it didn't work, and then 
he promptly had a second child (actually I suppose it was his wife). 
That was back in April. Since then, he's been busy with other things, 
and seems to be having Linux install issues to boot. I believe his 
development platform of choice is one of the BSDs. I've sent his first 
cut at a patched plugin to the guy who originally wrote the patch, and 
he sent back a list of things he needs to do to make it work (in July), 
which I forwarded to Chris. I got a note from him 8/10 that indicates 
that he's been really busy, but hopes to get back to working on this 
Real-Soon-Now(tm). 
                And now you know - the rest of the story... 
                        John 


-----Original Message----- 
From: snort-users-adminlists.sourceforge.net 
[mailto:snort-users-adminlists.sourceforge.net] On Behalf Of Paul 
Martin 
Sent: Wednesday, September 08, 2004 12:54 PM 
To: Snort-userslists.sourceforge.net 
Subject: [Snort-users] Snort 2.2.0, MS-SQL Server 2000, ODBC 


I've installed Snort/Apache/RH/MySQL according to Patrick Harper's HOWTO 


on the Snort page, and everything's been working just fine. 
Unfortunately, now the PTBs want to migrate our databases to MSSQL as 
opposed to MySQL. I understand that Snort does not support MSSQL 
natively under linux, and as such, I need to use the ODBC option. I've 
recompiled Snort with ODBC support, with no problem. I compiled and 
installed the ODBC interface from www.unixodbc.org, which make'd and 
installed just fine. However, now I need to configure it so that the 
ODBC will communicate with the MSSQL server. 


The instructions say that it is very similar to the Data Sources: ODBC 
under windows. The only problem is that I am running this Snort server 
sans WM. No GUI. So I have to configure this beast command-line. Or 
do I? All I know is that whenever I run "snort -c 
/etc/snort/snort.conf", I get: 


ERROR: database: ODBC unable to connect. 
Fatal Error, Quitting.. 


Any advice? This is driving me nuts. 


-- 
Paul Martin 
Network Technician 
Hilton Grand Vacations Co. 
(407) 393-3034 
pmartinhgvc.com 




------------------------------------------------------- 
This SF.Net email is sponsored by BEA Weblogic Workshop 
FREE Java Enterprise J2EE developer tools! 
Get your free copy of BEA WebLogic Workshop 8.1 today. 
http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click 
_______________________________________________ 
Snort-users mailing list 
Snort-userslists.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 


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

This message is for the designated recipient only and may 
contain privileged, proprietary, or otherwise private information. 
If you have received it in error, please notify the sender 
immediately and delete the original. Any unauthorized use of 
this email is prohibited. 
------------------------------------------------------------------------------------------------ 

[mf2] 



------------------------------------------------------- 
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 
Project Admins to receive an Apple iPod Mini FREE for your judgement on 
who ports your project to Linux PPC the best. Sponsored by IBM. 
Deadline: Sept. 13. Go here: http://sf.net/ppc_contest.php 
_______________________________________________ 
Snort-users mailing list 
Snort-userslists.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 



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


Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] 
  
 
  
Portions of this site are copyright 1998-2003, Neohapsis, Inc. Questions, 
comments or feedback, send E-mail to webmaster neohapsis.com   

------------------------------------------------------------------------------------------------
This message is for the designated recipient only and may
contain privileged, proprietary, or otherwise private information. 
If you have received it in error, please notify the sender
immediately and delete the original. Any unauthorized use of
this email is prohibited.
------------------------------------------------------------------------------------------------
[mf2]