Hi all,
I have a freeradius server with poetgresql configured, and I have imported the example db_postgresql.sql to the DB, they seems OK.
But when I run "radtest testing testing localhost 18 testing" command(I have user testing with passwd 'testing' in the table radcheck) , I am not able to get "Auth_accepted" message.
From postgresql's log file I could see that freeradius forwarded the "Auth request" to the DB. And the messages show:
2005-04-13 16:55:18 [1187] ERROR: permission denied for relation radcheck
2005-04-13 16:55:18 [1328] LOG: connection received: host=47.135.123.217 port=32784
2005-04-13 16:55:18 [1328] LOG: connection authorized: user=radius database=radius
2005-04-13 16:55:18 [1328] ERROR: permission denied for relation radcheck
From freeradius's debug mode, I could see the info like:
rad_recv: Access-Request packet from host 47.135.123.217:32769, id=62, length=59
rad_recv: Access-Request packet from host 47.135.123.217:32769, id=62, length=59
User-Name = "testing"
User-Password = "testing"
NAS-IP-Address = 255.255.255.255
NAS-Port = 18
rlm_sql (sql): Reserving sql socket id: 0
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op ??FROM radcheck ??WHERE Usernam
e = 'testing' ??ORDER BY id
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning SQL_DOWN
rlm_sql (sql): Attempting to connect rlm_sql_postgresql #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op ??FROM radcheck ??WHERE Usernam
e = 'testing' ??ORDER BY id
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning SQL_DOWN
rlm_sql (sql): failed after re-connect
rlm_sql_getvpdata: database query error
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 0
rad_recv: Access-Request packet from host 47.135.123.217:32769, id=62, length=59
Does anyone get this problem before? I think the problem is in the DB..
Any iedas?
Thanks
Brian
