Re: Where to find sql counter module ?

2007-02-24 Thread Abel Monzón 

  - Original Message - 
  From: YvesDM 
  To: FreeRadius users mailing list 
  Sent: Saturday, February 24, 2007 9:03 AM
  Subject: Re: Where to find sql counter module ?


  On 2/24/07, PD [EMAIL PROTECTED] wrote:

Simple questions...
how and where to get sql counter module ?
I try to googling for hours but still can not find it.

TIA

PD

  You should compile FR with experimental modules
  You have to create the module yourself 
  Read  rlm_sqlcounter in the doc/ folder .
  It's explained how to use this. 


  Kind Regards, 
  Yves





--

Everithing step I do, but, if the Max-Daily-Session  3600, the FR not do 
anything. why?- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Dial Up Admin Interface

2007-02-23 Thread Abel Monzón 

   
  We are looking at installing the Dial Up Admin Interface for administration 
purposes. 

   

  Research suggests that the place to in all the relevant information is at 

   

  /usr/share/doc/freeradius-dialupadmin/HOWTO.gz

   

   

  We have installed V1.1.4 and the HOWTO.gz cannot be found here. Could someone 
please point me in the right direction. 

   

  Or is there a better admin interface to use? Any recommendations greatly 
appreciated.

   

   

  Peter.

   


--



What system you have? And How you install that?

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

Re: Dial Up Admin Interface

2007-02-23 Thread Abel Monzón 
- Original Message -
From: Marc Hultquist [EMAIL PROTECTED]
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Friday, February 23, 2007 1:17 PM
Subject: Re: Dial Up Admin Interface


 Have a look at the dialup_admin package which is available on
 freshmeat.net ! I believe the direct link to the project is -
 http://freshmeat.net/projects/dialup_admin/  ! Not sure if that is what
 you are looking for though.
 -
 List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html

The Dial up Admin Interface at sourceforge.net is out of the date, but in
the freeradius-1.1.4.tar.gz have the lastest them.

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

Re: Fw: Attribute Max-Daily-Session + Session-Timeout

2007-02-20 Thread Abel Monzón 

Abel Monzón wrote:
 No body know what is the solution? I send this e-mail, and nothing of
 answer.

  People don't *have* to answer.

  In your case, you're trying to use sqlcounter.  Have you configured
the SQL module to store accounting data?  Is the NAS sending accounting
packets?
 Yes, I have configured the SQL module to store my accounting data and the
NAS is sending accounting packets. All work fine, but not the
Max-Daily-Session

  Alan DeKok.
--
  http://deployingradius.com   - The web site of the book
  http://deployingradius.com/blog/ - The blog
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html

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

Fw: Attribute Max-Daily-Session + Session-Timeout

2007-02-19 Thread Abel Monzón 
No body know what is the solution? I send this e-mail, and nothing of answer.

Good Day
From: Abel Monzón 
To: mailist 
Sent: Monday, February 19, 2007 2:04 AM
Subject: Attribute Max-Daily-Session + Session-Timeout


Hello List.

I have a problem. I had limited the Max-Daily-Session = 120, and the 
Session-Timeout = 60. 

The Session-Timeout work, but the Max-Daily-Session don't. because the 
Session-Timeout log out the user, but de Max-Daily-Session don't and let log in 
again.

I have this in my radiusd.conf:

sqlcounter contdiario {
counter-name = Daily-Session-Time
check-name = Max-Daily-Session
sqlmod-inst = sql
key = User-Name
reset = daily
count-attribute = Max-Daily-Session
query = SELECT SUM(AcctSessionTime - \
 GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0)) \
 FROM radacct WHERE UserName='%{%k}' AND \
 UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime  '%b'
}

authorize {

contdiario
.
}

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

Attribute Max-Daily-Session + Session-Timeout

2007-02-18 Thread Abel Monzón 
Hello List.

I have a problem. I had limited the Max-Daily-Session = 120, and the 
Session-Timeout = 60. 

The Session-Timeout work, but the Max-Daily-Session don't. because the 
Session-Timeout log out the user, but de Max-Daily-Session don't and let log in 
again.

I have this in my radiusd.conf:

sqlcounter contdiario {
counter-name = Daily-Session-Time
check-name = Max-Daily-Session
sqlmod-inst = sql
key = User-Name
reset = daily
count-attribute = Max-Daily-Session
query = SELECT SUM(AcctSessionTime - \
 GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0)) \
 FROM radacct WHERE UserName='%{%k}' AND \
 UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime  '%b'
}

authorize {

contdiario
.
}

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