(RADIATOR) Maximum Session
Mohammed Adam
adam at kccg.com
Tue Jun 12 10:51:52 CDT 2001
Hell All
Maximum session doesnt work with me, i think the problem is in RADONLINE inserinto but i couldnt find out why.
CFG File:
<SessionDatabase SQL>
#Identifier OnlineUsers
DBSource dbi:ODBC:MDBTest
DBUsername
DBAuth
AddQuery insert into RADONLINE \
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, SERVICETYPE, CALLEDSID) \
values \
('%n', '%N', %{NAS-Port}, '%{Acct-Session-Id}', %{Timestamp}, '%{Port-Type}', '%{Service-Type}', '%{Called-Station-Id}')
</SessionDatabase>
<Realm>
-------------------------------------------------
Log File
Tue Jun 12 13:11:07 2001: ERR: Could not open dictionary file 'd:\radiator-demo-2.18\dictionary.cisco': No such file or directory
Tue Jun 12 13:11:26 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4815 ....
Code: Access-Request
Identifier: 20
Authentic: 1234567890123456
Attributes:
User-Name = "ray"
Service-Type = Framed
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
NAS-Port-Type = Async
User-Password = "<205><184>m<156><175>\<4><246><188>8<9><160><216>}x<153>"
Tue Jun 12 13:11:29 2001: DEBUG: Handling request with Handler 'Realm='
Tue Jun 12 13:11:29 2001: DEBUG: Deleting session for ray, 203.63.154.1, 1234
Tue Jun 12 13:11:30 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Tue Jun 12 13:11:31 2001: ERR: Could not open dictionary file 'd:\radiator-demo-2.18\dictionary.cisco': No such file or directory
Tue Jun 12 13:11:33 2001: DEBUG: Query is: select NASIDENTIFIER, NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where USERNAME='ray'
Tue Jun 12 13:11:34 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:11:34 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:11:34 2001: DEBUG: Query is: select Password,BalanceTime from Authentication where USERNAME='ray' And ((BalanceTime > 0 And Type='H') or Type='P')
Tue Jun 12 13:11:34 2001: DEBUG: Radius::AuthSQL looks for match with ray
Tue Jun 12 13:11:34 2001: DEBUG: Radius::AuthSQL ACCEPT:
Tue Jun 12 13:11:34 2001: DEBUG: Access accepted for ray
Tue Jun 12 13:11:34 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 4815 ....
Code: Access-Accept
Identifier: 20
Authentic: 1234567890123456
Attributes:
Service-Type = Framed
Framed-Protocol = PPP
Tue Jun 12 13:11:34 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4815 ....
Code: Accounting-Request
Identifier: 21
Authentic: <246><200>*<172><149><4>\V<241>B)~<228>}<13><198>
Attributes:
User-Name = "ray"
Service-Type = Framed
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Start
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
Tue Jun 12 13:11:34 2001: DEBUG: Handling request with Handler 'Realm='
Tue Jun 12 13:11:34 2001: DEBUG: Adding session for ray, 203.63.154.1, 1234
Tue Jun 12 13:11:34 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Tue Jun 12 13:11:34 2001: DEBUG: do query is: insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) values ('ray', '203.63.154.1', 1234, '00001234', 992340694, #'', '', 'Framed', '123456789')
Tue Jun 12 13:11:35 2001: ERR: do failed for 'insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) values ('ray', '203.63.154.1', 1234, '00001234', 992340694, #'', '', 'Framed', '123456789')': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
Tue Jun 12 13:11:38 2001: ERR: do failed for 'insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) values ('ray', '203.63.154.1', 1234, '00001234', 992340694, #'', '', 'Framed', '123456789')': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
Tue Jun 12 13:11:38 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:11:38 2001: DEBUG: Handling accounting with Radius::AuthSQL
Tue Jun 12 13:11:38 2001: DEBUG: Accounting accepted
Tue Jun 12 13:11:38 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 4815 ....
Code: Accounting-Response
Identifier: 21
Authentic: <246><200>*<172><149><4>\V<241>B)~<228>}<13><198>
Attributes:
Tue Jun 12 13:11:38 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4815 ....
Code: Accounting-Request
Identifier: 22
Authentic: 8P<245>;<4>:i(<224><185><128><186>eP<187><250>
Attributes:
User-Name = "ray"
Service-Type = Framed
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Stop
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
Acct-Delay-Time = 0
Acct-Session-Time = 1000
Acct-Input-Octets = 20000
Acct-Output-Octets = 30000
Tue Jun 12 13:11:38 2001: DEBUG: Handling request with Handler 'Realm='
Tue Jun 12 13:11:39 2001: DEBUG: Deleting session for ray, 203.63.154.1, 1234
Tue Jun 12 13:11:39 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Tue Jun 12 13:11:39 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:11:39 2001: DEBUG: Handling accounting with Radius::AuthSQL
Tue Jun 12 13:11:39 2001: DEBUG: do query is: update Authentication set BalanceTime = (BalanceTime)-01000 where USERNAME = 'ray'
Tue Jun 12 13:11:39 2001: DEBUG: do query is: insert into Accounting
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctInputOctets, AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPort)
values
('ray', 'Jun 12, 2001 13:11', 2, 0, 20000, 30000, '00001234', 1000, '203.63.154.1', 1234)
Tue Jun 12 13:11:39 2001: DEBUG: Accounting accepted
Tue Jun 12 13:11:39 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 4815 ....
Code: Accounting-Response
Identifier: 22
Authentic: 8P<245>;<4>:i(<224><185><128><186>eP<187><250>
Attributes:
Tue Jun 12 13:11:55 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4817 ....
Code: Access-Request
Identifier: 53
Authentic: 1234567890123456
Attributes:
User-Name = "ray"
Service-Type = Framed
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
NAS-Port-Type = Async
User-Password = "<205><184>m<156><175>\<4><246><188>8<9><160><216>}x<153>"
Tue Jun 12 13:11:55 2001: DEBUG: Handling request with Handler 'Realm='
Tue Jun 12 13:11:55 2001: DEBUG: Deleting session for ray, 203.63.154.1, 1234
Tue Jun 12 13:11:55 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Tue Jun 12 13:11:55 2001: DEBUG: Query is: select NASIDENTIFIER, NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where USERNAME='ray'
Tue Jun 12 13:11:55 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:11:55 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:11:55 2001: DEBUG: Query is: select Password,BalanceTime from Authentication where USERNAME='ray' And ((BalanceTime > 0 And Type='H') or Type='P')
Tue Jun 12 13:11:55 2001: ERR: Could not open dictionary file 'd:\radiator-demo-2.18\dictionary.cisco': No such file or directory
Tue Jun 12 13:11:56 2001: DEBUG: Radius::AuthSQL looks for match with ray
Tue Jun 12 13:11:56 2001: DEBUG: Radius::AuthSQL ACCEPT:
Tue Jun 12 13:11:56 2001: DEBUG: Access accepted for ray
Tue Jun 12 13:11:56 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 4817 ....
Code: Access-Accept
Identifier: 53
Authentic: 1234567890123456
Attributes:
Service-Type = Framed
Framed-Protocol = PPP
Tue Jun 12 13:11:56 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4817 ....
Code: Accounting-Request
Identifier: 54
Authentic: <227>-<132><137><204><213><190><251><29><151>@<6>^<31><189><211>
Attributes:
User-Name = "ray"
Service-Type = Framed
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Start
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
Tue Jun 12 13:11:56 2001: DEBUG: Handling request with Handler 'Realm='
Tue Jun 12 13:11:56 2001: DEBUG: Adding session for ray, 203.63.154.1, 1234
Tue Jun 12 13:11:56 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Tue Jun 12 13:11:56 2001: DEBUG: do query is: insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) values ('ray', '203.63.154.1', 1234, '00001234', 992340716, #'', '', 'Framed', '123456789')
Tue Jun 12 13:11:56 2001: ERR: do failed for 'insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) values ('ray', '203.63.154.1', 1234, '00001234', 992340716, #'', '', 'Framed', '123456789')': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
Tue Jun 12 13:11:56 2001: ERR: do failed for 'insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) values ('ray', '203.63.154.1', 1234, '00001234', 992340716, #'', '', 'Framed', '123456789')': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
Tue Jun 12 13:11:56 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:11:57 2001: DEBUG: Handling accounting with Radius::AuthSQL
Tue Jun 12 13:11:57 2001: DEBUG: Accounting accepted
Tue Jun 12 13:11:57 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 4817 ....
Code: Accounting-Response
Identifier: 54
Authentic: <227>-<132><137><204><213><190><251><29><151>@<6>^<31><189><211>
Attributes:
Tue Jun 12 13:11:57 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4817 ....
Code: Accounting-Request
Identifier: 55
Authentic: <131><1><158><138><204>G<238><221><224><20><2>]<130><189><202>K
Attributes:
User-Name = "ray"
Service-Type = Framed
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Stop
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
Acct-Delay-Time = 0
Acct-Session-Time = 1000
Acct-Input-Octets = 20000
Acct-Output-Octets = 30000
Tue Jun 12 13:11:57 2001: DEBUG: Handling request with Handler 'Realm='
Tue Jun 12 13:11:57 2001: DEBUG: Deleting session for ray, 203.63.154.1, 1234
Tue Jun 12 13:11:57 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Tue Jun 12 13:11:57 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:11:57 2001: DEBUG: Handling accounting with Radius::AuthSQL
Tue Jun 12 13:11:57 2001: DEBUG: do query is: update Authentication set BalanceTime = (BalanceTime)-01000 where USERNAME = 'ray'
Tue Jun 12 13:11:57 2001: DEBUG: do query is: insert into Accounting
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctInputOctets, AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPort)
values
('ray', 'Jun 12, 2001 13:11', 2, 0, 20000, 30000, '00001234', 1000, '203.63.154.1', 1234)
Tue Jun 12 13:11:57 2001: DEBUG: Accounting accepted
Tue Jun 12 13:11:57 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 4817 ....
Code: Accounting-Response
Identifier: 55
Authentic: <131><1><158><138><204>G<238><221><224><20><2>]<130><189><202>K
Attributes:
Tue Jun 12 13:12:08 2001: ERR: Could not open dictionary file 'd:\radiator-demo-2.18\dictionary.cisco': No such file or directory
Tue Jun 12 13:12:16 2001: ERR: Could not open dictionary file 'd:\radiator-demo-2.18\dictionary.cisco': No such file or directory
Tue Jun 12 13:12:27 2001: ERR: Could not open dictionary file 'd:\radiator-demo-2.18\dictionary.cisco': No such file or directory
Tue Jun 12 13:12:28 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4818 ....
Code: Access-Request
Identifier: 87
Authentic: 1234567890123456
Attributes:
User-Name = "nadia"
Service-Type = Framed
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
NAS-Port-Type = Async
User-Password = "<200><186>n<156><175>\<4><246><188>8<9><160><216>}x<153>"
Tue Jun 12 13:12:28 2001: DEBUG: Handling request with Handler 'Realm='
Tue Jun 12 13:12:28 2001: DEBUG: Deleting session for nadia, 203.63.154.1, 1234
Tue Jun 12 13:12:28 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Tue Jun 12 13:12:28 2001: DEBUG: Query is: select NASIDENTIFIER, NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where USERNAME='nadia'
Tue Jun 12 13:12:28 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:12:28 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:12:28 2001: DEBUG: Query is: select Password,BalanceTime from Authentication where USERNAME='nadia' And ((BalanceTime > 0 And Type='H') or Type='P')
Tue Jun 12 13:12:28 2001: DEBUG: Radius::AuthSQL looks for match with nadia
Tue Jun 12 13:12:28 2001: DEBUG: Query is: select Password,BalanceTime from Authentication where USERNAME='DEFAULT' And ((BalanceTime > 0 And Type='H') or Type='P')
Tue Jun 12 13:12:29 2001: INFO: Access rejected for nadia: No such user
Tue Jun 12 13:12:29 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 4818 ....
Code: Access-Reject
Identifier: 87
Authentic: 1234567890123456
Attributes:
Reply-Message = "Request Denied"
Tue Jun 12 13:12:29 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4818 ....
Code: Accounting-Request
Identifier: 88
Authentic: #<4><139><16><137><153>+n<227><155><206>(<140>|k<253>
Attributes:
User-Name = "nadia"
Service-Type = Framed
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Start
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
Tue Jun 12 13:12:29 2001: DEBUG: Handling request with Handler 'Realm='
Tue Jun 12 13:12:29 2001: DEBUG: Adding session for nadia, 203.63.154.1, 1234
Tue Jun 12 13:12:29 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Tue Jun 12 13:12:29 2001: DEBUG: do query is: insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) values ('nadia', '203.63.154.1', 1234, '00001234', 992340749, #'', '', 'Framed', '123456789')
Tue Jun 12 13:12:29 2001: ERR: do failed for 'insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) values ('nadia', '203.63.154.1', 1234, '00001234', 992340749, #'', '', 'Framed', '123456789')': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
Tue Jun 12 13:12:29 2001: ERR: do failed for 'insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) values ('nadia', '203.63.154.1', 1234, '00001234', 992340749, #'', '', 'Framed', '123456789')': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
Tue Jun 12 13:12:29 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:12:30 2001: DEBUG: Handling accounting with Radius::AuthSQL
Tue Jun 12 13:12:30 2001: DEBUG: Accounting accepted
Tue Jun 12 13:12:30 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 4818 ....
Code: Accounting-Response
Identifier: 88
Authentic: #<4><139><16><137><153>+n<227><155><206>(<140>|k<253>
Attributes:
Tue Jun 12 13:12:30 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4818 ....
Code: Accounting-Request
Identifier: 89
Authentic: ?<238><189>Xq<26>q<156>v<203><201><251><12><170><239>t
Attributes:
User-Name = "nadia"
Service-Type = Framed
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Stop
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
Acct-Delay-Time = 0
Acct-Session-Time = 1000
Acct-Input-Octets = 20000
Acct-Output-Octets = 30000
Tue Jun 12 13:12:30 2001: DEBUG: Handling request with Handler 'Realm='
Tue Jun 12 13:12:30 2001: DEBUG: Deleting session for nadia, 203.63.154.1, 1234
Tue Jun 12 13:12:30 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Tue Jun 12 13:12:30 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:12:30 2001: DEBUG: Handling accounting with Radius::AuthSQL
Tue Jun 12 13:12:30 2001: DEBUG: do query is: update Authentication set BalanceTime = (BalanceTime)-01000 where USERNAME = 'nadia'
Tue Jun 12 13:12:31 2001: DEBUG: do query is: insert into Accounting
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctInputOctets, AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPort)
values
('nadia', 'Jun 12, 2001 13:12', 2, 0, 20000, 30000, '00001234', 1000, '203.63.154.1', 1234)
Tue Jun 12 13:12:31 2001: DEBUG: Accounting accepted
Tue Jun 12 13:12:31 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 4818 ....
Code: Accounting-Response
Identifier: 89
Authentic: ?<238><189>Xq<26>q<156>v<203><201><251><12><170><239>t
Attributes:
Tue Jun 12 13:12:55 2001: ERR: Could not open dictionary file 'd:\radiator-demo-2.18\dictionary.cisco': No such file or directory
Tue Jun 12 13:13:01 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4820 ....
Code: Access-Request
Identifier: 119
Authentic: 1234567890123456
Attributes:
User-Name = "khaled"
Service-Type = Framed
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
NAS-Port-Type = Async
User-Password = "<203><187>o<156><175>\<4><246><188>8<9><160><216>}x<153>"
Tue Jun 12 13:13:01 2001: DEBUG: Handling request with Handler 'Realm='
Tue Jun 12 13:13:01 2001: DEBUG: Deleting session for khaled, 203.63.154.1, 1234
Tue Jun 12 13:13:01 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Tue Jun 12 13:13:01 2001: DEBUG: Query is: select NASIDENTIFIER, NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where USERNAME='khaled'
Tue Jun 12 13:13:01 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:13:01 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:13:01 2001: DEBUG: Query is: select Password,BalanceTime from Authentication where USERNAME='khaled' And ((BalanceTime > 0 And Type='H') or Type='P')
Tue Jun 12 13:13:02 2001: DEBUG: Radius::AuthSQL looks for match with khaled
Tue Jun 12 13:13:02 2001: DEBUG: Radius::AuthSQL ACCEPT:
Tue Jun 12 13:13:02 2001: DEBUG: Access accepted for khaled
Tue Jun 12 13:13:02 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 4820 ....
Code: Access-Accept
Identifier: 119
Authentic: 1234567890123456
Attributes:
Service-Type = Framed
Framed-Protocol = PPP
Tue Jun 12 13:13:02 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4820 ....
Code: Accounting-Request
Identifier: 120
Authentic: <139><236><227>*<200><178>n<237><13><255><215><7><194>L<203><178>
Attributes:
User-Name = "khaled"
Service-Type = Framed
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Start
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
Tue Jun 12 13:13:02 2001: DEBUG: Handling request with Handler 'Realm='
Tue Jun 12 13:13:02 2001: DEBUG: Adding session for khaled, 203.63.154.1, 1234
Tue Jun 12 13:13:02 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Tue Jun 12 13:13:02 2001: DEBUG: do query is: insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) values ('khaled', '203.63.154.1', 1234, '00001234', 992340782, #'', '', 'Framed', '123456789')
Tue Jun 12 13:13:02 2001: ERR: do failed for 'insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) values ('khaled', '203.63.154.1', 1234, '00001234', 992340782, #'', '', 'Framed', '123456789')': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
Tue Jun 12 13:13:03 2001: ERR: do failed for 'insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, #NASPORTTYPE, SERVICETYPE, CALLEDSID) values ('khaled', '203.63.154.1', 1234, '00001234', 992340782, #'', '', 'Framed', '123456789')': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
Tue Jun 12 13:13:03 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:13:04 2001: DEBUG: Handling accounting with Radius::AuthSQL
Tue Jun 12 13:13:04 2001: DEBUG: Accounting accepted
Tue Jun 12 13:13:04 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 4820 ....
Code: Accounting-Response
Identifier: 120
Authentic: <139><236><227>*<200><178>n<237><13><255><215><7><194>L<203><178>
Attributes:
Tue Jun 12 13:13:04 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4820 ....
Code: Accounting-Request
Identifier: 121
Authentic: <144><4>Y<158><154><14>!<216><252><235><173>'<214><191>pg
Attributes:
User-Name = "khaled"
Service-Type = Framed
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Stop
Called-Station-Id = "123456789"
Calling-Station-Id = "987654321"
Acct-Delay-Time = 0
Acct-Session-Time = 1000
Acct-Input-Octets = 20000
Acct-Output-Octets = 30000
Tue Jun 12 13:13:04 2001: DEBUG: Handling request with Handler 'Realm='
Tue Jun 12 13:13:04 2001: DEBUG: Deleting session for khaled, 203.63.154.1, 1234
Tue Jun 12 13:13:04 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Tue Jun 12 13:13:04 2001: DEBUG: Handling with Radius::AuthSQL
Tue Jun 12 13:13:04 2001: DEBUG: Handling accounting with Radius::AuthSQL
Tue Jun 12 13:13:04 2001: DEBUG: do query is: update Authentication set BalanceTime = (BalanceTime)-01000 where USERNAME = 'khaled'
Tue Jun 12 13:13:04 2001: DEBUG: do query is: insert into Accounting
(UserName, CallDate, AcctStatusType, AcctDelayTime, AcctInputOctets, AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPort)
values
('khaled', 'Jun 12, 2001 13:13', 2, 0, 20000, 30000, '00001234', 1000, '203.63.154.1', 1234)
Tue Jun 12 13:13:04 2001: DEBUG: Accounting accepted
Tue Jun 12 13:13:04 2001: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 4820 ....
Code: Accounting-Response
Identifier: 121
Authentic: <144><4>Y<158><154><14>!<216><252><235><173>'<214><191>pg
Attributes:
Can you please help me
Thank you
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
More information about the radiator
mailing list