Hello All.
I am trying to upgrade my PF 6.0.2 to 6.1.1.
I have upgraded my server according to UPGRADE.asciidoc.
Everything is working fine with a exception.
I can see nodes and have huge CPU usage .
When I go to node pages I ses error.
I have done some instestigation and discovered next.
When I am tring to get list of nodes PF is trying to exexute next sql query:
SELECT `node`.`mac`, `node`.`pid`, `node`.`voip`, `node`.`bypass_vlan`,
`node`.`status`, `node`.`category_id`, `node`.`bypass_role_id`,
`node`.`user_agent`, `node`.`computername`, `node`.`last_arp`,
`node`.`last_dhcp`, `node`.`notes`, IF(lastskip = '0000-00-00 00:00:00', '',
lastskip) as lastskip, IF(detect_date = '0000-00-00 00:00:00', '', detect_date)
as detect_date, IF(regdate = '0000-00-00 00:00:00', '', regdate) as regdate,
IF(unregdate = '0000-00-00 00:00:00', '', unregdate) as unregdate,
IFNULL(node_category.name, '') as category,
IFNULL(node_category_bypass_role.name, '') as bypass_role, IFNULL(device_class,
' ') as dhcp_fingerprint, IF(r1.acctstarttime IS
NULL,'unknown',IF(r1.acctstoptime IS NULL, 'on', 'off')) as online,
`iplog`.`ip` as last_ip, `locationlog`.`switch` as switch_id,
`locationlog`.`switch_ip` as switch_ip_address, `locationlog`.`switch_mac` as
switch_mac FROM `node` LEFT JOIN `node_category` on
`node_category`.`category_id` = `node`.`category_id` LEFT JOIN `node_category`
as node_category_bypass_role on `node_category_bypass_role`.`category_id` =
`node`.`bypass_role_id` LEFT JOIN `iplog` on `iplog`.`ip` = ( SELECT `ip` FROM
`iplog` WHERE `mac` = `node`.`mac` ORDER BY `start_time` DESC LIMIT 1 ) LEFT
JOIN `locationlog` on `node`.`mac` = `locationlog`.`mac` AND
`locationlog`.`end_time` = '0000-00-00 00:00:00' LEFT JOIN `radacct` as r1 on
`node`.`mac` = `r1`.`callingstationid` LEFT JOIN `radacct` as r2 on
`node`.`mac` = `r2`.`callingstationid` AND ( `r1`.`acctstarttime` <
`r2`.`acctstarttime` OR ( `r1`.`acctstarttime` = `r2`.`acctstarttime` AND
`r1`.`radacctid` < `r2`.`radacctid` ) ) WHERE `r2`.`radacctid` IS NULL ORDER
BY `node`.`mac` ASC LIMIT 0 , 26;
But system never gets respod back from mysql server.
Andrey Vorobyev
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
