On Tue, 12 Jul 2005 15:21:52 +1000 "Ross Tsolakidis" <Ross.Tsolakidis@day3.com.au> wrote:

Ok, now I'm really confused :(

Can someone please clarify exactly what does the sqlcounter module do ? Basically I need to calculate the data on a daily basis for each user.

sqlcounter works fine. Your radgroupcheck or radcheck needs to have the same attributes you have in your sqlcounter config. Check out mine: http://www.yazzy.org/configs/linux/freeradius/sqlcounter.conf mysql> select * from radgroupcheck; +----+-----------+---------------------+----+-------+ | id | GroupName | Attribute | op | Value | +----+-----------+---------------------+----+-------+ | 1 | 24hours | Max-Daily-Session | := | 86400 | | 2 | 24hours | Max-Weekly-Session | := | 86400 | | 3 | 24hours | Max-Monthly-Session | := | 86400 | | 4 | 24hours | Max-All-Session | := | 86400 | | 5 | 10mins | Max-Daily-Session | := | 600 | | 6 | 10mins | Max-Weekly-Session | := | 600 | | 7 | 10mins | Max-Monthly-Session | := | 600 | | 8 | 10mins | Max-All-Session | := | 600 | +----+-----------+---------------------+----+-------+ 8 rows in set (0.00 sec) Read experimental.conf, it describes the module. It count's user's online time stored in the raddacct table and based on that info allows user to log in if her allowed session time is not exceeded. This can be done on daily, weekly, monthly or total basis.

Thanks for your patience :)

Read former postings to the list describing the behaviour and functionality of the module. People tend to be more patient if they know you did some work on your own. Cheers, Marcin Jessa

-----Original Message----- From: freeradius-users-bounces@lists.freeradius.org [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of Ross Tsolakidis Sent: Tuesday, 5 July 2005 2:14 PM To: FreeRadius users mailing list Subject: RE: sql counter clarification and issues

Yes the server is receiving accounting packets. The SQL rows are updating every 5 mins, (I have the NAS set to send accounting packets every 5 mins).

I run it in debug mode, I see: Module: Loaded SQL Counter sqlcounter: counter-name = "Daily-Session-Time" sqlcounter: check-name = "Max-Daily-Session" sqlcounter: key = "User-Name" sqlcounter: sqlmod-inst = "sqlcca3" sqlcounter: query = "SELECT SUM(AcctSessionTime - GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'" sqlcounter: reset = "1h" rlm_sqlcounter: Counter attribute Daily-Session-Time is number 1671 rlm_sqlcounter: Check attribute Max-Daily-Session is number 1672 rlm_sqlcounter: num=1, last=h rlm_sqlcounter: Current Time: 1120532709 [2005-07-05 13:05:09], Next reset 1120536000 [2005-07-05 14:00:00] rlm_sqlcounter: num=1, last=h rlm_sqlcounter: Current Time: 1120532709 [2005-07-05 13:05:09], Prev reset 1120532400 [2005-07-05 13:00:00] Module: Instantiated sqlcounter (dailycounter)

But no reset.

Does anyone have this working, if so, what am I looking for, what am I supposed to see ?

Thanks :)

Regards, -- Ross

-----Original Message----- From: freeradius-users-bounces@lists.freeradius.org [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Tuesday, 5 July 2005 2:05 AM To: FreeRadius users mailing list Subject: Re: sql counter clarification and issues

"Ross Tsolakidis" <Ross.Tsolakidis@day3.com.au> wrote:

...

At midnight every night will it begin a new row in SQL ?

I don't know, I've never used the module.

...

Because at the moment there are no new rows being created, no counters

...

being reset.

Is the server receiving accounting packets?

Run it in debug mode with "reset=hour", and spend some time looking at what it's doing.

Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html