Re: sqlcounter problem

--===============1397392558==
Content-Type: multipart/alternative; boundary="0-563035827-1169126887=:47733"
Content-Transfer-Encoding: 8bit

--0-563035827-1169126887=:47733
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

thx for help i got it what u want to say.

I have one more question how do i disconnect user in freeradius online user ??? and is it possible to bind per users bandwidth with Cisco-AVpair attributes i have cisco vpdn NAS and i want to limit user bandwidth restriction thruogh the radius .. is it possible and how do i configure it

Satish Patel

Alan DeKok <aland@deployingradius.com> wrote: 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html



---------------------------------
Here’s a new way to find what you're looking for - Yahoo! Answers
--0-563035827-1169126887=:47733
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

thx for help i got it what u want to say.<br> <br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p; I have one more question how do i disconnect user in freeradius online user ???&nbsp; and is it possible to bind per users bandwidth with&nbsp; Cisco-AVpair&nbsp; attributes i have cisco vpdn NAS&nbsp; and i want to limit user bandwidth restriction thruogh the radius .. is it possible and how do i configure it <br> <br> Satish Patel<br><br><b><i>Alan DeKok &lt;aland@deployingradius.com&gt;</i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> satish patel wrote:<br>&gt; Dear ALL<br>&gt; <br>&gt; I have configure freeradius-1.1.4 version with mysql and my<br>&gt; NSA is cisco with VPDN configuration now i have create user "aaa" in<br>&gt; mysql with this attributes<br>...<br>&gt; sqlcounter dailycounter {<br>&gt; driver =
"rlm_sqlcounter"<br><br> Where does that line come from? Why is it there?<br><br>&gt; counter-name = Daily-Session-Time<br>&gt; check-name = Max-Daily-Session<br>&gt; sqlmod-inst = sqlcca3<br><br> Where does that line come from? Why is it there?<br><br> The default "radiusd.conf" shipped with 1.1.4 has a sample sqlcounter<br>entry. Please use it as the template.<br><br>&gt; now problem is when i login throgh AAA user my user disconnect after 3<br>&gt; min but when i login again through this user it was login again and<br>&gt; disconnnect after 3 min why ??? i want to allow user to access only 3<br>&gt; min per day measn after 3 min completed use not allowd to login again<br>&gt; what is the configuration for that ???<br><br> Did you list dailycounter in the "authorize" section of<br>"radiusd.conf"? Did you list "sql" in the "accounting" section of<br>"radiusd.conf"?<br><br> Alan DeKok.<br>--<br> http://deployingradius.com
- The web site of the book<br> http://deployingradius.com/blog/ - The blog<br>- <br>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<br></blockquote><br><p>



<hr size=1></hr>
Here’s a new way to find what you're looking for - <a href="http://us.rd.yahoo.com/mail/in/yanswers/*http://in.answers.yahoo.com/">Yahoo! Answers</a>
--0-563035827-1169126887=:47733--

--===============1397392558==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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