Page MenuHomeDevCentral
Create Task
Maniphest T1868

NetBox to .db
Open, WishlistPublic
Actions

Description

Create a database from NetBox entries, especially IP > server interface tenant

Revisions and Commits

rDARKDBNETBOX Netbox Darkbot database
D3258rDARKDBNETBOXd71379b7142d Export Netbox IPAM information for darkbot

Related Objects

Event Timeline

dereckson triaged this task as Wishlist priority.May 14 2023, 08:32
dereckson created this task.
dereckson added a comment.EditedMay 15 2023, 17:11

Views of addresses for a prefix shows relevant information we can extract: https://netbox.nasqueron.org/ipam/prefixes/3/ip-addresses/

I've noted on https://agora.nasqueron.org/Operations_grimoire/NetBox#Integration_with_IRC the following example:

17:13:59 < Dereckson> 172.27.27.6
17:14:00 < Odderon> (Dereckson): 172.27.27.6/28 docker-001.nasqueron.org / Decommissioned address for docker-001.nasqueron.org / Drake [deprecated]

With the server and interface it would give:

17:17:16 < Dereckson> 172.27.27.6
17:17:16 < Odderon> Dereckson: well, 172.27.27.6/28 docker-001.nasqueron.org / docker-002 ens224 / Decommissioned address for docker-001.nasqueron.org / Drake [deprecated]
dereckson added a comment.Jun 13 2023, 21:32

Proof of concept:

