Re: billing freeradius
look for peter nixon's stuff ,nifty really O/H zahra bahar έγραψε: Hi, I want to use freeraidus in billing. what module do this ? how could I do this? Is there any document for using freeradius for billing? thanks - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: db performance
Alan is right , under www.unix.gr you can find some stats phps I wrote for FR+mysql , small reports are fine indeed, large multi table selects with mYIsam tables lock the tables and freeradius starts timing requests out. The reports are nice though :-) You see , I know FR,mysql,posgres,postfix and all the OSS incantations I need a power point presentation of all this knowledge, and no Peter I cannot hire you. O/H Peter Nixon έγραψε: On Thu 17 May 2007, [EMAIL PROTECTED] wrote: Hi, Unless you are doing monthly or yearly summary reports which can take a lightly loaded DB server and peg it for minutes at a time... The lesson.. Keep a second DB for reporting :-) or use a DB that can handle non-blocking selects? ducks ;-) I use PostgreSQL... I didnt say that it stops the DB or queries.. Just that it works it in a way the FreeRADIUS will not. If the report is big enough and you have a heavy enough RADIUS load, it _can_ be enough load to push your box over the limit and start timing out requests... - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: radius+ldap+peap
as a general rool of thumb ,always use clear text in the ldap databases where you are trying to offer enhnanced password protection like cram-md5 even chap etc. You need the original data to calculate the hashes from. O/H Alan DeKok έγραψε: Arjuna Scagnetto wrote: ... PEAP with user whose password is in LDAP ... userPAssword: {SSHA}tymetcetcetc This WILL NOT WORK. See: http://deployingradius.com/documents/protocols/compatibility.html use clear-text passwords in LDAP. If you can't put clear-text passwords in LDAP, stop trying to use PEAP. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
db fall back to users file
A good one for you , when using an rlm_sql module if the sql server is down the module fails to instantiate and FR does not start at all. Is there a way to force instantation of rml_sql no matter the status of the sql server. Specifically I am trying to do redundant { sql fastusers } the idea is to switch to a local file when the db is down. On a second thought can I do ? accounting { redundat { sql detail } } - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
db performance
Hello gentle people Has anyone had the time to do a DB performance comparison for heavily loaded freeradius servers ? Thank you - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: db performance
Man thanks to all you folks for all the info. Let me elucidate my situation a bit, the organization where I am currently employed is split into factions. The faction I run is heavily OSS friendly , the application development/ DBA faction is not! I have deployed freeradius with mysql backends in the past with great success (100K users etc.) but the current people being insecure prefer to fork out 50K euros / year for oracle RAC licenses instead of looking into an unsupported platform What I need is proof positive that mysql / postgresql is at least as good as oracle for a radius DB. Again thanks. BTW , I have been using freeradius for a number of years , I would like to thank the developers for an awesome product Arran Cudbard-Bell wrote: Alan DeKok wrote: Angelos Karageorgiou wrote: Has anyone had the time to do a DB performance comparison for heavily loaded freeradius servers ? If your server is busy enough to be heavily loaded, you need multiple machines to maintain quality service. Once you have multiple machines, DB performance matters a lot less, because the load is spread across multiple machines. For DB specific issues, look for DB performance on google. PostgreSQL usually has better performance than MySQL. The application using the DB (radius, web, etc.) has very little effect on DB performance. However if you do choose to use MySQL, setting up query caching properly will have a huge (positive) impact on performance. Same data being read out of the database four times, per authentication session Clustering is a good idea too, though it's not a good idea to run an SQL server / SQL cluster node / LDAP directory server on the same box as FreeRADIUS as it will almost always have a negative impact on performance. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html