[Asterisk-Dev] Dynamic Configuration from MS SQL Server

[Rob Gagnon]

Yes, you can look into a patch at the following location while it is waiting
to be included in CVS:

http://bugs.digium.com/bug_view_advanced_page.php?bug_id=0001765

If you don't already have a login to bugs.digium.com, you will need to
signup, or you can access the files for ast_data from their live location
at:

http://svn.asteriskdocs.org/res_data/

(NOTE that this is NOT an official Digium, or Asterisk supported patch-- it
is an effort by some (myself included) to externalize database specific code
from the Asterisk code base)

You can also look into the built-in functionality for both mySQL and
PostGreSQL in app_voicemail.c and some stuff in chan_sip.c.  Check
apps/Makefile, and channels/Makefile for more information in current CVS.

For configuration information on the built-in SQL code, see:
http://www.voip-info.org/tiki-index.php and search for MySQL--- its a little
spread-out, but its there

Rob

----- Original Message ----- 
From: James Dutton
To: asterisk-dev at lists.digium.com
Sent: Thursday, June 24, 2004 9:37 AM
Subject: RE: [Asterisk-Dev] Dynamic Configuration from MS SQL Server


Having searched for days for information I certainly feel like I'm running
into trouble. Is it possible to use MySQL instead of the underlying database
without using Perl scripts to rebuild the conf files?
-----Original Message-----
From: asterisk-dev-admin at lists.digium.com
[mailto:asterisk-dev-admin at lists.digium.com]On Behalf Of Michael Devenijn
Sent: 24 June 2004 14:15
To: asterisk-dev at lists.digium.com
Subject: RE: [Asterisk-Dev] Dynamic Configuration from MS SQL Server


your running into trouble...
try to use mysql as an intermediate and DTS (mysql odbc) to transfer data
from mysql <--> SQLserver)

-----Original Message-----
From: asterisk-dev-admin at lists.digium.com
[mailto:asterisk-dev-admin at lists.digium.com]On Behalf Of James Dutton
Sent: donderdag 24 juni 2004 15:07
To: asterisk-dev at lists.digium.com
Subject: [Asterisk-Dev] Dynamic Configuration from MS SQL Server


Hi

I would like to use Microsoft SQL Server running on a remote Windows Server
for Asterisk configuration and billing. I have managed to connect via
unixODBS and freeTDS but am confused as to whether the next stage is
possible. Some of the documentation that I have read suggests that it is
possible to override the underlying asterisk database and use my one
instead. Is this so? And would that mean that a change in my database would
result in a realtime change in the call plan, without calling reload(). Any
help would be much appreciated.
James
---
James Dutton


DISCLAIMER: The content of this e-mail message does not constitute a
commitment of DKMA bvba This e-mail and any attachments thereto may contain
information which is confidential and/or protected by intellectual property
rights and are intended for the intended recipient only. Any use of the
information contained herein ( including, but not limited to, total or
partial reproduction, communication or distribution in any form ) by persons
other than the designated recipient(s) is prohibited.If an addressing or
transmission error has misdirected this e-mail, please notify the author,
either by telephone or by e-mail and delete the material from any computer.