P341 NetBox database for Odderon
12001:470:1f13:9e1:0:c0ff:ee:8 2001:470:1f13:9e1:0:c0ff:ee:8/48
2172.27.27.1 172.27.27.1/28 / router-001.nasqueron.drake
3172.27.27.4 172.27.27.4/28 / dwellers.nasqueron.drake
42001:470:1f13:9e1:0:c0ff:ee:9 2001:470:1f13:9e1:0:c0ff:ee:9/48
52001:470:1f13:9e1:0:c0ff:ee:a 2001:470:1f13:9e1:0:c0ff:ee:a/48
62001:470:1f13:9e1:0:c0ff:ee:b 2001:470:1f13:9e1:0:c0ff:ee:b/48
72001:470:1f13:9e1:0:c0ff:ee:c 2001:470:1f13:9e1:0:c0ff:ee:c/48
82001:470:1f13:9e1:0:c0ff:ee:d 2001:470:1f13:9e1:0:c0ff:ee:d/48
92001:470:1f13:9e1:0:c0ff:ee:f 2001:470:1f13:9e1:0:c0ff:ee:f/48
10172.27.27.15 172.27.27.15/28 / db-b.nasqueron.drake / VIP for db-B MySQL cluster
1151.255.124.8 51.255.124.8/30 / router-001.nasqueron.org / IPFO in ORG-SS791-RIPE
12172.27.27.6 172.27.27.6/28 / docker-001.nasqueron.org / Decommissioned address for docker-001.nasqueron.org [deprecated]
1310.92.16.78 10.92.16.78/26
14163.172.49.16 163.172.49.16/24 / ysul-core.nasqueron.org / IP assigned to the server
1551.255.124.11 51.255.124.11/30 / dwellers.nasqueron.org / IPFO in ORG-SS791-RIPE
16188.165.200.229 188.165.200.229/24 / cloudhugger.nasqueron.org
17163.172.49.1 163.172.49.1/24 / 163-172-49-1.rev.poneytelecom.eu / Gateway for Scaleway machine in DC2 [reserved]
182001:470:1f13:9e1::1 2001:470:1f13:9e1::1/48 / For Ysul
192001:470:1f13:9e1::2 2001:470:1f13:9e1::2/48 / For Ysul
20172.27.27.28 172.27.27.28/28 / cloudhugger.nasqueron.drake
212001:470:1f13:9e1:0:cac:7e:1 2001:470:1f13:9e1:0:cac:7e:1/48 / Cool address for Ysul
222001:470:1f13:9e1:0:c0ff:ee:2 2001:470:1f13:9e1:0:c0ff:ee:2/48
232001:470:1f13:9e1:0:c0ff:ee:3 2001:470:1f13:9e1:0:c0ff:ee:3/48
24172.27.27.5 172.27.27.5/28 / docker-002.nasqueron.drake
252001:470:1f13:9e1:0:c0ff:ee:4 2001:470:1f13:9e1:0:c0ff:ee:4/48
262001:470:1f13:9e1:0:c0ff:ee:5 2001:470:1f13:9e1:0:c0ff:ee:5/48
272001:470:1f13:9e1:0:c0ff:ee:6 2001:470:1f13:9e1:0:c0ff:ee:6/48
2851.210.99.113 ns3173530.ip-51-210-99.eu
292001:470:1f13:9e1:0:c0ff:ee:e 2001:470:1f13:9e1:0:c0ff:ee:e/48
3051.210.99.254 51.210.99.254/24 / Gateway for OVH machines at GRA (not under our control) [reserved]
3191.121.86.254 91.121.86.254/24 / rbx-23-m0.fr.eu / Gateway for OVH machines at RBX (not under our control) [reserved]
322001:41d0:303:d971::6a7e 2001:41d0:303:d971::6a7e/64 / transit.router-001.nasqueron.org / IPv6 outgoing connectivity for machines using router-001
33172.27.27.3 172.27.27.3/28 / Reserved for mail server [reserved]
3451.159.18.59 51.159.18.59/24 / windriver.nasqueron.org
35172.27.27.7 172.27.27.7/28 / complector.nasqueron.drake
36172.27.27.8 172.27.27.8/28 / db-a-001.nasqueron.drake
37172.27.27.2 172.27.27.2/28 / Reserved for DNS server [reserved]
382001:41d0:303:d971::517e:c0de 2001:41d0:303:d971::517e:c0de/64 / www-alkane.nasqueron.org
3951.255.124.10 51.255.124.10/30 / web-001.nasqueron.org / IPFO in ORG-SS791-RIPE
4051.255.124.9 51.255.124.9/30 / docker-002.nasqueron.org / IPFO in ORG-SS791-RIPE
4110.92.16.65 10.92.16.65/26 / Gateway for 10.92.16.64/26 [reserved]
422001:bc8:6005:5:aa1e:84ff:fef3:5d9c Native IPv6 - SLAAC for WindRiver [deprecated]
432001:470:1f13:9ab:100:0:517e:c0de 2001:470:1f13:9ab:100:0:517e:c0de/80 / web-001.nasqueron.org [reserved]
44172.27.27.33 172.27.27.33/28 / ysul.nasqueron.drake
45172.27.27.35 172.27.27.35/28 / windriver.nasqueron.drake
46172.27.27.252 172.27.27.252/28 / Tunnel from router-001 to Ysul
47172.27.27.253 172.27.27.253/28 / Tunnel from router-001 to CloudHugger
48172.27.27.254 172.27.27.254/28 / Tunnel from router-001 to WindRiver
49212.83.187.132 ysul.nasqueron.org / Canonical address for Ysul. IPFO.
502001:bc8:2e84:700::da7a:7001 2001:bc8:2e84:700::da7a:7001/56 / windriver.nasqueron.org
51172.27.27.9 172.27.27.9/28 / db-b-001.nasqueron.drake / db-B-001
52188.165.200.254 188.165.200.254/24 / vss-gw-6k.fr.eu / Gateway for OVH machines at GRA (not under our control)
532001:41d0:2:91e5:: 2001:41d0:2:91e5::/56
542001:41d0:303:d9ff:ff:ff:ff:ff 2001:41d0:303:d9ff:ff:ff:ff:ff/64 / Gateway IPv6 for 2001:41d0:303:d971::/64 (hyper-001) [reserved]
552001:470:1f12:9e1::1 2001:470:1f12:9e1::1/48 / tunnel255107.tunnel.tserv10.par1.ipv6.he.net. / IPv6 tunnel for Ysul - HE side
562001:470:1f12:9e1::2 2001:470:1f12:9e1::2/48 / tunnel255107-pt.tunnel.tserv10.par1.ipv6.he.net / IPv6 tunnel for Ysul - Ysul side
572001:470:1f13:9e1::15 2001:470:1f13:9e1::15/48 / For Ysul
582001:470:1f13:9e1:0:c0ff:ee:7 2001:470:1f13:9e1:0:c0ff:ee:7/48 / viperserv.nasqueron.org / ViperServ canonical IP
59172.27.27.10 172.27.27.10/28 / web-001.nasqueron.drake / web-001
60fd27:155a:100e::1 fd27:155a:100e::1/64 / router-001.nasqueron.drake [reserved]
61172.27.27.14 172.27.27.14/28 / Reserved for temporary VM work [reserved]
622001:470:1f13:9e1::16 2001:470:1f13:9e1::16/48 / For Ysul
632001:470:1f13:9e1:0:c0ff:ee:1 2001:470:1f13:9e1:0:c0ff:ee:1/48 / ysul.nasqueron.org
642001:470:1f13:9e1::3 2001:470:1f13:9e1::3/48 / For Ysul
652001:470:1f13:9e1::4 2001:470:1f13:9e1::4/48 / For Ysul
662001:470:1f13:9e1::5 2001:470:1f13:9e1::5/48 / For Ysul
672001:470:1f13:9e1::6 2001:470:1f13:9e1::6/48 / For Ysul
682001:470:1f13:9e1::7 2001:470:1f13:9e1::7/48 / For Ysul
692001:470:1f13:9e1::8 2001:470:1f13:9e1::8/48 / For Ysul
702001:470:1f13:9e1::9 2001:470:1f13:9e1::9/48 / For Ysul
712001:470:1f13:9e1::a 2001:470:1f13:9e1::a/48 / For Ysul
722001:470:1f13:9e1::b 2001:470:1f13:9e1::b/48 / For Ysul
732001:470:1f13:9e1::c 2001:470:1f13:9e1::c/48 / For Ysul
742001:470:1f13:9e1::d 2001:470:1f13:9e1::d/48 / For Ysul
752001:470:1f13:9e1::e 2001:470:1f13:9e1::e/48 / For Ysul
762001:470:1f13:9e1::f 2001:470:1f13:9e1::f/48 / For Ysul
772001:470:1f13:9e1::10 2001:470:1f13:9e1::10/48 / For Ysul
782001:470:1f13:9e1::11 2001:470:1f13:9e1::11/48 / For Ysul
792001:470:1f13:9e1::12 2001:470:1f13:9e1::12/48 / For Ysul
802001:470:1f13:9e1::13 2001:470:1f13:9e1::13/48 / For Ysul
812001:470:1f13:9e1::14 2001:470:1f13:9e1::14/48 / For Ysul
822001:470:1f13:9e1::17 2001:470:1f13:9e1::17/48 / For Ysul
832001:470:1f13:9e1::18 2001:470:1f13:9e1::18/48 / For Ysul
842001:470:1f13:9e1::19 2001:470:1f13:9e1::19/48
852001:470:1f12:30b::1 2001:470:1f12:30b::1/64
862001:470:1f12:30b::2 2001:470:1f12:30b::2/64 / HE tunnel endpoint
872001:470:1f13:30b:ca5:cade:fab:1e 2001:470:1f13:30b:ca5:cade:fab:1e/64 / dwellers.nasqueron.org / Canonical address for Dwellers
882001:470:1f13:365::50f7:ba11 2001:470:1f13:365::50f7:ba11/64 / equatower.nasqueron.org. / Canonical address for Equatower (legacy Docker engine)
89router-001.nasqueron.drake 172.27.27.1 / fd27:155a:100e::1 [reserved]
90dwellers.nasqueron.drake 172.27.27.4
91db-b.nasqueron.drake 172.27.27.15
92router-001.nasqueron.org 51.255.124.8
93docker-001.nasqueron.org 172.27.27.6 [deprecated]
94ysul-core.nasqueron.org 163.172.49.16
95dwellers.nasqueron.org 51.255.124.11 / 2001:470:1f13:30b:ca5:cade:fab:1e
96cloudhugger.nasqueron.org 188.165.200.229
97163-172-49-1.rev.poneytelecom.eu 163.172.49.1 [reserved]
98cloudhugger.nasqueron.drake 172.27.27.28
99docker-002.nasqueron.drake 172.27.27.5
100ns3173530.ip-51-210-99.eu 51.210.99.113
101rbx-23-m0.fr.eu 91.121.86.254 [reserved]
102transit.router-001.nasqueron.org 2001:41d0:303:d971::6a7e
103windriver.nasqueron.org 51.159.18.59 / 2001:bc8:2e84:700::da7a:7001
104complector.nasqueron.drake 172.27.27.7
105db-a-001.nasqueron.drake 172.27.27.8
106www-alkane.nasqueron.org 2001:41d0:303:d971::517e:c0de
107web-001.nasqueron.org 51.255.124.10 / 2001:470:1f13:9ab:100:0:517e:c0de [reserved]
108docker-002.nasqueron.org 51.255.124.9
109ysul.nasqueron.drake 172.27.27.33
110windriver.nasqueron.drake 172.27.27.35
111ysul.nasqueron.org 212.83.187.132 / 2001:470:1f13:9e1:0:c0ff:ee:1
112db-b-001.nasqueron.drake 172.27.27.9
113vss-gw-6k.fr.eu 188.165.200.254
114tunnel255107.tunnel.tserv10.par1.ipv6.he.net. 2001:470:1f12:9e1::1
115tunnel255107-pt.tunnel.tserv10.par1.ipv6.he.net 2001:470:1f12:9e1::2
116viperserv.nasqueron.org 2001:470:1f13:9e1:0:c0ff:ee:7
117web-001.nasqueron.drake 172.27.27.10
118equatower.nasqueron.org 2001:470:1f13:365::50f7:ba11

dereckson claimed this task.Jan 6 2024, 18:03
dereckson added a commit: rDARKDBNETBOXd71379b7142d: Export Netbox IPAM information for darkbot.
dereckson added a revision: D3258: Export Netbox IPAM information for darkbot.
dereckson removed dereckson as the assignee of this task.Mon, Mar 23, 09:23

Unassigning this task to make it available for others.

As I'm not currently working actively on this issue, reset the assignee.

Contributions opportunity. If you’re interested, go ahead and assign yourself. I’m available to share context, review early approaches, or pair if helpful—just tag me.

Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator