Re: SQL based Simultaneous-Use troubles
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
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
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
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
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