(RADIATOR) AcctColumnDef with Realm

[Eric Lackey]

Hugh,

I have added this line to the Auth By section.  It is working fine about 75% of the time.  It sticks the username realm in the REALM field like it should.  Every once in a while, instead of putting the REALM in the field, it puts '%W'.

I verified that it wasn't specific to one radius or NAS server.  I have 4 radius servers using version 3.6, and 4 different NAS servers.  Accounting records from users dialing into any of the equipment have this problem.  I think this would indicate something configured wrong in my radius config.  

Thanks,

Eric


-----Original Message-----
From: Hugh Irvine [mailto:hugh at open.com.au] 
Sent: Friday, November 14, 2003 8:54 PM
To: Eric Lackey
Cc: radiator at open.com.au
Subject: Re: (RADIATOR) AcctColumnDef with Realm


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.