Hello Barry -

Yes this is very simple to do.

# define AuthBy clauses

<AuthBy SQL>
        Identifier SQLAccounting
        DBSource .....
        DBUsername .....
        DBAuth .....
        AuthSelect
        AccountingTable ACCOUNTING
        AcctCloumnDef .....
        .....
</AuthBy>

<AuthBy FILE>
        Identifier CheckFile
        Filename ./users
</AuthBy>

<AuthBy SYSTEM>
        Identifier CheckSystem
        UseGetspnamf
</AuthBy>

<AuthBy GROUP>
        Identifier CheckUsers
        AuthByPolicy ContinueUntilAccept
        AuthBy CheckFile
        AuthBy CheckSystem
</AuthBy>

# define Realm

<Realm auth>
        RewriteUsername s/^([^@]+).*/$1/
        MaxSessions 1
        AuthByPolicy ContinueAlways
        AuthBy SQLAccounting
        AuthBy CheckUsers
        AcctLogFileName /var/log/radius/detail
</Realm>


regards

Hugh



>Hi,
>
>Is it possible to record accounting data to the standard detail fiel as well
>as a mySQL database? We are currently logging just to the detail file but
>would like to change over to mySQL eventually so would like to log to both
>in the meantime while we rewrite the billing software to cope.
>
>Following is the appropriate section of our current radius.cfg
>
><Realm auth>
>  RewriteUsername s/^([^@]+).*/$1/
>  MaxSessions 1
><AuthBy FILE>
>   Filename ./users
></AuthBy>
><AuthBy SYSTEM>
>UseGetspnamf
>Identifier System
></AuthBy>
>AcctLogFileName /var/log/radius/detail
></Realm>
>
>Barry Andersson
>Simplex ISP
>
>
>
>===
>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.

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
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.

Reply via email to