RE: MySQL function

["Jeff Dell" <jdell () activeworx com>]

sure.. there is an easy way to do this with mysql 3.23.xx or newer. the
function is called inet_ntoa() here is an example:
 
SELECT inet_ntoa(ip_src) FROM `iphdr` group by ip_src;
 
to convert from ip to int you can use the function inet_aton()
 
Enjoy!
 
Jeff

-----Original Message-----
From: snort-users-admin () lists sourceforge net
[mailto:snort-users-admin () lists sourceforge net] On Behalf Of Bryan
Miller
Sent: Monday, August 04, 2003 1:51 PM
To: snort-users () lists sourceforge net
Subject: [Snort-users] MySQL function


Anyone out there have a function or know of a way to convert IP
addresses from Acid (MySQL) into a string containing the IP address?  I
know PHP can do it but I need a way to call this from a shell script to
produce monthly reports.
 
Bryan