Hello, Are you expecting to assign a role to the device based on rules in the connection profile? I'd start there since the log says no role was assigned. Without a role, I don't see how the device can be assigned to a vlan with autoregistration.
When upgrading to 9.3, were the accompanying MySQL schema updates applied? Towards the end a query fails, but it's not clear if that's because of the earlier max nodes per pid error or not. *Nicholas P. Pier* Network Architect CCNP R&S, PCNSE, VCIX6-DCV, VCIX6-NV, RHCE, CEHv10 On Mon, Mar 16, 2020 at 4:11 PM Wagner Liegio via PacketFence-users < [email protected]> wrote: > Good afternoon, I'm facing the same problem only in version 9.3. I have > done everything I can think of, reconfigured the domain, the connection > profile, checked the rules and functions. The error follows: No role > specified or found for pid ANA \ pereira (MAC d0: 94: 66: db: ee: 7d); > assumes maximum number of registered nodes is reached (pf :: node :: > is_max_reg_nodes_reached) > plpcktfpdin01 packetfence_httpd.aaa: httpd.aaa (9837) ERROR: [mac: d0: 94: > 66: db: ee: 7d] max nodes per pid met or exceeded - registration of d0: 94: > 66: db: ae: 7d to ANA \ pereira failed > (pf :: registration :: setup_node_for_registration) > plpcktfpdin01 packetfence_httpd.aaa: httpd.aaa (9837) ERROR: [mac: d0: > 94: 66: db: ee: 7d] auto-registration of node failed max nodes per pid met > or exceeded (pf :: radius :: authorize) > plpcktfpdin01 packetfence_httpd.aaa: httpd.aaa (9837) ERROR: [mac: d0: > 94: 66: db: ee: 7d] Database query failed with non retryable error: Cannot > add or update a child row: a foreign key constraint fails > (pf.node, CONSTRAINT 0_57 FOREIGN KEY (tenant_id, pid) REFERENCES person > (tenant_id, pid) ON DELETE CASCADE ON UPDATE CASCADE) (errno: 1452) [INSERT > INTO node > (autoreg, bandwidth_balance, bypass_role_id, bypass_vlan, category_id, > computername, detect_date, device_class, device_manufacturer, device_score, > device_type, > device_version, dhcp6_enterprise, dhcp6_fingerprint, dhcp_fingerprint, > dhcp_vendor, last_arp, last_dhcp, last_seen, lastskip, mac, > machine_account, notes, regdate, sessionid, status, tenant_id, > time_balance, void, user? ?,?,?,?,?,?,?,?,?,?,?,?,?,?, NOW > (),?,?,?,?,?,?,?,?,?, ?,?,?,?) ON DUPLICATE KEY UPDATE autoreg = ?, > Last_seen = NOW (), pid = ?, Status = ?, Tenant_id` =?] {Yes, NULL, NULL, > NULL, NULL, NULL, 2020 - 03-13 19:08:50, NULL, NULL, NULL, NULL, NULL, > NULL, NULL, NULL, NULL, > 0000-00-00 00:00:00, 0000-00-00 00:00:00, 0000-00-00 00:00:00, d0: 94: > 66: db: ae: 7d, NULL, NULL, ANA \ pereira, 0000-00-00 00:00:00, NULL, reg, > 1, NULL, 0000-00-00 00:00:00, NULL, no, yes, ANA \ pereira, reg, 1} > (pf :: dal :: db_execute) > > > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users >
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
