Migrating from Radiator to Freeradius....

[Eduard]

HI All!

I'm are planing to migrate from Radiator to Freeradius, but im finding 
much problems

From example:
in radiator  in can have diferent querys for each realm....
In one realm I only need que the username and password
-------8<--------- Pieze of RADIATOR CONFIGURATION 
-------------------------------------------------------------------------
       AuthSelect select PASSWORD, MAXUSERS  \
                          from  USERS  where LOGIN='%U' and REALM ='%W' 
and ACTIVEUSER=1
       AuthColumnDef 0, User-Password, check       
       AuthColumnDef 1, Simultaneous-Use, check  
--------------------------------------------------------------------------------------------------------------------------------------------------------------

but in other realms I need to
check ter Caller-Id and th Client-Port-DNIS
-------8<--------- Pieze of RADIATOR CONFIGURATION 
-------------------------------------------------------------------------
AuthSelect select PASSWORD, CLI_PORT, CALLER_ID , MAXUSERS  \
                  from USUARIOS where LOGIN='%U' and SERVICIO='%W' and 
ACTIVO=1
       AuthColumnDef 0, User-Password, check
       AuthColumnDef 1, Client-Port-DNIS, check
       AuthColumnDef 2, Caller-Id, check
       AuthColumnDef 3, Simultaneous-Use, check
--------------------------------------------------------------------------------------------------------------------------------------------------------------

for each AuthColumnDef Radiator compare a value returned from SQL with a 
value from the user request

My Questions are:
Can I have diferent  authentication select for each diferent realm ? How 
can I do it ?
There is possible have all user auth information in one table ? I have 
1300k users in database

Thanks All!







- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html