Re: SQL based Simultaneous-Use troubles

2005-06-14 Thread Alan DeKok
Aaron Paetznick <[EMAIL PROTECTED]> wrote:
> So even though I'm trying to do pure SQL-based Simultaneous-Use 
> checking, it's going to spawn an external process each time?

  If you tell it to.

>   I wanted to use SQL like this to avoid the overhead of spawning an
> external process in the first place.  Hrm...

  So make your clients "type=other", and checkrad won't run.

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


Re: SQL based Simultaneous-Use troubles

2005-06-14 Thread Aaron Paetznick


So even though I'm trying to do pure SQL-based Simultaneous-Use 
checking, it's going to spawn an external process each time?  I wanted 
to use SQL like this to avoid the overhead of spawning an external 
process in the first place.  Hrm...



--Aaron



Alan DeKok wrote:

Aaron Paetznick <[EMAIL PROTECTED]> wrote:

That worked!  Maybe the docs need to be changed to reflect this fact. 
I.e. SQL-based Simultaneous-Use still calls checkrad unless the NAS type 
is set to "other".



  Simultaneous-Use results in checkrad being called, for radutmp and
sql session checking.  The nas type is used by checkrad to determine
what else to do, independent of radutmp/sql.

  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


Re: SQL based Simultaneous-Use troubles

2005-06-14 Thread Alan DeKok
Aaron Paetznick <[EMAIL PROTECTED]> wrote:
> That worked!  Maybe the docs need to be changed to reflect this fact. 
> I.e. SQL-based Simultaneous-Use still calls checkrad unless the NAS type 
> is set to "other".

  Simultaneous-Use results in checkrad being called, for radutmp and
sql session checking.  The nas type is used by checkrad to determine
what else to do, independent of radutmp/sql.

  Alan DeKok.

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


Re: SQL based Simultaneous-Use troubles

2005-06-14 Thread Aaron Paetznick


That worked!  Maybe the docs need to be changed to reflect this fact. 
I.e. SQL-based Simultaneous-Use still calls checkrad unless the NAS type 
is set to "other".


Thanks for the help!


--Aaron



Alan DeKok wrote:

Aaron Paetznick <[EMAIL PROTECTED]> wrote:

I'm having some trouble getting FreeRADIUS to use the SQL tables for 
determining Simultaneous-Use.  I've reviewed the doc/Simultaneous-Use 
file.  I've uncommented the simul_count_query line in sql.conf.  I'm 
already successfully using SQL authentication and accounting.  I've 
entered Simultaneous-Use:=1 in the radgroupcheck table.



  That should work.


No matter what 
I do, this is what I get in the log:


Mon Jun 13 09:32:23 2005 : Error: Check-TS: timeout waiting for checkrad



  So Simultaneous-Use *is* working.  You now have to figure out why
checkrad is taking so long.


Can anybody offer any suggestions?  I'm just trying to use 100% 
SQL-based Simultaneous-Use checking, so checkrad shouldn't even be 
called, right?  I'm probably missing something really simple.  Thanks!



  Checkrad is called because the server may not have received
accounting data.  You can turn it off by making the client "type = other"

  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


Re: SQL based Simultaneous-Use troubles

2005-06-14 Thread Alan DeKok
Aaron Paetznick <[EMAIL PROTECTED]> wrote:
> I'm having some trouble getting FreeRADIUS to use the SQL tables for 
> determining Simultaneous-Use.  I've reviewed the doc/Simultaneous-Use 
> file.  I've uncommented the simul_count_query line in sql.conf.  I'm 
> already successfully using SQL authentication and accounting.  I've 
> entered Simultaneous-Use:=1 in the radgroupcheck table.

  That should work.

>  No matter what 
> I do, this is what I get in the log:
> 
> Mon Jun 13 09:32:23 2005 : Error: Check-TS: timeout waiting for checkrad

  So Simultaneous-Use *is* working.  You now have to figure out why
checkrad is taking so long.

> Can anybody offer any suggestions?  I'm just trying to use 100% 
> SQL-based Simultaneous-Use checking, so checkrad shouldn't even be 
> called, right?  I'm probably missing something really simple.  Thanks!

  Checkrad is called because the server may not have received
accounting data.  You can turn it off by making the client "type = other"

  Alan DeKok.

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