Users file or mysql database; radpostauth table
Hi all! I'm trying to implement a freeradius server and I have several questions. The freeradius version used is 2.1.8. First of all, I want to put a freeradius to manage a net with about 400~500 users. I don't know which method for manage users choose; users file or mysql database? I think manage users with a file is faster but the management is worse and mysql database is easily management but I think is slower than other. What do you think about? Which is the best option? Another question is referent a freeradius + mysql. I do a test and save the users passwords with SHA1 in the radcheck table. Then I activated the radpostauth logging table. The problem is in this table (when a user is logged in) the pass is stored in plain-text, without encryption. Is possible to store the pass encrypted with SHA1 in radpostauth table? Thanks for all. Regards, David Seira
David Seira wrote:
First of all, I want to put a freeradius to manage a net with about 400~500 users. I don't know which method for manage users choose; users file or mysql database?
Whatever makes you happy.
I think manage users with a file is faster but the management is worse and mysql database is easily management but I think is slower than other.
What do you think about? Which is the best option?
For 500 users, the speed of MySQL isn't an issue.
Another question is referent a freeradius + mysql. I do a test and save the users passwords with SHA1 in the radcheck table. Then I activated the radpostauth logging table. The problem is in this table (when a user is logged in) the pass is stored in plain-text, without encryption. Is possible to store the pass encrypted with SHA1 in radpostauth table?
No. Alan DeKok.
Alan DeKok wrote:
David Seira wrote:
First of all, I want to put a freeradius to manage a net with about 400~500 users. I don't know which method for manage users choose; users file or mysql database?
Whatever makes you happy.
I think manage users with a file is faster but the management is worse and mysql database is easily management but I think is slower than other.
What do you think about? Which is the best option?
For 500 users, the speed of MySQL isn't an issue.
Another question is referent a freeradius + mysql. I do a test and save the users passwords with SHA1 in the radcheck table. Then I activated the radpostauth logging table. The problem is in this table (when a user is logged in) the pass is stored in plain-text, without encryption. Is possible to store the pass encrypted with SHA1 in radpostauth table?
No.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi everyones, I'm a newbie in Radius. I just want to ask do I have to configure users file if use mysql to manage the users ? Vu Hung,
participants (3)
-
Alan DeKok -
David Seira -
VU VAN HUNG