When we first developed OpenWISP RADIUS we tried making the first database migration use the same schema used by freeradius at that time and then perform any change in subsequent DB migrations, so that it should be easier to migrate an existing freeradius DB to OpenWISP RADIUS.
However, since then, I believe freeradius kept changing the schema a bit and I am not sure we can do much about it.
The schema changes seem to be minimal and do not affect us because we are mostly using the freeradius rml_rest module as a backend for most operations and by default we do not rely on the sql module (which can be enabled if needed, but you may have to tweak the queries.conf file).
If I was you and I wanted to use the features offered by OpenWISP RADIUS, I would do it differently:
- I'd start with the OpenWISP RADIUS schema and configure freeradius as we recommend, I'd start on a single server
- I'd verify all the features work as expected
- I'd move the freeradius server away from the single server, they don't need to be on the same server, I believe you can have multiple freeradius instances as well if you need.
I hope this helps.
Best regards
Federico CapoanoOpenWISP OÜ
Kotkapoja tn 2a-10, 10615, Harju maakond, Tallinn, Estonia
VAT: EE101989729