> > Thor Spruyt wrote:
> >
> > > If you're not more specific about what you're trying to accomplish,
> > > I'm afraid nobody can advise you.
> >
> > Sorry I want to have the freeradius Accounting entry insert into 2
> > database at the same time.
> > Where the 1st DB is for log process and the 2nd DB is for some
> > calculation process (which remove of record is required)
> >
>
> I would suggest one of two things.  First use radrelay.  This will take
> all accounting details and put it into a text file and then push a copy of
> all the data over to another radius server that can log it in mysql.  So,
> you'd then have two copies in sql.  You setup your radius server to log to
> both sql and a detail file and then use radrelay to forward the accounting
> to another machine that logs to sql.  This will guarentee that all the
> data gets to the other server, even if it goes down.  Read about radrelay
> in doc/radrelay
>
> The second option is to use replication via mysql.  This is pretty easy to
> setup and what it will do for you is replicate every entry that is stored
> in your primary mysql database to another one.  You can read about that
> here:
>
> http://dev.mysql.com/doc/mysql/en/Replication.html
>
> Either of those options will probably get you what you want.
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>

Or do as Kostas said and just add both sql statements to the radiusd.conf.
Overlooked that idea.  That is probably the easiest setup.  Remember you
will need two sql configurations.

accounting{
        sql1
        sql2
}


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to