search for: readsql

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", "000000000000000000000000000000000000000000000000000") in new stack -- Executing [205 a...

...My dialplan code is as follows: exten => _.,n,Set(ARRAY(var1,var2,var3)=${ODBC_LOOKUP(${KEYVAL})}) exten => _.,n,Verbose(2,var1 = ${var1}) exten => _.,n,Verbose(2,var2 = ${var2}) exten => _.,n,Verbose(2,var3 = ${var3}) Here's the func_odbc.conf code: [LOOKUP] dsn=mysql-asterisk readsql=SELECT col1, col2, col3 from table1 WHERE keycol = '${ARG1}' and here's the full log: [Jan 22 20:12:50] VERBOSE[32348] pbx.c: -- Executing [123 at dolookup:8] Set("SIP/sip1-inbound-00000f99", "ARRAY(var1,var2,var3)=96829,-3,Name Unavailabl") in new stack [Jan 22...

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

...sp at localhost 703 => -7034,Pro Nek,pronek at gmail.com *res_odbc Configuration* [asterisk] enabled => yes dsn => asterisk-connector username => thet password => MyPassword pooling => 1 limit => 5 pre-connect => yes *func_odbc Configuration* [SQL] dsn=mysql1,asterisk readsql=${ARG1} ; ODBC_ANTIGF - A blacklist. [ANTIGF] dsn=mysql1,mysql2 ; Use mysql1 as the primary handle, but fall back to mysql2 ; if mysql1 is down. Supports up to 5 comma-separated ; DSNs. "dsn" may also be specified as "readhandle" and...

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

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

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})}) e...

...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, 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})...

...GI into the current channel so that it plays on the phone OR b) Do something like what Realtime Voicemail does, where it gets the file from the DB, saves as a temp file in the user mailbox directory and then plays it to the caller but this needs to happen through AGI, something along the lines of readsql (a la func_odbc) inside of AGI OR c) Anything else that's better than a) and b) above that someone can suggest. P.S> I do know about the AGI AddOn of PUT SOUNDFILE and GET SOUNDFILE which seems to be the only solution we can think of right now, other than of course having the DB machine e...

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

...lt is 'voip2' Jul 10 12:07:04 DEBUG[30281] pbx.c: Function 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 ds...

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

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 [REDACTED]-dev*CLI> odbc read ODBC_[REDACTED]-LOOKUP 10...

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

...trshk sanitysql => select 1 isolation => read_uncommitted username=anonymous password= pre-connect => yes forcecommit => yes connect_timeout => 10 negative_connection_cache => 300 max_connections=100 database=strshk func_odbc.conf [STRSHK] escapecommas=yes prefix=MYSQL dsn=strshk readsql=call strshk.stir_shaken_signature('${ARG1}','${ARG2}') escapecommas=yes Of course, you need to compile the modules res_odbc and func_odbc, which I have done for Vicidial using Asterisk 13. But any Asterisk 11 and up can use unixODBC. -------------- next part -------------- An HTML...

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,

I have a list of CLIDs prefixes that I want to use in a context. Basically, I want to do this but the list of prefix numbers is much longer. List of prefixes (556,557,557,989.....) [custom-inbound] exten => _556,1,answer exten => _556,n,playback(beep) exten => _557,1,answer exten => _557,n,playback(beep) exten => _558,1,answer exten => _558,n,playback(beep) exten =>

...ckup_group endpoint/call_group (Reported by Jean-Denis Girard) * ASTERISK-27243 - contrib: valgrind.supp doesn't suppress what it's supposed to due to invalid syntax (Reported by Richard Kenner) * ASTERISK-28497 - func_odbc: truncating Unicode string on readsql (Reported by Boris P. Korzun) * ASTERISK-28647 - chan_sip: RTP frames not transmitted after emitting a COLP (Reported by Jean Aunis - Prescom) * ASTERISK-28667 - Asterisk ignores parsing of config files if a Byte order mark is present (Reported by Robin Leffmann) *...

...ckup_group endpoint/call_group (Reported by Jean-Denis Girard) * ASTERISK-27243 - contrib: valgrind.supp doesn't suppress what it's supposed to due to invalid syntax (Reported by Richard Kenner) * ASTERISK-28497 - func_odbc: truncating Unicode string on readsql (Reported by Boris P. Korzun) * ASTERISK-28647 - chan_sip: RTP frames not transmitted after emitting a COLP (Reported by Jean Aunis - Prescom) * ASTERISK-28667 - Asterisk ignores parsing of config files if a Byte order mark is present (Reported by Robin Leffmann) *...

...processed until next frame arrives (Reported by Robert Sutton) * ASTERISK-27243 - contrib: valgrind.supp doesn't suppress what it's supposed to due to invalid syntax (Reported by Richard Kenner) * ASTERISK-28497 - func_odbc: truncating Unicode string on readsql (Reported by Boris P. Korzun) * ASTERISK-28647 - chan_sip: RTP frames not transmitted after emitting a COLP (Reported by Jean Aunis - Prescom) * ASTERISK-28667 - Asterisk ignores parsing of config files if a Byte order mark is present (Reported by Robin Leffmann) *...