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.