Hugh,
Is there anyway to actually have Radiator append info to the
incoming data, so that it only uses on query per request?
I have created an AcctSQLStatement, but it seems because it is an
additional query that it doesn't update the row of data in mysql every
time (It misses a few Acct submissions here and there). Here is what I am
using:
AcctSQLStatement Update ACCOUNTING set ORIGIN ='Auth-2:
local' where TIME_STAMP = %{Timestamp} and NAS_IDENTIFIER = '%N' and
NAS_PORT= '%{NAS-Port}'
The purpose of the query is to ID the realm and radiator server
which is doing the Authentication(The value of ORIGIN changes for each
Realm) . It there anyway to have radiator include this data in the
original ACCTING queries, so that it is all in one, so to speak? Perhaps
there is an easy way to modify AcctColumnDef to have a fourth field which
is the actual value for the column.
Thanks,
Oliver Stockhammer
Sys Admin
Internet Channel
On Thu, 12 Aug 1999, Hugh Irvine wrote:
>
> Hello Oliver -
>
> On Thu, 12 Aug 1999, O Stockhammer wrote:
> > Hi,
> > We were wondering if the AuthBy SQL accting tables and
> > "AcctColumnDef" specifically can be configured to send a line of text
> > specified in the radius.cfg file.
> > Because we have a backup server and a main auth server, we want to
> > set up radiator to send an additional accting line which specifies which
> > radius the request came through. We will be using a centralized db for
> > all the accting info and so it is important that we can tell which
> > radiator the requests are coming from. Is there any directive that will
> > do this?
>
> Yes there is.
>
> Have a look at AcctSQLStatement (Section 6.24.11 in the Radiator
> 2.14.1 reference manual). AcctSQLStatement allows you to define one or more
> SQL statements to be executed for every accounting request, so you should be
> able to do what you require.
>
> > Also, we will need to get a second license from you folks for the
> > backup radiator server.
> >
>
> I've asked Joanne to take care of this.
>
> cheers
>
> Hugh
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
> NT, Rhapsody
>
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
