Snort mailing list archives
RE: Snort -> Mysql formatting IP addresses
From: "Hutchinson, Andrew" <andrew.hutchinson () Vanderbilt Edu>
Date: Thu, 16 Oct 2003 15:20:10 -0500
In case the there any PostgreSQL people watching... Here's a stored procedure (aka function) that performs the inet_ntoa calculation: DECLARE t inet; BEGIN t = (($1>>24) & 255::int8) || '.' || (($1>>16) & 255::int8) || '.' || (($1>>8) & 255::int8) || '.' || ($1 & 255::int8); RETURN t; END; Andrew Hutchinson - Network Security Vanderbilt University Medical Center (615) 936-2856
-----Original Message----- From: Dusty Hall [mailto:halljer () auburn edu] Sent: Thursday, October 16, 2003 3:08 PM To: jake_roberts () byu edu; snort-users () lists sourceforge net; bnelson () rightnow com Subject: RE: [Snort-users] Snort -> Mysql formatting IP addresses These are the functions (if anyone cares): inet_ntoa inet_aton -Dusty"Nelson, Ben" <bnelson () rightnow com> 10/16/2003 1:16:16 PM >>>-----Original Message----- From: Jacob Roberts [mailto:jake_roberts () byu edu] Sent: Thursday, October 16, 2003 11:39 AM To: snort-users () lists sourceforge net Subject: RE: [Snort-users] Snort -> Mysql formatting IP addresses There is a function in MySQL that converts the valuesDoh!....I wish I would've known that before I wrote a python function to do it for me. --Ben ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net hosts over 70,000 Open Source Projects. See the people who have HELPED US provide better services: Click here: http://sourceforge.net/supporters.php _______________________________________________ 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 ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net hosts over 70,000 Open Source Projects. See the people who have HELPED US provide better services: Click here: http://sourceforge.net/supporters.php _______________________________________________ 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
------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net hosts over 70,000 Open Source Projects. See the people who have HELPED US provide better services: Click here: http://sourceforge.net/supporters.php _______________________________________________ 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
Current thread:
- RE: Snort -> Mysql formatting IP addresses Jacob Roberts (Oct 16)
- <Possible follow-ups>
- RE: Snort -> Mysql formatting IP addresses Nelson, Ben (Oct 16)
- Snort -> Mysql formatting IP addresses FWAdmin (Oct 16)
- RE: Snort -> Mysql formatting IP addresses Nelson, Ben (Oct 16)
- RE: Snort -> Mysql formatting IP addresses Dusty Hall (Oct 16)
- RE: Snort -> Mysql formatting IP addresses Hutchinson, Andrew (Oct 16)
- RE: Snort -> Mysql formatting IP addresses Steve Halligan (Oct 17)