(RADIATOR) Invalid object name 'inerted'

[Dave Kitabjian]

Hmm. Do you mean other than the fact that "inserted" is spelled wrong,
presumably in a trigger attached to the ACCOUNTING table?

 

Dave

 

-----Original Message-----
From: Michel Bant [mailto:michel at superweb.nl] 
Sent: Friday, June 13, 2003 10:22 AM
To: radiator at open.com.au
Subject: (RADIATOR) Invalid object name 'inerted'

 

Hello all,

 

We try to write back some accounting to our SQL database.

 

We receive the following error message:

Fri Jun 13 16:16:46 2003: DEBUG: do query is: 'insert into ACCOUNTING
(USERNAME)

 values ('qwerty')':

 

DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid

object name 'inerted'. (SQL-42S02)(DBD: Execute immediate failed err=-1)
at c:/P

erl/site/lib/Radius/SqlDb.pm line 219.

Fri Jun 13 16:16:46 2003: ERR: do failed for 'insert into ACCOUNTING
(USERNAME)

values ('qwerty')': [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid objec

t name 'inerted'. (SQL-42S02)(DBD: Execute immediate failed err=-1)

DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid

object name 'inerted'. (SQL-42S02)(DBD: Execute immediate failed err=-1)
at c:/P

erl/site/lib/Radius/SqlDb.pm line 219.

Fri Jun 13 16:16:46 2003: ERR: do failed for 'insert into ACCOUNTING
(USERNAME)

values ('qwerty')': [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid objec

t name 'inerted'. (SQL-42S02)(DBD: Execute immediate failed err=-1)

Fri Jun 13 16:16:46 2003: DEBUG: Accounting accepted

 

Part of the script that we use to take care of the accounting is:

 

<Realm DEFAULT>

 

          <AuthBy SQL>

          

                      AuthSelect        select e.password, e.timeleft,
e.timelimit, e.defaultroute from users e where e.username = %0 and
dialaccess=1

                      DBSource         dbi:ODBC: ***

                      DBUsername    ***

                       DBAuth            ***

 

                      

                      AuthColumnDef 0, Password, check

          

                      AccountingTable            ACCOUNTING

                      AcctColumnDef USERNAME,User-Name

                      AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type

                      AcctColumnDef
ACCTDELAYTIME,Acct-Delay-Time,integer

                      AcctColumnDef
ACCTINPUTOCTETS,Acct-Input-Octets,integer

                      AcctColumnDef
ACCTOUTPUTOCTETS,Acct-Output-Octets,integer

                      AcctColumnDef ACCTSESSIONID,Acct-Session-Id

                      AcctColumnDef
ACCTSESSIONTIME,Acct-Session-Time,integer

                      AcctColumnDef
ACCTTERMINATECAUSE,Acct-Terminate-Cause

                      AcctColumnDef NASIDENTIFIER,NAS-Identifier

                      AcctColumnDef NASPORT,NAS-Port,integer

                      AcctColumnDef NASPORTTYPE,NAS-Port-Type

                      AcctColumnDef MULTILINKID,Ascend-Multilink-ID

                      AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address

                      AcctColumnDef CALLINGID,Calling-Station-Id

                      AcctColumnDef Calledstation_ID,Called-Station-Id

                      

          </AuthBy>

</Realm>

 

Does anyone know what we did wrong?

 

Kind regards,

Michel Bant

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20030613/5a6f7d83/attachment.html>