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" <[EMAIL PROTECTED]> To: "Brian Morris" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] > > To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.