| |||||
| |||||
Search Irongeek.com:
Help Irongeek.com pay for bandwidth and research equipment: |
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.
15 most recent posts on Irongeek.com:
|
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
Louisville / Kentuckiana Information Security Enthusiast