(RADIATOR) BAS-Identifier in Accounting Table
Hugh Irvine
hugh at open.com.au
Tue Jan 3 17:22:36 CST 2006
Hello Martijn -
The accounting insert query is generated automatically from the
AcctColumnDef's that you have defined in the configuration file.
What you show below is correct and will include the NAS-Identifier in
the accounting insert _if_ the NAS-Identifier attribute is present in
the accounting request received from the NAS. You will need to look
at a trace 4 debug from Radiator to see exactly what attributes are
included in the accounting requests.
BTW - you will need to restart Radiator after you change the
configuration file.
regards
Hugh
On 3 Jan 2006, at 19:29, Martijn Balink wrote:
> Hi All,
>
> In January 2001 this exact same topic already went through the
> mailing list, Hugh said it was possible to fix, and referred to a
> chapter in the 2.x manual. We're currently running 3.13, and I just
> can't figure out how to do it.
> I want to add the NAS-Identifier to the MySql Accounting table.
> The query currently running is this (taken from the trace level 4
> log):
> ---
> do query is: 'insert into ACCOUNTING
> (ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,NASPORT,TIME_STAMP,USERNAM
> E) values (0,'0000037B','Start',1079,1135269418,'bnk at hesasd.nl')':
> ---
>
> The config part that does the MySql accounting looks like this:
>
> ****
> Identifier SQLAccounting
> DBSource dbi:mysql:Radiator
> DBUsername RadiatorUser
> DBAuth <nope>
> AuthSelect
>
> AccountingTable ACCOUNTING
> AcctColumnDef USERNAME,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,integer
> 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,Acct-Terminate-Cause
> AcctColumnDef NASIDENTIFIER,NAS-Identifier
> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
> ****
>
> I have a field NASIDENTIFIER in my Accounting table, I just can't
> figure out how to add the NASIDENTIFIER to my query.
> I found that it's possible to change the default query for
> ClientListSQL, but I could not find a way to alter the query that's
> ran for accounting.
> Does anyone have a clue?
>
> Thanks in advance,
>
> Martijn Balink
> Network Administrator
> Amsterdam School of Business
>
NB:
Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/
radiator)?
Have you had a quick look on Google (www.google.com)?
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