similar to: Updated app_mysql.c, enabling use of INSERT and UPDATE

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, 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 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, We've got endpoints and gateways who have T.38 fax support. We now use SER and Asterisk to do our routing and other functionality, but fax doesn't seem to work. Asterisk complains like this: Sep 9 09:25:45 WARNING[467828746]: RTP Read too short Sep 9 09:25:45 WARNING[467828746]: Asked to transmit frame type 256, while native formats is 32 (read/write = 256/256) With lots of the

asterisk-users-bounces@lists.digium.com wrote: > Isn't it possible to use T.38 for interconnecting hardware gates > supporting T.38 with asterisk using SIP REINVITE? > I'm not shure but but think its's might be possible because after > reinvite traffic goes directly from one gate to anotger, not over > Asterisk We've seen a problem here with asterisk. Wehn

Hi, I just started to "play" with Asterisk today and while I'm writing some IVR-like functionality in extensions.conf I would like to take a decision based on whether playing a file succeeds: exten => s,2,GotoIf($[Playback(${CALLERIDNUM}_personal) = 0]?3,501) So if Playback succeeds I want to jump to label 3, otherwise to label 500. Unfortunately Asterisk doesn't seem

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

asterisk-users-admin@lists.digium.com wrote: > It's running Debian Sarge with the stock 2.4.26 kernel (I > know it's still an "unstable" release, but I'd need to jump > through all sorts of hoops to get Woody working properly). I wouldn't make a fuss about this. sarge is at least as good as woody and much more up to date for the stuff asterisk can do /

Hi, In a VoIP only environment, Asterisk has to use ztdummy to have any chance of playing back understandable audio files (without drops, hickups etc). I have been using ztdummy to some degree of success, but I also have a "Wildcard TDM400P REV E/F Board 1" in the Asterisk machine I'm using. I'm not using this card for anything at all, but I'm wondering how to set it

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

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

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

Hi people, I'm trying to retrieve data from the database (server MySQL). I have the following dial plan: exten => s,1,Noop(Start) exten => s,n,MYSQL(Connect connid localhost user pass asteriskcdrdb) exten => s,n,Noop(Connid: ${connid}) ... The problem is that the 3? line is not showing the connid. How can I know the error? Thanks,

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)

Hello Jeremy, > OH - that's *really* interesting ! I wonder how it is > changing the SMB3+ redirector to do this ? It looks like applications could do something and give a hint to SMB3+ redirector, so far not quite sure how to make it, per process monitor (procmon) could show that write I/O size seems could be pass from the application layers,

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

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: