North American Network Operators Group

Date Prev | Date Next | Date Index | Thread Index | Author Index | Historical

Re: Where did freeipdb IP utility site go?

  • From: Jared Mauch
  • Date: Fri Jul 27 13:09:27 2007

On Fri, Jul 27, 2007 at 12:40:59PM -0400, Barry Shein wrote:
> 
> 
>  > 
>  > > Are there any "good" tools for IPv6 address management?
>  > 
> 
> Is there a "BCP" (convention, whatever) for storing IPv6 addresses
> into SQL databases? Particularly where you need to mix them with IPv4
> addresses.

	PostgreSQL supports this.  Check out the data types.

(yes, 8.2 is the latest, but google to the first hit is easier)

http://www.postgresql.org/docs/8.0/interactive/datatype-net-types.html#DATATYPE-INET

> I know postgresql has an ipv6 type but I was hoping for something more
> portable. The best I could come up with was packed decimal(39) and
> assume that if more than 32 bits are set it's IPv6 (ignoring the
> special case of all zeros etc.) The other would be to just use 4
> unsigned long ints similarly but it makes comparison and other ops
> clunky.

	um, lots of folks have written modules for almost every
language to do ip/subnet comparisons for both v4 and v6.  While
I can understand the desire to use locally derived code, etc..
it does make sense to not reinvent the wheel daily :)


OT:
	Speaking of which, someone know of something like the
multicast beacon software that works for unicast stuff that is "free"?

	I've wanted to make some udp-like probe matrix like this
and with all the folks that are asking about cogent, l3, etc.. outages
was thinking that a user community of this type of a test matrix could
be interesting :)  Think like the "internet health report" but with more
sites (possibly hundreds).

	- jared
	

-- 
Jared Mauch  | pgp key available via finger from [email protected]
clue++;      | http://puck.nether.net/~jared/  My statements are only mine.