sqlcounter problem

[Alan DeKok]

satish patel wrote:
> Dear ALL
> 
>              I have configure freeradius-1.1.4 version with mysql and my
> NSA is cisco with VPDN configuration now i have create user "aaa" in
> mysql with this attributes
...
> sqlcounter dailycounter {
>             driver = "rlm_sqlcounter"

  Where does that line come from?  Why is it there?

>             counter-name = Daily-Session-Time
>             check-name = Max-Daily-Session
>             sqlmod-inst = sqlcca3

  Where does that line come from?  Why is it there?

  The default "radiusd.conf" shipped with 1.1.4 has a sample sqlcounter
entry.  Please use it as the template.

> now problem is when i login throgh AAA user my user disconnect after 3
> min but when i login again through this user it was login again and
> disconnnect after 3 min  why ???   i want to allow user to access only 3
> min per day measn after 3 min completed use not allowd to login again
> what is the configuration for that ???

  Did you list dailycounter in the "authorize" section of
"radiusd.conf"?  Did you list "sql" in the "accounting" section of
"radiusd.conf"?

  Alan DeKok.
--
  http://deployingradius.com       - The web site of the book
  http://deployingradius.com/blog/ - The blog