similar to: MSSQL2000 + cdr_odbc.c fix (WAS: 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

Hi, I'm trying to detect and or log the duration a a conference (Meetme). I need it in order to do some billing for theses services. Any ideas on how to do it? I googled around but found nothing. Thanks in advance epablo -- Pablo Endres <epablo@comvoz.com> ComVoz Communications USA: +1 954 343-2085 Ext 199 Venezuela: +58 212 7713195 Ext 199 Colombia: +57 1 3256840 Ext 199

Does anyone know about a good documentation on the oh323.conf file. There are a bunch of paramters that I don't understand. Thanks in advance Pablo -- Pablo Endres <epablo@comvoz.com> ComVoz Comunications

Hi, I've installed dovecot-0.99.10.5 using the rpm from Dag Wieers, but when I start it all I get is nothing (but none of the processes are running). I checked the config file and set it up (I'm trying to use it with mysql support, but it doesn't work with traditional config) Any ideas -- Pablo Endres <epablo at comvoz.com> ComVoz Communications USA: +1 954 343-2085

Hi people. I have 2 cisco 7940, the first is behind a NAT and the second is behind 2 NATs (The one for the LAN and one for Wireless). The two phones worked perfectly until Friday. For some reason the second one stoped registering (chan_sip) and the today none would work. Any ideas on what could be happening? Thanks in advance. Pablo -- Pablo Endres <epablo@comvoz.com> ComVoz

Hi, This post may be a little off topic but I've seen lots of good ideas com from the list, so here it goes: I'm in the need of replacing Cisco Call Manager 3.2 that I have working as my primary GK. I thought I could replace it with gnugk, but it lackes some of the functionality that I need: 1.) Route retrying. If a call placed on a route fails for some reason try other routes 2.)

Hi, I've got a strange behavior on one of my new extentions. This is what I got: extensions.conf with to #includes: extensions-manual.conf & extensions-db.conf I have around 50 users and 100 contexts in these files. I reacently included one: (created from db) [marcela] include => Common include => VoiceMail include => marcela-extensions [marcela-extensions] ;; =======

Hi people. I've been having some audio problems with some of my cisco 7940 phones using firmware 7.1. The sound gets gargoled up, I can't understand much of what is said (listing on the IP phone). My setup is the following: 7940 - * - Cisco 2621(GW) - T1 I'm using SIP and g729 for all stages of the communication. I was using ulaw for the leg between * and the Gw, but some guys on

Hi guys, I've been trying to update my chan_oh323 from 6.1 to 6.3b. I built asterisk from cvs-head on the date Micheal said he made it compatible, pwlib-1.6.6 and openh323-1.13.5 (both with nothing more than the ./configure, make, well aplied patch on openh323) When I start * with my normal config I get this: [chan_oh323.so] => (OpenH323 Channel Driver) == Parsing

If I fire up asterisk it connects to my MSSQL server via ODBC just fine. However, if I issue a reload it unloads the ODBC.. then loads it again and I get an error... and keep getting it until I On a fresh start: Aug 26 15:43:14 WARNING[13818] cdr_odbc.c: cdr_odbc: table not specified. Assuming cdr Aug 26 15:43:14 VERBOSE[13818] logger.c: -- cdr_odbc: dsn is MSSQL-asterisk Aug 26 15:43:14

Hi, I am trying to get * log to mssql server. I have odbc and freetds configured, but my insert query is missing calldate which is a NOT NULL field in database schema. cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid) VALUES

"make menuconfig" does not show cdr_odbc as a selectable compile option. I have compiled and installed both unixODBC and freetds from source and have verified both successfully connect to my sql server. Both were installed to standard locations (/usr/lib). I had no problem compiling cdr_odbc on my test server(CentOS 4.6), however following the same steps on my production server (CentOS

Hello, I've been trying to send traffic to a Cisco Call Manager 3.2, but with no luck. Here's whats happening: * Call gets to CCM * Call gets to the gateway * Rings a couple times on destiny * Call gets hungup. On the CCM I get the following error: MediaManager - ERROR wait_AuConnectErrorInd On the Gw (Cisco AS5300) I get a disconnect cause of 2F (Resource not available) On asterisk:

Hi, is cdr logging using odbc buggy? I'im only getting an error "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.". Connecting with isql to the datasource given in cdr_odbc.conf works just fine, and using the database for sippeers also works. The documentation[1] is confusing because it says freeTDS is required and that you must not use multiple

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

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 =

Hi, i want to load the cdr into oracle using unixODBC. I'm using RH 9 2.4.20-30.9smp, unixODBC 2.2.6, easysoft odbc driver for oracle 1.3.1. My unixODBC is working well. With isql i can connect to the database, do selects, inserts and so on. I created the table cdr as described on the asterisk wiki site. When i configure the cdr_odbc.conf with the needed values, then * does not start any

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(

Hi. I want to the CDR detail to be logged to a database backend. For that I need the cdr_odbc module. Executing the CLI command "show modules" I realized I don't have the cdr_odbc module loaded. So, I tried to load it using "load cdr_odbc.so", but it didn't work because I don't have it. Where can I get this module and how do I install it? Thanks in advance.