asterisk users - Aug 2004 - Asterisk mysql database

I would like to configure asterisk to run complete out of mysql everything
from extensions to voicemail has this been implemented yet and how kind of
problems have their been

On Thu, 26 Aug 2004 18:29:29 -0400, Jeremy Kenney wrote
> I would like to configure asterisk to run complete out of mysql everything
> from extensions to voicemail has this been implemented yet and how 
> kind of problems have their been
> 
     There are several ways to do it, but no easy one.  I do store all
information on Mysql for extensions, sip, voicemail and iax, but I then have
to extract that information to create a text file which is then read by
asterisk using the #include directive from the main config files.  The only
thing that is read directly from Mysql is the voicemail config.

     There is a problem when you use Mysql for VM, the DIRECTORY application
does not work.  Apart from that everything is working but you will have to do
your own interface to add/delete/modify information.

--
Carlos Chavez
Director de Tecnolog?a
Telecomunicaciones Abiertas de M?xico S.A. de C.V.

I have just completed a project where I have just implemented running
extensions.conf from mysql.

When the extension is called, the dialplan passes the extension together
with the calling number a to a perl agi script. The perl script does a
couple of sql queries and sets a few variables which tells asterisk how to
route the call.

Here is an example of the extensions.conf


exten => _X.,1,AGI(SetVariablesFromSipToZap.agi|${CALLERIDNUM})
exten => _X.,2,SetCIDName(${CallerIDFullName})         
exten => _X.,3,SetGroup(SIP/${OriginalCallerIDNumber})
exten => _X.,4,GotoIf,$[${RecordCalls} = 1]?5:7  
exten => _X.,5,AGI(SetRecordOutgoingFromSip.agi|${CALLERIDNUM},${EXTEN})
exten => _X.,6,Monitor(gsm,${MonitorFile},m)
exten => _X.,7,Dial(Zap/g1/${EXTEN}) 
exten => _X.,8,StopMonitor
exten => _X.,9,Hangup

This works pretty well for me.

Daniel

 

-----Original Message-----
From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Jeremy Kenney
Sent: 26 August 2004 23:29
To: asterisk-users@lists.digium.com
Subject: [Asterisk-Users] Asterisk mysql database

I would like to configure asterisk to run complete out of mysql everything
from extensions to voicemail has this been implemented yet and how kind of
problems have their been

_______________________________________________
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users