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