Hi,
I re-created the ODBC System DSN again and rebooted. Now working. I don't
know what caused the problem.
Thanks for all,
Ferhat
> -----Original Message-----
> From: Mike McCauley [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 03, 1999 3:55 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Accounting Log Error
>
>
> Hi Ferhat,
>
> -----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: 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.
> Thats a good theory.
>
> >
> >Any ideas?
>
> Can you send the Radiator log file at trace level 4, so we
> can see whats
> happening?
>
> Cheers.
>
> >
> >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.
