radreply is not queried

[Alan DeKok]

On Apr 26, 2018, at 12:58 PM, Charly <netflow at geosciences.ensmp.fr> wrote:
> 
> I found the problem, if the user is not found in radcheck, radreply is not used

  See the wiki, and rlm_sql.  This is documented. 

> I would like to do this :
> 
>         if (notfound) {
>                 update reply {
>                         Cisco-AVPair += "%{sql-vpn:SELECT value FROM radreply WHERE username = '%{User-Name}' AND attribute = 'Cisco-AVPair' ORDER BY id}"
>                 }
>         }
> 
> But because the user is found in group table, i got :
> 
> (0)     [sql] = ok
> 
> How to know if user is not found ?

  You don't.

  Add a check item for the user.  It doesn't have to be anything in particular.  Just something which will always match.

  Alan DeKok.