Importing win dns&dhcp entries into pihole, possible?

Help Community Help
1

Expected Behaviour:

[can pihole import the exported dns & dhcp listing from the win2008 server? or a config file to paste into? or do i have to enter all dns & dhcp entries manually in pihole?

-operating system: DietPi v8.4.2
-Device model: RPi 4 Model B (armv7l)
-Pihole ver:
Pi-hole version is v5.10 (Latest: v5.10)
AdminLTE version is v5.12 (Latest: v5.12)
FTL version is v5.15 (Latest: v5.15)

win pdc: win2008
]

Actual Behaviour:

[haven't tried it yet]

1 Like
2

Hey !

I don't think pihole comes with an integrated way to do this (haven't seen any command nor API), but there are a few ways; from the top of my head :

  • Create new dnsmasq config files, either manually or by parsing your export and put it under /etc/dnsmasq.d
  • Use a tool like nsupdate or this perl script to dynamically create / update DNS records. Either loop through your items or prepare a well-formated file to import via either of those tools
  • Teleporter (Pihole's backup / restore tool) seems to allow DNS records and DHCP leases import, specifically, and not necessarily the whole thing. To have an idea of how it looks like, just export your whole configuration after having created dummy DNS records, and open the archive
3

Please provide an example of the files you want to import - contents, format, etc.

4

trying to upload 2 images of the data. but getting upload errors. i'll try something else.

edit: gee, finally(lol) saw the code/formatted text option. so 86 my image upload attempt.

5

here is small limited fake represented data from win2008 dns & dhcp exported lists, that if possible, i would like to import into pihole. i'm dropping domain and win systems as you know.
@melvinkitnick listed some good ideas i think.

[dns exported cvs data]

Name,Type,Data,Timestamp,,
(same as parent folder),Start of Authority (SOA),[25269], winDC1.home.com., administrator.home.com.,static
(same as parent folder),WINS Lookup,[192.168.1.100] ,static,,
(same as parent folder),Name Server (NS),winDC2.home.com.,static,,
(same as parent folder),Name Server (NS),winDC1.home.com.,static,,
(same as parent folder),Host (A),192.168.1.101,?2/?20/?2022 7:00:00 AM,,
(same as parent folder),Host (A),192.168.1.100,?2/?28/?2022 9:00:00 AM,,
_msdcs,,,,,
_sites,,,,,
_tcp,,,,,
_udp,,,,,
comp1,Host (A),192.168.1.21,,,static
comp2,Host (A),192.168.1.22,,,static
comp3,Host (A),192.168.1.23,,,
DomainDnsZones,,,,,
comp4,Host (A),192.168.1.24,,,static
comp5,Host (A),192.168.1.25,,,static
gw,Host (A),192.168.1.1,,,static
ForestDnsZones,,,,,
printer,Host (A),192.168.1.35,,,static
switch1,Host (A),192.168.1.11,,,static
switch2,Host (A),192.168.1.12,,,static
switch3,Host (A),192.168.1.13,,,static
winDC1,Host (A),192.168.1.100,,,static
winDC2,Host (A),192.168.1.101,,,static
rpi-pihole1,Host (A),192.168.1.201,,,static
rpi-pihole2,Host (A),192.168.1.202,,,static
rpi-pihole3,Host (A),192.168.1.203,,,static

[dhcp exported cvs data]

Client IP Address,Name,Lease Expiration,Type,Unique ID,Description,Network Access Protection,Probation Expiration,Filter Profile
192.168.1.21,comp1.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.22,comp2.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.23,comp3.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.24,comp4.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.25,comp5.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.1,gw.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.35,printer.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.11,switch1.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.12,switch2.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.13,switch3.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.100,winDC1.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.101,winDC2.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.201,rpi-pihole1.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.202,rpi-pihole2.home.com,Reservation (active),DHCP,,,Full Access,,
192.168.1.203,rpi-pihole3.home.com,Reservation (active),DHCP,,,Full Access,,
6

thanks for your reply and help!

gonna give this a try, looks doable.

7

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.