Hello,
I just solved it with sql trigger.
When a new user is created on other table, same user/password is inserted in
radcheck table with auth-Type and other static variables.
If password change occurs in other table, it updates radcheck table password
field too.
Thank you all for help.
On Thursday, December 02, 2010 04:52:01 pm Brian Candler wrote:
> > > But for radcheck, i need to add attribute and value fields as i see.
> > > How can i check just username and password from one table, and check
> > > other attributes (AuthType etc) from another??
> > >
> > Write an SQL function.
>
> Or use the group functionality. That is, use
>
> authorize_check_query
> authorize_reply_query
>
> to get the password, and
>
> group_membership_query
> authorize_group_check_query
> authorize_group_reply_query
>
> to get the attributes from another table. In group_membership_query you map
> the username to some other key, but you can just map it to the username
> again if you wish.
>
> But if this is MySQL, as Alan says it may be easier (and is certainly more
> flexible) to put your logic into stored procedures. Then use
>
> authorize_check_query = "call getCheck('%{User-Name}');"
> authorize_reply_query = "call getReply('%{User-Name}');"
>
> Regards,
>
> Brian.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
