similar to: ODBCExec and Asterisk 1.6 New Thread

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

Hi all, I am trying to install the ODBCexec and ODBCquery functions into my dialplan but I'm having difficulties in the installation of app_odbcexec.c itself. I'm using Asterisk 1.2.1 and I've downloaded and installed unixODBC. But when I try to run "make" after editing Makefile and copying the app_odbcexec.c to my asterisk/apps location, this is the output I get: cc -fPIC

Hi all, I am trying to install the ODBCexec and ODBCquery functions into my dialplan but I'm having difficulties in the installation of app_odbcexec.c itself. I'm using Asterisk 1.2.1 and I've downloaded and installed unixODBC. But when I try to run "make" after editing Makefile and copying the app_odbcexec.c to my asterisk/apps location, this is the output I get: cc -fPIC

Hello everyone, I have just gone through the installation process to add commands ODBCexec and ODBCquery to the extensions.conf. However I am receiving an error in asterisk "No application 'ODBCquery' for extension (incoming,33,2)". I have installed unixODBC-2.2.11 and myODBC 3.51. I have gone through the instructions as per

Hi, I'm trying to write a AGI in PHP to get the numbers dialed (with read()), save it into a variable to insert it into a SQL server database. But I cannot see results into the variable, it always return NULL. Here is a piece of the AGI. fwrite(STDOUT,"exec Read my_var|/sound_to_play|5|||15 \n"); fflush(STDOUT); $conn=odbc_connect('MSSQL', 'USER', 'PASS');

Hi list! I'm trying to configure my Asterisk to accept SIP-TLS connections, too. I followed this HowTo: http://remiphilippe.fr/sips-on-asterisk-sip-security-with-tls/ But as soon I try to connect to my Asterisk using SIP-TLS I get on Asterisk-CLI: == Problem setting up ssl connection: error:140760FC:lib(20):func(118):reason(252) [Jun 5 20:16:25] WARNING[20826]: tcptls.c:669

Bonjour. Je n''ai pas encore eu l''occasion d''utiliser TE_RICH2 en plus de TE_RICH | TE_MULTILINE, je compte l''essayé. Pour rentrer le texte dans TextCtrl j''utilise : @dou << texte Sebastien _______________________________________________ wxruby-users mailing list wxruby-users@rubyforge.org http://rubyforge.org/mailman/listinfo/wxruby-users

Salut alex, j''utilise ce bout de code pour faire apparaître mon texte dans ma fenêtre: @dou = TextCtrl.new(@s, -1, "", Point.new(10, 70), Size.new(410, 210), TE_RICH | TE_MULTILINE) @dou << "je vais à l''école" le problème c''est que l''encodage ne marche pas.Je ne peut pas mettre l''accentuation.J''ai essayer pas mal de

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

On 12/05/2018 05:00 PM, Antony Stone wrote: > On Wednesday 05 December 2018 at 15:31:38, hw wrote: >> I don't see a table for that. > > You need to create that for yourself. > > Asterisk can write to database tables, but doesn't help you set them up, for > reasons I can't comment on. How do I know what the schema needs to be? Does anybody have a scheme for

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

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

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

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

en fait je vous renvoi ce message car maintenant la taille de la police change au bout de 500 lignes environ, alors que j''avais reussi à garder la taille jusqu''à environ 5000 lignes. Je ne comprend pas. Est-ce que c''est instable? le bout de code que vous m''avez envoyer ne marche pas. merci Sebastien _______________________________________________ wxruby-users

Hi guys, Having issue with getting CDR to write to MS-SQL via ODBC. > cdr_odbc: Connected to freetds-connector > cdr_odbc: Error in PREPARE -1 > cdr_odbc: Query FAILED Call not logged! == Spawn extension (cisco, ##########, 2) exited non-zero on 'IAX2/astYYYY-507 Isql test: [xxx at YYYY asterisk]# isql freetds-connector XXXXXXX YYYYYYYYY

I have two questions; Do you know how to take out axes in a levelplot? Me doesn't work axes = FALSE And I would like to fix the values range of colorkey or legend from my rainbow col.regions, dou you know how can I fix this values independent of values database? Thanks and happy new year! [[alternative HTML version deleted]]

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 all, I'm trying to set up an odbc connection to a ms-sql server from an asterisk 1.6.1 install My problem is that I cannot get asterisk to build func_odbc & res_odbc.so I installed yum -y install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel And then went on to reconfigure / recompile asterisk after a ./configure --with-odbc=/usr/lib/ I get

I've been searching the Internet for information regarding the replacement of astdb with a modern sql engine. There are several reasons one would like to do this. First of all, external applications have a hard time reading/writing to the now-old astdb format. Also (and this is what interests me most), the sql astdb could easily be clustered throughout several servers (I'm looking for a