similar to: Asterisk to MySQL Data Lookup Warning Message?

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, If Iam doing UPDATE SQL statements I got an overload for connection. am doing everytime an Disconnect ${connid}) but this is ignored. any idea? best regards Thomas

Hi, Mr. Spencer written the article "Using DUNDi with a Cluster of Asterisk Servers <http://www.voip-magazine.com/content/view/3644/0/1/0/> " in the VoIP Magazine and the piece follow: [lookupdundi] exten => _X,1,Goto(${ARG1},1) switch => DUNDi/priv exten => i,1,Goto(lookupmysql,${INVALID_EXTEN},1) I didn't get understand the usage ARG1 argument in the context.

Ok, I am looking for some input on using dundi. Is anyone using dundi? And how is it working out? -- Best regards, Al Bochter Bochter Services http://www.BochterServices.com/?t=Email (VOIP PBX) 1-866-638-1254 (Voip PBX) Free World DialUp: 780-217 WebSite: http://www.freeworlddialup.com/ We have Toll Free DID's instock http://www.bochterservices.com/?t=TFdid For Information on PBX

I'm having trouble connecting a asterisk server to a SIP Express router. Inbound calls to my asterisk server works just fine, but when i try to make outbound calls I get the following error message: Nov 27 22:40:48 NOTICE[4687]: chan_sip2.c:7967 handle_response: Failed to WWW-authenticate on INVITE to '"username" <sip:username@mysipprovider>;tag=as5399a078' I'm

Hi, I am experiencing one-way audio from: SIP Device ----> Asterisk -----> Cisco 7200 The Cisco 7200 has a VXE+ card that will allow you to do SIP. I can pass audio from SIP Device to Asterisk through the Cisco 7200 to the other end, but the Cisco 7200 does not return any audio back to the SIP Device or Asterisk, it seems. I have tried upgrading to 12.3T IOS version, but no

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

Hi there, I want to add 4000 Callerids and Callernames to my asterisk-db. (/var/lib/asterisk/astdb) I do not want an external database or an sql-database because I do not want asterisk to depend on external processes. However, when I do 4000 "database put number name" via a shellscript and "asterisk -rx" I only have 600 entries later in my asterisk- database. The asterisk

I forgot to take out the portion that would read in the voicemail boxes from the text file. If you want to leave it in then you could have some voicemail boxes defined in the text voicemail.conf. I do not, so I have removed it. Below is the new patch: *** app_voicemail.c 2004-06-23 07:55:54.000000000 -0600 --- app_voicemail.c.new 2004-06-23 07:55:47.000000000 -0600 *************** *** 49,61 ****

Hello list, scrambling different pieces of info together I've come with the following : I want to have my "register =>" statements in a MySQL-database, so I've made the following table. table ast_config : id 1 cat_metric 0 var_metric 0 commented 0 filename sip.conf category general var_name register var_val username:password at sip.provider.net In ext_config

Hello all, I am just getting going on building my system, but I thought I'd send you all a patch that I wrote so the command: show voicemail users issued from the CLI works properly when there is a postgres backend for the voicemail. The current version of the app does not display the voicemail boxes found in a database. It is called in the load_config function. I haven't done

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! What are the typical ways to work around the 64 groups limit? thanks klaus

Hello, I am using asterisk realtime with a postgresql database on the same server. In res_pgsql.conf I have specified [general] dbhost=localhost dbport=5432 dbname=asteriskdb dbuser=psql dbsock=/tmp/.s.PGSQL.5432 Since both asterisk and db are on same server, I would like asterisk to connect to db using the local unix socket. However asterisk is not using the local unix socket to connect to

Hello, I'm testing with asterisk 1.8.3.2 and come across this: Call from one extension to another with: [macro-internal-call] ;ARG1=extension to call exten => s,1,Set(TOCALL=${DB(SIP/${ARG1})}) exten => s,2,Dial(SIP/${TOCALL},60,tT) ... As I had no entry in the asteriskdb, so the SIP uri was empty, and asterisk core dumped with: gdb output: #0 0xb7c7db33 in strchr () from

VOIP Users Conference Friday Oct 12 @ 12:30 PM EDT Today, besides whatever else is on anyone else's minds, we'll be discussing some asterisk communication techniques for use with SMS, email and web API. Also, some typical uses for the asteriskdb, what it is and why you care about it at all. Join us: http://VoipUsersConference.org/join.php IRC: freenode.net #voip-users-conference

managesieve has gone mad. One person went on holiday when he came back his out of office would not switch off, then it replicated it's self into two other users (the vacation noticE) and started to be sent out for them and those users had never set up an out of office or looted into round cube. even deleting the vacation notice did not stop it, but if we put another vacation notice in then the

Ok guys there's a lot of stuff in here. I am using Samba3.0beta1, becuase I tried beta3 and when I mounted shares i could look at them. Well anyways I'm in beta1 and I am attempting to set up winbind. Below is a copy of my pam.d/samb file: PAM.D/SAMBA: auth sufficient /lib/security/pam_winbind.so auth sufficient /lib/security/pam_unix.so use_first_pass auth

Trying to set up a mail server under CentOS7 - having done this with CentOS5 and CentOS6 over the last decade with no issues and reliable service, it was time to upgrade (?) to CentOS7. Shouldn't be a problem, right? Getting to grips with systemd has been challenging - to say the least. So a brief overview of what I am trying to set up: postfix / amavisd-new / spamassassin / clamav so we

Hi everyone, I am getting a segmentation fault (seems to occur randomly) using Asterisk 13.7.0-rc2 with PJProject 2.4.5. It appears to be something that libmysqlclient is complaining about when doing a query in ps_endpoint_id_ips. We are using Asterisk Realtime. This also seems to occur in Asterisk 13.5.0. Below is a backtrace that might help a little. I have looked through the change log for