Actually, I currently have a mail server setup on a MySQL backend for authentication and several other applications can use a MySQL backend for many functions, including ISP billing, and even DNS server I have seen that can get it's records from a MySQL server. Personally I would like to build a system that uses MySQL exclusively for everything.
Zack > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:freeradius-users- > [EMAIL PROTECTED]] On Behalf Of Kostas Kalevras > Sent: Friday, November 01, 2002 2:53 PM > To: [EMAIL PROTECTED] > Subject: RE: Experience > > On Fri, 1 Nov 2002, Zack W Kneisley wrote: > > > Thank you very much for your detailed answer to my questions. > > I am in the process of planning an ISP deployment with proxy and local > > clients, including wholesale dialup from Qwest, MegaPOP and Aleron, > > having multiple RADIUS servers downstream. > > I also will need to have a local authentication scheme for Dial-up, DSL, > > and Wireless. I have yet to begin that stage of investigating though, > > and any insight into either Wireless Authentication or DSL would be > > appreciated. > > No detailed instructions are necessary, only real-world deployments that > > have worked or failures. If it's being done, It can be done again with > > enough time and persistence. I also believe that if this whole setup > > could work over a MySQL backend, administration and maintenance could > > benefit from it. Any insight or comments here would be well appreciated > > also. > > Use InnoDB and not MyISAM tables if you have a lot of accounting records . > The > MyISAM global table lock will create big problems when the radacct tables > starts getting larger and you use things like dialup_admin which do a lot > of big > sql queries. > > The only thing about MySQL for Authentication/Authorization is that it is > used > only for freeradius. You could use LDAP instead and base all your services > on > it. > > Just my 0.02E > > -- > Kostas Kalevras Network Operations Center > [EMAIL PROTECTED] National Technical University of Athens, Greece > Work Phone: +30 210 7721861 > 'Go back to the shadow' Gandalf > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
