similar to: [asterisk users] asterisk realtime - database driven dialplan

Displaying 20 results from an estimated 200 matches similar to: "[asterisk users] asterisk realtime - database driven dialplan"

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"
2010 Oct 28
3
SIP client floods port 5060 and gets blocked
Hello, Is there any reason why an IP-phone would pounder on port 5060 ? My firewall blocks the public IP because it thinks the remote IP is port scanning on port 5060. I think the phone is just registering but for some reason it does this repeatedly in a very short time. Oct 28 09:01:48 astserver kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=00:00:00:00:00:00:00:00:00:00:00:00:00:00
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
2007 Oct 02
0
Segmentation fault in app_voicemail (ODBC/PSQL problem)
I have been testing with asterisk 1.4.11 and have found a segmentation fault while using voicemail. It happens when I try to forward a voicemail. As soon as I press the option the server crashes. I ran asterisk up inside gdb and got the following stack trace ==================================================================== Program received signal SIGSEGV, Segmentation fault. 0x00140adf in
2013 Oct 20
1
error cant write to function ODBC_DEVICES
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})}'
2018 Feb 28
4
Avaya 9608G and DHCP and TFTP and HTTP oh my
I'd like to start configuring my Avaya 9608G phones for use on Asterisk / FreePBX / PBX-In-a-Flash. I'm using a variety of other phones on my system without major issues. I've read the discussion back in March, May and August of 2016, but unfortunately, my difficulty is much more basic. I think it has to do with DHCP, specifically, what options I'm offering the phone via DHCP.
2009 Nov 16
1
Data source name not found and no default driver specified
I'm stumped. When trying to connect to Oracle using the RODBC package I get an error: *[RODBC] Data source name not found and no default driver specified. ODBC connect failed.* I've read over all the posts and documentation manuals. The system is Windows Server 2003 with R 2.81. and the latest downloadable RODBC package. The Oracle SID/DSN is mfopdw. I made sure to add it to Control
2005 Apr 08
2
BUG in RODBC with OS X?
This is my second posting on this topic, the first recieved no replies. Has anyone successfully used RODBC on the OS X platform? I've tested the ODBC drivers I'm using with two other applications and I've had no problems. I begining to think the problem is with R/RODBC and not the drivers. Here are the specifics: I'm having a problem connecting to an MS SQL Database via RODBC
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 =>
2009 Nov 16
1
Error using 32-bit R and RODBC package on 64-bit Windows Server OS with R version 2.10
I am receiving an error when trying to connect to the Oracle Database using RODBC on a 64-bit Windows Server OS. The version of R is 2.10.0-win32.exe Is this the wrong version. Does RODBC only work with 32-bit ODBC drivers? 've read over all the posts and documentation manuals. The system is Windows Server 2003 with R 2.81. and the latest downloadable RODBC package. The Oracle SID/DSN is
2005 Mar 28
0
RODBC and OS X
All, I'm having a problem connecting to an MS SQL Database via RODBC on OS X. If I try to connect through the GUI using chan <- odbcConnect("drewdb", uid="user", pwd ="pwd") it simply crashes R with the following crash report: Date/Time: 2005-03-28 12:30:48 -0600 OS Version: 10.3.8 (Build 7U16) Report Version: 2 Command: R Path:
2010 Jul 21
1
asterisk realtime SIP configuration
Hi All, I am trying to configure asterisk realtime. But i am unable to get the extensions listed successfully when i type "sip show peers" in the asterisk CLI . i am unable to see any failure logs when i do a reload i can able to connect to the data source through "odbc show" in the CLI, Any hep in this regard is highly appreciated. Following is the configuration
2009 Jan 09
1
shake rattle() and roll
Graham, nice package this :-)-O. It was easy to set up MySQL but I struggled immensely to get the stock ODBC working with PostgreSQL (8.3), which has been discussed on the mailing list before (Prof Brian): Warning messages: 1: In odbcDriverConnect(st, ...) : [RODBC] ERROR: Could not SQLDriverConnect 2: In odbcDriverConnect(st, ...) : ODBC connection failed aka (DBD::ODBC in Perl) Missing
2001 Oct 31
1
shared libraries on FreeBSD 4.*
I've used R for a couple of years on FreeBSD with few problems. Recently, a couple of the contributed packages seem to have difficulty finding symbols in the shared libraries. Currently, I'm running R 1.3.1 on FreeBSD 4.4. I've tried setting LD_LIBRARY_PATH to /usr/local/lib and some other things. The packages I've had trouble with are: Matrix 0.3.15 RODBC 0.8.3 RSPython 0.3
2008 Oct 31
1
*** buffer overflow detected ***: /usr/lib64/R/bin/exec/R terminated on R 2.6.2 to 2.8.0: logging a bug?
Dear friends, there is a serious problem with RODBC on R from 2.6.2 to 2.8.0 on a postgresql 8.3 database. Let's say we define an empty dsn called "test", with user "postgres" and password "none". We test the connection with another application, and it works properly. When you call the database using RODBC, you get the following: >
2008 Oct 31
1
*** buffer overflow detected ***: /usr/lib64/R/bin/exec/R terminated on R 2.6.2 to 2.8.0: logging a bug?
Dear friends, there is a serious problem with RODBC on R from 2.6.2 to 2.8.0 on a postgresql 8.3 database. Let's say we define an empty dsn called "test", with user "postgres" and password "none". We test the connection with another application, and it works properly. When you call the database using RODBC, you get the following: >
2013 Apr 18
5
ODBC dialplan looping problem
All, Thank you in advance for any help. I have a customer in need of a conferencing system. A requirement is for users to each have their own PIN for the same bridge. So, I put the list of users, PINs bridges into a MYSQL DB and used an ODBC connector to parse the table. 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,
2008 Feb 23
2
MySQL Voicemail Storage Questions\Errors
I am running CentOS 5 with Asterisk 1.4.14. I am trying to setup storage of voicemail messages into MySQL. It is my understanding that I can only do this via ODBC. I installed per http://www.voip-info.org/wiki/view/CentOS+5+and+Asterisk+1.4.x+installation unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel and mysql-connector-odbc. I reconfigured and built Asterisk, using menuconfig to
2019 Oct 12
3
setting up ODBC for cdr logging into MariaDB
Hello, I am trying to set up cdr logging into MariaDB through ODBC. I have installed unixodbc unixodbc-dev and now I am struggling with configuring /etc/odbcinst.ini All the examples online use non-existent libraries, ie: [MySQL] Description = MySQL ODBC MyODBC Driver Driver = /usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so FileUsage = 1 I have
2004 May 18
2
problem with cdr_odbc
Hi, Has anyone made a successfull instalation of cdr_odbc?? I've install unixODBC-2.2.8 (made my own RPM) and then built the module. I'm trying to send the cdrs to a M$ SQL server. The sql connection works because I can do any query via isql. When I do the calls I get the following output on the asterisk console: -- Executing Hangup("SIP/test1-a5e1", "") in new