[98269] in North American Network Operators' Group
Re: Where did freeipdb IP utility site go?
daemon@ATHENA.MIT.EDU (Jared Mauch)
Fri Jul 27 13:05:30 2007
Date: Fri, 27 Jul 2007 13:04:38 -0400
From: Jared Mauch <jared@puck.nether.net>
To: Barry Shein <bzs@world.std.com>
Cc: nanog@merit.edu
In-Reply-To: <18090.8219.502032.960439@world.std.com>
Errors-To: owner-nanog@merit.edu
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 jared@puck.nether.net
clue++; | http://puck.nether.net/~jared/ My statements are only mine.