(RADIATOR) AcctColumnDef with Realm

[Hugh Irvine]

Hello Eric -

There was a bug in an earlier version of Radiator with %W and it sounds 
like one of your servers has not been patched.

The latest version is Radiator 3.7.1 (plus patches).

regards

Hugh


On 20/12/2003, at 6:08 AM, Eric Lackey wrote:

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

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.