(RADIATOR) Maximum Session
Hugh Irvine
hugh at open.com.au
Tue Jun 12 19:45:23 CDT 2001
Hello Mohammed -
There appear to be at least two problems.
The first is that you haven't specified the correct dictionary file. You
should really start with the standard Radiator dictionary file
("dictionary"), and add or remove things you need or don't need. Note that
the standard Radiator dictionary includes all Cisco definitions.
The second problem is that the extract from the configuration file below does
not match the debug output.
> 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)
There is an incorrect reference here to "#NASPORTTYPE" at the very least.
hth
Hugh
On Wednesday 13 June 2001 01:51, Mohammed Adam wrote:
> 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.
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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