Hi,all
i configure the freeradius with mysql .when send the Access-Request ,and can
receive the Access-Accept.I can see
that authenticate is pass .but radius server can not send the ipaddress to user
radius -X
rad_recv: Access-Request packet from host 62.1.32.7:1645, id=248, length=111
NAS-IP-Address = 62.1.32.7
NAS-Port = 1
NAS-Port-Type = ISDN-V120
User-Name = "[EMAIL PROTECTED]"
Calling-Station-Id = "xxx"
CHAP-Password = 0x0b43a46dd00f1875ed6eb7e492db3eb3c1
Service-Type = Framed-User
Framed-Protocol = PPP
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
rlm_chap: Adding Auth-Type = CHAP
modcall[authorize]: module "chap" returns ok
modcall[authorize]: module "mschap" returns notfound
rlm_realm: Looking up realm picc.133vpdn.hi for User-Name = "[EMAIL PROTECTED]"
rlm_realm: No such realm picc.133vpdn.hi
modcall[authorize]: module "suffix" returns noop
users: Matched DEFAULT at 152
users: Matched DEFAULT at 171
users: Matched DEFAULT at 183
modcall[authorize]: module "files" returns ok
radius_xlat: '[EMAIL PROTECTED]'
rlm_sql (sql): sql_set_user escaped user --> '[EMAIL PROTECTED]'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
'[EMAIL PROTECTED]' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username = '[EMAIL PROTECTED]' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username =
'[EMAIL PROTECTED]' ORDER BY id'
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.Username = '[EMAIL PROTECTED]' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module "sql" returns ok
modcall: group authorize returns ok
rad_check_password: Found Auth-Type Local
auth: type Local
auth: user supplied CHAP-Password matches local User-Password
Login OK: [EMAIL PROTECTED]/] (from client router2610 port 1 cli
460030922009519)
Sending Access-Accept of id 248 to 62.1.32.7:1645
Framed-IP-Address := 255.255.255.254
Framed-MTU = 1500
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Compression = Van-Jacobson-TCP-IP
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
rad_recv: Accounting-Request packet from host 62.1.32.7:1646, id=249, length=147
NAS-IP-Address = 62.1.32.7
NAS-Port = 1
NAS-Port-Type = ISDN-V120
User-Name = "[EMAIL PROTECTED]"
Calling-Station-Id = "460030922009519"
Acct-Status-Type = Start
Acct-Authentic = RADIUS
Service-Type = Framed-User
Acct-Session-Id = "002D"
Framed-Protocol = PPP
Tunnel-Client-Endpoint:0 = "xxx.xxx.xxx.xxx"
Acct-Tunnel-Connection = "130029855"
Acct-Delay-Time = 0
modcall: entering group preacct
modcall[preacct]: module "preprocess" returns noop
rlm_realm: Looking up realm picc.133vpdn.hi for User-Name = "[EMAIL PROTECTED]"
rlm_realm: No such realm picc.133vpdn.hi
modcall[preacct]: module "suffix" returns noop
modcall[preacct]: module "files" returns noop
modcall: group preacct returns noop
modcall: entering group accounting
rlm_acct_unique: WARNING: Attribute 87 was not found in request, unique ID MAY be
inconsistent
rlm_acct_unique: Hashing ',Client-IP-Address = 62.1.32.7,NAS-IP-Address =
62.1.32.7,Acct-Session-Id = "002D",User-Name = "[EMAIL PROTECTED]"'
rlm_acct_unique: Acct-Unique-Session-ID = "109123494d0ff70e".
modcall[accounting]: module "acct_unique" returns ok
radius_xlat: '/usr/local/var/log/radius/radacct/detail-07'
rlm_detail: /usr/local/var/log/radius/radacct/detail-%m expands to
/usr/local/var/log/radius/radacct/detail-07
modcall[accounting]: module "detail" returns ok
modcall[accounting]: module "unix" returns ok
radius_xlat: '[EMAIL PROTECTED]'
rlm_sql (sql): sql_set_user escaped user --> '[EMAIL PROTECTED]'
radius_xlat: 'INSERT into radacct (RadAcctId, AcctSessionId, AcctUniqueId, UserName,
Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,
AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets,
AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType,
FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('', '002D',
'109123494d0ff70e', '[EMAIL PROTECTED]', '', '62.1.32.7', '1', 'ISDN-V120',
'2004-07-08 16:16:46', '0', '0', 'RADIUS', '', '', '0', '0', '', '46003