Managing IP range allocations
-
Does anyone have any recommendations for software to manage IP block allocation?
General situation: We have various projects for clients worldwide, and we need to start allocating non-overlapping parts of the 10/8 range (and probably parts of the other RFC1918 ranges) to each project, both existing (where it's been ad-hoc) and going forward (hence the need for a tool.) In addition, parts of the 10/8 cannot be allocated due to 3rd party networks we use which tend to be common amongst projects.
I'm after a tool that will manage existing ranges, and allow further addition of further ranges that don't clash with existing ones.
The only suggestion I've had thus far from the company sysadmins is Excel. I was hoping for something less... basic.
-
http://racktables.org has IP address management built in ... but I don't know whether it's sufficient for your case.
-
@flop said:
but I don't know whether it's sufficient for your case.
After a quick 5 minute play with it, it's probably more than I need.
Still open for any other suggestions from others however.
-
What's wrong with Excel? KISS.
-
@blakeyrat said:
What's wrong with Excel? KISS.
Surely one can imagine the benefits of a program that knows what an IP address is?
-
@dhromed said:
@blakeyrat said:
What's wrong with Excel? KISS.
Surely one can imagine the benefits of a program that knows what an IP address is?So spent the 15 seconds teaching Excel with an IP address is, what's the issue?
-
@blakeyrat said:
@dhromed said:
Or a few hours beating MSSQL and C# into a serviceable utility.@blakeyrat said:
What's wrong with Excel? KISS.
Surely one can imagine the benefits of a program that knows what an IP address is?So spent the 15 seconds teaching Excel with an IP address is, what's the issue?
Hell, buy me a 1-year Audible Platinum subscription and I'll totally write it for you.
-
@blakeyrat said:
What's wrong with Excel? KISS.
KISS stands for 'keep it simple, stupid,' not 'keep it stupid, simple.' Excel is totally unsuited for the purpose of managing IP range allocation across projects. (As is Calc before you go off on one of your OS penis size contests.)
Seriously blakey, fuck off contributing to threads asking a serious question if all your contribution is either going to be a troll answer or an ill-thought reply that thinks that something supplied with windows (with or without a premium) can solve.
Did I mention fuck off answering threads about stuff which you clearly know nothing about? Like creating websites that depend on people not using ad-blockers?
-
@PJH said:
(As is Calc before you go off on one of your OS penis size contests.)
Wha?
@PJH said:
Like creating websites that depend on people not using ad-blockers?
Double-wha? I frequently complain about people putting words into my mouth, but this is ridiculous. You've invented an entire personality for me that has absolutely nothing to do with my actual opinions or talents. Infuriating.
Look, if you don't want my advice, fine. Take weeks to build some cobbled-together piece of shit IP manager when you could do the same task in 10 minutes using Excel. No sweat off my brow.
-
@blakeyrat said:
when you could do the same task in 10 minutes using Excel.
You are either- trying to troll too hard,
- lack reading comprehension, or
- have the memory retention comparable to that which goldfish are sometimes accused of having.
Which parts of the following were too difficult for you to understand?: @PJH said:The only suggestion I've had thus far from the company sysadmins is Excel. I was hoping for something less... basic.
@PJH said:Excel is totally unsuited for the purpose of managing IP range allocation across projects
Let me reiterate - if you think Excel is the perfect tool for what I require, then you clearly have no idea about what's involved with large scale IP pool allocation, and why Excel is not even a reasonable tool for divvying up the 10/8 range of addresses (let alone the other two RFC1918 address ranges.) @blakeyrat said:Look, if you don't want my advice, fine.
I'd welcome any sensible advice from someone who knows what they're talking about. Sadly your advice is not sensible, and you don't know what you're talking about.
-
Forgive my ignorance, but why can't you just use a DHCP server?
-
@Reynoldsjt said:
Forgive my ignorance, but why can't you just use a DHCP server?
DHCP servers are being used - but the DHCP server has to allocate addresses from pools of IP addresses. Dishing out these pools is the administrative task I'm asking about.
For example Project Foo in Canada may require up to 1,000 addresses, so we'd give that project (say) 10.120.43.0/21.
Project Bar, in Norway, on the other hand, may require up to 10,000 addresses, so we'd give that project (say) 10.43.0.0/18, or both 10.43.0.0/19 and 10.44.0.0/19, depending on where the gaps are.
How the project managers choose to dish out the IP's (what you're asking about) in those ranges for their particular projects (DHCP, 'static DHCP' or simply using static addresses) is none of our (department's) concern.
People working on Project Foo may never talk to those working on Project Bar, so there needs to be some central repository that manages the pools of addresses being handed out. Certainly the computers on the two projects themselves will not be talking to the computers on the other project.
-
@PJH said:
lack reading comprehension, or
The person who thinks I'm a huge fan of Calc, and would recommend it over Excel, says I lack reading comprehension! That's classic.
@PJH said:
Let me reiterate - if you think Excel is the perfect tool for what I require, then you clearly have no idea about what's involved with large scale IP pool allocation, and why Excel is not even a reasonable tool for divvying up the 10/8 range of addresses (let alone the other two RFC1918 address ranges.)
Maybe you should tell me why it'a not suitable, instead of being an asshole?
I never said I thought Excel was "the perfect tool" (Mr. Reading Comprehension). If you need something that Excel doesn't do, maybe you should tell us what that thing is?
@PJH said:
Sadly your advice is not sensible,
It's the same advice your sysadmins gave you. And you haven't actually told us why it's not suitable.
Look, it's obvious that you're extremely angry at some entity that loves Calc, does something with ad-sponsored? websites?? (that one confused me), and thinks Excel is "the perfect tool" for managing IP addresses. I really wish you'd figure out who that entity is and yell at them instead of me.
-
IP allocation is something that doesn't really need to be changed that often, you have 16 million addresses on a 10/8 - no need to parsimoniuous with them.
-
@zipfruder said:
IP allocation is something that doesn't really need to be changed that often
But it's something that has to be done for each new project that comes along, which is frequent.@zipfruder said:you have 16 million addresses on a 10/8 - no need to parsimoniuous with them.
Indeed. But what we don't want is for all the projects to be using 10.1.1.0/24 because they aren't talking to each other, to be trampling on the (say) 10.0.0.0/21 network that will be used for client/server tunnels that will break their clients' connectivity, or any of the 10/8 subnets that the mobile carriers, in various countries, use that could likewise potentially break connectivity.
-
@flop said:
http://racktables.org
Looks like we'll be using this for the moment.
-
Yes, I know - a necro.
@PJH said in Managing IP range allocations:
Looks like we'll be using this for the moment.
And an update, 5 years later, for those coming here from https://what.thedailywtf.com/post/921033
Racktables is still being used, and it was perfectly suitable for what I needed it for.
-
@PJH said in Managing IP range allocations:
Yes, I know - a necro.
Your post was on topic and added additional useful information. Nothing shameful about that.
-
@ben_lubar
I would recommend deleting it ... just to keep in the spirit of things
-
@PJH have you thought about office 365? I hear they have excel in the cloud now.
-
@bb36e said in Managing IP range allocations:
@PJH have you thought about office 365? I hear they have excel in the cloud now.
Ah - I may need more than 365 allocations soon; it might not be scalable...
mysql> select count(*) from IPv4Network; +----------+ | count(*) | +----------+ | 230 | +----------+ 1 row in set (0.02 sec) mysql>
-
@PJH Thanks for necroing this. I have been looking for something along these lines.
-
@PJH said in Managing IP range allocations:
select count(*) from IPv4Network;
You didn't anonymize your table names! lol doxxed
-
@Polygeekery said in Managing IP range allocations:
I have been looking for something along these lines.
why not use Excel?
-
@Jaloopa said in Managing IP range allocations:
why not use Excel?
I here with Excel 2016 on Windows 10 you can even do it in the Cloud!
-
@Luhmann said in Managing IP range allocations:
do it in the Cloud!
Is that a dirty euphemism the cool kids are using now?
-
typical thing to say for someone who still does it in the server room
-
-
@Polygeekery is your signature your business motto?
-
@Jaloopa No. My business motto is "Pay up or I will wreck your shit". I borrowed it from the EU.
-
@Polygeekery
Next thing after the Cloud is often Rain. Or maybe Storm.
The Storm. Did your company already joined in the Storm?