similar to: MySQL Update from exten

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:

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

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

A friend and I have recently added the ability to announce the callers position in the call queue every x seconds.. or even just inject an anouncement every x seconds. All setup in queues.conf and can be setup per queue. My next project is to add the ability to announce the callers estimated wait time. I want some feedback to see whats the best method to calculate that? What do you want just

Hi all, What format is the LastCall variable of QueueMember event? I'm looking at: 1201897536 for instance. Thanks ! -- Warm Regards, Lee "Everything I needed to learn in life, I learned selling encyclopedias door to door."

Hello everybody, we are using asterisk 16 with a realtime config and have a problem with FOP2. We have developed a webinterface for managing the queues. If we add a member to a queue, everything works fine but the user is not shown in the queue in FOP2 Panel. The problem is that the FOP2 Panel does not receive the QueueMemberAdded Event. This will only be sent if the QueueAdd Function is

Hi all, Where can I find the status definitions for the status field below? Googled /web/voip-info.org and can't seem to find anything. Event: QueueMemberStatus Privilege: agent,all Queue: support Location: SIP/111 Membership: dynamic Penalty: 0 CallsTaken: 0 LastCall: 0 Status: 1 Paused: 0 Thank you! -- Warm Regards, Lee

Hi,all, Now,I am working at make an realtime monitor for the call center based on asterisk. and ,I had search the archive and wiki.Through the return info from the management API, I can get the waiting calls ,abandoned calls ,hold time, etc,but I don't know how to get the number of incoming calls. The info like following :

Hi all, I would like to track/store concurrent call usage per user by day/week/month and get server totals by day/week/month. Google comes up with mostly info regarding concurrent call limits, though my goal is to calculate actual concurrent channel usage and add it into reporting. I'm using * 1.6.2 + mysql - realtime (no gui). Any suggestions / open-source / AGI on where to start looking

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)

Greetings all- I have a handful of Asterisk 1.4.x installations where users dial 'outbound calls' to the PSTN even though the destination is on the same Asterisk box or on another Asterisk box on the same network. Instead of paying twice for the call to go out to the PSTN on one channel and back in on another channel, I'd like the ability to lookup the destination number in a MySQL

Very odd issue. Transitioning over to a new samba 3.6.9 (from 3.0.33) server. Majority of the users are ok, but a handful of users cannot map their home directories from windows7 clients. Logged into XP their homes map fine. They pass authentication: (log snippet) [2014/03/24 17:20:43.277337, 3] auth/auth.c:219(check_ntlm_password) check_ntlm_password: Checking password for unmapped

We just recently upgraded from Asterisk 1.2 to 1.4, and quickly noticed a change in the behaviour of the queues--a change that we cannot live with. We've used AddQueueMember/RemoveQueueMember to manage logging into and out of our queues for over a year now with Asterisk 1.2, and in that version the queue members were sorted in such a way that the person who had been logged in the longest

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

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: