The problem is we have databases in slave mode, only reading is allowed. We want pass these informations to another database...
2013/8/6 <a.l.m.bu...@lboro.ac.uk> > Hi, > > > Hi, I would like to store freeradius session information like > > Acct-Session-Id, Acct-Start-Time, Acct-Stop-Time, Acct-Input-Octets, > > Acct-Output-Octets, Framed-IP-Address, NAS-IP-Address in external > > database. > > the defauly config does this - you just need to edit the SQL module to > be appropriate to your database (and have a DB you can write to!) and then > use the 'sql' option in the accounting section (thats the section that > will have > those details as they are in RADIUS Accounting packets). > > > accounting { > > # sql > > } > > look. there. > > > to optimise you might then want to look at other virtual servers to do > this stuff like > bufferedsql or the remote accounting proxy one.....and then make sure your > DB is > optimised....both running environment (memory allocation, disk platters > etc) , the > table indexes and the DB engine used for the tables. > > alan > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > -- Pozdrawiam Maciej Lew tel. 883-376-062
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html