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:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 8:54 PM To: Eric Lackey Cc: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
