one username and 2 NAS

[Enrico Fanti]

Ok, Thank you.

But for yiu, it's possible to use mysql for my target ?

If yes, do you have any ideas?

I would like to have a system (PHP-Mysql) to configure my server radius 
without use text files.

Thank you

Enrico


Ivan Kalik wrote:
> It's a file in raddb directory, not a part of the database schema.
>
> Ivan Kalik
> Kalik Informatika ISP
>
> Dana 18/2/2008, "Enrico Fanti" <efanti.list at gmail.com> piše:
>
>   
>> Sorry.
>>
>> I mistake with my thunderbird button.
>>
>> I would like to know whatt'is the huntgroups concept in radius database. 
>> I have this db schema:
>>
>> mysql> show tables;
>> +------------------+
>> | Tables_in_radius |
>> +------------------+
>> | nas              |
>> | radacct          |
>> | radcheck         |
>> | radgroupcheck    |
>> | radgroupreply    |
>> | radippool        |
>> | radpostauth      |
>> | radreply         |
>> | usergroup        |
>> +------------------+
>>
>>
>> Thank you
>>
>> Enrico
>>
>> Ivan Kalik wrote:
>>     
>>> You have asked this once already. It has been answered.
>>>
>>> Ivan Kalik
>>> Kalik Informatika ISP
>>>
>>>
>>> Dana 18/2/2008, "Enrico Fanti" <efanti.list at gmail.com> piše:
>>>
>>>   
>>>       
>>>> Hi ,
>>>>
>>>> I have freeradius configured with Mysql.
>>>>
>>>> I would like to have a user "pippo"  can ssh login to 2 server linux
>>>> wich uses pam_radius in /etc/pam.d/sshd (i.e. 2 NAS , same username).
>>>>
>>>> Freeradius must make the control if NAS-IP Address is ok for this user
>>>> in the radcheck table..
>>>>
>>>> I use the "==" operator end my radcheck table is:
>>>>
>>>> mysql> SELECT id, UserName, Attribute, Value, op from radcheck WHERE
>>>> Username = 'pippo' order by id;
>>>> +----+----------+----------------+---------------+----+
>>>> | id | UserName | Attribute      | Value         | op |
>>>> +----+----------+----------------+---------------+----+
>>>> | 39 | pippo    | NAS-IP-Address | 10.0.0.52 <http://10.0.0.52>     | == |
>>>> | 40 | pippo    | NAS-IP-Address | 10.0.0.49 <http://10.0.0.49>     | == |
>>>> | 41 | pippo    | Expiration     | 1203325200    | == |
>>>> | 42 | pippo    | Crypt-Password | v7fawImvQUoXM | == |
>>>> +----+----------+----------------+---------------+----+
>>>>
>>>>
>>>> It doesn't work......
>>>>
>>>> Some ideas ???
>>>>
>>>> Thank you
>>>>
>>>> Enrico
>>>>
>>>> -
>>>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/usershtml
>>>>
>>>>
>>>>     
>>>>         
>>> -
>>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>>>
>>>   
>>>       
>> -
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>>
>>
>>     
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>