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 > > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
