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
signature.asc
Description: This is a digitally signed message part
