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

[Hugh Irvine]

Hello Brian -

Could you please send me a trace 4 debug from Radiator showing the 
packet dumps when this happens?

I think you are right - there are two values in the same request.

Toomas probably has the right idea - a hook to pre-process the 
attributes prior to insertion.

regards

Hugh


On Monday, Dec 9, 2002, at 19:09 Australia/Melbourne, Brian Morris 
wrote:

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

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