Freeradius with hotels

[Martin, Jeremy]

I wrote this back on Jan 25 but for some reason it does not look like it posted the list, at least I can't find it in the archive.

Have a look at the mods-enabled/sql config file and mods-config/sql files/directories.  I just got done with a pretty large implementation with various sql sources and all of what you need to do your integration in contained within those files.  You will need to have some sql admin and query skills in the target databases and a reasonable understanding of how the FreeRADIUS models interacts with these files but it was doable learning from scratch.  You will not likely find any one or two sources that have all the information laid out in a guide but the information and resources are laid out by example in the files that I outlined above.  If each system is different than it may make sense to look at the mods-available/rest file and configure FR the same and make a rest api to a url that is configured to each site, this will likely be the simpler of the two approaches as you can work with your favorite language, web server, framework or other sources as the restful api makes the backend resources agnostic to FR.  In the end I actually will likely go back through my solution and change most of it work with the rest api.

For any avenue you choose: you will not find any one config or resource to complete this project you are going to have to source the pieces and build the configs and/or components, there is likely to be nothing ready made to just set a few configuration options and be off and running.  Also from reading some of your past posts it appears you are trying to build a large encompassing solution that is likely to be complex and is not going to be trivial.  From some your previous questions you are likely to need to seek specific resources for each part of the solution as they all touch various areas, networking, accounting, erp-dataabse and overall project management, again not trivial and will take a well-seasoned network admin to implement, FR is just one small part in your solution.  We did a similar project, not exactly, but a tight integration for our campus last year and by the time we deployed the database integration, network authentication and authorization, and integrated our firewalls and web content filtering I was over a month of solid work and currently maintain all the aforementioned systems, again the integration for all of this is not trivial.   In the end it works well and is comprehensive but was no short quick easy implementation.

Jeremy

-----Original Message-----
From: Freeradius-Users [mailto:freeradius-users-bounces+jmartin=emcc.edu at lists.freeradius.org] On Behalf Of Muhammed Buvaydani
Sent: Friday, February 9, 2018 1:54 AM
To: freeradius-users at lists.freeradius.org
Subject: Freeradius with hotels

Hello
I working on freeradius management system and I wish to implement freeradius with hotels database but I have problems with this .
Hotels have different databases and different database integration I want to make authentication using room number and guest name .
I don't know alote about this idea so How can I do this integration with freeradius



-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html