NetAlertX accessing pihole's db's from a separate rpi

[FoLkjF]

i have two rpi's one rpi-v4 with latest pihole running and one rpi-v5 running NetAlertX. both on same home LAN.

would a cron job entry utilizing scp or rsync from rpi-v4 pihole db's to a dir on rpi-v5 between the two rpi's suffice and config NetAlertX what dir to access those db's? or what other ways, if not? another post asked this back in 2023 "#273".

[jokob-sk]

Hi,

You could probably use the DHCPLSS plugin which supports multiple source files. But yes you would need to get them into the NAX instance.

[FoLkjF]

this is doable. i'll narrow down a time schedule. and i'll checkout that plugin you suggest. thank you.

[lacouelle]

Hi All

I jump in this discussion as I have a similar set up but with 3 RPi Zero 2 W , all on the same network(wlan0)
I amended the eth0 to wlan0 with "192.168.1.0/24 --interface=wlan0"

my current set up is :
Rpi_1 : Tailscale + Pihole_1 enabling DHCP server with range from 192.168.1.1 to 192.168.1.100 + unbound
Rpi_2 : Tailscale + Pihole_2 enabling DHCP server with range from 192.168.1.101 to 192.168.1.253 thus avoiding IP's overlapping.
Rpi_3 : Tailscale + just installed NetAlertx i discovered y'day.

Both DHCPLSS & PIHOLE plugins have been loaded.

As mentioned above, It's clear that I should copy / transfer the 2 dhcp.leases files to my RPI_3 running NetAlertX via Docker.
Ok, It makes sense, and I should find the way to write scripts to do this with a cron scheduler...I am a newbie on RPI and Linux, and It's never to late to learn (close to 60's :D)...

Q1 : For DHCP lease set up, as NetAlertX is running via Docker, should I copy/transfer the 2 DHCP files n a specific directory on the RPI_3 or somewhere on Docker ?

Q2 : For PiHole device Sync : I know that I can save and export SQL files ; SoI assume that I could do something similar to the DHCP leases, but in the PiHole Sync setting screen, It seems that it's not enable to add 2 or more SQL database , is it ?!
Any ideas, suggestions will be welcome ;).

Best

[jokob-sk]

Hi,

Please read these docs which should answer your questions:

https://jokob-sk.github.io/NetAlertX/PIHOLE_GUIDE/?h=pihol#settings
https://github.com/jokob-sk/NetAlertX/tree/main/front/plugins/dhcp_leases#overview

The PiHole plugin only supports one DB, but you can use the DHCPLSS plugin instead. Alternatively you can have multiple netalertx instances and use the sync plugin.

https://github.com/jokob-sk/NetAlertX/tree/main/front/plugins/sync

[lacouelle]

Thx
Got it !
I will look at tomorrow morning.
Thx

[jokob-sk]

Happy to answer followup questions :)