(RADIATOR) AcctColumnDef with Realm

[Eric Lackey]

Hello,

 

This might be easy, but I haven't been able to find how to do it.  I
want to include the realm in the accounting query insert.  I see the
value of %W is the realm before any rewriting has occurred, but when I
add the AcctColumnDef it doesn't send anything to the database.  I have
included the AuthBy statement below.

 

Thanks for any help.

 

Eric Lackey

 

<AuthBy SQL>

                DBSource        dbi:mysql:RADACCT:host=192.168.0.1

                DBUsername      username

                DBAuth          password

                FailureBackoffTime  60

                AuthSelect

                AccountingStopsOnly

                AccountingTable ACCOUNTING

                AcctColumnDef   USERNAME,User-Name

                AcctColumnDef   TIME_STAMP,Timestamp,integer

                AcctColumnDef
ACCT_DATE,Timestamp,formatted-date,'%Y-%m-%d'

                AcctColumnDef
ACCT_TIME,Timestamp,formatted-date,'%H:%M:%S'

                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,Ascend-Disconnect-Cause,integer

                AcctColumnDef   NASIDENTIFIER,NAS-IP-Address

                AcctColumnDef   NASPORT,NAS-Port,integer

                AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address

                AcctColumnDef
DisconnectCause,Ascend-Disconnect-Cause,integer

                AcctColumnDef
ConnectProgress,Ascend-Connect-Progress,string

                AcctColumnDef   CallingStationId,Calling-Station-Id

                AcctColumnDef   REALM,%W

                AcctColumnDef   CalledStationId,Called-Station-Id

        </AuthBy>

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20031114/d49e2f7b/attachment.html>