FR1 -> FR2: authenticate_query

Rakotomandimby Mihamina mihamina at gulfsat.mg
Thu Jul 23 08:16:25 CEST 2009


I am in the process of migrating from freeradius v1.4 to v2
I am running Debian Lenny, all installed from packages.

I am first trying to merge the configuration.
I use Postgresql behind.

In the v1:
         #######################################################################
         #  Authentication Query
         #######################################################################
         #authenticate_query = "SELECT Value,Attribute FROM ${authcheck_table} \
         #       WHERE UserName = '%{User-Name}' AND ( Attribute = 'User-Password' OR Attribute = 'Crypt-Password' ) \
         #       ORDER BY Attribute DESC"

         authenticate_query = "We put ours here....."
         # Postauth query
         # postauth_query = "INSERT INTO radreply (username, attribute,op,value) VALUES ('%{SQL-User-Name}', 'Session-Timeout', '=','100')"

I did not find 'authenticate_query' in the v2 default 'postegressql/dialup.conf' file.
Have I just to add what we have in v1?
-- 
                             Architecte Informatique:
    Administration Systeme, Recherche & Developpement
                                   + 261 32 11 401 65
Pensez a l'environnement avant d'imprimer ce message



More information about the Freeradius-Users mailing list