Hello Chris, How often the Mac address change status ? How they change status / VLAN ?
You could export the Mac addresses from postgresql and import them in PF. As is, we don’t do external call during the authentication process because it will create issue if the external service fast enough. I think it will be better to sync the data set. Thanks, Ludovic Zammit Product Support Engineer Principal Cell: +1.613.670.8432 Akamai Technologies - Inverse 145 Broadway Cambridge, MA 02142 Connect with Us: <https://community.akamai.com/> <http://blogs.akamai.com/> <https://twitter.com/akamai> <http://www.facebook.com/AkamaiTechnologies> <http://www.linkedin.com/company/akamai-technologies> <http://www.youtube.com/user/akamaitechnologies?feature=results_main> > On Jan 27, 2022, at 2:07 PM, Chris Jordan via PacketFence-users > <packetfence-users@lists.sourceforge.net> wrote: > > 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, > > -- > > <https://urldefense.com/v3/__http://www.formlabs.com/__;!!GjvTz_vk!DidLQccce8I57_4wEvu7CIhL4MsbHE4yMbdapumw2CsLYgo95BqeJ0Eiom5Mpa-1$> > > Christopher Jordan | Sr. Systems Administrator > <> <>22 McGrath Hwy | Suite 206 | Somerville | MA 02143 <> > www.formlabs.com > <https://urldefense.com/v3/__http://www.formlabs.com/__;!!GjvTz_vk!DidLQccce8I57_4wEvu7CIhL4MsbHE4yMbdapumw2CsLYgo95BqeJ0Eiom5Mpa-1$> > > > <https://urldefense.com/v3/__https://www.facebook.com/Formlabs/__;!!GjvTz_vk!DidLQccce8I57_4wEvu7CIhL4MsbHE4yMbdapumw2CsLYgo95BqeJ0Eiou33xRq0$> > > <https://urldefense.com/v3/__https://twitter.com/formlabs__;!!GjvTz_vk!DidLQccce8I57_4wEvu7CIhL4MsbHE4yMbdapumw2CsLYgo95BqeJ0EiovGGc_XN$> > > <https://urldefense.com/v3/__https://youtube.com/formlabs__;!!GjvTz_vk!DidLQccce8I57_4wEvu7CIhL4MsbHE4yMbdapumw2CsLYgo95BqeJ0Eion5PR0VL$> > > <https://urldefense.com/v3/__https://instagram.com/formlabs__;!!GjvTz_vk!DidLQccce8I57_4wEvu7CIhL4MsbHE4yMbdapumw2CsLYgo95BqeJ0EiokyGJ-L-$> > > <https://urldefense.com/v3/__https://linkedin.com/company/formlabs__;!!GjvTz_vk!DidLQccce8I57_4wEvu7CIhL4MsbHE4yMbdapumw2CsLYgo95BqeJ0EioucmlsPh$> > www.christopherjordan.com > <https://urldefense.com/v3/__http://www.christopherjordan.com__;!!GjvTz_vk!DidLQccce8I57_4wEvu7CIhL4MsbHE4yMbdapumw2CsLYgo95BqeJ0EiohCHPRCd$> > _______________________________________________ > PacketFence-users mailing list > PacketFence-users@lists.sourceforge.net > https://urldefense.com/v3/__https://lists.sourceforge.net/lists/listinfo/packetfence-users__;!!GjvTz_vk!DidLQccce8I57_4wEvu7CIhL4MsbHE4yMbdapumw2CsLYgo95BqeJ0EiogQ13Z2q$ >
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users
