similar to: Re: Best way to access MySQL data from dial plan

I'm not sure that any solution with the MySQL dialplan command is going to be ideal. You also can't nest your queries, ie the connectid/result id seems to only be good for one resultset at a time... try doing something like findme/followme with that! Doug. > -----Original Message----- > From: kjcsb [mailto:kjcsb@orcon.net.nz] > Sent: Monday, December 18, 2006 11:33 AM > To:

Resending as message didn't show up the first time >I need to access MySQL from the dial plan. Currently I am using the MYSQL >function: > exten => *78,n,MYSQL(Connect asterisklocal localhost asteriskuser password > asterisk) > exten => *78,n,MYSQL(Query resultid ${asterisklocal} CALL\ > sp_ins_into_avp(\'/DND/${CALLERID(number)}\'\,\'YES\')) >

Hi Adam, I appreciate your feedback, and understand totally where you're coming from as far as the database perspective goes. For the first "draft" of the app, I think I'm going to let it default to using a conf file for two reasons. First, my setup currently does not utilize a database. I would like to move to that type of a setup in the future however. Secondly, seeing as

Boy, am I stuck... I'm officially ready to toss Asterisk out the window. I have to admit it isn't necessarily all the fault of Asterisk either. It just seems that every option I turn to suddenly ends in failure. I don't know if it's me that's bitten of more than I can chew with this project, or maybe Asterisk just isn't mature enough yet. Nothing complicated really....

Hi, I can't figure out what syntax to use with the Dial() "M" parameter for the AEL parser to interpret properly. Creating an AEL macro named "macro-screen()" partly works as a hack, but it must not turn into a gosub properly, so I get warnings about the "return;". Dial(...,tgM(&screen)) with the ael macro named "screen" does not work

Hello all, I'm going to tackle learning C this week, and start writing my first * add-on/contribution; assuming it's actually worthy of contributing once it's done.. I think I've chosen a hefty project for my first go round here... I'd like to get some feedback from everyone on a FindMe/FollowMe spec I've put together. Before you read on, let me say, I don't want

Today is Swedens national day - since a few years a holiday too. We don't have a tradition on how to celebrate. Sweden has not been to war for a very long time, so there's no real spirit for the country here - it's been aroundfor such a long time, so what? :-) Guess we have to learn from abroad, to get a celebration feeling like July 4th in the US or May 17th in Norway (from

We have a number of DID's that do the standard VoIP tricks: ringing multiple locations, findme-followme etc. What is happening more and more is that customers call those DID numbers, and draw the reasonable conclusion that they are calling mobile numbers because they literally can HEAR that the called party is on a mobile. Consequently many of those customers draw the conclusion that they

"Douglas Garstang" <dgarstang@oneeighty.com> wrote: >Boy, am I stuck... > >I'm officially ready to toss Asterisk out the window. I have to admit it isn't necessarily all the fault of Asterisk either. It just seems that every option I turn to suddenly ends in failure. I don't know if it's me that's bitten of more than I can chew with this project, or

> > > > What is a better way to do it then in terms of performance, security, > and > > flexibility? Using exec and a shell script, or agi or something else? > > Setup extconfig to have realtime access to the database/table you want to pull info from, then in the dialplan use the app Realtime. -= Info about application 'RealTime' =- [Synopsis] Realtime

----- Original Message ----- From: "kjcsb" <kjcsb@orcon.net.nz> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> Sent: Wednesday, January 24, 2007 8:24 AM Subject: Re: [asterisk-users] realtime sipusers and rtcachefriends... bigheadache!! > >> hi folks, >> >> I am using asterisk 1.2.13 (debian

I need to manually set certain CDR fields. 1). Callers are allowed to call someone within the same organisation by using a 4 digit extension. A database lookup maps the 4 digit extension to the real number. However, a CDR for this call shows the original 4 digit extension still. What variable is used to set the 'dst' field in the CDR? Is it the dnid AGI var? How can I set this? I tried

Hi, I think this must be a bug introduced with 1.6.2.17.something. When I upgrade from asterisk-1.6.2.16.1 to asterisk-1.6.2.17.2 or 1.6.2.18, my AEL Dial() commands with the "U" options fail with the following error: [May 3 12:05:54] ERROR[6300] app_stack.c: Attempt to reach a non-existent destination for gosub: (Context:screen, Extension:s, Priority:1) Here are the segments

Trying to do a FollowMe test. When the extension is dialed, it dials my cellphone and my cell phone rings. But when I answer my cell phone it's just silence. When I press '1' on my cell phone, nothing happens. extensions.conf: exten => 140,1,FollowMe(mleonetti) followme.conf [general] featuredigittimeout=>5000 takecall=>1 declinecall=>2

The variable ${CONTEXT} stores the value of the current context. However if we are in a macro that will be the name of the macro. How do I access the name of the local channel's context. For example: [macro-test] exten => s,n,NoOp(Context ${CONTEXT}) CLI shows: -- Executing NoOp("Local/2592@1100006-2000-e802,2", "Context macro-test") in new stack I want to get

I am trying to get to the bottom of audio clicks, pops, dropouts with my Asterisk server. These occur even when the system is under minimal load (e.g. 1 Zap device in a queue being played music on hold) and occurs with both Zap and Sip devices so isn't network related. The audio problems occur at the same time on all channels and seems to be when Asterisk "gets busy" and uses

Hi, I have an extension which has the follow me option activated. The followme option should go to a IVR if no answer... The problem that I have is that everything works when I'm calling it from my extension, but if I use any landline phone or a cell phone, I'm unable to enter any options. When I press one option, it seems I do nothing... Please, could you help me? Thanks, Anahi

crashing. So, as a first step to solving **that** problem, make sure asterisk is compiled with debug flags, dumps another core file, and then you do the "gdb asterisk <corefilename>", and get a stack trace. That should give us some idea of what happened. > > I have a fairly simple Followme sequence in place to see how it works > before I get into the complex scenarios.

Hi list, I'm writing a little survey application, and surveys are generated dynamically. I use form_remote_tag and AJAX to submit the form to a method 'submit' in my 'survey' controller. The view generates the form as: <tr> <td>Question 1?</td> <td><input id="resultset_1" name="resultset[1]" size="30"

I'm trying to use the FollowMe app with Asterisk 1.4.17. I've followed the WIKI page on setting it up but I can't seem to get it to work. Here is my Asterisk version: pbx1*CLI> core show version Asterisk 1.4.17 built by root @ pbx1 on a i686 running Linux on 2008-01-10 12:08:48 UTC Here is a log of when the FollowMe is being called: NOTE: I've tried to use the AstDB as