similar to: func_odbc

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

Gentlemen, I have googled, searched the mailing list archives, and even spoke on the IRC channel, but have not found an answer to the following problem. I am attempting to retrieve multiple columns in an ODBC query using ARRAY per the solutions offered by many individuals. My dialplan code is as follows: exten => _.,n,Set(ARRAY(var1,var2,var3)=${ODBC_LOOKUP(${KEYVAL})}) exten =>

Hello, I'm working with asterisk 1.6. And I have success using func_odbc with one row query results (SELECT source,destination from cc WHERE ... ): exten => s,1,Ringing exten => s,n,Wait(4) exten => s,n,Answer exten => s,n,Set(ARRAY(NUMBER,REALNUMBER1,REALNUMBER2,STATUSAS)=${ODBC_GETVARIABLES(${NUMERIS})}) exten => s,n,Verbose(1| ${NUMERIS}, ${REALNUMBER1} ${REALNUMBER1},

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

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

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,

I'm trying to use func_odbc to write to a MS SQL db. Here's my func_odbc conf: [OPTIN] dsn=MSSQL-Optin write=INSERT into OptIn (orgID) values (${VAL1}) Dial Plan exten => +18665551212,n,Set(ODBC_OPTIN()=dave) When I do an odbc show, it shows that I am connected to the db. If I use isql, I can write to the db, however, when I use func_odbc, a record will not write. I'm using

Dear List, I have an asterisk 1.6.2 installation. I'm trying to configure func_odbc to read some mysql tables... but every time I tried I got this message: ERROR[24968] func_odbc.c: Unable to execute query [SELECT bloqueada FROM funciones WHERE extension='750'] I'm sure the DSN is right because I can do this: [root at grupodelavega asterisk]# su - asterisk [asterisk at

I need to insert/update multiple MySQL columns in a single row with the func_odbc function at the SAME TIME. Someone showed me how to use ARRAY to retrieve multiple values at the same time, but I need to SET multiple values. Can this be done? If not, I will just stick with MySQL, but that's a pain in the ass because the asterisk-addons package has no default rpm spec file for building an

Is func_odbc still working in trunk? I've recently (in the last few weeks) started having a problem where my custom functions don't work. The module loads, the configuration file is parsed fine, and the functions are even created and visible in "core show functions", but when executed from the dialplan I get a "no such function" error. Here's a bit of console

Is there any way to return multiple values from functions defined in func_odbc.conf? It appears that you can only return one value. True? Hope not.... Doug. ____________________________________________________________________________________ Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/ -------------- next part

This is primarily aimed at Sir Lesher, whose name graces the source code for func_odbc that I'm currently trying to read to answer this question. Tilghman (or anyone else who has determined the answer to this query), I have googled, searched wikis, and I'm currently perusing the source code, but the long and short of it is that I cannot seem to find any reference to variables set by

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

with func_odbc, in the definitive asterisk guide, they were suggesting the possibility that part, or perhaps all of, the dialplan could be written as SQL statement!? First off, that sounds like a good idea to me, but the tone of the authors was suggesting not so much, but that it was a personal preference. >From a naive perspective, why SQL statements at all? Why not just database config

Hi I'm using a macro to dial in a AEL dialplan. The problem is the macro do not set the field CDR(dst), showing only ~~s~~. I tried various configurations, but without solutions. This is the macro: macro dial-out(destno,dialstring,route_descr,interno) { __TRANSFER_CONTEXT=ipbx; if(${interno} = 1) { Set(__PICKUPMARK=${destno}); if(${ODBC_verify_user(${CALLERID(num)})} > 0) { t = tT; }

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

Hello, Does asterisk func odbc support multi query? I'm executing stored procedure which returns two tables. With tsql command I can see both tables. But asterisk only shows the first. My database is MSSQL. Maybe there is workaround... Thanks -- Best Regards, Giedrius -------------- next part -------------- An HTML attachment was scrubbed... URL:

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