Re: [PacketFence-users] radius, accounting, database issue

[Louis M. <lm...@in...>]

On Jul 29, 2015, at 5:14 , heupink <he...@gm...> wrote:

> Hi,
> 
>> 
> etc etc
> 
> But, in the gui, "reports", "Top 25" gives:
> Error! Can't fetch data from database for report nodebandwidth.
> 
> And in the gui, "reports", "per operating system" gives:
> Error! Can't fetch data from database for report osclassbandwidth.
> 
> Searching the list archives tells me that someone asked a similar 
> question a while ago, but never received a reply, alas. Hoping that 
> someone will reply this time...
> 
> This is on pf 3.5.1 on debian wheezy.

Hopefully that’s 5.3.1. 

Are there errors in the packetfence.log when you try to generate those reports? 

You could turn on query logging in MySQL and see what queries are running.
You could try to run those queries manually yourself and see what gets returned, and how long it takes.

If the tables get too large you could conceivably be seeing the results of a timeout where the query takes longer to run that the GUI is willing to wait.


Regards,
--
Louis Munro
lm...@in...  ::  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)