(RADIATOR) Invalid object name 'inerted'

[Hugh Irvine]

Hello Michel -

I don't know where the object called 'inerted' is coming from.

A more complete trace 4 debug would be very useful.

regards

Hugh


On Saturday, Jun 14, 2003, at 00:21 Australia/Melbourne, Michel Bant  
wrote:

> Hello all,
>
>  
>
> We try to write back some accounting to our SQL database.
>
>  
>
> We receive the following error message:
>
> Fri Jun 1316:16:462003: DEBUG: do query is: 'insert into ACCOUNTING  
> (USERNAME)
>
>  values ('qwerty')':
>
>  
>
> DBD::ODBC::dbdo failed: [Microsoft][ODBC SQL Server Driver][SQL  
> Server]Invalid
>
> objectname 'inerted'. (SQL-42S02)(DBD: Execute immediate failed  
> err=-1) at c:/P
>
> erl/site/lib/Radius/SqlDb.pmline 219.
>
> Fri Jun 1316:16:462003: ERR: do failed for 'insert into ACCOUNTING  
> (USERNAME)
>
> values('qwerty')': [Microsoft][ODBC SQL Server Driver][SQL  
> Server]Invalid objec
>
> tname 'inerted'. (SQL-42S02)(DBD: Execute immediate failed err=-1)
>
> DBD::ODBC::dbdo failed: [Microsoft][ODBC SQL Server Driver][SQL  
> Server]Invalid
>
> objectname 'inerted'. (SQL-42S02)(DBD: Execute immediate failed  
> err=-1) at c:/P
>
> erl/site/lib/Radius/SqlDb.pmline 219.
>
> Fri Jun 1316:16:462003: ERR: do failed for 'insert into ACCOUNTING  
> (USERNAME)
>
> values('qwerty')': [Microsoft][ODBC SQL Server Driver][SQL  
> Server]Invalid objec
>
> tname 'inerted'. (SQL-42S02)(DBD: Execute immediate failed err=-1)
>
> Fri Jun 1316:16:462003: 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
>
>  
>
>  
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 10306 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20030614/96fed31c/attachment.bin>