<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="Open WebMail 2.20 20031014" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<font size="2">Do you have two entries for each user in the radcheck table?
<br />
<br />Each user needs two entries. One with the attribute User-Password containing the plaintext password, and one with the Attribute Auth-Type containing the Digest value (and a different OP). For instance:
<br />
<br />
<br />id user domain UserName Attribute Value op
<br />--------------------------------------------------------------------------------------
<br />12 552 sip.proxy.com 552@sip.proxy.com User-Password p4ssw0rd ==
<br />13 552 sip.proxy.com 552@sip.proxu.com Auth-Type Digest :=
<br />
<br />
<br />Only with BOTH those lines will it work. It looks from the error message that you have the second but not the first (since it can't find the User-Password attribute according to the error message)
<br />
<br />N.
<br />
<br />
<br /><b>
<br />
<br />On Fri, 10 Nov 2006 11:49:45 -0000, Lokesh Kumar wrote</b>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Hello,<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p> </o:p></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">I am running old ser version 0.9.6, where I am authenticating
on radius and keeping the users record in default sql database of radius. But
it is not authenticating, the logs are mentioned below.<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p> </o:p></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">But it worked absolutely fine with radius users files.<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p> </o:p></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">I have the entry for the user in radcheck file but still it
is saying user not found.<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p> </o:p></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Can anyone give any hint where I am doing wrong.<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p> </o:p></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Going to the next request<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">--- Walking the entire request list ---<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Waking up in 1 seconds...<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">rad_recv: Access-Request packet from host 127.0.0.1:54086,
id=241, length=262<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> User-Name =
"211069020@voip.nortenet.pt"<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> Digest-Attributes
= 0x0a0b323131303639303230<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> Digest-Attributes
= 0x0112766f69702e6e6f7274656e65742e7074<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> Digest-Attributes
=
0x022a34353534363466343439376235396563623463356332613233646564366565323939343565316432<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> Digest-Attributes
= 0x04167369703a766f69702e6e6f7274656e65742e7074<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> Digest-Attributes
= 0x030a5245474953544552<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> Digest-Attributes
= 0x050661757468<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> Digest-Attributes
= 0x090a3030303030303031<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> Digest-Attributes
= 0x08103132373935383532383139343033<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> Digest-Response =
"2ae0ba094f508b9dff7bb56d96649875"<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> Service-Type =
Sip-Session<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> </span></font><font size="2" face="Arial"><span lang="PT" style="font-size: 10pt; font-family: arial;">Sip-Uri-User
= "211069020"<o:p /></span></font>
<br />> <font size="2" face="Arial"><span lang="PT" style="font-size: 10pt; font-family: arial;"> NAS-Port = 5060<o:p /></span></font>
<br />> <font size="2" face="Arial"><span lang="PT" style="font-size: 10pt; font-family: arial;"> </span></font><font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">NAS-IP-Address
= 127.0.0.1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> Processing the authorize section of radiusd.conf<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">modcall: entering group authorize for request 1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> modcall[authorize]: module "preprocess"
returns ok for request 1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> modcall[authorize]: module "chap" returns
noop for request 1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> modcall[authorize]: module "mschap" returns
noop for request 1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">rlm_digest: Adding Auth-Type = DIGEST<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> modcall[authorize]: module "digest" returns
ok for request 1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> rlm_eap: No EAP-Message, not doing EAP<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> modcall[authorize]: module "eap" returns
noop for request 1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span lang="PT" style="font-size: 10pt; font-family: arial;">radius_xlat: '211069020@voip.nortenet.pt'<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">rlm_sql (sql): sql_set_user escaped user --> '211069020@voip.nortenet.pt'<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">radius_xlat: 'SELECT id, UserName, Attribute, Value,
op FROM
radcheck WHERE
Username = '211069020@voip.nortenet.pt'
ORDER BY id'<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">rlm_sql (sql): Reserving sql socket id: 13<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">rlm_sql (sql): User 211069020@voip.nortenet.pt not found in
radcheck<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username =
'211069020@voip.nortenet.pt' AND usergroup.GroupName = radgroupcheck.GroupName
ORDER BY radgroupcheck.id'<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.Username = '211069020@voip.nortenet.pt'
AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">rlm_sql (sql): User 211069020@voip.nortenet.pt not found in
radgroupcheck<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">rlm_sql (sql): Released sql socket id: 13<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">rlm_sql (sql): User not found<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> modcall[authorize]: module "sql" returns
notfound for request 1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">modcall: leaving group authorize (returns ok) for request 1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> rad_check_password: Found Auth-Type DIGEST<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">auth: type "digest"<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> Processing the authenticate section of radiusd.conf<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">modcall: entering group authenticate for request 1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">rlm_digest: Configuration item "User-Password" or
Digest-HA1 is required for authentication.<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> modcall[authenticate]: module "digest"
returns invalid for request 1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">modcall: leaving group authenticate (returns invalid) for
request 1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">auth: Failed to validate the user.<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Login incorrect: [211069020@voip.nortenet.pt] (from client
localhost port 5060)<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Delaying request 1 for 1 seconds<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Finished request 1<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Going to the next request<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">--- Walking the entire request list ---<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Waking up in 1 seconds...<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">--- Walking the entire request list ---<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Sending Access-Reject of id 240 to 127.0.0.1 port 54085<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Waking up in 1 seconds...<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">--- Walking the entire request list ---<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Sending Access-Reject of id 241 to 127.0.0.1 port 54086<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Waking up in 3 seconds...<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">--- Walking the entire request list ---<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Cleaning up request 0 ID 240 with timestamp 455463c8<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Waking up in 1 seconds...<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">--- Walking the entire request list ---<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Cleaning up request 1 ID 241 with timestamp 455463c9<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Nothing to do. Sleeping until we see a request.<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p> </o:p></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Thanks very much<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p> </o:p></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Lokesh<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p> </o:p></span></font>
<br />>
<br />> <font size="2">--
<br />>
No virus found in this outgoing message.
<br />>
Checked by AVG Free Edition.
<br />>
Version: 7.1.409 / Virus Database: 268.14.1/527 - Release Date: 11/9/2006
<br />>
</font>
<br />
<br />
<br />
</font>
</BODY>
</HTML>