<!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">
Thanks for the reply Stefan, <br>
<br>
Here is the output from mysql for the statement below:<br>
<br>
mysql> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username <br>
-> = 'mpearson' ORDER BY id<br>
-> <br>
-> ;<br>
+------+----------+------------------+--------+----+<br>
| id | UserName | Attribute | Value | op |<br>
+------+----------+------------------+--------+----+<br>
| 1118 | mpearson | Password | XXXX| == |<br>
| 1119 | mpearson | Simultaneous-Use | 1 | == |<br>
+------+----------+------------------+--------+----+<br>
2 rows in set (0.29 sec)<br>
<br>
Also I went down through the debug of radisud and put in the select
statments from I didn't get any results from:<br>
<br>
SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'mpearson' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id<br>
<br>
and<br>
<br>
SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username =
'mpearson' ORDER BY id<br>
<br>
<br>
Thanks<br>
Mike<br>
<br>
<br>
<br>
<br>
<br>
Stefan Winter wrote:
<blockquote cite="mid200610241641.12362.stefan.winter@restena.lu"
type="cite">
<pre wrap="">Hi,
nicely done problem report!
My guess is that your tables contain a check item that is not satisfied by the
incoming requests. Could you do a
SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username
= 'mpearson' ORDER BY id
(this is one of the SQL statements in the debug output. It might also help to
execute all other statements that appeared in the debug output for the user
and post them too)
and post it to the list (obfuscate the password of course)? Because
</pre>
<blockquote type="cite">
<pre wrap="">rlm_sql (sql): No matching entry in the database for request from user
[mpearson]
</pre>
</blockquote>
<pre wrap=""><!---->
this output looks suspiciously like the user itself was found in the database,
but there was more than one line concerning him and not all of those lines
containing check items were satisfied.
Greetings,
Stefan Winter
</pre>
<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>
</body>
</html>