chap rlm_sql authentication problem

[Alan DeKok]

Andrew Long wrote:
> I am adding a new MSC to our list of clients and trying to verify the config with -X and ntradping.
> I keep getting rejected. 
...
> I note the "could not find clear text password" at bottom of reply, but am not sure why this is so;
> The password is present in radcheck.

  It's not found:

> The -X out put is as follows:
...
> rlm_sql (sql): No matching entry in the database for request from user [bufhiegall_cn3200]
>   modcall[authorize]: module "sql" returns notfound for request 0

  That's pretty definitive.

> I have run all the queries manually on the server, and they all return results as 
> expected (except the query to radgroupreply, as there is nothing configured there).

  They may return what you expect, but not what the server needs.

  Please post the output from the queries here.  Odds are something is
misconfigured, so that the queries return data, but not anything the
server can use.

  Alan DeKok.
--
  http://deployingradius.com       - The web site of the book
  http://deployingradius.com/blog/ - The blog