(RADIATOR) Oops!... Multiple Items in the same AcctColumnDef

[Brian Morris]

Oops.. This didn't work quite right..

I added the following line to my radiator cfg file :

  AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
  AcctColumnDef ACCTTERMINATECAUSE,Ascend-Disconnect-Cause
  AcctColumnDef ACCTTERMINATECAUSE,LE-Terminate-Detail

Started up and got the following error...

Mon Dec  9 18:56:59 2002: ERR: do failed for 'insert into ACCOUNTING
  (USERNAME, TIMESTAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, ACCTINPUTOCTETS,
ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, ACCTTERMINATECAUSE,
ACCTTERMINATECAUSE, NASIDENTIFIER, NASPORT, FRAMEDIPADDRESS, CONNECTINFO)
  values
  ('xxxx', 1039420619, 'Stop', 0, 8024, 160863, '4A00DCC7', 219,
'User-Request', 'User Request - PPP Term Req', '203.xx.xx.xx', '17',
'203.xx.xx.xx', '42666 LAPM/V42BIS')':
[Microsoft][ODBC SQL Server Driver][SQL Server]Column name
'ACCTTERMINATECAUSE' appears more than once in the result column list.
(SQL-37000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be
prepared. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)

It appears that if Radiator receives two or more of the ACCTTERMINATECAUSE
attributes in a stop record it tries to insert it twice (or more) in the
same insert statement.

Is there a work around for this?  Ideally to get it to concatenate them all
into a single ACCTTERMINATECAUSE value.  Perhaps something like the
timestamp / formatted date parameters

Thanks in advance..

Brian.







----- Original Message -----
From: "Hugh Irvine" <hugh at open.com.au>
To: "Brian Morris" <brian at netspeed.com.au>
Cc: <radiator at open.com.au>
Sent: Monday, December 09, 2002 6:49 PM
Subject: Re: (RADIATOR) Multiple Items in the same AcctColumnDef


>
> Hello Brian -
>
> Yes this is possible, simply specify the AcctColumnDef twice.
>
> Ie:
>
> .....
> AcctColumnDef TERMINATECAUSE, Ascend-Disconnect-Cause
> AcctColumnDef TERMINATECAUSE, Acct-Terminate-Cause
> .....
>
> regards
>
> Hugh
>
>
> On Monday, Dec 9, 2002, at 18:38 Australia/Melbourne, Brian Morris
> wrote:
>
> > Hi All,
> >
> > We receive session info from a few different NAS's but I would like to
> > store
> > all the connection specific information in a single table element.
> > EG:  I
> > would like to store the Ascend-Disconnect-Cause as well as the standard
> > Account-Terminate-Cause into the same table column.
> >
> > Is this possible to do?  If so, what is the syntax for the
> > ACCTCOLUMNDEF
> > entry?
> >
> > Thanks in advance.
> >
> > Brian Morris
> >
> >
> > ===
> > 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.
> >
> >
>
> --
> 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.
>

===
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.