[Asterisk-Users] Re: Asterisk mysql database

[Daniel Niasoff]

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 at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Jeremy Kenney
Sent: 26 August 2004 23:29
To: asterisk-users at 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 at 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