similar to: Calling MySQL 5 stored procedures from app_mysql

Hi All, I'm getting a strange warning message when I perform a MYSQL data lookup. The operation performs fine, I retrive the data I'm looking for and continue on through the dial sequence without an issue. I'm wondering if this warning message is something to be concerned about, can't find any info about it. warning message: Mar 28 15:55:40 WARNING[27481]:

Hello all: I am trying to use the mysql command to retrieve information from a mysql database. my example here was formed from using the wiki reference to using the mysql command. The problem is with the fetch command. Here is the macro code: Mysql(QueryString=SELECT\ ivr-password\ from\ users\ where\ ivr-id=${userid}) Mysql(Query r ${connid} ${QueryString}) Mysql(Fetch fetchid ${r} dbuserpass)

Hi, For those interested in using MySQL directly from extensions.conf, there's already a source file floating around for using a MYSQL application to do SELECT queries. We're using the MYSQL app a lot in our exensions.conf, but we missed support for queries that don't return a result like UPDATE or INSERT. Here's an updated app_mysql.c which introduces the Execute command.

Here's an interesting question: If I transfer a call from Asterisk system to another with IAX, is there any way I can get control back on the original system? Or.. do I lose control, and the dialplan has to continue on the new system? Scenario is we transfer calls to an Asterisk system that handles ACD queues. If the ACD queue times out, we want to send the caller to voicemail on another

Hi, I am experiencing one-way audio from: SIP Device ----> Asterisk -----> Cisco 7200 The Cisco 7200 has a VXE+ card that will allow you to do SIP. I can pass audio from SIP Device to Asterisk through the Cisco 7200 to the other end, but the Cisco 7200 does not return any audio back to the SIP Device or Asterisk, it seems. I have tried upgrading to 12.3T IOS version, but no

Hi guys, I'm trying to connect Asterisk to the MySQL, but I can't execute it. It returns an error, as below: -- Executing [200 at teste:2] MYSQL("Console/dsp", "Query resultid 1 SELECT/ ramal/ FROM/ colaboradores/ WHERE/ ramal=200") in new stack [Feb 18 15:55:13] WARNING[7696]: app_mysql.c:393 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in

