Re: use existing sql table for user-password

2010-12-02 Thread Oguzhan Kayhan
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

Re: use existing sql table for user-password

2010-12-02 Thread Brian Candler
> > 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

Re: use existing sql table for user-password

2010-12-02 Thread Alan DeKok
Oguzhan Kayhan wrote: > As i noticed (i might be wrong), there is only one setting for > authcheck_table. > My username and passwords are in a table that i shouldnt change its structure. Yes, that was clear from your previous message. > But for radcheck, i need to add attribute and value field

Re: use existing sql table for user-password

2010-12-01 Thread Oguzhan Kayhan
On Thursday, December 02, 2010 08:39:18 am Alan DeKok wrote: > Oguzhan Kayhan wrote: > > Hello, > > I want to use freeradius for wireless authentication. > > I got an already installed mysql server, and some tables including > > usernames and passwords. > > I want to use this user/passwords with fr

Re: use existing sql table for user-password

2010-12-01 Thread Alan DeKok
Oguzhan Kayhan wrote: > Hello, > I want to use freeradius for wireless authentication. > I got an already installed mysql server, and some tables including usernames > and passwords. > I want to use this user/passwords with freeradius. > How can it be possible? Yes. Edit the queries in raddb/s

use existing sql table for user-password

2010-12-01 Thread Oguzhan Kayhan
Hello, I want to use freeradius for wireless authentication. I got an already installed mysql server, and some tables including usernames and passwords. I want to use this user/passwords with freeradius. How can it be possible? I will create a radius table to keep logs etc, but just to use user/pa