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 = "xxxxxxxxxxx"
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]/<CHAP-Password>] (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 = "0000002D"
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 = "0000002D",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('', '0000002D',
'109123494d0ff70e', '[EMAIL PROTECTED]', '', '62.1.32.7', '1', 'ISDN-V120',
'2004-07-08 16:16:46', '0', '0', 'RADIUS', '', '', '0', '0', '', '460030922009519',
'', 'Framed-User', 'PPP', '', '0', '0')'
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql (sql): Released sql socket id: 3
modcall[accounting]: module "sql" returns ok
radius_xlat: '[EMAIL PROTECTED]'
modcall[accounting]: module "radutmp" returns ok
modcall: group accounting returns ok
Sending Accounting-Response of id 249 to 62.1.32.7:1646
Finished request 1
Going to the next request
Cleaning up request 1 ID 249 with timestamp 40ed02ee
rl_next: returning NULL
Waking up in 6 seconds...
rad_recv: Accounting-Request packet from host 62.1.32.7:1646, id=250, length=210
NAS-IP-Address = 62.1.32.7
NAS-Port = 1
NAS-Port-Type = ISDN-V120
User-Name = "[EMAIL PROTECTED]"
Calling-Station-Id = "xxxxxxxxxx"
Acct-Status-Type = Stop
Acct-Authentic = RADIUS
Service-Type = Framed-User
Acct-Session-Id = "0000002D"
Framed-Protocol = PPP
Tunnel-Client-Endpoint:0 = "xxx.xxx.xxx.xxx"
Acct-Tunnel-Connection = "130029855"
Acct-Terminate-Cause = Lost-Carrier
Acct-Input-Octets = 0
Acct-Output-Octets = 0
Acct-Input-Packets = 0
Acct-Output-Packets = 0
Acct-Session-Time = 0
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 = "0000002D",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: 'UPDATE radacct SET AcctStopTime = '2004-07-08 16:16:46',
AcctSessionTime = '0', AcctInputOctets = '0', AcctOutputOctets = '0',
AcctTerminateCause = 'Lost-Carrier', AcctStopDelay = '0', ConnectInfo_stop = '' WHERE
AcctSessionId = '0000002D' AND UserName = '[EMAIL PROTECTED]' AND NASIPAddress =
'62.1.32.7' AND AcctStopTime = 0'
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql (sql): Released sql socket id: 2
modcall[accounting]: module "sql" returns ok
radius_xlat: '[EMAIL PROTECTED]'
modcall[accounting]: module "radutmp" returns ok
modcall: group accounting returns ok
Sending Accounting-Response of id 250 to 62.1.32.7:1646
Finished request 2
Going to the next request
Cleaning up request 2 ID 250 with timestamp 40ed02ee
rl_next: returning NULL
Waking up in 6 seconds...
rad_recv: Accounting-Request packet from host 62.1.32.7:1646, id=251, length=210
NAS-IP-Address = 62.1.32.7
NAS-Port = 1
NAS-Port-Type = ISDN-V120
User-Name = "[EMAIL PROTECTED]"
Calling-Station-Id = "xxxxxxxxxx"
Acct-Status-Type = Stop
Acct-Authentic = RADIUS
Service-Type = Framed-User
Acct-Session-Id = "0000002D"
Framed-Protocol = PPP
Tunnel-Client-Endpoint:0 = "xxx.xxx.xxx.xxx"
Acct-Tunnel-Connection = "130029855"
Acct-Terminate-Cause = Lost-Carrier
Acct-Input-Octets = 0
Acct-Output-Octets = 0
Acct-Input-Packets = 0
Acct-Output-Packets = 0
Acct-Session-Time = 0
Tunnel-Client-Endpoint:0 = "xxx.xxx.xxx.xxx"
Acct-Tunnel-Connection = "130029855"
Acct-Delay-Time = 5
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 = "0000002D",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: 'UPDATE radacct SET AcctStopTime = '2004-07-08 16:16:51',
AcctSessionTime = '0', AcctInputOctets = '0', AcctOutputOctets = '0',
AcctTerminateCause = 'Lost-Carrier', AcctStopDelay = '5', ConnectInfo_stop = '' WHERE
AcctSessionId = '0000002D' AND UserName = '[EMAIL PROTECTED]' AND NASIPAddress =
'62.1.32.7' AND AcctStopTime = 0'
rlm_sql (sql): Reserving sql socket id: 1
radius_xlat: 'rlm_sql: Stop packet with zero session length. (user '[EMAIL
PROTECTED]', nas '62.1.32.7')'
rlm_sql: Stop packet with zero session length. (user '[EMAIL PROTECTED]', nas
'62.1.32.7')
rlm_sql (sql): Released sql socket id: 1
modcall[accounting]: module "sql" returns noop
radius_xlat: '[EMAIL PROTECTED]'
modcall[accounting]: module "radutmp" returns ok
modcall: group accounting returns ok
Sending Accounting-Response of id 251 to 62.1.32.7:1646
Finished request 3
Going to the next request
--- Walking the entire request list ---
Cleaning up request 3 ID 251 with timestamp 40ed02f3
Waking up in 1 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 248 with timestamp 40ed02ee
Nothing to do. Sleeping until we see a request.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
