Option 4.) Dump data from ACT to a "real" DB, then dump ACT completely? j/k - sorta... Does ACT support triggers and / or stored procedures? If so it would be relatively easy to keep a subset of the ACT DB in MySQL (or whatever) and keep it synchronized. If ACT is ODBC, I'm sure one could install an ODBC driver and write a query in SQL ( or whatever ACT uses). At that point it wouldn't be any different than any other backend data store. There is probably an option 5 - 10 as well. Is this a high volume environment? How many requests per sec / minute are we guestimating? I ask because if it's low you have many more options than if it's high. G -----Original Message----- From: freeradius-users-bounces+ggatten=waddell.com@lists.freeradius.org [mailto:freeradius-users-bounces+ggatten=waddell.com@lists.freeradius.org] On Behalf Of Jim Rice Sent: Tuesday, April 05, 2011 5:36 PM To: freeradius-users@lists.freeradius.org Subject: Can FreeRadius connect to ACT! database? I've been tinkering with dialup_admin and MySQL with FR 2.1.10. I have been able to get it to work for doing MAC authentication of Motorola Canopy SM's. The problem is that the customer database is hosted on Windows using ACT! It already contains the user account info, radio type, MAC address, and specified rate limits. A couple of choices: 1. Duplicate much of the data from ACT! and populate the MySQL database, then forever perform dual maintenance manually. 2. Use the ACT! SDK to develop a custom add-on to update the Radius database, or to write to flat files and copy them over (yuk.) (or hopefully): 3. Have Radius query the ACT! database directly? Is there an ODBC that can be made to work here? (At this point, I could care less about accounting.) I just need a simple MAC address lookup, and an Accept reply with a few attributes. I'd consider choice #4 if someone knows of one ... Thanks, Jim - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html <font size="1"> <div style='border:none;border-bottom:double windowtext 2.25pt;padding:0in 0in 1.0pt 0in'> </div> "This email is intended to be reviewed by only the intended recipient and may contain information that is privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any review, use, dissemination, disclosure or copying of this email and its attachments, if any, is strictly prohibited. If you have received this email in error, please immediately notify the sender by return email and delete this email from your system." </font>