RE: Where did freeipdb IP utility site go?
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 | [EMAIL PROTECTED] | http://www.TheWorld.com Purveyors to the Trade | Voice: 800-THE-WRLD| Login: Nationwide Software Tool Die| Public Access Internet | SINCE 1989 *oo*
Re: Where did freeipdb IP utility site go?
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.
Re: Where did freeipdb IP utility site go?
On Fri, Jul 27, 2007 at 12:40:59PM -0400, Barry Shein wrote: I know postgresql has an ipv6 type but I was hoping for something more portable. I am a PostgreSQL weenie, I admit, but if you can at all use it, I strongly suggest you use the inet and cidr datatypes in PostgreSQL for this. Alternatives often give up the data rigour that you get from a datatype. Portability is often a target that forces you to give up all the nice features that you got when you chose your RDBMS. I suppose in other systems, you could put a trigger on a varchar() or whatever field that would validate the address on the way in. That's what I'd do if I had to give up the datatype. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 jabber: [EMAIL PROTECTED] +1 416 646 3304 x4110
RE: Where did freeipdb IP utility site go?
Are there any good tools for IPv6 address management? --- Thanks, - Joseph W. Breu, CCNA phone : +1.319.268.5228 Senior Network Administratorfax : +1.319.266.8158 Cedar Falls Utilities cell : +1.319.493.1686 support: +1.319.268.5221 web: www.cfu.net
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
Re: Where did freeipdb IP utility site go?
Incredibly enough, I contacted the maintainer about this a while ago. Here is the cut paste: Looks like we forgot to renew the domain registration. I was leaning towards the idea of moving it to something like sourceforge, but I wanted to clean up some things first. The page is available at: http://home.globalcrossing.net/~freeipdb/ -monte On Thu, Feb 01, 2007 at 03:36:52PM -0700, Randal Kohutek wrote: FreeIPdb - It seems like freeipdb.org is now owned by a domain squatter or something similar. Do you guys still have the code running around somewhere? I found some of it on archive.org, and would like to mirror it or something, as I like the product and work at a datacenter that can do that kind of thing. Please let me know! ## On 7/25/07, Brian Raaen [EMAIL PROTECTED] wrote: I was trying to investigate some the ip management tools and followed the link www.freeipdb.org and was more than a little upset with what I found. This domain name apparently has been taken by a porn site that is wanting to auction it off. does anyone know if the project died or if it changed domain names. I have removed the reference to it in the wiki page, but there are other references to the site on the NANOG site. I am not sure who will need to remove the links, but they no longer point to an ip management tool. If the utility still exist I would be intersted in finding it, as I saw not able to dig it up on a quick Google search. -- Brian Raaen Network Engineer [EMAIL PROTECTED]
Re: Where did freeipdb IP utility site go?
Dear Brian, I was trying to investigate some the ip management tools and followed the link www.freeipdb.org and was more than a little upset with what I found. This domain name apparently has been taken by a porn site that is wanting to auction it off. does anyone know if the project died or if it changed domain names. I have removed the reference to it in the wiki page, but there are other references to the site on the NANOG site. I am not sure who will need to remove the links, but they no longer point to an ip management tool. If the utility still exist I would be intersted in finding it, as I saw not able to dig it up on a quick Google search. also quick google search: http://www.rickyninja.net/ could also be interesting: http://www.brownkid.net/NorthStar bye, Ingo
RE: Where did freeipdb IP utility site go?
Don't know about freeipdb, but we use IPPlan: http://iptrack.sourceforge.net/ -Scott -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Raaen Sent: Wednesday, July 25, 2007 8:13 AM To: nanog@merit.edu Subject: Where did freeipdb IP utility site go? I was trying to investigate some the ip management tools and followed the link www.freeipdb.org and was more than a little upset with what I found. This domain name apparently has been taken by a porn site that is wanting to auction it off. does anyone know if the project died or if it changed domain names. I have removed the reference to it in the wiki page, but there are other references to the site on the NANOG site. I am not sure who will need to remove the links, but they no longer point to an ip management tool. If the utility still exist I would be intersted in finding it, as I saw not able to dig it up on a quick Google search. -- Brian Raaen Network Engineer [EMAIL PROTECTED]