Housekeeping of accounting data

The most common problem with accounting data is when the NAS and the FreeRADIUS server's data do not correspond.

You can then use radzap to close orphan sessions as we have done at the start of the chapter.

Web-based tools

If you use MySQL for accounting there are various web-based tools to manage the accounting data. phpMyAdmin is very popular. There are also complete software packages (open source or commercial) focused on giving a central management dashboard for user management, billing, vouchers, and other such applications.

Note

Should you have opted for PostgreSQL instead of MySQL, you just have to try out phpPgAdmin. This serves as a great help to beginners.

In large deployments it is good practice to archive older accounting records from the MySQL database in order to keep the size of the database manageable.

You may also want to index certain columns that are common to regular queries.

This brings us to the end of the chapter on accounting. Let&apos...