Hi again,
The file "detail-20031229" contains :
------------------------------------------------------------------------
Mon Dec 29 19:18:57 2003
Event-Timestamp = "Dec 29 2003"
User-Name = "[EMAIL PROTECTED]"
NAS-IP-Address = 217.66.112.153
NAS-Identifier = "tnt-TH2-1.b3g-telecom.com"
NAS-Port = 4099
NAS-Port-Type = Async
Service-Type = Framed-User
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "433984411"
Acct-Authentic = RADIUS
X-Ascend-Modem-PortNo = 94
X-Ascend-Modem-SlotNo = 7
X-Ascend-Modem-ShelfNo = 1
Calling-Station-Id = "565382425"
Called-Station-Id = "0860463314"
Framed-Protocol = PPP
Framed-IP-Address = 217.66.114.164
Proxy-State = 0x323039
Client-IP-Address = 217.66.113.2
Acct-Unique-Session-Id = "55b304c1a31aabed"
Timestamp = 1072721937
Mon Dec 29 19:21:35 2003
Event-Timestamp = "Dec 29 2003"
User-Name = "[EMAIL PROTECTED]"
NAS-IP-Address = 217.66.112.153
NAS-Identifier = "tnt-TH2-1.b3g-telecom.com"
NAS-Port = 4099
NAS-Port-Type = Async
Service-Type = Framed-User
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "433984411"
Acct-Authentic = RADIUS
Acct-Session-Time = 157
Acct-Input-Octets = 48610
Acct-Output-Octets = 85573
Acct-Input-Packets = 610
Acct-Output-Packets = 532
X-Ascend-Disconnect-Cause = 45
X-Ascend-Connect-Progress = 60
X-Ascend-Data-Rate = 28800
X-Ascend-PreSession-Time = 36
X-Ascend-Pre-Input-Octets = 386
X-Ascend-Pre-Output-Octets = 310
X-Ascend-Pre-Input-Packets = 15
X-Ascend-Pre-Output-Packets = 14
X-Ascend-First-Dest = 255.255.255.255
X-Ascend-Xmit-Rate = 28800
X-Ascend-Modem-PortNo = 94
X-Ascend-Modem-SlotNo = 7
X-Ascend-Modem-ShelfNo = 1
Calling-Station-Id = "565382425"
Called-Station-Id = "0860463314"
Framed-Protocol = PPP
Framed-IP-Address = 217.66.114.164
Proxy-State = 0x323135
Client-IP-Address = 217.66.113.2
Acct-Unique-Session-Id = "55b304c1a31aabed"
Timestamp = 1072722095
------------------------------------------------------------------------
The file "radiusd.out" contains :
------------------------------------------------------------------------
rad_recv: Access-Request packet from host 217.66.113.2:1814, id=6,
length=257
User-Name = "[EMAIL PROTECTED]"
CHAP-Password = 0x01278a9e9d5f474d1081fdb1e2d62d2dda
NAS-IP-Address = 217.66.112.153
NAS-Identifier = "tnt-TH2-1.b3g-telecom.com"
NAS-Port = 4099
Ascend-NAS-Port-Format = 2_4_5_5
NAS-Port-Type = Async
Service-Type = Framed-User
Framed-Protocol = PPP
Calling-Station-Id = "565382425"
Ascend-Calling-Id-Type-Of-Num = National-Number
Ascend-Calling-Id-Number-Plan = ISDN-Telephony
Ascend-Calling-Id-Presentatn = Allowed
Ascend-Calling-Id-Screening = Network-Provided
Called-Station-Id = "0860463314"
Acct-Session-Id = "433984411"
Ascend-Data-Rate = 28800
Ascend-Xmit-Rate = 28800
CHAP-Challenge = 0xd6f88b9ba5a8dc0ac98c2783cc0b5f2c
Proxy-State = 0x313734
rad_lowerpair: User-Name now '[EMAIL PROTECTED]'
rad_rmspace_pair: User-Name now '[EMAIL PROTECTED]'
modcall: entering group authorize for request 0
modcall[authorize]: module "preprocess" returns ok for request 0
radius_xlat: '/var/log/radius/radacct/217.66.113.2/auth-detail-20031229'
rlm_detail: /var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d
expands to /var/log/radius/radacct/217.66.113.2/auth-detail-20031229
modcall[authorize]: module "auth_log" returns ok for request 0
users: Matched DEFAULT at 171
users: Matched DEFAULT at 183
modcall[authorize]: module "files" returns ok for request 0
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
rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM radcheck
WHERE Username = '[EMAIL PROTECTED]' ORDER BY id
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = '[EMAIL PROTECTED]' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
rlm_sql_mysql: query: SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.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'
rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM radreply
WHERE Username = '[EMAIL PROTECTED]' ORDER BY id
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = '[EMAIL PROTECTED]' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql_mysql: query: SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.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 for request 0
modcall: group authorize returns ok for request 0
auth: type Local
auth: user supplied CHAP-Password matches local User-Password
modcall: entering group session for request 0
modcall[session]: module "sql" returns noop for request 0
modcall: group session returns noop for request 0
radius_xlat: 'Bienvenue chez Erevia'
Login OK: [EMAIL PROTECTED]/<CHAP-Password>] (from client NAS2_B3G port
4099 cli 565382425)
Sending Access-Accept of id 6 to 217.66.113.2:1814
Framed-IP-Address = 255.255.255.254
Framed-MTU = 576
Framed-Routing := None
Framed-IP-Netmask := 255.255.255.255
Ascend-Idle-Limit := 600
Ascend-Send-Auth := Send-Auth-None
Ascend-Assign-IP-Pool := 0
Reply-Message := "Bienvenue chez Erevia"
Framed-Compression := Van-Jacobson-TCP-IP
Framed-Protocol := PPP
Service-Type := Framed-User
Proxy-State = 0x313734
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 217.66.113.2:1814, id=7,
length=186
Event-Timestamp = "Dec 29 2003"
User-Name = "[EMAIL PROTECTED]"
NAS-IP-Address = 217.66.112.153
NAS-Identifier = "tnt-TH2-1.b3g-telecom.com"
NAS-Port = 4099
NAS-Port-Type = Async
Service-Type = Framed-User
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "433984411"
Acct-Authentic = RADIUS
X-Ascend-Modem-PortNo = 94
X-Ascend-Modem-SlotNo = 7
X-Ascend-Modem-ShelfNo = 1
Calling-Station-Id = "565382425"
Called-Station-Id = "0860463314"
Framed-Protocol = PPP
Framed-IP-Address = 217.66.114.164
Proxy-State = 0x323039
rad_lowerpair: User-Name now '[EMAIL PROTECTED]'
rad_rmspace_pair: User-Name now '[EMAIL PROTECTED]'
modcall: entering group preacct for request 1
modcall[preacct]: module "preprocess" returns noop for request 1
modcall[preacct]: module "files" returns noop for request 1
modcall: group preacct returns noop for request 1
modcall: entering group accounting for request 1
rlm_acct_unique: Hashing 'NAS-Port = 4099,NAS-IP-Address =
217.66.112.153,Acct-Session-Id = "433984411",User-Name =
"[EMAIL PROTECTED]"'
rlm_acct_unique: Acct-Unique-Session-ID = "55b304c1a31aabed".
modcall[accounting]: module "acct_unique" returns ok for request 1
radius_xlat: '/var/log/radius/radacct/217.66.113.2/detail-20031229'
rlm_detail: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d
expands to /var/log/radius/radacct/217.66.113.2/detail-20031229
modcall[accounting]: module "detail" returns ok for request 1
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('', '433984411',
'55b304c1a31aabed', '[EMAIL PROTECTED]', '', '217.66.112.153', '4099',
'Async', '2003-12-29 19:18:57', '0', '0', 'RADIUS', '', '', '0', '0',
'0860463314', '565382425', '', 'Framed-User', 'PPP', '217.66.114.164', '0',
'0')'
radius_xlat: '/var/log/radius/sqltrace.sql'
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql_mysql: query: 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('',
'433984411', '55b304c1a31aabed', '[EMAIL PROTECTED]', '', '217.66.112.153',
'4099', 'Async', '2003-12-29 19:18:57', '0', '0', 'RADIUS', '', '', '0',
'0', '0860463314', '565382425', '', 'Framed-User', 'PPP', '217.66.114.164',
'0', '0')
rlm_sql (sql): Released sql socket id: 3
modcall[accounting]: module "sql" returns ok for request 1
modcall: group accounting returns ok for request 1
Sending Accounting-Response of id 7 to 217.66.113.2:1814
Proxy-State = 0x323039
Finished request 1
Going to the next request
Waking up in 6 seconds...
rad_recv: Accounting-Request packet from host 217.66.113.1:1814, id=199,
length=262
Event-Timestamp = "Dec 29 2003"
User-Name = "[EMAIL PROTECTED]"
NAS-IP-Address = 217.66.112.153
NAS-Identifier = "tnt-TH2-1.b3g-telecom.com"
Ascend-Owner-IP-Addr = 0.0.0.0
NAS-Port = 4099
Ascend-NAS-Port-Format = 2_4_5_5
NAS-Port-Type = Async
Service-Type = Framed-User
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "433984411"
Acct-Authentic = RADIUS
Ascend-Auth-Delay = 200
Ascend-Modem-PortNo = 94
Ascend-Modem-SlotNo = 7
Ascend-Modem-ShelfNo = 1
Calling-Station-Id = "565382425"
Called-Station-Id = "0860463314"
Framed-Protocol = PPP
Framed-IP-Address = 217.66.114.164
Ascend-Call-Direction = Ascend-Call-Direction-Incoming
Ascend-Service-Type = Ascend-Service-Type-PPP
Proxy-State = 0x323130
rad_lowerpair: User-Name now '[EMAIL PROTECTED]'
rad_rmspace_pair: User-Name now '[EMAIL PROTECTED]'
modcall: entering group preacct for request 2
modcall[preacct]: module "preprocess" returns noop for request 2
modcall[preacct]: module "files" returns noop for request 2
modcall: group preacct returns noop for request 2
modcall: entering group accounting for request 2
rlm_acct_unique: Hashing 'NAS-Port = 4099,NAS-IP-Address =
217.66.112.153,Acct-Session-Id = "433984411",User-Name =
"[EMAIL PROTECTED]"'
rlm_acct_unique: Acct-Unique-Session-ID = "55b304c1a31aabed".
modcall[accounting]: module "acct_unique" returns ok for request 2
radius_xlat: '/var/log/radius/radacct/217.66.113.1/detail-20031229'
rlm_detail: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d
expands to /var/log/radius/radacct/217.66.113.1/detail-20031229
modcall[accounting]: module "detail" returns ok for request 2
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('', '433984411',
'55b304c1a31aabed', '[EMAIL PROTECTED]', '', '217.66.112.153', '4099',
'Async', '2003-12-29 19:18:58', '0', '0', 'RADIUS', '', '', '0', '0',
'0860463314', '565382425', '', 'Framed-User', 'PPP', '217.66.114.164', '0',
'0')'
radius_xlat: '/var/log/radius/sqltrace.sql'
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql_mysql: query: 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('',
'433984411', '55b304c1a31aabed', '[EMAIL PROTECTED]', '', '217.66.112.153',
'4099', 'Async', '2003-12-29 19:18:58', '0', '0', 'RADIUS', '', '', '0',
'0', '0860463314', '565382425', '', 'Framed-User', 'PPP', '217.66.114.164',
'0', '0')
rlm_sql (sql): Released sql socket id: 2
modcall[accounting]: module "sql" returns ok for request 2
modcall: group accounting returns ok for request 2
Sending Accounting-Response of id 199 to 217.66.113.1:1814
Proxy-State = 0x323130
Finished request 2
Going to the next request
--- Walking the entire request list ---
Waking up in 5 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 6 with timestamp 3ff07011
Cleaning up request 1 ID 7 with timestamp 3ff07011
Waking up in 1 seconds...
--- Walking the entire request list ---
Cleaning up request 2 ID 199 with timestamp 3ff07012
Nothing to do. Sleeping until we see a request.
rad_recv: Accounting-Request packet from host 217.66.113.2:1814, id=11,
length=276
Event-Timestamp = "Dec 29 2003"
User-Name = "[EMAIL PROTECTED]"
NAS-IP-Address = 217.66.112.153
NAS-Identifier = "tnt-TH2-1.b3g-telecom.com"
NAS-Port = 4099
NAS-Port-Type = Async
Service-Type = Framed-User
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "433984411"
Acct-Authentic = RADIUS
Acct-Session-Time = 157
Acct-Input-Octets = 48610
Acct-Output-Octets = 85573
Acct-Input-Packets = 610
Acct-Output-Packets = 532
X-Ascend-Disconnect-Cause = 45
X-Ascend-Connect-Progress = 60
X-Ascend-Data-Rate = 28800
X-Ascend-PreSession-Time = 36
X-Ascend-Pre-Input-Octets = 386
X-Ascend-Pre-Output-Octets = 310
X-Ascend-Pre-Input-Packets = 15
X-Ascend-Pre-Output-Packets = 14
X-Ascend-First-Dest = 255.255.255.255
X-Ascend-Xmit-Rate = 28800
X-Ascend-Modem-PortNo = 94
X-Ascend-Modem-SlotNo = 7
X-Ascend-Modem-ShelfNo = 1
Calling-Station-Id = "565382425"
Called-Station-Id = "0860463314"
Framed-Protocol = PPP
Framed-IP-Address = 217.66.114.164
Proxy-State = 0x323135
rad_lowerpair: User-Name now '[EMAIL PROTECTED]'
rad_rmspace_pair: User-Name now '[EMAIL PROTECTED]'
modcall: entering group preacct for request 3
modcall[preacct]: module "preprocess" returns noop for request 3
modcall[preacct]: module "files" returns noop for request 3
modcall: group preacct returns noop for request 3
modcall: entering group accounting for request 3
rlm_acct_unique: Hashing 'NAS-Port = 4099,NAS-IP-Address =
217.66.112.153,Acct-Session-Id = "433984411",User-Name =
"[EMAIL PROTECTED]"'
rlm_acct_unique: Acct-Unique-Session-ID = "55b304c1a31aabed".
modcall[accounting]: module "acct_unique" returns ok for request 3
radius_xlat: '/var/log/radius/radacct/217.66.113.2/detail-20031229'
rlm_detail: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d
expands to /var/log/radius/radacct/217.66.113.2/detail-20031229
modcall[accounting]: module "detail" returns ok for request 3
radius_xlat: '[EMAIL PROTECTED]'
rlm_sql (sql): sql_set_user escaped user --> '[EMAIL PROTECTED]'
radius_xlat: 'UPDATE radacct SET AcctStopTime = '2003-12-29 19:21:35',
AcctSessionTime = '157', AcctInputOctets = '48610', AcctOutputOctets =
'85573', AcctTerminateCause = '', AcctStopDelay = '0', ConnectInfo_stop = ''
WHERE AcctSessionId = '433984411' AND UserName = '[EMAIL PROTECTED]' AND
NASIPAddress = '217.66.112.153' AND AcctStopTime = 0'
radius_xlat: '/var/log/radius/sqltrace.sql'
rlm_sql (sql): Reserving sql socket id: 1
rlm_sql_mysql: query: UPDATE radacct SET AcctStopTime = '2003-12-29
19:21:35', AcctSessionTime = '157', AcctInputOctets = '48610',
AcctOutputOctets = '85573', AcctTerminateCause = '', AcctStopDelay = '0',
ConnectInfo_stop = '' WHERE AcctSessionId = '433984411' AND UserName =
'[EMAIL PROTECTED]' AND NASIPAddress = '217.66.112.153' AND AcctStopTime =
0
rlm_sql (sql): Released sql socket id: 1
modcall[accounting]: module "sql" returns ok for request 3
modcall: group accounting returns ok for request 3
Sending Accounting-Response of id 11 to 217.66.113.2:1814
Proxy-State = 0x323135
Finished request 3
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
rad_recv: Accounting-Request packet from host 217.66.113.1:1814, id=181,
length=412
Event-Timestamp = "Dec 29 2003"
User-Name = "[EMAIL PROTECTED]"
NAS-IP-Address = 217.66.112.153
NAS-Identifier = "tnt-TH2-1.b3g-telecom.com"
Ascend-Owner-IP-Addr = 0.0.0.0
NAS-Port = 4099
Ascend-NAS-Port-Format = 2_4_5_5
NAS-Port-Type = Async
Service-Type = Framed-User
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "433984411"
Acct-Authentic = RADIUS
Ascend-Auth-Delay = 200
Acct-Session-Time = 157
Acct-Input-Octets = 48610
Acct-Output-Octets = 85573
Acct-Input-Packets = 610
Acct-Output-Packets = 532
Ascend-Disconnect-Cause = PPP-Rcv-Terminate-Req
Ascend-Connect-Progress = LAN-Session-Up
Ascend-Data-Rate = 28800
Ascend-PreSession-Time = 36
Ascend-Pre-Input-Octets = 386
Ascend-Pre-Output-Octets = 310
Ascend-Pre-Input-Packets = 15
Ascend-Pre-Output-Packets = 14
Ascend-First-Dest = 255.255.255.255
Ascend-Xmit-Rate = 28800
Ascend-Modem-PortNo = 94
Ascend-Modem-SlotNo = 7
Ascend-Modem-ShelfNo = 1
Calling-Station-Id = "565382425"
Called-Station-Id = "0860463314"
Framed-Protocol = PPP
Framed-IP-Address = 217.66.114.164
Ascend-Call-Direction = Ascend-Call-Direction-Incoming
Ascend-Service-Type = Ascend-Service-Type-PPP
Proxy-State = 0x323136
rad_lowerpair: User-Name now '[EMAIL PROTECTED]'
rad_rmspace_pair: User-Name now '[EMAIL PROTECTED]'
modcall: entering group preacct for request 4
modcall[preacct]: module "preprocess" returns noop for request 4
modcall[preacct]: module "files" returns noop for request 4
modcall: group preacct returns noop for request 4
modcall: entering group accounting for request 4
rlm_acct_unique: Hashing 'NAS-Port = 4099,NAS-IP-Address =
217.66.112.153,Acct-Session-Id = "433984411",User-Name =
"[EMAIL PROTECTED]"'
rlm_acct_unique: Acct-Unique-Session-ID = "55b304c1a31aabed".
modcall[accounting]: module "acct_unique" returns ok for request 4
radius_xlat: '/var/log/radius/radacct/217.66.113.1/detail-20031229'
rlm_detail: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d
expands to /var/log/radius/radacct/217.66.113.1/detail-20031229
modcall[accounting]: module "detail" returns ok for request 4
radius_xlat: '[EMAIL PROTECTED]'
rlm_sql (sql): sql_set_user escaped user --> '[EMAIL PROTECTED]'
radius_xlat: 'UPDATE radacct SET AcctStopTime = '2003-12-29 19:21:35',
AcctSessionTime = '157', AcctInputOctets = '48610', AcctOutputOctets =
'85573', AcctTerminateCause = '', AcctStopDelay = '0', ConnectInfo_stop = ''
WHERE AcctSessionId = '433984411' AND UserName = '[EMAIL PROTECTED]' AND
NASIPAddress = '217.66.112.153' AND AcctStopTime = 0'
radius_xlat: '/var/log/radius/sqltrace.sql'
rlm_sql (sql): Reserving sql socket id: 0
rlm_sql_mysql: query: UPDATE radacct SET AcctStopTime = '2003-12-29
19:21:35', AcctSessionTime = '157', AcctInputOctets = '48610',
AcctOutputOctets = '85573', AcctTerminateCause = '', AcctStopDelay = '0',
ConnectInfo_stop = '' WHERE AcctSessionId = '433984411' AND UserName =
'[EMAIL PROTECTED]' AND NASIPAddress = '217.66.112.153' AND AcctStopTime =
0
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('', '433984411',
'55b304c1a31aabed', '[EMAIL PROTECTED]', '', '217.66.112.153', '4099',
'Async', DATE_SUB('2003-12-29 19:21:35',INTERVAL (157 + 0) SECOND),
'2003-12-29 19:21:35', '157', 'RADIUS', '', '', '48610', '85573',
'0860463314', '565382425', '', 'Framed-User', 'PPP', '217.66.114.164', '0',
'0')'
radius_xlat: '/var/log/radius/sqltrace.sql'
rlm_sql_mysql: query: 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('',
'433984411', '55b304c1a31aabed', '[EMAIL PROTECTED]', '', '217.66.112.153',
'4099', 'Async', DATE_SUB('2003-12-29 19:21:35',INTERVAL (157 + 0) SECOND),
'2003-12-29 19:21:35', '157', 'RADIUS', '', '', '48610', '85573',
'0860463314', '565382425', '', 'Framed-User', 'PPP', '217.66.114.164', '0',
'0')
rlm_sql (sql): Released sql socket id: 0
modcall[accounting]: module "sql" returns ok for request 4
modcall: group accounting returns ok for request 4
Sending Accounting-Response of id 181 to 217.66.113.1:1814
Proxy-State = 0x323136
Finished request 4
Going to the next request
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 3 ID 11 with timestamp 3ff070af
Cleaning up request 4 ID 181 with timestamp 3ff070af
Nothing to do. Sleeping until we see a request.
------------------------------------------------------------------------
Thanks a lot for explaining to me where the matter is
Antoine Cavalié
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
