Hello there, Did you run the schema upgrade from 12.1 to 13.0 ?
root@PF:/usr/local/pf# ls -ltr db/upgrade-12* -rw-r--r-- 1 pf pf 1569 Nov 13 00:24 db/upgrade-12.2-13.0.sql -rw-r--r-- 1 pf pf 2485 Nov 13 00:24 db/upgrade-12.1-12.2.sql -rw-r--r-- 1 pf pf 1710 Nov 13 00:24 db/upgrade-12.0-12.1.sql Use pfacct. /usr/local/pf/bin/pfcmd fixpermissions /usr/local/pf/bin/pfcmd pfconfig clear_backend systemctl restart packetfence-config /usr/local/pf/bin/pfcmd configreload hard /usr/local/pf/bin/pfcmd service pf restart Thanks, Ludovic Zammit Product Support Engineer Principal Lead 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 Nov 14, 2023, at 3:00 AM, rein--- via PacketFence-users > <packetfence-users@lists.sourceforge.net> wrote: > > > Hi, > > I've tried to upgrade from 12.1 to 13 for some time now, but never succeed. > First i got an error regarding some tenant-id. Figured out some part of the > upgrade scripts did not run /usr/local/pf/addons/upgrade/to-xxx, so now at > least the database starts. > Second: i could no longer log in into my switches for some reason, after > changing from cisco_2960 to ios_15.0 that got restored, whoohoow > > but unfortunately, MAC auth (MAB) was still failing on the switches. > > This one i cant seem to figure out. > > when checking the logs: > > for some reason radiusd-acct wont start, as the port 1813 is already in use > by a process called pfacct. > > which one should be the one to run? > > I tried with both, and had some form of success with pfacct. > > last but not least: node lookup fails in the DB due to a missing field, I'm > not really sure what's wrong here either: > > > Nov 14 01:44:09 packetfence httpd.aaa-docker-wrapper[1969]: httpd.aaa(10) > INFO: [mac:00:04:c4:05:31:97] handling radius autz request: from switch_ip => > (192.168.101.30), conn ection_type => Ethernet-NoEAP,switch_mac => > (54:4a:00:6e:63:a8), mac => [00:04:c4:05:31:97], port => 10140, username => > "0004c4053197" (pf::radius::authorize) > Nov 14 01:44:09 packetfence httpd.aaa-docker-wrapper[1969]: httpd.aaa(10) > ERROR: [mac:00:04:c4:05:31:97] Database query failed with non retryable > error: Unknown column 'node. bypass_acls' in 'field list' (errno: 1054) > [SELECT `node`.`mac` AS `mac`, `node`.`pid` AS `pid`, `node`.`category_id` AS > `category_id`, `node`.`detect_date` AS `detect_date`, `node`.`regdate` AS > `regdate`, `node`.`unregdate` AS `unregdate`, `node`.`lastskip` AS > `lastskip`, `node`.`time_balance` AS `time_balance`, > `node`.`bandwidth_balance` AS `ba ndwidth_balance`, `node`.`status` AS > `status`, `node`.`user_agent` AS `user_agent`, `node`.`computername` AS > `computername`, `node`.`notes` AS `notes`, `node`.`last_arp` AS ` last_arp`, > `node`.`last_dhcp` AS `last_dhcp`, `node`.`dhcp_fingerprint` AS > `dhcp_fingerprint`, `node`.`dhcp6_fingerprint` AS `dhcp6_fingerprint`, > `node`.`dhcp_vendor` AS `dhc p_vendor`, `node`.`dhcp6_enterprise` AS > `dhcp6_enterprise`, `node`.`device_type` AS `device_type`, > `node`.`device_class` AS `device_class`, `node`.`device_version` AS `device > _version`, `node`.`device_score` AS `device_score`, > `node`.`device_manufacturer` AS `device_manufacturer`, `node`.`bypass_vlan` > AS `bypass_vlan`, `node`.`voip` AS `voip`, `no de`.`autoreg` AS `autoreg`, > `node`.`sessionid` AS `sessionid`, `node`.`machine_account` AS > `machine_account`, `node`.`bypass_role_id` AS `bypass_role_id`, > `node`.`last_seen` AS `last_seen`, `node`.`bypass_acls` AS `bypass_acls`, > `nc`.`name` AS `category`, `nr`.`name` AS `bypass_role` FROM node LEFT OUTER > JOIN `node_category` AS `nc` ON ( `node`.` category_id` = `nc`.`category_id` > ) LEFT OUTER JOIN `node_category` AS `nr` ON ( `node`.`bypass_role_id` = > `nr`.`category_id` ) WHERE ( `node`.`mac` = ? )]{00:04:c4:05:31:97} > (pf::dal::db_execute) > Nov 14 01:44:09 packetfence httpd.aaa-docker-wrapper[1969]: httpd.aaa(10) > ERROR: [mac:00:04:c4:05:31:97] Database query failed with non retryable > error: Unknown column 'bypas s_acls' in 'field list' (errno: 1054) [INSERT > INTO `node` ( `autoreg`, `bandwidth_balance`, `bypass_acls`, > `bypass_role_id`, `bypass_vlan`, `category_id`, `computername`, `de > tect_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`, `pid`, `regdate`, `sessionid`, > `status`, `time_balance`, `unregdate`, `user_agent`, `vo ip`) VALUES ( ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ? ) ON DUPLICATE KEY UPDATE `autoreg` = ?, `bandwidth_balance` = ?, > `bypass_acls` = ?, `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` = > ?, `pid` = ?, `regdate` = ?, `sessionid` = ?, `status` = ?, `time_balance` = > ?, `unregdate` = ?, `user_agent` = ?, `voip` = ?]{no, NULL, NULL, NULL, NULL, > NULL, NULL, 2023-11-14 01:44:09, 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, > 0000-00-00 00:00:00, 00:04:c4:05:31:97, NULL, NULL, default, 0000-00-00 > 00:00:00, NULL, unreg, NULL, 0000-00-00 00:00:00, NULL, no, no, NULL, NULL, > NULL, NULL, NULL, NULL, 2023-11-14 01:44:09, 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, 0000-00-00 00:00:00, 00:04:c4:05:31:97, NULL, NULL, default, > 0000-00-00 00:00:00, NULL, unreg, NULL, 0000-00-00 00:00:00, NULL, no} > (pf::dal::db_execute) > Nov 14 01:44:09 packetfence httpd.aaa-docker-wrapper[1969]: httpd.aaa(10) > WARN: [mac:00:04:c4:05:31:97] (192.168.101.30) Sending REJECT since switch is > unsupported (pf::radiu s::_switchUnsupportedReply) > Nov 14 01:44:09 packetfence httpd.aaa-docker-wrapper[1969]: httpd.aaa(10) > ERROR: [mac:00:04:c4:05:31:97] Database query failed with non retryable > error: Unknown column 'bypas s_acls' in 'field list' (errno: 1054) [INSERT > INTO `node` ( `autoreg`, `bandwidth_balance`, `bypass_acls`, > `bypass_role_id`, `bypass_vlan`, `category_id`, `computername`, `de > tect_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`, `pid`, `regdate`, `sessionid`, > `status`, `time_balance`, `unregdate`, `user_agent`, `vo ip`) VALUES ( ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ? ) ON DUPLICATE KEY UPDATE `autoreg` = ?, `bandwidth_balance` = ?, > `bypass_acls` = ?, `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` = > ?, `pid` = ?, `regdate` = ?, `sessionid` = ?, `status` = ?, `time_balance` = > ?, `unregdate` = ?, `user_agent` = ?, `voip` = ?]{no, NULL, NULL, NULL, NULL, > NULL, NULL, 2023-11-14 01:44:09, NULL, NULL, NULL, NULL, NULL, NULL, NULL, > NULL, NULL, 0000-00-00 00:00:00, 0000 -00-00 00:00:00, 2023-11-14 01:44:09, > 0000-00-00 00:00:00, 00:04:c4:05:31:97, NULL, NULL, default, 0000-00-00 > 00:00:00, NULL, unreg, NULL, 0000-00-00 00:00:00, NULL, no, no, NULL, NULL, > NULL, NULL, NULL, NULL, 2023-11-14 01:44:09, NULL, NULL, NULL, NULL, NULL, > NULL, NULL, NULL, NULL, 0000-00-00 00:00:00, 0000-00-00 00:00:00, 2023-11-14 > 01:44:09, 0000-00-00 00:00:00, 00:04:c4:05:31:97, NULL, NULL, default, > 0000-00-00 00:00:00, NULL, unreg, NULL, 0000-00-00 00:00:00, NULL, no} > (pf::dal::db_execute) > Nov 14 01:44:09 packetfence httpd.aaa-docker-wrapper[1969]: httpd.aaa(10) > ERROR: [mac:00:04:c4:05:31:97] Cannot save 00:04:c4:05:31:97 error (500) > (pf::radius::authorize) > > > anyone who has some input? > > With kind regards > > Rein > _______________________________________________ > PacketFence-users mailing list > PacketFence-users@lists.sourceforge.net > https://urldefense.com/v3/__https://lists.sourceforge.net/lists/listinfo/packetfence-users__;!!GjvTz_vk!Rj_gD7Sc5heosbpH9IWkisoOjh3muNay5kJBmC-A3f34mTXo19mvfceZ4_Oowl_JsVeSd63jZByFY_qBjD_IYP021Ayyzb8a_cZeSw$ >
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users
