(RADIATOR) AcctColumnDef with Realm

[Hugh Irvine]

Hello Eric -

Very easy:

	AcctColumnDef REALM, %W, formatted

see section 6.28.14 in the Radiator 3.7.1 reference manual 
("doc/ref.html").

regards

Hugh


On 15/11/2003, at 5:41 AM, Eric Lackey wrote:

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

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