Back To MAN Pages From BackTrack 5 R1 Master List
The rlm_sql_log module does something similar, but for SQL queries. See it's man page for details.
That will cause your accounting packets to go the the backup server - and some NASes don't even switch back to the primary server when it comes back up.
The result is that accounting records are missed, and/or the administrator must jump through hoops in order to combine the different detail files from multiple servers. It also means that the session database ("radutmp", used for radwho and simultaneous use detection) gets out of sync.
We solve this issue by "relaying" packets from one server to another, so they both have the same set of accounting data.
See raddb/sites-available/buffered-sql for more information.
Similarly, you may have one database that tracks "live" sessions, and another that tracks historical accounting data. In that case, accessing the first database is fast, as it is small. Accessing the second database many be slower, as it may contain multiple gigabytes of data. In addition, writing to the first database in a timely manner is important, while data may be written to the second database with a few minutes delay, without any harm being done.
See raddb/sites-available/copy-to-home-server for more information.
If you would like to republish one of the articles from this site on your webpage or print journal please contact IronGeek.
Copyright 2020, IronGeek