Thank you..
I reed the manual and my config in admin.conf "sql_command: /usr/bin/mysql"
are wrong.
My dialup_admin works i see online status! Great !!
But when is try this to run tot_stats i get a error 1045. My user in
admin.conf is good
and have a password!?
[EMAIL PROTECTED] bin]# ./tot_stats
DELETE FROM totacct WHERE AcctDate = '2004-12-09 00:00:00';
INSERT INTO totacct (UserName,AcctDate,ConnNum,ConnTotDuration,
ConnMaxDuration,ConnMinDuration,InputOctets,OutputOctets,NASIPAddress)
SELECT UserName,'2004-12-09',COUNT(*),SUM(AcctSessionTime),
MAX(AcctSessionTime),MIN(AcctSessionTime),SUM(AcctInputOctets),
SUM(AcctOutputOctets),NASIPAddress FROM radacct
WHERE AcctStopTime >= '2004-12-09 00:00:00' AND
AcctStopTime < '2004-12-10 00:00:00' GROUP BY UserName,NASIPAddress;
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
----- Original Message -----
From: "Kostas Kalevras" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 09, 2004 11:45 PM
Subject: Re: Ttotacct is empty in mysql db, how to?
> On Thu, 9 Dec 2004, Michel van Dop wrote:
>
> > Hello,
> >
> > I using freeradius-mysql-0.9.3-1.1 on fedora 1, i connect to mysql
server
> > 3.58.x db. It work okay mysql on username and groupname.
> > My totacct is empty in mysql db. Can anyone tell me how to config this
or can
> > me send a good link with information about this.
>
> totacct is populated by the dialupadmin/bin/tot_stats script. Configure it
> properly, run it and things should work. The dialupadmin/doc/HOWTO should
> contain more information.
>
> >
> > Thank you to read my problem,
> >
> > Michel
> >
> >
> >
>
> --
> 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
