similar to: app_dbodbc URGENT

Is anyone out there using app_dbodbc (http://www.bkw.org/~brian/app_dbodbc.c)? Any problems with it? I was able to get it all working, but it causes * to segfault every now and then. It does not appear to be related to any specific function (ODBCget,ODBCput,ODBCdel,ODBCdelltree). It is 100% repeatable. If I noload the module, everything works fine, but when its running, after calls to any of the

Has anyone tried using BroadVoice for VSP? I have Asterisk configured for a home office & I've been trying to decide which VoIP provider to go with for a little while now. I had heard you could get sub $.01 calls but I have not found that to be true yet (not saying it's not possible, I just haven't found it!). Also I'm not sure if BV will support multiple lines. Any

Hi, Has anyone manage to comile app_dbodbc or ast_data with the latest stable release (1.09). If so can you give some guidence on howto do it as I have trouble getting either working. Umar

I'm trying to get asterisk cdr_odbc configured, but it can't connect through my odbc driver. switchboard*CLI> module load cdr_odbc [May 4 20:06:04] ERROR[17758]: cdr_odbc.c:358 odbc_load_module: cdr_odbc: Unable to connect to datasource: asterisk /etc/odbcinst.ini: [MySQL] Description = MySQL driver Driver = /usr/lib/odbc/libmyodbc.so Setup =

I have done a little work on asterisk and database integration. Below is a link to app_dbmysql, modeled after Brian's app_dbodbc but for pure MySQL. I also ported the mysql-vm-routines.h to ODBC in case anyone is interested. You can get both of these from: http://www.cheapnet.net/~mike/asterisk They were working as of yesterday CVS, but today CVS will not compile and I have not looked

I'm trying to add cdr_odbc.so to log my CDR data to a mysql DB. I've managed to compile everything, and seem to almost be ready to head home. I've added a small debug line to cdr_odbc.c as follows: if((ODBC_res != SQL_SUCCESS) && (ODBC_res != SQL_SUCCESS_WITH_INFO)) { if(option_verbose > 10) ast_verbose(

Hi listers, We want to implement one call center with asterisk. The idea is it should be scalable, with openser as an dispatcher and bunch of asterisk servers to do ACD, Queues, Agents things... Easy to say :( Look closely to the current asterisk, we do see some problem: - SIP registrations was stored in astdb. - And queue members also was stored in astdb. - ... asterisk was built as

if a phone number starts with one of 50+ prefixes, i want to send the sip call to gateway X. if it is in any other prefix, i want to send it to gate Y. i am not excited about a looooong list of extens, but will do it if i have to. i suspect there is a database hack, but i lose all database contents if i reinstall the port (this may be a feature of the freebsd port), and i have not figured out a

I'd like to be able to add additional fields to the the Asterisk database. I'm using Mysql for most of my data lookup and manipulation, and it seems to work pretty well. In keeping with what I know how to do, it would be very handy to be able to insert say a "call forward number" into a customer record. That way, I could automatically route calls to extensions to a forwarded

I'm trying to formulate a strategy for our interconnected Asterisk IAX peers to failover to the PSTN in the event of a DDoS. We currently use them like this: DID--->PRI--->Primary Asterisk--->IAX--->On-site Asterisk--->SIP This works fine, and everyone is happy. One of my concerns, though, is if we get DDoS'd - which happens probably once every couple of years. I'd

I've been searching the Internet for information regarding the replacement of astdb with a modern sql engine. There are several reasons one would like to do this. First of all, external applications have a hard time reading/writing to the now-old astdb format. Also (and this is what interests me most), the sql astdb could easily be clustered throughout several servers (I'm looking for a

Ive got realtime and mysql.cmd to read from databases but apart from cdr how else can * write? I need to write to 2x tables and cant do this with cdr? Any advice appreciated thanks. --- Rafal Kaniewski -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.7 - Release Date: 09/05/2005

Let's say I have a third-party device acting as a sip<-->pstn gateway, a cluster of three asterisk servers, and a teensy bit of dns knowledge. Let's now say those asterisk servers are a1.company.com at 192.168.0.1, a2.company.com at 192.168.0.2, and a3.company.com at 192.168.0.3. 1. If I setup round-robin dns like so: asterisk.company.com. IN A 192.168.0.1 asterisk.company.com. IN

I'm not really being too lucky in the last days. After trying to compile cdr_mysql with no success, I am switching to cdr_odbc. I have installed unixODBC, iODBC and MyODBC correctly, I am even able to make queries with isql. But when trying to "make" in the cdr directory of the latest CVS, that's what I get: # cd /usr/src/asterisk/cdr # make cc -o cdr_odbc.so cdr_odbc.o -lodbc

Hello, I'm building a new Asterisk system from source on Debian Stretch. My building script fails as package libmyodbc is currently missing from Debian Stretch repo. Is there a work around this without leaving MySQL/MariaDB galaxy ? Best regards -------------- next part -------------- An HTML attachment was scrubbed... URL:

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

Hi, I'm trying to establish a connection to a MySQL database, and am using the rodbc package for it. This is in a GNU/Debian Linux box, with the corresponding Debian unstable packages. I can login to my MySQL databases from any shell and directory, so the problem is probably not there. Here's an example of what I'm doing: R> odbcConnect("test",

Hi, I am trying now for over 4 hours setting up cdr-logging via odbc into a mysql database. But with no success. Do you have any hint for me? cat /etc/odbc.ini ------------------ [MySQL-asterisk] Description = MySQL ODBC Driver Driver = MySQL Socket = /var/run/mysqld/mysqld.sock Server = localhost User = xxx Password = xxx Database = asterisk Option = 3 Port = and /etc/odbcinst.ini

G'day Just for the record, I have wine and foxpro working fine with one small exception. I have followed the instructions from "3.3.6.1 Configuring ODBC on unix" and understand from the docs that this is all wine needs. I have a DSN called "tuna" to a MySql database called "dolphin" which I can use isql to connect to no problem. However, when I use the ODBC

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