Re: MySQL logs wrong IP - Addresses ( caution - NEWBIE ! )

["Roman Danyliw" <roman () danyliw com>]

> hi, folks !
> my sql drives me crazy.
> table "iphdr" contains
> - ip - addresses without dots : "176689530"
  
Yes, IP addresses are represented 32-bit unsigned integers.  The format is
documented here:
  
http://www.andrew.cmu.edu/~rdanyliw/snort/snortdb/snortdb_faq.html
  
> - ip - addresses that do not make any sense at all, no matter where you
> put           the dots : "3501791526"
  
> From the documentation, if you want to see a dotted-quad IP address, use
the inet_ntoa() function:
  
SELECT ip_src, inet_ntoa(ip_src) FROM iphdr;

cheers,
Roman


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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