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

Fajar A. Nugraha list at fajar.net
Tue Jul 31 19:25:21 CEST 2012


On Tue, Jul 31, 2012 at 11:31 PM, Kaya Saman <kayasaman at gmail.com> wrote:
> mysql> select * from radcheck;
> +----+--------------+-------------------------+----+----------+
> | id | username     | attribute               | op | value    |
> +----+--------------+-------------------------+----+----------+
> |  1 | 0015c5537baa | Auth-Type               | := | Accept   |

Is this intentional? You DO know what setting that means, right?


> |  2 | 0015c5537baa | Tunnel-Type             | =  | VLAN     |
> |  3 | 0015c5537baa | Tunnel-Medium-Type      | =  | IEEE-802 |
> |  4 | 0015c5537baa | Tunnel-Private-Group-Id | =  | 20       |
> |  5 | 0015c5537baa | Tunnel-Preference       | =  | 0x000000 |
> +----+--------------+-------------------------+----+----------+


I'd suggest you change "=" to ":=", but it looks like you don't know
what the tables are for, as AFAIK those attributes should be in
radreply (also with ":="), not in radcheck. So just delete those rows
for now.

I highly suggest you re-read the documentation, including the included
doc/rlm_sql (also available on
https://github.com/alandekok/freeradius-server/blob/v2.1.x/doc/rlm_sql)

-- 
Fajar


More information about the Freeradius-Users mailing list