Hi Fajar I think the secondname field may be realm instead of. I am thinking this in case without proxy, using local database it can determine by two field "username+realm" instead one check field username such as "gary@companyA" . User can see his/her name like "gary" only without "@companyA" character. Best Regards Gary ----- Original Message ----- From: "Fajar A. Nugraha" <list@fajar.net> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Monday, October 31, 2011 11:04 AM Subject: Re: add field in radcheck table
2011/10/31 gary <gary.yang@browan.com>:
Hi there Is it possible to add check field in radcheck table?
Short answer: yes
Long answer: yes, but you need to have sufficient knowledge about how FR works and how to design SQL queries. If you don't even know where the queries are stored, then I suggest you don't even bother.
Something look like below,gary.companyA and gary.companyB as user name for authentication. +----+------------+-----------------+-------------------------+----+-------------+ | id | username | secondname |attribute | op | value | +----+------------+-----------------+-------------------------+-------------------+ | 1 | gary | companyA |Cleartext-Password | := | garypass | +----+------------+-----------------+-------------------------+-------------------+ | 2 | gary | companyB |Cleartext-Password | := | garypass | +----+------------+-----------------+-------------------------+-------------------+
option 1: just store gary.companyA and gary.companyB in username field.
option 2: be more clear in what you want, then maybe others can help you. What's your goal to add the field? Does user send gary.companyA as username, or just gary? How does the server get information about companyA or companyB? username? realm? NAS-IP-Address?
-- Fajar
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html