Hello all, I'm running freeradius-1.0.1-3.RHEL4, and trying to authenticate using postgresql-7.4.8-1.RHEL4.1. My freeradius daemon loads with no problems, and everything appears ready-to-go. However I cannot authenticate against data stored in my Postgres database. My database is setup as follows:
radius=# select * from radcheck; id | username | attribute | value | op ----+-----------+---------------+-----------+---- 1 | ROSStest3 | User-Password | bdwnlc274 | == 2 | ROSStest4 | User-Password | nntlpa401 | == (2 rows) radius=# select * from radreply; id | username | attribute | value | op ----+-----------+-------------------+---------------+---- 1 | ROSStest3 | Framed-IP-Address | 10.150.19.134 | := 2 | ROSStest4 | Framed-IP-Address | 10.150.19.134 | := (2 rows) radius=# select * from usergroup; id | username | groupname ----+-----------+----------- 1 | ROSStest3 | static 2 | ROSStest4 | static (2 rows) Other tables are empty. Running freeradius in debug mode, the following output is given when attempting an authentication request using NTRadPing: rad_recv: Access-Request packet from host <my ip address>:1859, id=28, length=49 User-Name = "ROSStest4" User-Password = "nntlpa401" Processing the authorize section of radiusd.conf modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok for request 0 modcall[authorize]: module "chap" returns noop for request 0 modcall[authorize]: module "mschap" returns noop for request 0 rlm_realm: No '@' in User-Name = "ROSStest4", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 0 rlm_eap: No EAP-Message, not doing EAP modcall[authorize]: module "eap" returns noop for request 0 users: Matched DEFAULT at 156 modcall[authorize]: module "files" returns ok for request 0 radius_xlat: 'ROSStest4' rlm_sql (sql): sql_set_user escaped user --> 'ROSStest4' radius_xlat: '' rlm_sql (sql): Reserving sql socket id: 4 rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns fail for request 0 modcall: group authorize returns fail for request 0 Finished request 0 I'm running a trace against my database, and no output is given when attempting a radius query, so I'm assuming that freeradius is not even reaching the database. The error... rlm_sql (sql): SQL query error; rejecting user ...would seem to confirm this. However I'm not sure what part of the configuration files I need to change to rectify this. At a guess, I would say it's the following line in postgresql.conf: sql_user_name = "%{User-Name}" I've tried all sorts of entries in here, without success. Any assistance would be appreciated - apologies for the long entry above! Ross McOwat - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html