> On Jul 5, 2016, at 2:28 , Воробьёв Андрей <[email protected]> wrote:
>
> 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.
>
Hellon Andrei,
Try adding an index on the radacct table:
ALTER TABLE radacct ADD KEY `callingstationid` (`callingstationid`);
Let me know if it helps.
--
Louis Munro
[email protected] :: www.inverse.ca
+1.514.447.4918 x125 :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
------------------------------------------------------------------------------
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
