On Mon August 4 2003 21:53, Evren Yurtesen wrote: > think about it yourself, > > -easy data manipulation, > -reload of freeradius is not needed > -nice web interface dialup_admin > -you can make your own web interface with php easily with sql connectivity.
Yes. These are all correct.. > These are what I can think of at the moment. I also think it would be > faster than using users file and freeradius would use less memory since > it doesnt load the whole users file to memory (I think it loads it?!) > if you have many users for example. SQL is also designed for quick data > retrieval so if you plan to have many users than it would give better > performance when the server needs to find one user. Actually, you are wrong on this point I think. FreeRadius _would_ use less memory, that is correct, although memory usage should not be an issue, however using a SQL server as an Authentication backend _must_ be slower than a userlist that is already in memory. Just think about what happens.. FreeRadius with users file: * Request comes in * FreeRadius checks if the user is valid from its copy of the users file in memory * FreeRadius responds to the NAS with allow or deny FreeRadius with DB backend for Authentication: * Request comes in * FreeRadius sends a SQL query to the DB. * DB does an index search for the username * DB loads the usename records from disk into memory * DB Sends the username record back to FreeRadius * FreeRadius responds to the NAS with allow or deny Which do you think will be faster?? > Perhaps you should also ask to yourself, what is the disadvantage? See above. DB backends are good, and save alot of admin, but don't expect them to be faster than a memory scan :-) > Evren > > Patrick wrote: > > hi, > > > > im a freeradius newbie but i was wondering if there are any major > > advantages to running freeradius on an sql auth system or not ? other > > than of course the obvious stuff like being able to replicate the tables > > etc... > > > > Thanks > > P > > > > > > - > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
