Hi Hugh, I still want to authenticate by the UNIX passwd file for the time being but write accounting records to mySQL. Is thsi the correct config for that scenario?
Barry ----- Original Message ----- From: "Hugh Irvine" <[EMAIL PROTECTED]> To: "Barry Andersson" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, November 02, 2001 15:02 Subject: Re: (RADIATOR) Multiple accounting methods > > 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.