RE: Database Question

["Wirth, Jeff" <WirthJe () DNB com>]

> How do I convert these to dotted decimal ip addresses? 

IP addresses are store as integer values.  I would assume that PostgreSQL
has an "inet_ntoa" function. "select inet_ntoa(IPADDRESS);" should do the
trick.

- Jeff


-----Original Message-----
From: Dean Scott [mailto:ScottD () FamilyMeds com]
Sent: Wednesday, March 13, 2002 3:34 PM
To: snort-users () lists sourceforge net
Subject: [Snort-users] Database Question


I am sending Snort logs to a Postgresql database.  The output for the data
section is in hex but the source and destination ip's are always 10 digit
numbers.  How do I convert these to dotted decimal ip addresses?  Is there a
way for Snort to do this for me?

Dean

_______________________________________________
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

_______________________________________________
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