O/H apolyxrono έγραψε:
> Hi list,
> I have freeradius-1.1.3 doing accounting with mysql. I am thinking to
> create 2 or 3 new tables in the radius db for my purposes and write in
> them the info i want every time freeradius writes data to the other
> tables (nas ,radcheck ,radacct etc.).
freeradius only writes to radacct. It assumes someone else has written
> Is it possible to do that ? If yes
> how ? If yes is it possible to do it using php scripts and not perl (for
> example to call a php script to update my tables every time freeradius
> writting accounting data in the radius db)
> Thanks a lot
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
1. Use sql triggers if your sql server supports them
2. Just create 2-3 more sql module instances that will execute the
queries you want
3. Create an external php script to do that. That will be slower though
since you 'll have to execute it on every request and create a new sql
connection (sql module uses a connection pool).
I would suggest 2-1-3 (in that order).
Network Operations Center - National Technical University of Athens
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html