Help adding DHCPD-leases monitoring in Cacti

[RedFarmer]

Hi all!

I'm far from a Linux or Cacti expert but have succeeded installing the latest Cacti using slow-pace, step by step tactics

We've been using an old 0.8.7i installation but have now installed 1.2.26 as a completely new setup, so no migration from the old system has been done.

New setup:
Win10 Pro -> Virtual Box -> Ubuntu 22.04.4 LTS -> Cacti 1.2.26

I've added all our switches for traffic graphing without any issues, but i'm struggling to get DHCPD lease-graphing up and running.

I've exported our old Graph Template called DHCP Statistics (SNMP) from 0.8.7i and imported it to the new installation. I've also copied:

/var/www/cacti/resource/snmp_queries/dhcpd-snmp.xml

...to the same directory on the new installation. Everything else should already be working on the DHCP-server because of the old working Cacti (there's a dhcp-snmp.conf with all the pools that also includes a pointer to the leases-file (/var/lib/dhcp3/dhcpd.leases and so on).

But, even after importing the old template it doesn't appear in the list when i try to associate the template with the device. (the DHCP-server). However, i do see the imported DHCPD Statistics (SNMP) under Templates/Data Source and Templates/Graph.

I'm not sure what i should do next

[macan]

please export dhcp templates for graph,data template or data query and your dhcpd-snmp.xml and upload it here

[RedFarmer]

Thanks for swift responce!

Did i attach the correct files?

[RedFarmer]

Let me do that again...

[TheWitness]

You should have exported the Data Query. Export that instead and upload.

[RedFarmer]

The problem is solved, and you helped me probably without knowing it

When both of you asked for the Data Query template i noticed i had only exported the graph template (and you did to). Didn't notice the drop down at the top of the old Cacti where more templates could be exported.

After importing the rest, and more specifically the host template i could associate it with the DHCP and now all my lease graphs are working.

Thanks!

[TheWitness]

Yea, the Host/Device Template is the only way to go when you are dealing with Data Queries.