Can FreeRadius connect to ACT! database?

[Johan Meiring]

On 2011/04/06 12:52 AM, Gary Gatten wrote:
> 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.
>


Hi all,

ACT is actually a CRM system.

Unsure what database it uses, but I suspect it is Access Based (that 
horrible M$ thing)

My suggestion would be to use a php script (called using rlm_exec) that can 
query the ACT database directly.

Php can query weird and wonderful databases using odbc, and rlm_exec can 
call any php script.

Cheers,


-- 


Johan Meiring
Cape PC Services CC
Tel: (021) 883-8271
Fax: (021) 886-7782

-------------------------------------------------------
Before acting on this email or opening any attachments
you should read Cape PC Service's email disclaimer at:

http://www.pcservices.co.za/disclaimer.html
-------------------------------------------------------