hi all,
i have installed freeRADIUS-0.8.1 and don't have any problem with auth when
using users file, but when i wanna use postgresql, get this message from
radius -X command:
rad_recv: Access-Request packet from host 127.0.0.1:32773, id=38, length=55
User-Name = "fred"
User-Password = "123"
NAS-IP-Address = 255.255.255.255
NAS-Port = 0
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
rlm_chap: Could not find proper Chap-Password attribute in request
modcall[authorize]: module "chap" returns noop
modcall[authorize]: module "mschap" returns notfound
rlm_realm: No '@' in User-Name = "fred", looking up realm NULL
rlm_realm: No such realm NULL
modcall[authorize]: module "suffix" returns noop
radius_xlat: 'fred'
rlm_sql (sql): sql_set_user escaped user --> 'fred'
radius_xlat: 'SELECT id,UserName,Attribute,Value,Op FROM radcheck WHERE
Username = 'fred' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_postgresql: query: SELECT id,UserName,Attribute,Value,Op FROM radcheck
WHERE Username = 'fred' ORDER BY id
rlm_sql_postgresql: PostgreSQL Query failed Error: no connection to the server
rlm_sql_getvpdata: database query error
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module "sql" returns fail
modcall: group authorize returns fail
Finished request 0
i maked these changes for working with PostgreSQL:
1.edited /usr/local/etc/raddb/radiusd.conf and added a "sql" line before
"files" in authorize section.
2.i did the same thing as in my first step in accounting section.
3.changed "$INCLUDE ${confdir}/sql.conf" to "$INCLUDE
${confdir}/postgresql.conf"
4.created a db and user in sql named radius and created tables using script in
source files; added an entry " fred password == 123 " in radcheck table and
also altered some other tables.
5.i even added " local all trust" line to pg_hba.conf file for ensuring that i
wouldn't have any security problem in postgresql.
thank you in advance for your helps,
bye,
habib
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
