[BBLISA] MySQL feeding DHCP & DNS?

[Bob Keyes]

Hello all,
We're going to be fielding a large number of mesh sensor nodes (see
http://www.citysense.net). We want to control the chaos while it is still
nascent. Administration has a MySQL database containing information on
where nodes are and what they are doing, their IP addresses and so forth.
Administration requires that this information be up to date. Right now, I
am updating this database by hand. I am going to have to move to a DHCP
server soon, so my idea is to have the central repository be in MySQL, and
that the DHCP server queries it. The local, authoritative DNS server would
also query the MySQL server, though it would cache responses.

The only DHCP solution I have found to this is MyDHCPGen, which can
generate dhcpd.conf files from MySQL. I'd prefer some dhcp software that
goes directly to MySQL, and does not have a dhcpd.conf file that
constantly needs to be synchronized with SQL. Does anyone know of any
DHCP server that does this?

Regards,
Bob