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
-------------------------------------------------------
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html