How to Add bulk of Mac Address with IP address into DHCP server.



  • i am new in this forum , my apologies if this question has already been asked before.
    i wan to Check "Deny unknown Clients" in DHCP server setting.
    want to add 100s of Mac addresses in this list below to allow the access to DHCP server.
    is there any to add all the Mac address Using .CVS file?



  • Not directly, as I understand it. Although if you examine the /conf/config.xml file, you'll see that static entries are set up in the <dhcpd>section of the config file. You could write a short script which could take your CSV file and convert this into a text file with the corresponding entries formatted as XML, then just cut and paste these directly into the config.xml file.

    If you set up a test static entry and then examine the /conf/config.xml file you'll see how the format looks. (See below)

    <staticmap><mac>88:67:9a:1f:43:e8</mac>
                                    <ipaddr>172.16.16.242</ipaddr>
                                    <hostname>static1</hostname></staticmap></dhcpd>



  • thank you so much for your reply,
    i am almost done with this. please tell what does <netbootfile>means?</netbootfile>



  • I believe netbootfile refers to the entry for the file the device you're entering for the static entry to boot from across the network. This is left blank in my cases, so the entry for <netbootfile>is just left there as a placeholder. From what I can gather, it is required for each entry, even if the device doesn't require the information. Though I'm not a developer so I can't speak with authority on that.</netbootfile>



  • ok i have done it. thank you once again.

    For others convenience i have used online converter to convert .CSV file to .XML .
    i don't know rather it is allowed to share the link here or not. everybody can google it.



  • Dear,
    I have conveted and copied it to config.xml file.
    Now do i need to refresh pfsense or something to update the arp table?
    If yes then how?

    Waiting for your kind reaponse .
    Thanx



  • Assuming you've entered all the data correclty, just restore the file to the system (Diagnostics/Backup+Restore).

    Make sure you take a backup of your running config first before you restore the file you amended!**



  • @hny1:

    ok i have done it. thank you once again.

    For others convenience i have used online converter to convert .CSV file to .XML .
    i don't know rather it is allowed to share the link here or not. everybody can google it.

    How did you do your csv file to be converted as xml online?  would you post by inbox the url where you convert it?

    This because i'm doing an excel file using columns as titles, and lines as values, but i think i'm doing wrong.  :-[

    would you help, please?

    Regards




Log in to reply