(RADIATOR) platradacct.cgi

[Hugh Irvine]

Hello John -

This appears to be a problem with the data in the database, and it  
looks like at least one of the sum(..) operations is overflowing the  
capacity of an integer.

I suggest you check the MS-SQL server log to see what is happening  
there, and you can also run the offending query directly against the  
database in the MS-SQL query tool.

If this is indeed the problem you will need to either prune the data  
or modify the script.

regards

Hugh


On 4 Oct 2006, at 17:49, John Vorstermans wrote:

> Hi,
>
> I installed platradacct.cgi which is in the goodies directory to  
> talk to
> our platypus MS-SQL (8.0) server vie the sybase ODBC drivers.  I  
> had it
> working fine by we are now getting the following errors.   Has anyone
> any idea what is going on?
>
> We are also running radwho.cgi which is working fine.
>
>
>  Fatal Error
>
> *A serious problem was encountered:*
>
> Execute failed for 'select USERNAME, sum(ACCTSESSIONTIME),
> sum(ACCTINPUTOCTETS), sum(ACCTOUTPUTOCTETS) from Calls group by
> USERNAME': Server message number=8115 severity=16 state=2 line=1
> server=PLATYPUS text=Arithmetic overflow error converting  
> expression to
> data type int.Server message number=8153 severity=0 state=1 line=1
> server=PLATYPUS text=Warning: Null value is eliminated by an aggregate
> or other SET operation.
>
>
> Cheers
> John
>
>
> --
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.



NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
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, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.


--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.