Hello.
Cli command
/usr/local/pf/bin/pfcmd node view all
Outputs nothing, except table header.
In usr/local/pf/logs/packetfence.log appears error:
Feb 4 12:08:41 core-s-pf01 packetfence: ERROR pfcmd.pl(12612): Database query
failed with non retryable error: Unknown column 'locationlog' in 'on clause'
(errno: 1054) [SELECT `node`.`mac`, `node`.`pid`, `node`.`voip`,
`node`.`bypass_vlan`, `node`.`status`, IF(ISNULL(nc.name), '', nc.name) as
category, IF(ISNULL(nr.name), '', nr.name) as bypass_role, IF(node.detect_date
= '0000-00-00 00:00:00', '', node.detect_date) as detect_date, IF(node.regdate
= '0000-00-00 00:00:00', '', node.regdate) as regdate, IF(node.unregdate =
'0000-00-00 00:00:00', '', node.unregdate) as unregdate, IF(node.lastskip =
'0000-00-00 00:00:00', '', node.lastskip) as lastskip, `node`.`user_agent`,
`node`.`computername`, `device_class` AS `dhcp_fingerprint`, `node`.`last_arp`,
`node`.`last_dhcp`, `node`.`last_seen`, `locationlog`.`switch` AS
`last_switch`, `locationlog`.`port` AS `last_port`, `locationlog`.`vlan` AS
`last_vlan`, IF(ISNULL(locationlog.connection_type), '',
locationlog.connection_type) as last_connection_type,
`locationlog`.`dot1x_username` AS `last_dot1x_username`, `locationlog`.`ssid`
AS `last_ssid`, `locationlog`.`stripped_user_name` AS `stripped_user_name`,
`locationlog`.`realm` AS `realm`, `locationlog`.`switch_mac` AS
`last_switch_mac`, `ip4log`.`ip` AS `last_ip`, COUNT(DISTINCT
security_event.id) as nbopensecurity_events, `node`.`notes` FROM node LEFT
OUTER JOIN `node_category` AS `nr` ON ( `nr`.`category_id` =
`node`.`bypass_role_id` ) LEFT OUTER JOIN `node_category` AS `nc` ON (
`node`.`category_id` = `nc`.`category_id` ) LEFT OUTER JOIN security_event ON (
( `security_event`.`status` = ? AND `node`.`mac` = `security_event`.`mac` ) )
LEFT OUTER JOIN locationlog ON ( ( `locationlog` = ? AND `node`.`mac` =
`locationlog`.`mac` ) ) LEFT OUTER JOIN ip4log ON ( ( ( `ip4log` = ? OR
`ip4log` > NOW() ) AND `node`.`mac` = `ip4log`.`mac` ) ) WHERE (
`node`.`tenant_id` = ? ) GROUP BY `node`.`mac`]{open, 0000-00-00 00:00:00,
0000-00-00 00:00:00, 1} (pf::dal::db_execute)
If I add mac
/usr/local/pf/bin/pfcmd node view 14:9d:09:17:f2:1e
Cli Outputs proper result.
How to fix it?
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
