Dear Hugh, Attached are the file of my both configuration & log file.
My problem is I am getting connection successfully but for every connection it is not insert record in radonline table which is enabling multiple logins. Regards, AbdusSami
EXPIRY=1034842169, USERNAME='tsq09976' where YIADDR='212.24.246.33
' and TIME_STAMP =1034624194
Wed Oct 16 15:45:39 2002: DEBUG: Access accepted for tsq09976
Wed Oct 16 15:45:39 2002: DEBUG: Packet dump:
*** Sending to 212.26.73.61 port 1645 ....
Code: Access-Accept
Identifier: 63
Authentic: @<237>Ogf<140>K<206><154><186>\<152><187><248>af
Attributes:
Session-Timeout = 33830
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-IP-Address = 212.24.246.33
Wed Oct 16 15:45:39 2002: DEBUG: Packet dump:
*** Received from 212.26.73.61 port 1645 ....
Code: Access-Request
Identifier: 63
Authentic: @<237>Ogf<140>K<206><154><186>\<152><187><248>af
Attributes:
NAS-IP-Address = 212.26.73.61
NAS-Port = 2
NAS-Port-Type = Async
User-Name = "tsq09976"
Called-Station-Id = "5060"
Calling-Station-Id = "14627870"
User-Password =
"<27><2><236><25><159>2<241><255><12>A<250><179><206>x<149><205>"
Service-Type = Framed-User
Framed-Protocol = PPP
Wed Oct 16 15:45:39 2002: DEBUG: Handling request with Handler ''
Wed Oct 16 15:45:39 2002: DEBUG: SDB1 Deleting session for tsq09976, 212.26.73.61, 2
Wed Oct 16 15:45:39 2002: DEBUG: do query is: DELETE FROM RADONLINE WHERE
ACCTSESSIONID like '' AND UserName like 'tsq09976'
Wed Oct 16 15:45:39 2002: DEBUG: Query is: select NASIDENTIFIER, NASPORT,
ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where USERNAME='tsq09976'
Wed Oct 16 15:45:39 2002: DEBUG: Handling with Radius::AuthSQL
Wed Oct 16 15:45:39 2002: DEBUG: Handling with Radius::AuthSQL: Check_tasweeq_SQL
Wed Oct 16 15:45:39 2002: DEBUG: Query is: select password, timeleft from Cards where
status = 'A' and username like 'tsq09976' and timeleft > 0
Wed Oct 16 15:45:39 2002: DEBUG: Radius::AuthSQL looks for match with tsq09976
Wed Oct 16 15:45:39 2002: DEBUG: Radius::AuthSQL ACCEPT:
Wed Oct 16 15:45:39 2002: DEBUG: Handling with Radius::AuthDYNADDRESS
Wed Oct 16 15:45:39 2002: DEBUG: Query is: select TIME_STAMP, YIADDR, SUBNETMASK,
DNSSERVER from RADPOOL
where POOL='TASNAS01' and STATE=0 order by TIME_STAMP
Wed Oct 16 15:45:40 2002: DEBUG: do query is: update RADPOOL set STATE=1,
TIME_STAMP=1034808339,
EXPIRY=1034842169, USERNAME='tsq09976' where YIADDR='212.24.246.34
' and TIME_STAMP =1034624194
Wed Oct 16 15:45:40 2002: DEBUG: Access accepted for tsq09976
Wed Oct 16 15:45:40 2002: DEBUG: Packet dump:
*** Sending to 212.26.73.61 port 1645 ....
Code: Access-Accept
Identifier: 63
Authentic: @<237>Ogf<140>K<206><154><186>\<152><187><248>af
Attributes:
Session-Timeout = 33830
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-IP-Address = 212.24.246.34
Wed Oct 16 15:45:40 2002: DEBUG: Packet dump:
*** Received from 212.26.73.61 port 1645 ....
Code: Access-Request
Identifier: 63
Authentic: @<237>Ogf<140>K<206><154><186>\<152><187><248>af
Attributes:
NAS-IP-Address = 212.26.73.61
NAS-Port = 2
NAS-Port-Type = Async
User-Name = "tsq09976"
Called-Station-Id = "5060"
Calling-Station-Id = "14627870"
User-Password =
"<27><2><236><25><159>2<241><255><12>A<250><179><206>x<149><205>"
Service-Type = Framed-User
Framed-Protocol = PPP
Wed Oct 16 15:45:40 2002: DEBUG: Handling request with Handler ''
Wed Oct 16 15:45:40 2002: DEBUG: SDB1 Deleting session for tsq09976, 212.26.73.61, 2
Wed Oct 16 15:45:40 2002: DEBUG: do query is: DELETE FROM RADONLINE WHERE
ACCTSESSIONID like '' AND UserName like 'tsq09976'
Wed Oct 16 15:45:40 2002: DEBUG: Query is: select NASIDENTIFIER, NASPORT,
ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where USERNAME='tsq09976'
Wed Oct 16 15:45:40 2002: DEBUG: Handling with Radius::AuthSQL
Wed Oct 16 15:45:40 2002: DEBUG: Handling with Radius::AuthSQL: Check_tasweeq_SQL
Wed Oct 16 15:45:40 2002: DEBUG: Query is: select password, timeleft from Cards where
status = 'A' and username like 'tsq09976' and timeleft > 0
Wed Oct 16 15:45:40 2002: DEBUG: Radius::AuthSQL looks for match with tsq09976
Wed Oct 16 15:45:40 2002: DEBUG: Radius::AuthSQL ACCEPT:
Wed Oct 16 15:45:40 2002: DEBUG: Handling with Radius::AuthDYNADDRESS
Wed Oct 16 15:45:40 2002: DEBUG: Query is: select TIME_STAMP, YIADDR, SUBNETMASK,
DNSSERVER from RADPOOL
where POOL='TASNAS01' and STATE=0 order by TIME_STAMP
Wed Oct 16 15:45:40 2002: DEBUG: do query is: update RADPOOL set STATE=1,
TIME_STAMP=1034808340,
EXPIRY=1034842170, USERNAME='tsq09976' where YIADDR='212.24.246.35
' and TIME_STAMP =1034624194
Wed Oct 16 15:45:40 2002: DEBUG: Access accepted for tsq09976
Wed Oct 16 15:45:40 2002: DEBUG: Packet dump:
*** Sending to 212.26.73.61 port 1645 ....
Code: Access-Accept
Identifier: 63
Authentic: @<237>Ogf<140>K<206><154><186>\<152><187><248>af
Attributes:
Session-Timeout = 33830
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-IP-Address = 212.24.246.35
Wed Oct 16 15:45:40 2002: DEBUG: Packet dump:
*** Received from 212.26.73.61 port 1646 ....
Code: Accounting-Request
Identifier: 64
Authentic: 9<242>%g<19><189><14>"<12><147><133><22>S|<137><
Attributes:
NAS-IP-Address = 212.26.73.61
NAS-Port = 2
NAS-Port-Type = Async
User-Name = "tsq09976"
Called-Station-Id = "5060"
Calling-Station-Id = "14627870"
Acct-Status-Type = Start
Acct-Authentic = RADIUS
Service-Type = Framed-User
Acct-Session-Id = "0000000F"
Framed-Protocol = PPP
Tunnel-Server-Endpoint = 50:12.24.246.1
Tunnel-Client-Endpoint = 49:92.168.224.1
Tunnel-Client-Auth-ID = 116:asweeq
Tunnel-Server-Auth-ID = 105:net-ula-tnt1
Tunnel-ID = 49:67926667
Acct-Delay-Time = 0
Wed Oct 16 15:45:40 2002: DEBUG: Handling request with Handler 'Request-Type =
Accounting-Request'
Wed Oct 16 15:45:40 2002: DEBUG: SDB1 Adding session for tsq09976, 212.26.73.61, 2
Wed Oct 16 15:45:40 2002: DEBUG: do query is: DELETE FROM RADONLINE WHERE
ACCTSESSIONID like '0000000F' AND UserName like 'tsq09976'
Wed Oct 16 15:45:40 2002: DEBUG: do query is: insert into RADONLINE (USERNAME,
NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE,
SERVICETYPE, datetime) values ('tsq09976', '212.26.73.61', 2, '0000000F', 1034808340,
'', '', 'Framed-User', getdate())
Wed Oct 16 15:45:40 2002: DEBUG: Handling with Radius::AuthSQL
Wed Oct 16 15:45:40 2002: DEBUG: Handling accounting with Radius::AuthSQL
Wed Oct 16 15:45:40 2002: DEBUG: Handling with Radius::AuthDYNADDRESS
Wed Oct 16 15:45:40 2002: DEBUG: Accounting accepted
Wed Oct 16 15:45:40 2002: DEBUG: Packet dump:
*** Sending to 212.26.73.61 port 1646 ....
Code: Accounting-Response
Identifier: 64
Authentic: 9<242>%g<19><189><14>"<12><147><133><22>S|<137><
Attributes:
tasweeq for hugh.cfg
Description: Binary data
