Can FreeRadius connect to ACT! database?

[Gary Gatten]

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 at lists.freeradius.org [mailto:freeradius-users-bounces+ggatten=waddell.com at lists.freeradius.org] On Behalf Of Jim Rice
Sent: Tuesday, April 05, 2011 5:36 PM
To: freeradius-users at 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>