Re[14]: daily limit

2005-05-12 Thread avudz
Hello Marcin, Wednesday, May 11, 2005, 6:32:36 PM, you wrote: MJ Maybe the date format is incorrect? MJ I am not sure what those silly americans use but afair it's MJ of Month-Day-Year format - as logical as using bodyparts as the MJ scale value for meassurements :) MJ What does the debugging

Re: Re[14]: daily limit

2005-05-12 Thread Marcin Jessa
Hi! On Thu, 12 May 2005 15:42:52 +0700 avudz [EMAIL PROTECTED] wrote: nah nah, you quite right :-) when i change the date format, its work well now :-) I'd propably stumble on the same problem if I was going to implement expiration date on my system. I don't find the american date format

Re[2]: daily limit

2005-05-11 Thread avudz
Monday, May 9, 2005, 9:34:05 PM, you wrote: SE Hm... maybe you should set the SQL statements in your sqlcounter.conf file SE that can be usually found in /etc/raddb or SE /usr/local/etc/raddb depending on SE distribution... SE You can define the different counters for your vouchers that will

Re: Re[2]: daily limit

2005-05-11 Thread Marcin Jessa
You dont understand the way the counter works. As stated in the experimental.conf: # The 'reset' parameter defines when the counters are all # reset to zero. It can be hourly, daily, weekly, monthly or # never. It can also be user defined. It should be of the

Re[4]: daily limit

2005-05-11 Thread avudz
Hello Marcin, Wednesday, May 11, 2005, 2:54:09 PM, you wrote: MJ In your case you should change reset=never to reset=1h if you MJ want to reset the counter every hour. MJ But in that case it would not make sense to call it MJ Max-Hour-Session-Time since the counter would be reset after the MJ

Re: Re[4]: daily limit

2005-05-11 Thread Marcin Jessa
Hi. As far as I know the sqlcounter will disallow furhter authentrication only if the user has used her time limit quota. The Session-Timeout Attribute will kick him out when loged in and the Max-XYZ-Session will be checked the next time a user wants to login. You would need an additional

Re[6]: daily limit

2005-05-11 Thread avudz
Hello Marcin, Wednesday, May 11, 2005, 4:06:52 PM, you wrote: MJ Hi. MJ As far as I know the sqlcounter will disallow furhter MJ authentrication only if the user has used her time limit quota. MJ The Session-Timeout Attribute will kick him out when loged in MJ and the Max-XYZ-Session will be

Re: Re[6]: daily limit

2005-05-11 Thread Chris Knipe
On Wed, May 11, 2005 at 04:31:49PM +0700, avudz wrote: Hello Marcin, Wednesday, May 11, 2005, 4:06:52 PM, you wrote: MJ Hi. MJ As far as I know the sqlcounter will disallow furhter MJ authentrication only if the user has used her time limit quota. MJ The Session-Timeout Attribute will

Re[8]: daily limit

2005-05-11 Thread avudz
Wednesday, May 11, 2005, 4:36:26 PM, you wrote: CK I'll second that idea. Definately would need some external maintenance CK on the database every night to expire accounts older than 24hrs... CK Alternatively, you *can* do some nifty sql query on the authentication query CK that compaires

Re: Re[8]: daily limit

2005-05-11 Thread Marcin Jessa
Hi. Yepp, that should work, i.e. mysql select * from radcheck; ++--+---+++ | id | UserName | Attribute | op | Value | ++--+---+++ | 5 | yazzy| User-Password | := | yazzy | | 6 |

Re: Re[8]: daily limit

2005-05-11 Thread Marcin Jessa
Errata. I meant radgroupcheck, not radgroupreply. On Wed, 11 May 2005 12:09:01 +0200 Marcin Jessa [EMAIL PROTECTED] wrote: Hi. Yepp, that should work, i.e. mysql select * from radcheck; ++--+---+++ | id | UserName | Attribute | op |

Re[10]: daily limit

2005-05-11 Thread avudz
Hello Marcin, Wednesday, May 11, 2005, 5:09:01 PM, you wrote: MJ Hi. MJ Yepp, that should work, i.e. mysql select * from radcheck; MJ ++--+---+++ MJ | id | UserName | Attribute | op | Value | MJ

Re[11]: daily limit

2005-05-11 Thread avudz
Wednesday, May 11, 2005, 5:47:16 PM, you wrote: a Hello Marcin, a Wednesday, May 11, 2005, 5:09:01 PM, you wrote: MJ Hi. MJ Yepp, that should work, i.e. mysql select * from radcheck; MJ ++--+---+++ MJ | id | UserName | Attribute | op |

Re: Re[11]: daily limit

2005-05-11 Thread Marcin Jessa
Maybe the date format is incorrect? I am not sure what those silly americans use but afair it's of Month-Day-Year format - as logical as using bodyparts as the scale value for meassurements :) What does the debugging info say? On Wed, 11 May 2005 18:24:52 +0700 avudz [EMAIL PROTECTED] wrote:

Re[13]: daily limit

2005-05-11 Thread avudz
Hello Marcin, Wednesday, May 11, 2005, 6:32:36 PM, you wrote: MJ Maybe the date format is incorrect? MJ I am not sure what those silly americans use but afair it's MJ of Month-Day-Year format - as logical as using bodyparts as the MJ scale value for meassurements :) MJ What does the debugging

Re: Re[13]: daily limit

2005-05-11 Thread Marcin Jessa
Run your radiusd with -X flag, this will force it to foreground and give you more info. On Wed, 11 May 2005 18:40:38 +0700 avudz [EMAIL PROTECTED] wrote: Hello Marcin, Wednesday, May 11, 2005, 6:32:36 PM, you wrote: MJ Maybe the date format is incorrect? MJ I am not sure what those

daily limit

2005-05-09 Thread avudz
Hello, i'm realy happy my rlm_sqlcounter now run as i hope :-) but now i have 3 another case, i have three model voucher. 1st for 4 hours and the voucher valid for 2 days, 2nd 8 hours, valid for four days, last is one day, valid for 24 hours, so when the user log in, *maybe* the radius

RE: daily limit

2005-05-09 Thread Seferovic Edvin
To: freeradius-users@lists.freeradius.org Subject: daily limit Hello, i'm realy happy my rlm_sqlcounter now run as i hope :-) but now i have 3 another case, i have three model voucher. 1st for 4 hours and the voucher valid for 2 days, 2nd 8 hours, valid for four days, last is one day, valid