FR v2 database structure and content

Alan DeKok aland at deployingradius.com
Thu Oct 4 13:18:36 CEST 2018


On Oct 4, 2018, at 7:13 AM, Hatem Sabrey <hatem.sabrey at afkar.net.ly> wrote:
> 
> 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.

  The descriptions are in the comments.  See the schema and queries.

> 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?

  All of the accounting information is in the "radacct" table.  The documentation makes this clear.  You can construct SQL queries for any information you want.

  The real question is why are you depending on emailed questions?  The answers are already in front of you.  All you need to do is read the files you were told to read.

  Why is it so hard to read them?

 Alan DeKok.





More information about the Freeradius-Devel mailing list