Re: [asterisk-users] error cant write to function ODBC_DEVICES
On Sun, Oct 20, 2013 at 6:12 AM, Israel Gottlieb isr...@gmail.com wrote: snip but from the dialplan gives me a error cant write to function ODBC_DEVICES happy to hear any ideas I don't use func_odbc on a regular basis, but from looking at the sample file and looking at the functions provided within Asterisk. The ODBC_DEVICES function does not exist. The three functions available for configuration within func_odbc.conf appear to be ODBC_SQL,ODBC_ANTIGF,ODBC_PRESENCE Also the only examples of the string ODBC_DEVICES out on the web according to Google show up at the various forums you have asked about it. :) So.. can't write to function is definitely expected behavior. Hope that helps! -- Rusty Newton Digium, Inc. | Community Support Manager 445 Jan Davis Drive NW - Huntsville, AL 35806 - US direct: +1 256 428 6200 Check us out at: http://digium.com http://asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] error cant write to function ODBC_DEVICES
Thanks for replying (I only asked on this list) Whatever function you add to that file becomes a function and that was a odbc function I added Anyhow after a restart of asterisk it started working ok It worked like a charm (I had more than 5 inserts to a database within a few hours) -Original Message- From: Rusty Newton rnew...@digium.com Sender: asterisk-users-bounces@lists.digium.comDate: Wed, 23 Oct 2013 12:15:50 To: Asterisk Users Mailing List - Non-Commercial Discussionasterisk-users@lists.digium.com Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [asterisk-users] error cant write to function ODBC_DEVICES On Sun, Oct 20, 2013 at 6:12 AM, Israel Gottlieb isr...@gmail.com wrote: snip but from the dialplan gives me a error cant write to function ODBC_DEVICES happy to hear any ideas I don't use func_odbc on a regular basis, but from looking at the sample file and looking at the functions provided within Asterisk. The ODBC_DEVICES function does not exist. The three functions available for configuration within func_odbc.conf appear to be ODBC_SQL,ODBC_ANTIGF,ODBC_PRESENCE Also the only examples of the string ODBC_DEVICES out on the web according to Google show up at the various forums you have asked about it. :) So.. can't write to function is definitely expected behavior. Hope that helps! -- Rusty Newton Digium, Inc. | Community Support Manager 445 Jan Davis Drive NW - Huntsville, AL 35806 - US direct: +1 256 428 6200 Check us out at: http://digium.com http://asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] error cant write to function ODBC_DEVICES
On Wed, Oct 23, 2013 at 12:27 PM, isr...@gmail.com wrote: Thanks for replying (I only asked on this list) Whatever function you add to that file becomes a function and that was a odbc function I added Anyhow after a restart of asterisk it started working ok It worked like a charm (I had more than 5 inserts to a database within a few hours) You can tell I haven't used func_odbc in ages. :) Glad you figured it out despite me misleading you unwittingly. An Asterisk restart! It is usually the simple things. -- Rusty Newton Digium, Inc. | Community Support Manager 445 Jan Davis Drive NW - Huntsville, AL 35806 - US direct: +1 256 428 6200 Check us out at: http://digium.com http://asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] error cant write to function ODBC_DEVICES
Hi all asterisk 1.8.23 I have odbc all setup to mysql but cant figure out why the dialplan wont write to the odbc function fubc_odbc.conf [DEVICES] dsn=device-conn;dsn in res_odbc not odbc.ini readsql=SELECT call.callNum, call.city, devices.callId, devices.id FROM call INNER JOIN devices ON call.id = devices.callId WHERE deviceNumber = '${ SQL_ESC(${ARG1})}' writesql=insert into voted (callId,callNum,city,deviceId,SerialNum, serverResponse) values (${VAL1},${VAL2},${VAL3},${VAL4},${VAL5},${VAL6} extension.conf the relevant line same = n,set(ODBC_DEVICES()=${callid},${call},1,${deviceid},${num},${ serverupdate}) when sending the values from the cli using odbc write it works ok reading from the dialplan works ok i tried sending plain values without variables but from the dialplan gives me a error cant write to function ODBC _DEVICES happy to hear any ideas -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users