(RADIATOR) AcctColumnDef with Realm
Hugh Irvine
hugh at open.com.au
Fri Dec 19 17:55:17 CST 2003
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.
More information about the radiator
mailing list