Just from my experience with Radiator The have *.sql files that will setup the db nicely, including a radonline table for Simultaneous-Use, table for accounting and plus several others. This can be easily used as a template for your own db. I just find that having 1 backend system easier to manipulate. Just about anyone can write (or learn to write) queries and scripts to make life a whole lot easier. Slightly OT, Mike, Does inserting the correct records in your db completely setup the users mailbox on the mail server, or is their another process required? I have an older qmail installation that is patched to the hilt and only authenticates through the db backend. I have also been looking into using a mailserver that authenticates via radius. Thanks for the specs on the mydns, I didn't know how scalable it was Mike.
Zack > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:freeradius-users- > [EMAIL PROTECTED]] On Behalf Of Mike Cathey > Sent: Friday, November 01, 2002 6:39 PM > To: [EMAIL PROTECTED] > Subject: RE: Experience > > On Fri, 2002-11-01 at 17:10, Zack W Kneisley wrote: > > 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. > > I'll have to ditto Zack here. I'm in the process of migrating a small > ISP (~4k users) to using a centralized (My)SQL DB for authentication. > > We're moving from Sendmail to Postifx, which natively supports MySQL. > Cyrus will be used for IMAP/POP3 (including TLS). POP3/IMAP > authentication will be handled by SASL/pam_mysql. > > It sounds like Zack and I are using the same DNS server, mydns. I'm > using it in production now with ~150 active zones (4k PTR/4.6k RR). It > seems to be humming along nicely. > > As everyone here already knows, FreeRADIUS supports using SQL quite > well. =) > > I would be really interested in looking at how some of the other > FreeRADIUS users are processing accounting data stored in MySQL. I > haven't started to look at this yet, but it's on the list. From what I > can gather, I might even be able to steal some code from dailup_admin > > Thanks for the heads up about InnoDB/MyISAM tables Kostas. :) > > Cheers, > > Mike - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
