similar to: create table in mysql using asterisk

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:

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

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

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

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

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

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

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

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

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\

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

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

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

Hello, I am trying to put my rails app on a host .So I presume the method to do this is to first do rake db_schema_dump and then copy it to the host and do rake db_schema_import. I use mySQL Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 4.3 ** Invoke db_schema_import (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db_schema_import rake

Hi, I would like to figure out how to determine what the id of the last element in a table is. Is there an equivalent to the Table.find() method which will tell me the number of elements in a table? also, maybe more importantly, where are the available methods on tables documented? What i am trying to do is to increment the id and work through a table and check whether the id i am currently

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)

Hey everybody, I've been using mysql databases more and more. I've run across a couple of instances where I've either made a mistake on the ip address of the mysql database or for whatever reason, mysql wasn't running. In those instances, I've noted that the mysql command will hang indefinitely (I've counted to 40 before killing it). The offending line is: exten =>

Hello All, I have managed to upgrade ruby to 1.8.7. However, when I use Terminal and ''cd'' to the app and run ''ruby script/ server'' ... I get an error when i click the link ''about your applications environment''. When I look into Terminal, it suggests Status: 500 Internal Server Error no such file to load -- mysql How do I overcome this?

Hello I am tying to install asterisk addson, but when i give make, it shows me following error messages: cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o app_addon_sql_mysql.o app_addon_sql_mysql.c app_addon_sql_mysql.c:164:77: macro "AST_LIST_REMOVE" passed 4 arguments, but takes just 3 app_addon_sql_mysql.c: In function `del_identifier':