*** From dhcp-server -- To unsubscribe, see the end of this message. ***
Stephen Joyce wrote:
> Please forgive me if this is a FAQ, but has anyone automated the
> construction of dhcpd.conf from external data?
Yes, I do it for our laboratory subnet from an Excel spreadsheet using a Perl program
I wrote. It also
creates the DNS records for our name server, with the help of h2n.
> On our campus, we do not allow dynamic allocation and therefore statically
> assign all our departmental addresses based on MAC.
We use fixed addresses for most, and a range of 51 addresses for machines that haven't
been entered into
the spreadsheet yet.
> I'd like to build the dhcpd.conf from data in a mysql database (ideally)
> or a file (less ideal) based on defined group membership, with the option
> to over-ride global options for individual hosts if needed (the database
> would, of course, contain all the necessary info for each host).
Yes, a good idea. I'm thinking of changing from Excel to PostgreSQL, and using DBI.
> I'm envisioning a perl-script to do this, but I don't want to re-invent
> the wheel if someone has already worked on this. (If someone has, I would
> appreciated being pointed in the right direction).
>
> If no one has yet constructed such a beast, is there interest in my
> eventual solution? Implementing it shouldn't be too hard...
My Perl programs are quick and dirty, and were not designed to be general purpose, but
if you want them,
please ask.
--
Nick Urbanik, Dept. of Electrical & Communications Engineering
Hong Kong Institute of Vocational Education (Tsing Yi)
email: [EMAIL PROTECTED], [EMAIL PROTECTED]
Tel: (852) 2436 8660, (825) 2436 8674 Fax: (852) 2436 8643
------------------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://www.isc.org/dhcp-lists.html
If you are without web access, or if you are having trouble with the web page,
please send mail to [EMAIL PROTECTED] with the subject line of
'unsubscribe'.
Archives for this mailing list are available at:
http://www.webnology.com/list-archives/dhcp/dhcp-server
------------------------------------------------------------------------------
