Re: (RADIATOR) AcctColumnDef with Realm

Hugh Irvine Fri, 14 Nov 2003 20:06:46 -0800

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.

Re: (RADIATOR) AcctColumnDef with Realm

Reply via email to