Re: Freeradius with postgresql (Login incorrect)

[Thor Spruyt]

Title: Freeradius with postgresql (Login incorrect)

Please send mail in PLAIN TEXT! I don't know where YOU see an error message, but I don't see any. I would suggest turning SQL traces on (see postgresql.conf)   -- Groeten, Regards, Salutations,   Thor Spruyt M: +32 (0)475 67 22 65 E: [EMAIL PROTECTED] W: www.thor-spruyt.com   www.salesguide.be www.telenethotspot.be ----- Original Message ----- From: Brian Gao To: freeradius-users@lists.freeradius.org Sent: Thursday, April 14, 2005 7:42 PM Subject: Freeradius with postgresql (Login incorrect) Hi, all I am trying to configure postgresql 7.4 as a backend of freeradius server. After I run " radtest radius radius 47.135.23.217 1812 testing123 "The debug file shows: rad_recv: Access-Request packet from host 47.135.123.217:32782, id=217, length=58         User-Name = "radius"         User-Password = "radius"         NAS-IP-Address = 255.255.255.255         NAS-Port = 1812 rlm_sql (sql): Reserving sql socket id: 4 rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op ??FROM radcheck ??WHERE Usernam e = 'radius' ??ORDER BY id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: affected rows = rlm_sql_postgresql: query: SELECT radgroupcheck.id, radgroupcheck.GroupName, ??radgroupcheck.Attribu te, radgroupcheck.Value,radgroupcheck.Op ??FROM radgroupcheck, usergroup ??WHERE usergroup.Username = 'radius' AND usergroup.GroupName = radgroupcheck.GroupName ??ORDER BY radgroupcheck.id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: affected rows = rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op ??FROM radreply ??WHERE Usernam e = 'radius' ??ORDER BY id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: affected rows = rlm_sql_postgresql: query: SELECT radgroupreply.id, radgroupreply.GroupName, radgroupreply.Attribute , ??radgroupreply.Value, radgroupreply.Op ??FROM radgroupreply,usergroup ??WHERE usergroup.Username = 'radius' AND usergroup.GroupName = radgroupreply.GroupName ??ORDER BY radgroupreply.id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: affected rows = rlm_sql (sql): Released sql socket id: 4 Login incorrect: [radius/radius] (from client 47.135.123.0 port 1812) rad_recv: Access-Request packet from host 47.135.123.217:32782, id=217, length=58 Sending Access-Reject of id 217 to 47.135.123.217:32782 This looks to me like the connection is established already, the error that is being thrown looks like it is coming from the PostgreSQL. I have searched on Internet but didn't find the exact error.  Any ideas? TIA Brian