(RADIATOR) Invalid object name 'inerted'

[Michel Bant]

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/180aa3b7/attachment.html>