similar to: func_odbc and hash problem

Hello, I'm working with asterisk 1.6. And I have success using func_odbc with one row query results (SELECT source,destination from cc WHERE ... ): exten => s,1,Ringing exten => s,n,Wait(4) exten => s,n,Answer exten => s,n,Set(ARRAY(NUMBER,REALNUMBER1,REALNUMBER2,STATUSAS)=${ODBC_GETVARIABLES(${NUMERIS})}) exten => s,n,Verbose(1| ${NUMERIS}, ${REALNUMBER1} ${REALNUMBER1},

Hi. When I call my RNIS numbers (with a mobile phone for example), I can see 2 incoming calls on the IPBX, which should not happend. I'm not sure if it's a problem with the telco France Telecom and their ISDN setup, or if it's a problem with the MISDN driver on the IPBX itself. I'm stuck ... Any advices for troubleshooting that? Someone provide working configuration files

Hi. I'm testing out the new 'master users' feature, and I'm not having any luck getting it to work. Anyone out there using it yet? Here's what I have so far: dovecot.conf: ------------ auth_master_user_separator = * auth default { passdb passwd-file { # Master users that can login as anyone else args = /etc/dovecot/dovecot.masterusers master = yes

Hi. I'm running Asterisk server with 10 sip phones, and 2 grouped T0 lines with 10 DDI numbers. My provider is France Telecom and my setup is : - Debian Lenny - Asterisk 1.4 - Linux kernel 2.6.25.17 - mISDN 1.1.8 driver - Sip phones Thomson ST2030 No problem with the SIP . But when reveiving a call on RNIS line (any of the DDI numbers), the associated SIP phone rings indicating _two_

All, I am new to using R and know some basics. I wish to use kriging in R to do the following: given data Y =f(X1,X2,X3,.....,Xn) --1000+ irregular measured data set. I would like to be able to get a single value y given sinle input set (x1,x2,x3,...xn) A google search on this takes me lierally to the same example on involving analysis with soil sampling and I cannot figure out how to

Hi Oliver, My opinion is that try delleting the machine name using the 'control center' and delete the machine account in the passwd file. Then add the machine name again using "control center, edit & creat users ", then In console add the machine using: # smbpasswd -a -m <machinename>. Note i managed to do this on SuSE 8.1. Please send me an email if u're

I'm setting up a samba server that should authenticate against a samba 3.0 +Ldap PDC server. This is the situation 1) getenet passwd and getent group are ok 2) wbinfo -t -> checking the trust secret via RPC calls succeeded 3) wbinfo -g -> lists all the groups on PDC (nice!) 4) wbinfo -u -> lists all the users on PDC (nice again!) the problem is wbinfo -a test 1: a non existing user

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

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

Is func_odbc still working in trunk? I've recently (in the last few weeks) started having a problem where my custom functions don't work. The module loads, the configuration file is parsed fine, and the functions are even created and visible in "core show functions", but when executed from the dialplan I get a "no such function" error. Here's a bit of console

This is primarily aimed at Sir Lesher, whose name graces the source code for func_odbc that I'm currently trying to read to answer this question. Tilghman (or anyone else who has determined the answer to this query), I have googled, searched wikis, and I'm currently perusing the source code, but the long and short of it is that I cannot seem to find any reference to variables set by

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",

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

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

Hello, we are migrating an Asterisk install from Trixbox/Asterisk 1.2 to Elastix 0.92 with asterisk-1.4.17 on CentOS 5. I need to migrate an funtion that consults a remote sybase database, using ODBC and freetds. On the new server I am able to connect to the database using isql without problems. When I try to connect from asterisk logs show: pbx.c: Function ODBC_SQL not registered Indeed I

Hello everyone, I have Asterisk SVN-trunk-r7498 installed on a server (celeron 2.4 Ghz, 256MB) with a TDM40b a TDM04b and an avm fritz!card pci. I experience a problem with voicemail: my messages are good unless the incoming call comes from isdn, which means via the avm fritz!card. In this case (and in this case only) the message is disjointed and I can hear at most 1 second out of a 1 minute

Hi, I'm expiriencing very annoying issue with Asterisk while using ODBC on Linux box running Debian with following packages: Asterisk-node0:/tmp# dpkg -l | grep -i odbc ii libiodbc2 3.52.6-2 iODBC Driver Manager ii libmyodbc 3.51.15r409-4 the MySQL ODBC driver ii libodbcinstq1c2

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

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