<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2658.24">
<TITLE>CHAP on freeradius & mysql</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">Hi all</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">My freeradius server has been running for some time now and due to</FONT>
<BR><FONT SIZE=2 FACE="Arial">the users file getting a bit long, I decide to go with the mysql-database.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I have my PAP-clients running on the new mysql-radius setup but my CHAP </FONT>
<BR><FONT SIZE=2 FACE="Arial">clients are still failing.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">When I was running from the users-file, an entry would look like this:</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">DEFAULT Auth-Type = MS-CHAP, Password == "void", Calling-Station-ID == '271111111'</FONT>
<BR> <FONT SIZE=2 FACE="Arial">Framed-IP-Address = 1.2.3.4</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">but moving to mysql, I cannot have "" as usernames.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">So my radcheck table has</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">john Auth-Type MS-CHAP</FONT>
<BR><FONT SIZE=2 FACE="Arial">john User-Password john</FONT>
<BR><FONT SIZE=2 FACE="Arial">john Calling-Station-ID 271111111'</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">When I run radiusd in debug mode, it says</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">modcall : module sql returns ok for request 1</FONT>
<BR><FONT SIZE=2 FACE="Arial">rlm_chap login attempt by "john" with CHAP-password</FONT>
<BR><FONT SIZE=2 FACE="Arial">rlm_chap: Using clear text password john for user john authentication</FONT>
<BR><FONT SIZE=2 FACE="Arial">rlm_chap : Password check failed</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">Is there any othe rdebugging aids that I can switch on to see whats cooking ??</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thanks !</FONT>
<BR><FONT SIZE=2 FACE="Arial">John</FONT>
</P>
</BODY>
</HTML>