FR v2 database structure and content
Hello Gentlemen, i’m planning to build a dashboard for FreeRADIUS v2.x so i need a reference where to find detailed explanation about the database structure and what are the data inside of it. many thanks Hatem
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: https://github.com/FreeRADIUS/freeradius-server/tree/v3.0.x/raddb/mods- config/sql/main -- Matthew
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@freeradius.org> 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:
https://github.com/FreeRADIUS/freeradius-server/tree/v3.0.x/raddb/mods- config/sql/main
-- Matthew
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
On Oct 4, 2018, at 7:13 AM, Hatem Sabrey <hatem.sabrey@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.
Thank you Alan for your valued information
Why is it so hard to read them?
No it is not hard to read but i’m new to this so it was confusing and now it is clear.
On Oct 4, 2018, at 1:18 PM, Alan DeKok <aland@deployingradius.com> wrote:
On Oct 4, 2018, at 7:13 AM, Hatem Sabrey <hatem.sabrey@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.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
participants (3)
-
Alan DeKok -
Hatem Sabrey -
Matthew Newton