(RADIATOR) Maximum Session
Hell All
Maximum session doesnt work with me, i think the problem is in RADONLINE inserinto but
i couldnt find out why.
CFG File:
#Identifier OnlineUsers
DBSourcedbi:ODBC:MDBTest
DBUsername
DBAuth
AddQueryinsert 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}')
-
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 = "1234"
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, '1234', 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, '1234', 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, '1234', 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:
Re: (RADIATOR) Maximum Session
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, '1234', 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:
>
>
>
> #Identifier OnlineUsers
> DBSourcedbi:ODBC:MDBTest
> DBUsername
> DBAuth
> AddQueryinsert 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}')
>
>
>
>
>
> -
> 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 = "1234"
> 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, '1234', 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, '1234', 992340694, #'', '', 'Framed',
> '123456789')': [Microsoft][ODBC Microsoft Ac
