realtime Aterisk dialplan

. I am using asterisk 1.6 and wrote my own dial plans for routing and billing wholesale calls. I often get 10 calls or more per second, sometimes even high as 70 calls in a single second.

I end up opening and closing a mysql connection about 5 times for each call. I need a way to use one connection for all my dialplans. I think Asterisk real time is the way to go. My asterisk is fully installed with freepbx. I need a simple method to use only one connection or 2 connections should I using 2 databases for each time I need to read or write data to a database from my diaplan or dialplans.

I write my own dialplans and pretty good at it and did a little google search and see this Job a small and simple job. I just don’t have the time to try to figure it out. I am willing to pay $30 for this job. I think enabling real time is the best way to go but I don’t need my setup completely switched to real time however willing to pay more if the bidder on this project is really good and can do it. Keep in mind for now I only need only a method to access the database multiple times at the same time using Dialplan by using only one shared connection. I posted my dialplan or context below which you will also need to modify to make work with the new connection method you set up for me to use to access my data tables.


exten => _.,1,Goto(numcleanup,${EXTEN},1)

exten => _1NXXNXXXXXX,2,Goto(222${EXTEN:0:11},3)

exten => _XXX1NXXNXXXXXX,2,Set(StrEXTEN=${EXTEN:0:11})

exten => _XXX1NXXNXXXXXX,3,Set(Strtech=${EXTEN:0:3})

exten => _XXX1NXXNXXXXXX,4,MYSQL(Connect connid [url removed, login to view] root mypassword a2b)

exten => _XXX1NXXNXXXXXX,5,MYSQL(Query resultid ${connid} SELECT prefix, ext, interstate, intrastate FROM cc_ext WHERE prefix=${Strtech})

exten => _.,7,MYSQL(Clear ${resultid})

exten => _.,8,MYSQL(Disconnect ${connid})

exten => _XXX1NXXNXXXXXX,9,GotoIf($[0${strext}>0]?10:11)

exten => _XXX1NXXNXXXXXX,10,goto(${strext},${EXTEN:3:11},1)

exten => _XXX1NXXNXXXXXX,11,Goto(222${EXTEN:3:11},3)

Kemahiran: Kejuruteraan, Linux, PHP, Memasang Skrip, Sistem Admin

Lihat lagi: asterisk realtime dialplan, asterisk dialplan query, mysql dialplan, prefix search, is in a prefix, dial n search, realtime dialplan example, can keep dialplan asterisk, realtime mysql dialplan, mysql clear dialplan, goto asterisk dialplan, asterisk mysql select dialplan, access mysql dial plan, asterisk realtime freepbx, asterisk time dialplan, asterisk mysql dialplan calls, goto realtime asterisk, asterisk persisten connection mysql, fastest process dialplan asterisk, freepbx realtime

Tentang Majikan:
( 19 ulasan ) English, United States

ID Projek: #370086

3 pekerja bebas membida secara purata $93 untuk pekerjaan ini


bid for fastAGI method with 1/2 conenction. numeber of conenction is [login to view URL] supported. conenction is persistent, no reconects.

$80 USD dalam sehari
(149 Ulasan)

Can be done. Please read PM message for more details. Thank you.

$150 USD dalam 6 hari
(31 Ulasan)

Bid price and time-frame is absurd, because you case need to be discussed in-tight over voice or some IM, please see PM for details. If you simply set up me a winner, I retract the bid, at first - read PM.

$50 USD dalam sehari
(1 Ulasan)