Displaying 20 results from an estimated 100 matches similar to: "func_odbc and hash problem"
2008 Dec 01
1
func_odbc questions
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},
2009 Jan 05
1
B410p, Ast1.4, France Télecom Numeris Double T0 problem
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
2006 Apr 03
1
How to use Master Users.
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
2008 Nov 05
0
b410p mIDSN - RNIS signaling problems
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_
2013 Apr 04
5
help with kriging interpolation
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
2004 Feb 11
1
Fwd: machine account with strange behaviour
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
2006 Mar 22
0
weird winbind problem
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
2009 May 07
1
func_odbc.c: Unable to execute query
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
2010 Oct 22
1
MS-SQL / Freetds -- func_odbc
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,
:)
2011 Dec 29
0
func_odbc not returning whole smalldatetime MS Sql field.
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
2007 Jan 20
1
func_odbc still working in trunk?
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
2011 Jan 26
1
Return variables from func_odbc calls?
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
2014 Mar 13
2
func_odbc do not read LIKE predicate
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",
2014 Apr 03
1
func_odbc
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
2015 Mar 10
1
func_odbc 123
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
2008 Jan 30
2
func_odbc - trouble
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
2006 Jun 19
2
Asterisk voicemail problem with isdn avm fritz!card
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
2010 May 24
1
[0017330] 1.6.1 and 1.6.2 + MySQL crases on ODBC Query (via func_odbc or sip realtime)
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
2008 Dec 09
2
Func_ODBC question
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
2007 Nov 28
3
Multiple Return Values from func_odbc
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