net/freeradius: allow remote mysql to be used for accounting

[Trickfilm400]

Important notices
Before you add a new report, we ask you kindly to acknowledge the following:

• I have read the contributing guide lines at https://github.com/opnsense/plugins/blob/master/CONTRIBUTING.md
• I have searched the existing issues, open and closed, and I'm convinced that mine is new.
• When the request is meant for an existing plugin, I've added its name to the title.

Is your feature request related to a problem? Please describe.
I have set up the freeradius server plugin which works fine and great. But I want to use accounting, which is only available with the integrated sqlite:

plugins/net/freeradius/src/opnsense/service/templates/OPNsense/Freeradius/sites-enabled-default

Line 117 in 8cafe71

{% if helpers.exists('OPNsense.freeradius.general.sqlite') and OPNsense.freeradius.general.sqlite == '1' %}

I would like to use an external mysql database (via the remote mysql feature) to be able to use the accounting data for reports (like visualisations and so on). With the sqlite I would have to copy the database somewhere else or execute a sqlite command on the opnsense to display the data for example in grafana or something like that.

If I try to enable accounting with remote mysql, I get the error in the GUI: MySQL and SQLite can not be combined.

Describe the solution you'd like
I would like to be able to enable the remote mysql feature along the accounting feature and the accounting data should be pushed into the remote mysql. MAybe a switch to select the destination of the accountign data could e added (like Enable accounting and Acoounting Database with Mysql or sqlite.

---

For accounting sqlite should be enough which is already integrated?

Originally posted by mimugmail in #1092

I think it could be enough, but it's unclear how to use the data, without some workarounds which don't improve the security aspect compared to a simple remote mysql user.

---

Describe alternatives you've considered
Currently the only alternative would be to use an externally hosted freeradius and do the configuration yourself. Editing the config files on the opnsense should not be an option, as in case of a restore, the feature gets broken.

Additional context
None. If you have questions, just ask :)

[mimugmail]

I'll have a look at it, maybe a new checkbox to override sqlite.