RE: Where did freeipdb IP utility site go?

> Are there any "good" tools for IPv6 address
management?

"There's so many bits they don't need managing"

brandon

 > 
 > > 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.

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.

-- 
        -Barry Shein

The World              | bzsTheWorld.com           | http://www.TheWorld.com
Purveyors to the Trade | Voice: 800-THE-WRLD        | Login:
Nationwide
Software Tool & Die    | Public Access Internet     |
SINCE 1989     *oo*

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/do
cs/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 jaredpuck.nether.net
clue++;      | http://puck.nether.net
/~jared/  My statements are only mine.