similar to: Mysql identifier not found

Hello, There are 3 PRI's connected to the card each from different operators. Especially echo occured on span 3 is really annoying. Configuration files are as follows. Is there something wrong in conf ? Zapata.conf -------------------------- [channels] context=default switchtype=euroisdn usecallerid=yes hidecallerid=no callwaiting=yes usecallingpres=yes callwaitingcallerid=yes

Hello all. I am trying to use app_mysql. It works for selects and functions, but does not want to work with procedures. Pls have a look: Calling function: CREATE FUNCTION f_1(a VARCHAR(20)) RETURNS INTEGER RETURN (SELECT count(*) from peer where name = a); Result: -- Executing Macro("IAX2/100-3", "local|100") in new stack -- Executing MYSQL("IAX2/100-3",

I've tried every combination I could find on the net and so far there is no joy The thing is I can do this update from the command line: Maybe some new eyes might find the answer? exten => update,1,MYSQL(Connect connid localhost root password dax) exten => update,n,MYSQL(QUERY resultid ${connid} UPDATE\ caller\ SET\

An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090909/4ba848c0/attachment.htm -------------- next part -------------- A non-text attachment was scrubbed... Name: bhfisher.vcf Type: text/x-vcard Size: 253 bytes Desc: not available Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20090909/4ba848c0/attachment.vcf

Hello list, I have the following problem with MySQL-queries : it seems that the resultid and connid are not cleared ! [macro-GetMailboxFromSIPuserID] exten => s,1,MYSQL(Connect connid localhost xxx xxx xxx) exten => s,n,MYSQL(Query resultid ${connid} SELECT\ extensie FROM\ tbl_SIPaccounts\ WHERE\ ID="${ARG1}") exten => s,n,MYSQL(Fetch fetchid ${resultid} extensie) exten

Hello all, I have data: Genes time rep vart dye y trt 130911 sa1-d07 030min 1 col g 9.636244 o 145771 sa1-d07 030min 1 col r 8.107577 c 93335 sa1-d07 030min 1 ler g 7.409566 o 94821 sa1-d07 030min 1 ler r 5.107160 c 10119101 sa1-d07 030min 2 col g 8.336862 o 11605101 sa1-d07 030min 2 col r 7.824530 c 725313 sa1-d07

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

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}" =

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

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

Can some tell me what this warnings means? The dialplan works, but I get these warnings every once in a while: Log: [Dec 1 12:26:31] WARNING[20425] app_addon_sql_mysql.c: Identifier 0, identifier_type 2 not found in identifier list [Dec 1 12:26:31] WARNING[20425] app_addon_sql_mysql.c: Invalid result identifier 0 passed in aMYSQL_clear [Dec 1 12:26:31] WARNING[20425] app_addon_sql_mysql.c:

i have problem in compiling asterisk-addons 1.0.1 --------------------------------------------------------- [root@kamran asterisk-addons-1.0.1]# make cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/local/mysql/include -c -o cdr_addon_mysql.o cdr_addon_mysql.c ../asterisk: Not a directory make: *** [cdr_addon_mysql.o] Error 1 --------------------------------------------------------- i want to

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)

What I'm retrying to do is update mysql field with the new message ID that was just recorded. Ideally, I'd like to specify the field to update using a variable ${BINID} and use ${NEWPHRASENAME} for the value - I'm not sure asterisk will allow using a variable for the field name and if not, I'll attempt to create an exten for each bin to update. Here the method I'd like to

> On 2020-06-06 10:38, Antony Stone wrote: > On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote: > >> In a situation when I start asterisk, and the remote database is >> unreachable, asterisk waits for several minutes before it actually >> starts (before it loads sip module, etc). >> >> And when database is unreachable during operation, when call

I have several rasters that I want to do some calculations ,basically calculating the moving average. dir2 <- list.files("D:\\2010+2011", "*.bin", full.names = TRUE) saf=stack(dir2) movi <- overlay(stack(saf),fun=function(x) movingFun(x, fun=mean, n=3, na.rm=TRUE)) Error in .overlayList(x, fun = fun, filename = filename,

Ok, i tried the suggestion: Instead of: sippuser => resource, database_name, table_name sippeer => resource, database_name, table_name I put in: sippuser => resource, context, table_name sippeer => resource, context, table_name Unfortunately, with the same results. btw i tried both "general" as "default" Besids the commands i tried below, isn't there any

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.

This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. --1133331701-635408861-993124011=:10449 Content-Type: TEXT/PLAIN; charset=US-ASCII I'm not sure if the warning messages Warning messages: 1: variable 67 is not a factor in: