On Fri, 1 Nov 2002, Zack W Kneisley wrote: > 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.
If you're looking for something like this with FreeRADIUS, check src/modules/rlm_sql/rlm_sql_mysql/db_mysql.sql Franklin -- Franklin Trumpy, NFA, MNGS, GSc | Say not, "I have found the truth," Sr. UNIX Systems Administrator | but rather, "I have found a truth." Lighthouse Communications | [EMAIL PROTECTED] | Say not, "I have found the path of the soul." (515)244-1115 | Say rather, "I have met the soul walking (888)953-3278 | upon my path." http://www.lh.net | | -Kahlil Gibran, _The Prophet_, 1923 | On Fri, 1 Nov 2002, Zack W Kneisley wrote: > Date: Fri, 1 Nov 2002 19:13:58 -0500 > From: Zack W Kneisley <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: RE: Experience > > 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 > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html