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://lists.sourceforge.net/lists/listinfo/packetfence-users
