How to store session info in external database?

[Maciej Lew]

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.Buxey at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130806/13d76eb6/attachment.html>