Hello Christopher, if you have an API in front of the postgresql db then it won´t be too complicate to code.
I did that in the past and the code is there: https://github.com/inverse-inc/packetfence/compare/feature/rest_provisioner Regards Fabrice Le jeu. 27 janv. 2022 à 14:51, Chris Jordan via PacketFence-users < packetfence-users@lists.sourceforge.net> a écrit : > Hello, > > I am trying to figure out how to get PacketFence to query a postgresql > database to look for MAC addresses in a column to determine what vlan they > belong to. > > For example a user connects to wifi, packetfence goes to the database to > see if there is a mac address and if it does exist then it is approved on > the corporate vlan. If the mac address is not found in the database it will > set it to the guest vlan. > > This will help us determine what is corporate owned device and what is not > to prevent unauthorized access to our network. Has anybody done this before? > > Thanks, > > -- > [image: formlabslogo] <http://www.formlabs.com/> > > *Christopher Jordan* | Sr. Systems Administrator > 22 McGrath Hwy | Suite 206 | Somerville | MA 02143 > > www.formlabs.com > > <https://www.facebook.com/Formlabs/> <https://twitter.com/formlabs> > <https://youtube.com/formlabs> <https://instagram.com/formlabs> > <https://linkedin.com/company/formlabs> > www.christopherjordan.com > _______________________________________________ > PacketFence-users mailing list > PacketFence-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/packetfence-users >
_______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users