Re: postgres + freeradius trouble

[André Lemos]

a bit more information: radius_xlat:  'SELECT radgroupreply.id, radgroupreply.GroupName, radgroupreply.Attribute, ??radgroupreply.Value, radgroupreply.Op ??FROM radgroupreply,usergroup ??WHERE usergroup.Username = 'user2' AND usergroup.GroupName = radgroupreply.GroupName ??ORDER BY radgroupreply.id' rlm_sql_postgresql: query: SELECT radgroupreply.id, radgroupreply.GroupName, radgroupreply.Attribute, ??radgroupreply.Value, radgroupreply.Op ??FROM radgroupreply,usergroup ??WHERE usergroup.Username = 'user2' AND usergroup.GroupName = radgroupreply.GroupName ??ORDER BY radgroupreply.id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: affected rows = rlm_sql (sql): No matching entry in the database for request from user [user2] rlm_sql (sql): Released sql socket id: 3   modcall[authorize]: module "sql" returns notfound for request 1   modcall[authorize]: module "mschap" returns noop for request 1 modcall: group authorize returns ok for request 1 auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user auth: Failed to validate the user. André Lemos wrote: Hi, I'm sorry to be bothering you, but I'm having a strange problem with this combo. I am using freeradius 1.0.5 and have the following user: radius=# select * from radcheck order by id;  id | username |    attribute    | op |  value ----+----------+-----------------+----+---------  10 | user2    | Framed-Protocol | != | PPP  14 | user2    | NAS-Port-Type   | == | Virtual  16 | user2    | Password        | == | teste if I remove the id 10, everything works as expected, but if I leave it as is, I can't authorize the user, although it matches the id 14 and the 10. The message I get is: rlm_sql (sql): No matching entry in the database for request from user [user2] which seems rather strange. Any insight you could give me? Very much appreciate it. -- _____________________ André Ventura Lemos Software Engineer Critical Software, SA MSN: [EMAIL PROTECTED] GSM: +351969495155 TLF: +351239989100 DISCLAIMER: This message may contain confidential information or privileged material and is intended only for the individual(s) named. If you are not a named addressee and mistakenly received this message you should not copy or otherwise disseminate it: please delete this e-mail from your system and notify the sender immediately. E-mail transmissions are not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, the sender does not accept liability for any errors or omissions in the contents of this message that arise as a result of e-mail transmissions. Please request a hard-copy version if verification is required. Critical Software. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- _____________________ André Ventura Lemos Software Engineer Critical Software, SA MSN: [EMAIL PROTECTED] GSM: +351969495155 TLF: +351239989100 DISCLAIMER: This message may contain confidential information or privileged material and is intended only for the individual(s) named. If you are not a named addressee and mistakenly received this message you should not copy or otherwise disseminate it: please delete this e-mail from your system and notify the sender immediately. E-mail transmissions are not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, the sender does not accept liability for any errors or omissions in the contents of this message that arise as a result of e-mail transmissions. Please request a hard-copy version if verification is required. Critical Software.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html