search for: sql_esc

...unction result is 'CF/4053' Jul 10 12:07:04 ERROR[30281] func_odbc.c: Unable to load ODBC write class (check res_odbc.conf) func_odbc.conf: [ASTDB_CLUSTER] ; readhandle=astdb_cluster ; writehandle=astdb_cluster dsn=astdb_cluster readsql=SELECT value FROM astdb_cluster WHERE field='${SQL_ESC(${ARG1})}' and host='${SQL_ESC(${ARG2})}' writesql=INSERT INTO astdb_cluster (host,field,value) VALUES ('${SQL_ESC(${ARG1})}','${SQL_ESC(${ARG2})}',${VALUE}) res_odbc.conf: [astdb_cluster] enabled => yes dsn => astdb_cluster pre-connect => yes /etc/unixODBC...

...; DSNs. "dsn" may also be specified as "readhandle" and ; "writehandle", if it is important to separate reads and ; writes to different databases. readsql=SELECT COUNT(*) FROM exgirlfriends WHERE callerid='${SQL_ESC(${ARG1})}' syntax=<callerid> synopsis=Check if a specified callerid is contained in the ex-gf database ; ODBC_PRESENCE - Retrieve and update presence [PRESENCE] dsn=mysql1 readsql=SELECT location FROM presence WHERE id='${SQL_ESC(${ARG1})}' writesql=UPDATE presence SET location=&...

.../lib/odbc/libodbcpsqlS.so FileUsage = 1 /etc/asterisk/res_odbc.conf -- following lines were included, [postgres] enabled = yes dsn = banking pre-connect = yes /etc/asterisk/func_odbc.conf -- following lines were included, [DUMMY] dsn=postgres read=select name from dialplan_data where ext='${SQL_ESC(${ARG1})}' writesql=UPDATE dialplan_data SET name='${SQL_ESC(${VAL1})}' WHERE ext='${SQL_ESC(${ARG1})}' then i searched and there is no file available with name libodbcpsql.so. How do can i make it possible to work ? Thanks in Advance, Balakrishnan M root at astserve...

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,

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 => s,n,Set(HASH(RESULTATAS)=${ODBC_GETNUMBER(${NUMERIS})}) exten => s,n,Verbose(1, Number is ${HASH(RESULTATAS, number)}.) exten => s,n,Verbose(...

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

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

...cted. The problem is that if a user enters a PIN that is NOT in the table, asterisk goes crazy and continues to loop forever. Please have a look and tell me where I went so wrong. Func_odbc.conf looks like this: [PIN] dsn=BRIDGE mode=multirow readsql=SELECT pin from users WHERE confid='${SQL_ESC(${CONF_ID})}' extensions.conf section: [infromhost] ;Host dials 8888 over SIP trunk exten=8888,1,Answer exten=8888,n,Background(conf-getconfno) exten=8888,n,WaitExten(10) exten=8888,n,Hangup exten=_XXXXXX,1,Set(GLOBAL(CONF_ID)=${EXTEN}) exten=_XXXXXX,n,GoTo(rooms,${EXTEN},1) ; [room...

Hello Everyone, I have an installation where the client has a Microsoft SQL database that holds all of their case information. They would like the asterisk system to require users to enter a valid case number when making an outgoing call. I?m seeing some documentation regarding people using Microsoft SQL for CDR storage, however nothing regarding validating authentication using a Microsoft SQL

...igure 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},${ serveru...

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