Hi Oliver -
On Fri, 13 Aug 1999, O Stockhammer wrote:
> 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.
>
Hmmm. I am perplexed to imagine how your configuration could miss any updates,
given that the insert and the update are executed sequentially with the same
packet. It would be most enlightening to see a debug at trace level 4 to see
what is going on.
But to answer your question, yes you can set up a PreAuthHook to insert a
pseudo-attribute into the packet and you can even use the special formatting
character "%h" to set it to the Radiator hostname. Then you can use the
standard AcctColumnDef to insert the value directly into the original
accounting record. This is probably a better solution in any case.
There is an example PreAuthHook in Section 6.13.10 of the Radiator 2.14.1
reference manual.
hth
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.