Hello Ferhat,
from this log file, I would say that you have not created the ACCOUNTING or
RADONLINE  tables. At any rate, Radiator cant find it in the default
database for your ODBC user . Is it possible you created them in a different
database, perhaps master?

What happens if you connect using isqlw, log in to SQL as the same user that
Radiator logs ion as, and do "select * from ACCOUNTING"


Hope that helps.
Cheers.


----------------------------------------------------------------------------
---------------
Mike McCauley                                 [EMAIL PROTECTED]
Open System Consultants                 +61 3 9598 0985

Mike is travelling right now, and there may be delays
in our correspondence.
-----Original Message-----
From: Ferhat Dilman <[EMAIL PROTECTED]>
To: 'Mike McCauley' <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Wednesday, March 03, 1999 2:40 AM
Subject: (RADIATOR) Accounting Log Error


>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.
>


===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to