similar to: Asterisk cdr_odbc problems

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, 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

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

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

svn trunk. I'm trying to get cdr to work with my odbc database. I have followed a checklist that I had previously but still can't get it to work. There are no errors (verbose 40 and debug 40), I get [cdr_odbc.so] => (ODBC CDR Backend) == Parsing '/etc/asterisk/cdr_odbc.conf': Found *CLI> cdr status CDR logging: enabled CDR mode: simple CDR registered backend:

Hello,

HI, I am trying to setup CDR with ODBC and MySQL but get the following error :- [Apr 28 21:30:01] ERROR[14567]: cdr_odbc.c:133 odbc_log: Unable to retrieve database handle. CDR failed. I can successfully connect with iSQL so ODBCINST and ODBC ini files must be okay. I have modified /etc/asterisk/cdr_odbc.conf to include :- [global] dsn=asterisk username=asterisk password=*******

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

Hi, I have configured the cdr throught ODBC with this files: /etc/cdr_odbc.conf [global] dsn=asterisk2 ;loguniqueid=yes dispositionstring=yes table=cdr ;"cdr" is default table name usegmtime=no ; set to "yes" to log in GMT hrtime=yes ;Enables microsecond accuracy with the billsec and duration fields /etc/cdr.conf [general] enable=yes unanswered =

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 am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this error: [Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts

I've just noticed that since swapping from the direct mysql cdr driver to cdr_odbc, the call duration (and anything else that's an integer) isn't logged - anyone else seen this and know the reason. The cdr_odbc driver gives no error messages and records any string based fields correctly. Iain

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

"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

On 12/07/2018 02:25 PM, Joshua C. Colp wrote: > On Fri, Dec 7, 2018, at 9:19 AM, hw wrote: >> >> 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,

; ; cdr_odbc.conf ; ;[global] ;dsn=MySQL-test ;username=username ;password=password ;loguniqueid=yes ;dispositionstring=yes ;table=cdr ;"cdr" is default table name ;usegmtime=no ; set to "yes" to log in GMT Though, reading from https://issues.asterisk.org/view.php?id=15021, it seems that lines username= and password= in cdr_odbc.conf are not used

I'm currently using Asterisk running version 1.2.5 and trying to use cdr_odbc to connect to a Microsoft SQL database. I have everything running, but the insert statement being sent to database doesn't appear to have the "start, answer, end" information in it. Below is the insert statement that MS Profiler shows being sent. As you can see those fields are missing. INSERT INTO

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

Hi, I'm having a bit of a problem with storing voicemail messages in an odbc database. I *think* I've got everything configured correctly but messages are stored on the asterisk server instread of in the database. System info 64 bit redhat RHEL 5.1 Asterisk 1.4.26 unixODBC installed used makemenuselect to instal res_odbc and cdr_odbc Back end database DB2 Database name voiceml

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