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

Reply via email to