Hy all, I have an oracle database storing authentication information for thousounds of differents users. This database is of course, not compliant at all with freeradius requirements (users file like). What is the best practice to make it work. I have many attributes to manage in checks as well in replys, such as simultaneous-use, counters, ippools, session-timeout,traffic-limit etc... I though using views to achieve compliance with freeradius tables specs, but maybe there is a better solution. Of course, the database structure cannot be changed.!
Alexandre Chapellon wrote:
I have an oracle database storing authentication information for thousounds of differents users. This database is of course, not compliant at all with freeradius requirements (users file like). What is the best practice to make it work.
You can edit the default SQL queries. That's why they're in a configuration file.
I have many attributes to manage in checks as well in replys, such as simultaneous-use, counters, ippools, session-timeout,traffic-limit etc... I though using views to achieve compliance with freeradius tables specs, but maybe there is a better solution.
If you're just looking for username -> password, editing the SQL queries is fine. If you're adding lots of attributes based on a complex existing schema, another method like views is best. Alan DeKok.
participants (2)
-
Alan DeKok -
Alexandre Chapellon