Hi Ludovic, It changes since it comes from a software called ManageEngine Desktop Central which manages our inventory. I can do a mass export and import it but with multiple nics (wifi/wired) and inventory changes not sure how well that would work
Is there anything for Desktop Central or Postgresql API? On Thu, Jan 27, 2022 at 3:23 PM Zammit, Ludovic <[email protected]> wrote: > 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 < > [email protected]> 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, > > -- > [image: formlabslogo] > <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 > [email protected] > > https://urldefense.com/v3/__https://lists.sourceforge.net/lists/listinfo/packetfence-users__;!!GjvTz_vk!DidLQccce8I57_4wEvu7CIhL4MsbHE4yMbdapumw2CsLYgo95BqeJ0EiogQ13Z2q$ > > > -- [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 [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
