Can someone look at my query and tell me what is wrong?
-----------------------------------------------------------
db=> select id, username, attribute, value, op from radstart('username');
id | username | attribute | value | op
----+----------+-----------------+----------+----
1 | username | User-Password | password | ==
5 | username | Auth-Type | Local | :=
6 | username | Session-Timeout | 600 | =
-----------------------------------------------------------From what I am reading that should be everything I need to authorize a user, but I keep getting:
-----------------------------------------------------------
radius_xlat: 'select id, username, attribute, value, op from radstart('username')'
rlm_sql_postgresql: query: select id, username, attribute, value, op from radstart('username')
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
radius_xlat: ''
rlm_sql (sql): No matching entry in the database for request from user [username]
-----------------------------------------------------------
What specifically does FR need to authorize against a sql module?
Thanks,
schu
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
