RE: Snort -> Mysql formatting IP addresses

["Hutchinson, Andrew" <andrew.hutchinson () Vanderbilt Edu>]

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 values
>
> Doh!....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