On Sunday 06 April 2003 09:50, Kostas Kalevras wrote: > On Sun, 6 Apr 2003, tarvid wrote: > > The CVS from today is starting to come up but selecting User Statistics > > displays nothing. > > > > With SQL debug on > > > > DEBUG(SQL,MYSQL DRIVER): Query: SELECT * FROM WHERE AcctDate >= > > '2003-03-30' AND AcctDate <= '2003-04-06' ORDER BY ConnNum desc LIMIT 10; > > > > The code from user_stats.php3: > > > > "SELECT * FROM $config[sql_total_accounting_table] > > WHERE AcctDate >= '$start' AND AcctDate <= '$stop' $server_str > > ORDER BY $order_attr $order $limit;"); > > > > But sql_total_accounting_table is not defined. > > > > [EMAIL PROTECTED] conf]# grep sql_total_accounting_table * > > [EMAIL PROTECTED] conf]# > > Fixed, thanks > > > Even if it were, I have nothing in either totacct nor mtotacct. > > You will have to run tot_stats (for totacct) and monthly_tot_stats (for > mtotacct). > > > Jim Tarvid > > I presume I should put tot-stats and monthly_tot_stats in cron somewhere.
Where should I get the patch fo sql_total_accounting_table? Thanks, Jim Tarvid - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html