Simultaneous-Use question

[Roberto Greiner]

After checking the sql.conf file, it really looks that all I need to do
is to add the NASIPaddress to the "simul_count_query" query. Is it just
that simple? Damn, and here was I thinking I would have to set three
different accounting databases, worry about keeping them in synch, and
handle three different sql.conf files. :-P

Thanks, I will try that.

Marcos Roberto Greiner

Chris Knipe wrote:
>
> Why not just optimise the SQL query to check for simultaneous users in
> sql.conf?
>
> It's rather easy to just change the SQL query to suit your needs??
>
>
>
> Regards,
> Chris.
>
> ----- Original Message ----- From: "Roberto Greiner"
> <mrgreiner at gmail.com>
> To: "FreeRadius users mailing list"
> <freeradius-users at lists.freeradius.org>
> Sent: Friday, August 25, 2006 4:20 PM
> Subject: Simultaneous-Use question
>
>
>> I'm intend to use Simultaneous-Use attribute to check logins for 3
>> different NAS. What I want to do is to allow 1 connection for each user
>> in each box, at the same time. So, user1 should be able to connect to
>> NAS1 and NAS2 at the same time, but not to NAS1 twice.  For the user
>> list I'm using the MYSQL with the default schema.
>>
>> If I understand it correctly (based on the /doc/Acct-Type file), to make
>> this work I would have to create 3 Acct-Type entries in the Accounting
>> section of radius.conf, and create 3 different sql.conf files, one for
>> each Acct-Type, right?
>>
>> Also, does it work properly if I make all 3 sql.conf files point to the
>> same database, using only different tables for accounting? Or did I get
>> something wrong?
>>
>> Thank you for your help,
>>
>> Marcos Roberto Greiner
>>
>> -- 
>> -------------------------------------------------------------------
>> |                     Marcos Roberto Greiner                        |
>> |                                                                   |
>> |         Os otimistas acham que estamos no melhor dos mundos       |
>> |         Os pessimistas tem medo de que isto seja verdade          |
>> |                                                     Murphy        |
>> -------------------------------------------------------------------
>> |                         rgreiner at usp.br                           |
>> -------------------------------------------------------------------
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>
> - List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>


-- 
 ------------------------------------------------------------------- 
|                     Marcos Roberto Greiner                        | 
|                                                                   | 
|         Os otimistas acham que estamos no melhor dos mundos       | 
|         Os pessimistas tem medo de que isto seja verdade          | 
|                                                     Murphy        | 
 ------------------------------------------------------------------- 
|                         rgreiner at usp.br                           | 
 -------------------------------------------------------------------