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" <[email protected]>
To: "FreeRadius users mailing list" <[email protected]>
Sent: Monday, October 31, 2011 11:04 AM
Subject: Re: add field in radcheck table
2011/10/31 gary <[email protected]>:
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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
