Snort mailing list archives
RE: MySQL function
From: "Jeff Dell" <jdell () activeworx com>
Date: Mon, 4 Aug 2003 14:22:00 -0400
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
Current thread:
- MySQL function Bryan Miller (Aug 04)
- RE: MySQL function Jeff Dell (Aug 04)
- <Possible follow-ups>
- FW: MySQL function Hutchinson, Andrew (Aug 04)
- MySQL function support (Aug 04)