Hello Colin -
On Fri, 15 Dec 2000, Colin wrote:
>
> Hi,
>
> We currently have radiator storing the accounting records into the Mysql
> Accounting table.
>
> Is it possible by using the radius.cfg file to insert the same
> accounting data into another table as well as the accounting table
> during authentication.
>
> I added another 'AccountingTable tablename' together with the same
> AcctColumnDefs in the <AuthBy SQL>. Essentially i had two blocks for
> storing data into Mysql but into separate tables, however this does not
> seem to work as its producing errors and not logging any data.
>
> I have also attempted to use the AcctSQLStatement syntax but this also
> produces errors as the number of columns do not match the number of
> attributes that radius picks up which seems to vary from time to time.
>
> Is there a proper way to acheive this?
>
Yes - use two AuthBy SQL clauses.
# configuration with two SQL clauses
<AuthBy SQL>
Identifier SQLAccounting1
DBSource ....
DBUsername ....
DBAuth ....
.....
</AuthBy>
<AuthBy SQL>
Identifier SQLAccounting2
DBSource ....
DBUsername ....
DBAuth ....
.....
</AuthBy>
# your normal Realms or Handlers
<Handler>
AuthByPolicy ContinueAlways
AuthBy SQLAccounting1
AuthBy SQLAccounting2
AuthBy .....
</Handler>
Have a look at section 6.26 in the Radiator 2.17.1 reference manual.
There are also examples in the "goodies" directory and there are many examples
and discussions on the archive site:
http://www.starport.net/~radiator
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
