search for: writesql

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 works fine, I j...

...1] 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/odbc.ini: [astdb_cluster] Description = MySQL ODBC Driver...

...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 astserver: ~#isql -v banking [IM...

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

...an 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 th...

...rlfriends 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='${SQL_ESC(${VAL1})}' WHERE id='${SQL_ESC(${ARG1})}' *voicemail show command* abox*CLI> voicemail show users You must specify a specific context to show users from realtime! Usage: voicemail show users [for <context>] Lists all mailboxe...

Hi all, I would like to track/store concurrent call usage per user by day/week/month and get server totals by day/week/month. Google comes up with mostly info regarding concurrent call limits, though my goal is to calculate actual concurrent channel usage and add it into reporting. I'm using * 1.6.2 + mysql - realtime (no gui). Any suggestions / open-source / AGI on where to start looking