similar to: cmd MySQL

Hi Guys, I am getting an error when executing another mysql query in dialplan after calling stored procedure. If calling the procedure from mysql cli it gives a result like: mysql> call call_control(78236721,1000,1233); +------+ | pass | +------+ | 1 | +------+ So I need asterisk to recognize this pass and take some actions based on what the pass value is. Dialplan looks like this:

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

Hello list, I'm having some problem integrating the SELECT TIMEDIFF() and SELECT DATEDIFF() in my code. The syntax I'm using works without any problems if I run them directly from the MySQL Client, but from the Asterisk Dialplan it just wont work. Is there a limitation in the MySQL() application for the Asterisk dialplan that produces this error? <CODE> context testsql { s =>

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",

Hi, I try to create a new table using MYSQL command in asterisk. This is what i write: Query resultid ${connid} CREATE TABLE IF NOT EXISTS "conference_600" ("id" int(11) NOT NULL auto_increment, "channel_id" varchar(40), "number_in_line" int(2), PRIMARY KEY("id")") and this is the warning that i get in the cli: app_addon_sql_mysql.c:383

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 list, I'm stuck for the moment @ the following : My Query (in a macro) : exten => s,n,MYSQL(Query resultid ${connid} SELECT\ vakantie_set\ vakantie_data1\ vakantie_data2\ FROM\ AstDB\ where\ SIPACCOUNT="${ARG1}") Asterisk CLI : [Aug 30 14:07:42] -- Executing [s at macro-vakantie:2] MYSQL("IAX2/zoiper-9238", "Query resultid 1 SELECT vakantie_set

hi, dear all MYSQL commands work well in 1.4.28 edition, but not in 1.6.21 is that the grammar is different between them? extensions.conf exten => s,2,MYSQL(Query resultid ${connid} SELECT\ callerid\ from\ blacklist\ where\ companycode = ${ARG2} and callerid=${ARG1} and blockenabled = 1) cli: -- Executing [s at macro-checkblacklist:2] MYSQL("SIP/1003-00000006", "Query

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

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

Hola: Tengo un absoluto desconocimiento de las posibilidades que ofrece R desde el punto de vista web así que agradecería que alguien me ?encaminara? para un proyecto que me está rondando. El proyecto consistiría básicamente en montar una especie de formulario web al cual accederían distintas personas (colaboradores) repartidas por España. El formulario tendría una serie de datos precargados y

What wrong with this: [get-dnisinfo] ; sub-routine to get owner's password exten => s,1,Verbose( == ) exten => s,n,MYSQL(Connect connid localhost root password dax) exten => s,n,MYSQL(Query resultid ${connid} SELECT\ password\ FROM\ dnislookup\ WHERE\ dnis=\'${IVR-Exten}\') exten => s,n,MYSQL(Fetch fetchid ${password} password) exten => s,n,Verbose( == Password found

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 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 All Does anyone know how to use the MySQL cmd in Asterisk with LIKE and % in the query? I have: exten => s,5,Set(query=SELECT name from contacts where tel like %${number}) exten => s,6,MySQL(Connect connid hostname username password dbname) exten => s,7,MySQL(Query resultid ${connid} ${query}) But there seems to be a problem with the % sign and I don't know how to

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]:

I don?t know if the last message was with content. So, I sent again. I have installed a Digium card TE210P and unicall for use MFC/R2. I think that it?s all right but I can?t make and receive calls. I?m using asterisk 2.1 with the patch made by Jos? P. Leit?o and the follow libs: libsupertone-0.0.2 libunicall-0.0.3 libmfcr2-0.0.3 zaptel 2.1 My number is 34318300. The Telco send me only 8300.

Hi everyone, What is wrong in below asterisk application? The output should be content of field booth_status from table booths: [extension-status] exten => _X.,1,MYSQL(Connect connid 127.0.0.1 root password my-extensions) exten => _X.,n,MYSQL(Query allow_call ${connid} SELECT extension_status FROM mytable WHERE extension=${CALLERID(num)} ORDER BY id DESC LIMIT 1) exten =>

Hi, I am trying to connect the outbound dialing with mysql with the following code, exten => 88,1,MYSQL(Connect connid hostname username password dbname) exten => 88,2,GotoIf($["${connid}" = ""]?error,1) exten => 88,3,MYSQL(Query resultid ${connid} SELECT\ phone\ FROM\ <tablename>\ WHERE\ phone =${a}) exten => 88,4,MYSQL(Fetch fetchid ${resultid} ph\ sa)

Hi, all. I've been searching google, bug reports and forums and have looked in all the asterisk-users list archives back to 2003 but haven't seen an answer to this, so thought I'd post here. The problem seems to be that Asterisk 1.6.0.5 is sending backslashes (needed to escape commas and so forth in 1.4.21.2) as *literal* backslashes to Mysql, so that Mysql gives a syntax error