radiusd -X SQL suggests "not found" however user attributes are in the radcheck table?

Fajar A. Nugraha list at fajar.net
Wed Aug 1 14:36:22 CEST 2012

On Wed, Aug 1, 2012 at 7:20 PM, Kaya Saman <kayasaman at gmail.com> wrote:
> IF %User-Name notfound IN SQL

This one might not work the way you intended. What you've done so far,
the "=" part says "add this attribute if it doesn't already exist"
(e.g. not in SQL)

If you HAVE to do "notfound" check, something like this MIGHT work

authorize {

if (notfound) {


> Accept AND Provision onto VLAN 80 (my demo guest vlan in this case but
> could be any number (n))

Then just add Auth-Type = Accept inside the update block.


More information about the Freeradius-Users mailing list