Hi,
I am trying a configuration using Windows/NT (for special purpose
authentication) using SQLserver.
I use ODBC, and SQLserver v7.0. Authentication works well. However I receive
error message in accounting using radpwtst. When I issue the insert
statement using sqlquery program, it works..
The tables exist and since it does authentication well I assume
perlDBI/DBD/ODBC works too.
Any ideas?
Ferhat
Tue Mar 2 17:11:57 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 1528 ....
Code: Access-Request
Identifier: 207
Authentic: 1234567890123456
Attributes:
User-Name = "dilman"
Service-Type = Framed-User
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
User-Password = "<149><228>)<200><155>9r<147><206>@<9><160><216>}x<153>"
Tue Mar 2 17:11:57 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Tue Mar 2 17:11:57 1999: DEBUG: Handling with Radius::AuthSQL
Tue Mar 2 17:11:57 1999: DEBUG: Handling with Radius::AuthSQL
Tue Mar 2 17:11:57 1999: DEBUG: Query is: select PASSWORD from SUBSCRIBERS
where USERNAME='dilman'
Tue Mar 2 17:11:58 1999: DEBUG: Radius::AuthSQL looks for match with dilman
Tue Mar 2 17:11:58 1999: DEBUG: Radius::AuthSQL ACCEPT:
Tue Mar 2 17:11:58 1999: DEBUG: Access accepted for dilman
Tue Mar 2 17:11:58 1999: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 1528 ....
Code: Access-Accept
Identifier: 207
Authentic: 1234567890123456
Attributes:
Tue Mar 2 17:11:58 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 1528 ....
Code: Accounting-Request
Identifier: 208
Authentic: <198><243>(<144>2/<189>-W<181><135><228><180><136>M<134>
Attributes:
User-Name = "dilman"
Service-Type = Framed-User
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Start
Tue Mar 2 17:11:58 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Tue Mar 2 17:11:58 1999: DEBUG: Handling with Radius::AuthSQL
Tue Mar 2 17:11:58 1999: DEBUG: Handling accounting with Radius::AuthSQL
Tue Mar 2 17:11:58 1999: DEBUG: do query is: insert into ACCOUNTING
(USERNAME, ACCTSTATUSTYPE, TIME_STAMP, NASPORT, ACCTSESSIONID)
values
('dilman', 'Start', 920387518, 1234, '00001234')
Tue Mar 2 17:11:58 1999: ERR: do failed for 'insert into ACCOUNTING
(USERNAME, ACCTSTATUSTYPE, TIME_STAMP, NASPORT, ACCTSESSIONID)
values
('dilman', 'Start', 920387518, 1234, '00001234')': [Microsoft][ODBC SQL
Server Driver][SQL Server]Invalid object name 'ACCOUNTING'. (SQL-S0002)(DBD:
st_execute/SQLExecute err=-1)
Tue Mar 2 17:11:58 1999: DEBUG: Adding session for dilman, 203.63.154.1,
1234
Tue Mar 2 17:11:58 1999: DEBUG: do query is: delete from RADONLINE where
NASIDENTIFIER='203.63.154.1' and NASPORT=1234
Tue Mar 2 17:11:58 1999: ERR: do failed for 'delete from RADONLINE where
NASIDENTIFIER='203.63.154.1' and NASPORT=1234': [Microsoft][ODBC SQL Server
Driver][SQL Server]Invalid object name 'RADONLINE'. (SQL-S0002)(DBD:
st_execute/SQLExecute err=-1)
Tue Mar 2 17:11:58 1999: DEBUG: do query is: insert into RADONLINE
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('dilman', '203.63.154.1',
1234, '00001234', 920387518, '', 'Async', 'Framed-User')
Tue Mar 2 17:11:59 1999: ERR: do failed for 'insert into RADONLINE
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('dilman', '203.63.154.1',
1234, '00001234', 920387518, '', 'Async', 'Framed-User')': [Microsoft][ODBC
SQL Server Driver][SQL Server]Invalid object name 'RADONLINE'.
(SQL-S0002)(DBD: st_execute/SQLExecute err=-1)
Tue Mar 2 17:11:59 1999: DEBUG: Accounting accepted
Tue Mar 2 17:11:59 1999: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 1528 ....
Code: Accounting-Response
Identifier: 208
Authentic: <198><243>(<144>2/<189>-W<181><135><228><180><136>M<134>
Attributes:
Tue Mar 2 17:11:59 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 1528 ....
Code: Accounting-Request
Identifier: 209
Authentic: ]<223><190><224>l<155>9A<255>5<147>$"u<18><233>
Attributes:
User-Name = "dilman"
Service-Type = Framed-User
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Time = 1000
Acct-Input-Octets = 20000
Acct-Output-Octets = 30000
Tue Mar 2 17:11:59 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Tue Mar 2 17:11:59 1999: DEBUG: Handling with Radius::AuthSQL
Tue Mar 2 17:11:59 1999: DEBUG: Handling accounting with Radius::AuthSQL
Tue Mar 2 17:11:59 1999: DEBUG: do query is: insert into ACCOUNTING
(USERNAME, ACCTSTATUSTYPE, TIME_STAMP, NASPORT, ACCTDELAYTIME,
ACCTSESSIONID, ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTSESSIONTIME)
values
('dilman', 'Stop', 920387519, 1234, 0, '00001234', 20000, 30000, 1000)
Tue Mar 2 17:11:59 1999: ERR: do failed for 'insert into ACCOUNTING
(USERNAME, ACCTSTATUSTYPE, TIME_STAMP, NASPORT, ACCTDELAYTIME,
ACCTSESSIONID, ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTSESSIONTIME)
values
('dilman', 'Stop', 920387519, 1234, 0, '00001234', 20000, 30000,
1000)':
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'ACCOUNTING'. (SQL-S0002)(DBD: st_execute/SQLExecute err=-1)
Tue Mar 2 17:11:59 1999: DEBUG: Deleting session for dilman, 203.63.154.1,
1234
Tue Mar 2 17:11:59 1999: DEBUG: do query is: delete from RADONLINE where
NASIDENTIFIER='203.63.154.1' and NASPORT=1234
Tue Mar 2 17:11:59 1999: ERR: do failed for 'delete from RADONLINE where
NASIDENTIFIER='203.63.154.1' and NASPORT=1234': [Microsoft][ODBC SQL Server
Driver][SQL Server]Invalid object name 'RADONLINE'. (SQL-S0002)(DBD:
st_execute/SQLExecute err=-1)
Tue Mar 2 17:11:59 1999: DEBUG: Accounting accepted
Tue Mar 2 17:11:59 1999: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 1528 ....
Code: Accounting-Response
Identifier: 209
Authentic: ]<223><190><224>l<155>9A<255>5<147>$"u<18><233>
Attributes:
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