Thanks a lot for the reply. I did follow that already, but i do have a problem. Here is my extensions.conf part for that particular number exten => 6912345678,1,Answer() exten => 6912345678,n,MYSQL(Connect connid 127.0.0.1 root mypasswd asterisk) exten => 6912345678,n,MYSQL(Query resultid ${connid} SET NAMES utf8) exten => 6912345678,n,GotoIf($["${connid}" =

Egads. Getting queues to work is like pulling teeth. extensions.conf: exten => q_main,1,Queue(oneeighty_main||||1) exten => 80014055,1,Dial(SIP/80014018,15,tr) exten => 80014057,1,Dial(SIP/80014018,15,tr) exten => 80014052,1,Dial(SIP/80014018,15,tr) queues.conf: [oneeighty_main] musiconhold = default joinempty = strict leavewhenempty = strict strategy = rrmemory retry = 0 member

Hi All, Please refresh my memory. I am trying to install asterisk after 2 years. I hav'nt used it since 2008 (version 1.4.2). Now I am trying to install 1.8.0-rc2 on centos 5.5 but getting the following errors. app_mysql.c:33:25: error: mysql/mysql.h: No such file or directory app_mysql.c: In function ?mysql_ds_destroy?: app_mysql.c:135: warning: implicit declaration of function ?mysql_close?

Hello; I was using the 1.8 version of Asterisk. However, due to a problem I had to update. Update reporting system is broken when you have made. Current version 11.10. I installed the modules in the system for problems that are missing. I getting error as follows. ^[[A[Sep 24 03:16:50] WARNING[3624] loader.c:* Module 'app_mysql.so' was not compiled with the same compile-time options as

Aloha, I'm not sure why I'm getting this error, but I can't seem to get chan_dahdi to load. SIP & IAX2 are working fine. Debian 4 w/ 2.6.28 kernel. Asterisk 1.6.1.5, dahdi-linux 2.2.0.2, dahdi-tools-2.2.0 CLI> module load chan_dahdi.so Unable to load module chan_dahdi.so Command 'module load chan_dahdi.so' failed. [Sep 1 10:57:51] WARNING[31696]: pbx.c:4550

Hello, notice in the console output beneath that there is a resultid 6 but it can not be cleared : [May 5 11:46:27] -- Executing [s at sub:3] MYSQL("SIP/vart-00000336", "Connect connid localhost dialplan host Asterisk") in new stack [May 5 11:46:27] -- Executing [s at sub:4] MYSQL("SIP/vart-00000336", "Query resultid 4 DELETE FROM pickuptbl WHERE

Hi folks, I am having a question about efficiently finding the integrals of a list of functions. To be specific, here is a simple example showing my question. Suppose we have a function f defined by f<-function(x,y,z) c(x,y^2,z^3) Thus, f is actually corresponding to three uni-dimensional functions f_1(x)=x, f_2(y)=y^2 and f_3(z)=z^3. What I am looking for are the integrals of these three

Hello, Apologies if this question has already arised, hope you can help me to the find the solution to this or point the place to look at. I have a multidimensional piece-wise regression linear problem, i.e. to find not only the regression coefficients for each "interval" but also the beginning and ends of the intervals. To simplify it to the one dimensional case and two intervals,

Hi Soham, You're right that in LLVM IR arithmetic (with the current definition of `undef`) is not distributive. You can't replace `A * (B + C)` with `A * B + A * C` in general, since (exactly as you said) for A = `undef`, B = `1`, C = `-1` the former always computes `0` while the latter computes `undef`. This is fundamentally because replacing `A * (B + C)` with `A * B + A * C`

Hello, i wrote this function guete and now i want to plot it: but i get this error message. i hope someone can help me. Error in dim(robj) <- c(dX, dY) : dims [product 16] do not match the length of object [1] p_11=seq(0,0.3,0.1) p_12=seq(0.1,0.4,0.1) guete = function(p_11,p_12) { set.seed(1000) S_vek=matrix(0,nrow=N,ncol=1) for(i in 1:N) { X_0=rmultinom(q-1,size=1,prob=p_0)

Hello everybody, I've been using asterisk 1.2 for quite a long time now, but I thought it's time to try a newer version of asterisk. So I downloaded 1.8.5, extracted the tar, ran configure, make, make install ... Everything looks fine (no obvious compile/link errors). But as soon as I start asterisk, it dies with a segfault. I executed asterisk within strace and last action before the

Hi all, Is there any other packages to do numerical integration other than the default 'integrate'? Basically, I am integrating: integrate(function(x) dnorm(x,mu,sigma)/(1+exp(-x)),-Inf,Inf)$value The integration is ok provided sigma is >0. However, when mu=-1.645074 and sigma=17535.26 It stopped working. On the other hand, Maple gives me a value of 0.5005299403. It is an

Dear users, I am trying to show the equation (including coefficients from the model estimates) for a gam model but do not understand how to. Slide 7 from one of the authors presentations (gam-theory.pdf URL: http://people.bath.ac.uk/sw283/mgcv/) shows a general equation log{E(yi )} = ?+ ?xi + f (zi ) . What I would like to do is put my model coefficients and present the equation used. I am an

This came up in D20764, this IR verifies today: %X = type opaque define void @f_0(%X* %ptr) { %t = load %X, %X* %ptr ret void } define void @f_1(%X %val, %X* %ptr) { store %X %val, %X* %ptr ret void } which I found surprising -- what does it mean to load / store values of unknown sizes? Passing it to llc fails an assertion. Are there legitimate cases where we'd want to generate