similar to: FUNC_ODBC and ARRAY

Hello everyone, I would be extremely glad if someone could help me with the following issue: cat /etc/asterisk/func_odbc.conf [call_user] prefix=GET dsn=asterisk_odbc_sip readsql=SELECT name FROM asterisk_sippeers WHERE name = '%477' Asterisk CLI show the following issue: -- Executing [205 at phones_wildcard:1] NoOp("SIP/Y_MD_vlungu_477-00000008",

Hi I have On func_odbc [EXEC] readhandle=ressqlserver writehandle=ressqlserver readsql=${ARG1} writesql=${ARG1} I'm trying an update on dialplan: exten=> 141,3,Set(dummy=${ODBC_EXEC(UPDATE Tabla set campo = ${EXTEN})}) On Cli: WARNING[3579]: func_odbc.c:353 acf_odbc_read: Error -1 in FETCH [UPDATE Tabla set campo = 4356] Any idea why is this?? The query

Hello, I have been trying to completely disable music on hold on my asterisk system. When a call is put on hold I do not want any music on hold, but I would like the remote user to get informed of this event (depending on the technology e.g. with a SIP reinvite and an SDP indicating the call is on hold). I have searched and tried out various approaches, but when putting the call on hold

Hi All Anyone know how to do include files with func_odbc.conf? I now have several pages of functions in my func_odbc.conf and it is getting harder to maintain it. I would like to break them up into files by category. The standard method of using the #include does not seem to work . Ideas are appreciated. Bryant -------------- next part -------------- An HTML attachment was

Hello, Now I'm testing func_odbc and hash. My configurations are: func_odbc.conf [GETNUMBER] dsn=sqlserver ;mode=multirow ;rowlimit=10 readsql=SELECT number,real_number1,real_number2,status FROM ivr.dbo.numbers WHERE number=${SQL_ESC(${ARG1})} extensions.conf exten => s,1,Ringing exten => s,n,Wait(4) exten => s,n,Answer exten => s,n,Set(NUMERIS=37037210602) exten =>

Hi, With 1.6.1.7-rc2, doc says: select*CLI> -= Info about function 'SPRINTF' =- [Syntax] SPRINTF(<format>,<arg1>[,...<argN>]) [Synopsis] Format a variable according to a format string [Description] Parses the format string specified and returns a string matching that format. Supports most options supported by sprintf(3). Returns a shortened string if a format

Hi folks, How would I go about running a stored procedure call from asterisk via func_odbc. I'm after an example entry in func_odbc if possible for ast 1.4 Also, if someone could post an insert statement that actually works, would be nice. Thanks, :)

Hi, I've got a brand new Asterisk 11 setup for which I would like to keep the number of loaded modules to a minimum. My goal is to this setup in a pure SIP environment, for switching incoming calls to outgoing tSIP trunks. When I leave autoload=yes in /etc/asterisk/modules.conf, I can handle an incoming SIP call with a Playback app. When I leave autoload=no in /etc/asterisk/modules.conf, it

Hello, I'm trying to match a number in international format, like +49XXXX... The regexp string "^\+49" doesn't work. Both in $["+49..." : "^\+49"] and ${REGEX("^\+49" ${NUMBER})}. The error is: WARNING[12486]: func_strings.c:138 regex: Malformed input REGEX(): Invalid preceding regular expression. The regexp expression "^49\+" works.

Hi, I''ve got a TimeStamp field in MySql and want to use the hour and minutes in the value. for example: StartTime = Schedule.find(action2.ScheduleID).DateTimeStart.to_s That returns "Mon Feb 20 08:00:00 Romance Standard Time 2006" How do I get 08:00 returned ?? Thanks ! Steven. -- Posted via http://www.ruby-forum.com/.

Hi there, I'm using asterisk meetme function like: exten => 9070,n,MeetMe(|dcM) and everything works pretty well. But I would like to add a review of the entered conference number before the user jumps into the conference. Somthing like: *:"Please enter the conference number followed by the hash key" (works) U: 123456# (works) *: "You are entering conference number

Hey All, Odd thing. I am just trying to return the whole date time stamp from a SMALLDATETIME field in a MS SQL server. func_odbc.conf = readsql=SELECT DateCreated FROM [REDACTED] WHERE Code = '${ARG1}' Problem is I only get the first 15 back from the field. Like so... Connected to Asterisk 1.8.6.0 currently running on [REDACTED]-dev (pid = 2240) Verbosity is at least 3

Hi. i have an asterisk 11 installation that i run in my soho environment. My system has mysql to store all the cdrs. I would like make use of the mysql and store numbers and names. eg +4922123456789 "Atux Null". So when the +4922123456789 calls in my system the name "Atux Null" will pop up next to the number. at the moment i have a database called MyNames in mysql that has this

All, Thank you in advance for any help. I have a customer in need of a conferencing system. A requirement is for users to each have their own PIN for the same bridge. So, I put the list of users, PINs bridges into a MYSQL DB and used an ODBC connector to parse the table. Asterisk is connected and reads the rows as expected. The problem is that if a user enters a PIN that is NOT in the table,

Asterisk 1.4.19, Zaptel 1.4.10 and libpri 1.4.3. When I try to start up Asterisk (with -cvvv) I get an error regarding func_curl.so (lines omitted) ... == Registered custom function STRFTIME == Registered custom function STRPTIME == Registered custom function EVAL == Registered custom function KEYPADHASH == Registered custom function SPRINTF func_strings.so => (String handling

On Mon, May 2, 2011 at 3:15 AM, A E [Gmail] <all.eforums at gmail.com> wrote: > Hello All, > > Probably a silly question, but we're wondering if people have had any > experience and have data to demonstrate if the performance of the Asterisk > system might suffer in terms of latency etc. if we're to have it retrieve > sound files from a database using odbc as

Hello list, I'm hoping that you could read through this mail and give me some tips on how to improve my setup (functionality, security, really anything). It's my first Asterisk installation and meant for simple home use. I installed Asterisk 11 on an OpenWrt Barrier Breaker router. Currently it's configured for Ekiga so I can test. In a few weeks I'll change to a Telco SIP

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title></title> </head> <body bgcolor="#ffffff" text="#000000"> <font face="Arial">Greetings,<br> <br> I'm running

It may have gone to sleep. Chris Cooper Systems/Network Administrator EFC International 1940 Craigshire Blvd St. Louis, MO 63146 US Phone - 314-439-4325 Fax - 314-439-4443 Mobile - 314-402-8912 - -----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of asterisk-users-request at lists.digium.com Sent:

How do I make a user dial a passcode if he wants to make an international call? ________________________________ This electronic message contains information from BOSH Global Services which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above. If you are not an intended recipient,