Hi,
I'm
trying to connect to pptp server (with freeradius + mysql) with no success.
when
trying with radtest or NTradping from remote server it's work fine (the server
return me Access-Acept)
here
is my radiusd dump :
rad_recv:
Access-Request packet from host 127.0.0.1:32787, id=39, length=69
Service-Type = Framed-User
Framed-Protocol = PPP
User-Name = "danielmi"
Calling-Station-Id = "192.168.8.244"
NAS-IP-Address = 127.0.0.1
NAS-Port = 0
Processing the authorize
section of radiusd.conf
modcall:
entering group authorize for request 0
modcall[authorize]:
module "preprocess" returns ok for request 0
modcall[authorize]:
module "chap" returns noop for request 0
modcall[authorize]:
module "mschap" returns noop for request 0
rlm_realm: No
'@' in User-Name = "danielmi", looking up realm NULL
rlm_realm: No
such realm "NULL"
modcall[authorize]:
module "suffix" returns noop for request 0
radius_xlat:
'danielmi'
rlm_sql
(sql): sql_set_user escaped user --> 'danielmi'
radius_xlat:
'SELECT id, UserName, Attribute, Value,
op FROM
radcheck WHERE
Username = 'danielmi'
ORDER BY id'
rlm_sql
(sql): Reserving sql socket id: 4
rlm_sql_mysql:
query: SELECT id, UserName, Attribute, Value,
op FROM
radcheck WHERE
Username = 'danielmi'
ORDER BY id
radius_xlat:
'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'danielmi' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
rlm_sql_mysql:
query: SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'danielmi' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat:
'SELECT id, UserName, Attribute, Value,
op FROM
radreply WHERE
Username =
'danielmi' ORDER BY
id'
rlm_sql_mysql:
query: SELECT id, UserName, Attribute, Value,
op FROM
radreply WHERE
Username = 'danielmi'
ORDER BY id
radius_xlat:
'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.Username = 'danielmi' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql_mysql:
query: SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.Username = 'danielmi' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql
(sql): Released sql socket id: 4
modcall[authorize]:
module "sql" returns ok for request 0
modcall:
leaving group authorize (returns ok) for request 0
rad_check_password:
Found Auth-Type Local
auth:
type Local
auth:
No User-Password or CHAP-Password attribute in the request
auth:
Failed to validate the user.
Delaying
request 0 for 1 seconds
Finished
request 0
Going
to the next request
Any
idea why I keep getting failed message.
thanks
Danny
J