similar to: cdr_unixodbc

I would like some Asterisk community input: It was requested of me to create an Asterisk FreeTDS (cdr_tds.c) module to allow Asterisk to populate MS SQL Server (and Sybase) with CDR records. unixODBC has been thrown around as a bright shiny button but it adds an additional layer of DB abstraction. That additional layer of abstraction can cause problems when it is not necessary for our TDS (MS

hi, i saw the cdr file called Master.csv and i want to know what these represent. examples "","","4","incoming","","Zap/1-1","Zap/4-1","Voicemail","u8888","2003-11-07 17:43:04","2003-11-07 17:43:04","2003-11-07 17:43:22","ANSWERED","DOCUMENTATION"

This is not really a problem just something I noticed in my testing.. When two or more Asterisk servers are connected by IAX2 trunks it does not make use of any "shortest path" type system.. (maybe this is still planned somwhere down the line, but may come in handy to those who have multi asterisk installations) Here is the setup.. UA1--- Asterisk1----[IAX2 Trunk]---Asterisk2---UA2

I would just like to get a refresh of the situation for Australian users. It would seem that the TE400P is currently available and is likely to acheive approval for use in Australia within the next 2 months ? (when is the end of summer?). Once this is done, it will certainly suit larger installations, but it still leaves a number of 'gaps'. Anyone with analog phone lines will need

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

Hello All, I have pingtel and asterisk working really well. I have a really annoying little problem - mainly with pingtel. When a call comes in pingtel displays the caller ID on the phone. If I miss it then I click on the number for redial - this doesn't include a 9 to dial an outside line. The second problem is with the dialer from outlook again it bypasses the outlook dialing rules so

In the absence of "The Definitive Guide to Asterisk Dial Plans" book, I'd like to do something possibly unique with the formatting of extensions in my dial plan, and am having trouble. We use VoicePulse connect, which gives us local DID for inbound and outbound calls (even though DTMF tones are not working in Voice Pulse Connect at the moment). To dial local numbers, you have to

Does anybody have useful tips on creating good quality recordings for use with prompts in asterisk? I'm interested in hearing input on hardware (mics, dats, sound cards, etc) and software (recording software, dsp) as well as recording techniques. Jerimiah Tularosa Communications

I've seen this question asked before but haven't seen a definative answer. Does the e100p work in australia? Did any one who was asking the question before bite the bullet and get one? I can get a te410 if i really have to but would prefer to stay with the cheaper option. Any comments appreciated, Thanks ------------------------------------------------- This mail sent through IMP:

We are not having any luck with the E100p card here in Australia, it will work with a crossover cable to another device but will not talk to our Telco Telstra who probably have a weird implementation of an E1. Any suggestions on a replacement? Regards Mark McKibbin DCS Internet 64 Queen St Warragul Victoria 3820 Australia www.dcsi.net.au mark@team.dcsi.net.au Ph. 1300 665575 Fx. 1300 556595

Hi I have problems trying to load asterisk call data into the cdr table using cdr_odbc config. My unixODBC is properly configured and it's working fine (able to connect, load data, query tables, etc.). unixodbc is configured to use easysoft Oracle ODBC library. Table cdr was created following instructions in asterisk wiki site. My /etc/asterisk/cdr_odbc.conf is configured as follow:

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(

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

Good Morning, I'm working with a queue at the moment and I having trouble with my digits. Australia is my example. On the tiki it says for international digits, I can dump them in the "digits/au" directory. I tried that -- just because, I also made a copy in "au/digits". When the queue announces the position I it says: -- Started music on hold, class

Hello everybody, I have tried to connect to external databases (specifically, to a MS Access database in my computer) from R using the RODBC package. Unfortunatelly I haven't been able to do it, even if I 'followed' the instructions in the manual. COuld someone please help me? I have a MS Access database in my computer and I went to the control panel in order to create a DSN file

I have posted soo many times in the past but never recieved even a single reply . seem like you people are ignoring me or either way too busy .. never mind this is my last try . How can record a conversation with asterisk ? I tried to use Record() but dint work for me .. here is what i tried . exten => s,1,Wait,1 ; Wait a second, just for fun exten => s,2,Answer

I think I figured this out. I should not have put the Driver name in braces. Changing it from {MySQL} to MySQL seems to work. -----Original Message----- From: Marcus, Jeffrey Sent: Tuesday, January 12, 2010 6:09 PM To: 'r-help at r-project.org' Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux I am sure I'm doing something wrong here but not

Hi, I have a data base in oracle and need to link R using ODBC. When i use the command odbcConnect a dsn is needed. I would like to create a dsn.Do you know how can i do it? Thank you. Margarida,Portugal

Hi list! I have a little question about groups and Asterisk ... is there anyone out there that can say if Asterisk can do any of this; We have a customer that want call handling we cant give him with a traditional PBX, and I'm running Asterisk @home so I thought I could give it a try ... The customer wants that incoming call should go to one group with some phones in it, if the group is

Greetings, I'm having some trouble with the realtime engines. When asterisk loads, everything looks fine, there don't seem to be any problems via notices or anything. Furthermore, cdr_odbc is working, and actively logging my failed call attempts to db through ODBC using the same DSN. unixODBC and the mysql drivers are installed from source. Here are the relevant parts of the config: