Hi Louis, list, Yes, I meant 5.3.1, and those errors appear in the web gui, and no results are displayed. Those two reports/accounting menu items just give an error in red.
There are no errors in packetfence.log, but there are in httpd.admin.log for top 25 bandwidth: > Aug 03 10:35:20 httpd.admin(4058) WARN: database query failed with: BIGINT > value is out of range in '(`pf`.`radacct_log`.`acctinputoctets` + > `pf`.`radacct_log`.`acctoutputoctets`)' (errno: 1690), will try again > (pf::db::db_query_execute) > Aug 03 10:35:20 httpd.admin(4058) WARN: database query failed with: BIGINT > value is out of range in '(`pf`.`radacct_log`.`acctinputoctets` + > `pf`.`radacct_log`.`acctoutputoctets`)' (errno: 1690), will try again > (pf::db::db_query_execute) > Aug 03 10:35:20 httpd.admin(4058) WARN: database query failed with: BIGINT > value is out of range in '(`pf`.`radacct_log`.`acctinputoctets` + > `pf`.`radacct_log`.`acctoutputoctets`)' (errno: 1690), will try again > (pf::db::db_query_execute) > Aug 03 10:35:20 httpd.admin(4058) ERROR: Database issue: We tried 3 times to > serve query report_nodebandwidth_sql called from pf::db::db_data and we > failed. Is the database running? (pf::db::db_query_execute) and for bandwidth per OS: > Aug 03 10:39:39 httpd.admin(4058) WARN: database query failed with: BIGINT > value is out of range in '(`pf`.`radacct_log`.`acctinputoctets` + > `pf`.`radacct_log`.`acctoutputoctets`)' (errno: 1690), will try again > (pf::db::db_query_execute) > Aug 03 10:39:39 httpd.admin(4058) WARN: database query failed with: BIGINT > value is out of range in '(`pf`.`radacct_log`.`acctinputoctets` + > `pf`.`radacct_log`.`acctoutputoctets`)' (errno: 1690), will try again > (pf::db::db_query_execute) > Aug 03 10:39:39 httpd.admin(4058) WARN: database query failed with: BIGINT > value is out of range in '(`pf`.`radacct_log`.`acctinputoctets` + > `pf`.`radacct_log`.`acctoutputoctets`)' (errno: 1690), will try again > (pf::db::db_query_execute) > Aug 03 10:39:39 httpd.admin(4058) ERROR: Database issue: We tried 3 times to > serve query report_osclassbandwidth_sql called from pf::db::db_data and we > failed. Is the database running? (pf::db::db_query_execute) I also enabled query logging in mysql, so I cna give you the result of that too, but perhaps the above clue from httpd.admin.log already tells you enough? regards, MJ On 07/29/2015 11:03 PM, Louis Munro wrote: > > > On Jul 29, 2015, at 5:14 , heupink <[email protected]> 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 > [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) > ------------------------------------------------------------------------------ > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users > ------------------------------------------------------------------------------ _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
