Together with our jrwhois.p5 RWhois server, this allows our clients to easily track their IP assignments internally and to customers; as well as publish utilization data to their ISPs or to RIRs such as the ARIN. This eliminates the need to send SWIP templates to the ARIN for every customer assignment.
Utilization efficiency data can be easily generated by using the summary command, and data may be exported to Excel or CSV file formats. Clients can easily determine how much free address space they have, what size the free blocks are, and if they qualify for additional ISP or RIR allocations.
These tools are designed to ease provisioning and keep your allocation data organized in such a manner that interacting with the ARIN is a breeze.
jcidr.p5 requires a configuration file called /etc/jsw.cf or $HOME/.jsw.cf. This allows it to access the appropriate SQL database.
Usage: jcidr.p5 <client name> <operation> [arguments ...]
-
jcidr.p5 ex show custid custid
- show all re-allocations and re-assignments to a specified custid
- show one or more prefixes
- show records by next-hop
- find free spaces of a desired subnet length
- add a new ISP or RIR allocation record
- delete an existing ISP or RIR allocation record. The name must be specified.
- add a new re-allocation or re-assignment record
- update an existing re-allocation or re-assignment record
- delete an existing re-allocation or re-assignment record
- display a summary of available and utilized ISP and RIR address space
- import address utilization data from INC formatted tab-seperated-value file
- export the database
prefix is an IP address and subnet length in the format 192.168.0.0/16.
nexthop identifies the point at which traffic for a particular subnet egresses the client network. This may be a real IP address or a value selected for an unnumbered circuit or layer 2 aggregation port.
length is the size of a CIDR subnet in bits. A single IP address existing as its own subnet has a subnet length of 32. A subnet of 64 addresses has a subnet length of 26. The familar "class c"-sized subnet, encompassing 256 IP addresses, has a length of 24.
isp space is IP address space allocated to our clients by their upstream transit providers. This is non-portable address space.
When supplied as an argument to the find free operation, the tool will search only ISP allocated address space.
rir space is IP address space allocated to our clients by a national or regional internet registry such as the ARIN, RIPE, APNIC, LACNIC, KRNIC, JPNIC, etc.
When supplied as an argument to the find free operation, the tool will search only RIR allocated address space.
name is a character string, without whitespace, identifying a particular prefix. If no name is supplied when creating new allocation or assignment records, the format CUSTBLK-192-168-0-0-24 is utilized.
description is a text string describing the prefix to which a record refers. It may include whitespace.
exact indicates that the tool should not look for shorter subnets if a given prefix is not found
orlonger indicates that the tool should display longer prefixes than the prefix specified on the command line
jsw@odyssey:~ 469% jcidr.p5 ex show custid 42
192.168.111.120/30 ASGN custid 42
EXAG-172
FastEthernet0/16.c1r5ag1.lsvlky01
192.168.116.192/27 ASGN custid 42 next-hop 192.168.111.122
CUSTBLK-192-168-116-192-27
192.168.116.224/27 ASGN custid 42
CUSTBLK-192-168-116-224-27
reserved until 2004-09-15 for customer growth
jsw@odyssey:~ 470% jcidr.p5 ex show 192.168.96.0/26 orlonger
192.168.96.0 /30 ASGN custid -4 next-hop 192.168.97.34
EXINT-DNS-1
authoratitive and resolving nameserver #1
192.168.96.8 /30 ASGN custid -2
EXBB-2
ATM OC12 between core1.lsvlky01 and core2.lsvlky01
192.168.96.12 /30 ASGN custid -2
EXBB-3
vlan between core1.lsvlky01 and core2.lsvlky01
192.168.96.16 /30 ASGN custid -3
EXDIST-1
vlan between core1.lsvlky01 and c1r3ag1.lsvlky01
192.168.96.20 /30 ASGN custid -3
EXDIST-2
vlan between c1r3ag1.lsvlky01 and c1r4ag1.lsvlky01
192.168.96.24 /30 ASGN custid -3
EXDIST-3
vlan between core2.lsvlky01 and c1r4ag1.lsvlky01
192.168.96.32 /27 ASGN custid -2
EXBB-1
router loopbacks at lsvlky01
jsw@odyssey:~ 471% jcidr.p5 ex show nexthop 192.168.111.122
192.168.116.192/27 ASGN custid 42 next-hop 192.168.111.122
CUSTBLK-192-168-116-192-27
jsw@odyssey:~ 472% jcidr.p5 ex find free /24 in rir
192.168.117.0 /24 FREE custid 0
FREE-BLOCK
192.168.118.0 /23 FREE custid 0
FREE-BLOCK
192.168.120.0 /21 FREE custid 0
FREE-BLOCK
jsw@odyssey:~ 473% jcidr.p5 ex rira 172.16.0.0/19 name ARIN-EX-2 \
> descr ARIN /19 allocation with second /19 reserved
172.16.0.0 /19 RIRA custid -1
ARIN-EX-2
ARIN /19 allocation with second /19 reserved
jsw@odyssey:~ 474% jcidr.p5 ex ispd 169.254.0.0/24 name PSINET-EX-4
169.254.0.0 /24 ISPA custid -1
***DELETED***
PSInet allocation
jsw@odyssey:~ 475% jcidr.p5 ex asgn 192.168.117.0/24 custid 314 \
> nexthop 192.168.110.50 descr web hosting farm
192.168.117.0 /24 ASGN custid 314
CUSTBLK-192-168-117-0-24
web hosting farm
jsw@odyssey: 476% jcidr.p5 ex update 192.168.117.0/24 nexthop 192.168.110.54
192.168.117.0 /24 ASGN custid 314
CUSTBLK-192-168-117-0-24
web hosting farm
jsw@odyssey:~ 477% jcidr.p5 ex dele 192.168.116.224/27
192.168.116.224/27 ASGN custid 42
***DELETED***
reserved until 2004-09-15 for customer growth
jsw@odyssey:~ 478% jcidr.p5 ex summ
Total ASGN ALLC FREE
Addresses allocated from RIR: 8192 0 0 3720
Addresses allocated from ISP: 0 0 0 0
/19s: 0 0 0
/20s: 0 0 0
/21s: 0 0 1
/22s: 0 0 0
/23s: 0 0 1
/24s: 1 3 2
/25s: 5 0 2
/26s: 9 0 2
/27s: 24 0 3
/28s: 33 0 5
/29s: 94 0 3
/30s: 115 0 9
Total prefixes : 312
Allocation efficiency : 54.59%
jsw@odyssey:~ 479% jcidr.p5 ex export csv > ex.csv jsw@odyssey:~ 480% ls -l ex.csv -rw-r--r-- 1 jsw jsw 66013 2004-11-14 05:32 ex.csv
jsw@odyssey:~ 481% cat /etc/jsw.cf
{
dsn => "DBI:mysql:ex;sql.inconcepts.biz",
user => "example",
pass => "12345",
}
