similar to: mysql call stored procedure

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

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

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

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

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

Please could someone advise good manual for using lua for asterisk dialplan. There is not much docu about it. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110218/42642787/attachment.htm>

Hi, downloaded the latest snapshot just right now at soft-switch for MFC/R2 support and I get this message when trying to do libmfcr2; any idea ? it looks like he's not reaching Unicall. Thanks, Fred # make make all-am make[1]: Entering directory `/usr/src/libmfcr2-0.0.3' if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/include/libxml2 -g -O2 -MT

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 everyone Is there a possibility to catch an outbound callleg ID for the follovong scenario: some carrier -----> ------(asterisk1) --->-----asterisk2 ? I can get inbound callid for asterisk1 with a ${SIPCALLID} in extensions.conf or to look it up in cdrs field (are the same). But how about outbound? I have all calls just forwarded through asterisk1, not answered and for every call I

Hello, I encountered the dtmf problem between my asterisk box (1.4.23) and suppliers gateway (unknown vendor). I have dtmf mode set to rfc2833 and it alway worked till supplier has changed something. Now I receive from him dtmf payload 100. With the second supplier which sends dtmf with payload type 101 everything works. in cli I get this message as dtmf is entered rtp.c:1287 ast_rtp_read:

Hello, trying to load ael module in asterisk ver 1.6.2 got the following: asterisk*CLI> module load pbx_ael.so Unable to load module pbx_ael.so Command 'module load pbx_ael.so' failed. [Feb 18 11:25:47] WARNING[7412]: loader.c:449 load_dynamic_module: Error loading module 'pbx_ael.so': /usr/lib/asterisk/modules/pbx_ael.so: undefined symbol: ast_compile_ael2 [Feb 18 11:25:47]

Hello, I have the following structure: - app - controllers - helpdesk - call_controller.rb (Helpdesk::CallController < ApplicationController) - models - employee.rb - department.rb (Department < ActiveRecord::Base) - helpdesk - call.rb - call_history.rb (Helpdesk::CallHistory < ActiveRecord::Base) Is it possible to have a relationship between

Hello, I have transcoding card TC400P installed in server running Debian with Asterisk 1.4.23. Everything seams to be fine and after I boot up server I see in dmesg: 7.590966] Zapata Telephony Interface Registered on major 196 [ 7.590966] Zaptel Version: 1.4.12.1 [ 7.590966] Zaptel Echo Canceller: MG2 [ 7.610963] zttranscode: Loaded. [ 7.618969] wctc4xxp: tc400b0: Attached to

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

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

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 Everyone! According to voip-info.org the correcy syntax for the realtime function is: REALTIME(family|fieldmatch[|value[|delim1[|delim2]]]) on read REALTIME(family|fieldmatch|value|field) on write It seems from the syntax that it is only possible to retrieve a full row according to the value of only of column. This translates in SQL language as Select * from family where fieldmath =