RE: database IP attribute logging format

[Jamil Farshchi <jfarshch () hq nasa gov>]

Hello all,

Thanks to all of your comments and suggestions, they really helped me get 
on the right track. I have finally found the exact answer to the issue and 
some of you had requested info if I found a solution so here it is... and 
its really simple.

Mysql actually has a function that will convert the decimal representation 
of the hex value into an ip address. The function is inet_ntoa()

So to solve my previous example:

mysql> select distinct inet_ntoa(ip_src) from iphdr;

-----------------
|ip_src         |
-----------------
|128.183.235.153|
-----------------

I hope that helps...

Thanks,
-jamil
----------------------------------------------------------------------------------------------------
Jamil D. Farshchi
Computer Specialist, Inspections and Assessments
NASA Office of Inspector General
Washington, DC  20546
Phone: (202) 358-1897 


_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
http://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users