Displaying 20 results from an estimated 100 matches similar to: "Func_ODBC question"
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
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,
:)
2008 Jul 10
1
res_odbc.conf and odbc show
I have a mixed PBX system with both Asterisk 1.4.21 and 1.2.27 (moving to 1.2.28).
For now I need to keep a few boxes in 1.2 and not migrate them all to 1.4.
However, I would like to have func_odbc and res_odbc on all servers.
On 1.4.21, native func_odbc seems to work fine.
On 1.2.27, the func_odbc backport is giving me an error (I know that this backport is not "officially supported"
2012 Sep 12
3
kernel: dahdi: Master changed to TE2/0/2 --- Is a normal message
I have a server with an asterisk ss7 link connected to a Siemens working
well for over a year.
A few days ago I started having problems with signaling.
I found the following logs in / var / log / messages
Sep 12 11:49:25 call3 kernel: [1018427.030959] dahdi: Master changed to
TE2/0/2
Sep 12 11:49:25 call3 kernel: [1018427.120740] dahdi: Master changed to
TE2/0/1
Sep 12 11:49:26 call3 kernel:
2007 Jan 10
2
Get dialed numbers in AGI
Hi,
I'm trying to write a AGI in PHP to get the numbers dialed (with read()),
save it into a variable to insert it into a SQL server database. But I
cannot see results into the variable, it always return NULL.
Here is a piece of the AGI.
fwrite(STDOUT,"exec Read my_var|/sound_to_play|5|||15 \n");
fflush(STDOUT);
$conn=odbc_connect('MSSQL', 'USER', 'PASS');
2014 May 29
1
voicemail with odbc
Hi,
I have some issue with voice mail with ODBC on asterisk 11.7 box. I may not
understand database functionality on asterisk fully. The most suspected
area is func_odbc. I already googled but not luck. Your guide is warmly
welcomed
*Error messages when I make call and leave message.*
-- <SIP/1ffa9-00000007> Playing 'auth-thankyou.g722' (language 'en')
[2014-05-28
2008 Nov 06
4
ODBCExec and Asterisk 1.6 New Thread
Ok, sorry for the response on the same thread.
This is a new one.
The main thing is that with this I set the Store Procedure or Query directly
on the dialplan line, is easier to configure, change, manage, etc.
I also know that works great with heavy load, and it reconnects when the
network goes down and up.
Can you help me porting this app? I think woun`t be difficult for someone
that
2009 Mar 21
2
1.6.2 beta 1 crash
Hi,
I'm starting testing 1.6.2 beta. CentOs 5.2
I found my first crash, first I have
[Mar 20 20:30:41] WARNING[11201]: res_config_mysql.c:611 update_mysql:
Attempted to update column 'useragent' in table 'sip', but column does not
exist!
[Mar 20 20:30:41] ERROR[11201]: res_config_mysql.c:581 update_mysql: MySQL
RealTime: Updating on column 'lastms', but
2011 May 11
4
concurrent call tracking
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
2007 Jan 12
4
FW: Get dialed numbers in AGI
On 1/11/07, Mike D'Ambrogia <miked@jamagination.com> wrote:
>
> Ralph
>
> Kind of new to asterisk, and really new to AGI but it looks like you were
> trying to have the AGI script tell asterisk to read and lay the results into
> my_var and then regain control in the AGI script, is that correct?
>
> If so I don't think that will work since the dialplan
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
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
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},
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
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 02
1
func_odbc and hash problem
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 =>