<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
a bit more information:<br>
<br>
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'<br>
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<br>
rlm_sql_postgresql: Status: PGRES_TUPLES_OK<br>
rlm_sql_postgresql: affected rows =<br>
rlm_sql (sql): No matching entry in the database for request from user
[user2]<br>
rlm_sql (sql): Released sql socket id: 3<br>
modcall[authorize]: module "sql" returns notfound for request 1<br>
modcall[authorize]: module "mschap" returns noop for request 1<br>
modcall: group authorize returns ok for request 1<br>
auth: No authenticate method (Auth-Type) configuration found for the
request: Rejecting the user<br>
auth: Failed to validate the user.<br>
<br>
<br>
<br>
André Lemos wrote:
<blockquote cite="mid43B422C4.2010803@criticalsoftware.com" type="cite">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
Hi,<br>
<br>
I'm sorry to be bothering you, but I'm having a strange problem with
this combo.<br>
<br>
I am using freeradius 1.0.5 and have the following user:<br>
<br>
radius=# select * from radcheck order by id;<br>
id | username | attribute | op | value<br>
----+----------+-----------------+----+---------<br>
10 | user2 | Framed-Protocol | != | PPP<br>
14 | user2 | NAS-Port-Type | == | Virtual<br>
16 | user2 | Password | == | teste<br>
<br>
<br>
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:<br>
<br>
rlm_sql (sql): No matching entry in the database for request from user
[user2]<br>
<br>
which seems rather strange.<br>
<br>
Any insight you could give me?<br>
<br>
Very much appreciate it.<br>
<br>
<div class="moz-signature">-- <br>
<strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">_____________________</span></font></b></strong><o:p></o:p>
<table>
<tbody>
<tr>
<td colspan="2"> <strong> <b><font face="Verdana" size="1"><span
style="font-size: 8pt; font-family: Verdana;">André Ventura Lemos</span></font></b></strong></td>
</tr>
<tr>
<td colspan="2"> <strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">Software Engineer</span></font></b></strong></td>
</tr>
<tr>
<td colspan="2"> <strong><b><font color="#a30030"
face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana; color: rgb(163, 0, 48);">Critical
Software, SA</span></font></b></strong></td>
</tr>
<tr>
<td> <strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">MSN:</span></font></b></strong></td>
<td> <strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;"><a
class="moz-txt-link-abbreviated" href="mailto:tux@tuxslare.org">tux@tuxslare.org</a></span></font></b></strong></td>
</tr>
<tr>
<td> <strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">GSM:</span></font></b></strong></td>
<td> <strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">+351969495155</span></font></b></strong></td>
</tr>
<tr>
<td> <strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">TLF:</span></font></b></strong></td>
<td> <strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">+351239989100</span></font></b></strong></td>
</tr>
</tbody>
</table>
</div>
<br>
<br>
<font color="#0000ff" size="1">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.</font><br>
<br>
<pre wrap="">
<hr size="4" width="90%">
-
List info/subscribe/unsubscribe? See <a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">_____________________</span></font></b></strong><o:p></o:p>
<table>
<tbody>
<tr>
<td colspan="2">
<strong> <b><font face="Verdana" size="1"><span
style="font-size: 8pt; font-family: Verdana;">André Ventura Lemos</span></font></b></strong></td>
</tr>
<tr>
<td colspan="2">
<strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">Software Engineer</span></font></b></strong></td>
</tr>
<tr>
<td colspan="2">
<strong><b><font color="#a30030" face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana; color: rgb(163, 0, 48);">Critical
Software, SA</span></font></b></strong></td>
</tr>
<tr>
<td>
<strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">MSN:</span></font></b></strong></td>
<td>
<strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;"><a class="moz-txt-link-abbreviated" href="mailto:tux@tuxslare.org">tux@tuxslare.org</a></span></font></b></strong></td>
</tr>
<tr>
<td>
<strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">GSM:</span></font></b></strong></td>
<td>
<strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">+351969495155</span></font></b></strong></td>
</tr>
<tr>
<td>
<strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">TLF:</span></font></b></strong></td>
<td>
<strong><b><font face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana;">+351239989100</span></font></b></strong></td>
</tr>
</tbody>
</table>
</div>
<br><br><Font size="1" color="#0000ff">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.</Font><br><br>
</body>
</html>