FR v2 database structure and content

Hatem Sabrey hatem.sabrey at
Thu Oct 4 13:13:49 CEST 2018

Thank you Matthew for the information, 

i have been in the GitHub and got the schemas but for the sake fast deploy the Proof of concept of my idea i want to know the description of each table n the Database.

for example if i want to get the number of users logged-in per each NAS par day, in which table i will find this information?
Best Regards

> On Oct 4, 2018, at 12:01 PM, Matthew Newton <mcn at> wrote:
> On Thu, 2018-10-04 at 11:50 +0200, Hatem Sabrey wrote:
>> i’m planning to build a dashboard for FreeRADIUS v2.x so i need a
> Don't build anything for v2 - it's obsolete.
> Use v3 now.
> Though the SQL schemas as largely the same for both.
>> reference where to find detailed explanation about the database
>> structure and what are the data inside of it.
> The queries and schemas are all here:
> config/sql/main
> -- 
> Matthew
> -
> List info/subscribe/unsubscribe? See

More information about the Freeradius-Devel mailing list