similar to: Problems compiling cdr_odbc.so

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(

Hello All: I'm having some difficutly getting res_config_mysql from the 1.4.1 addons package to compile ( I need it for Realtime) First of all, when I make everything appears to compile ok with no errors however the res_config_mysql doesn't get compiled. So I tried "make res_config_mysql" and a whackload of errors starting with the following: # make res_config_mysql gcc -g

Hi All I just completed a custom application for Asterisk (i m not a C guru so i just copy codes from other application and alter according to my needs) attached files is the source file this application is working fine but still i need you people to give suggestion to improve it Primary task of this application is to get a parameter from extensions.conf, query sql server and play a files

I'm trying to move our asterisk setup from an i686 server to an x86_64 (Dual AMD Opteron) server. Everything has been manually compiled: MySQL 4.1.10, MyODBC 3.51.11, unixODBC 2.2.10 (because I couldn't find any usable RPMs). And obviously Asterisk, where I'm using the STABLE release CVS-Nv1-0-5-02/21/05. The OS is Redhat Enterprise ES 4.0, kernel 2.6.9-5.0.3.ELsmp. Asterisk is

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

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,

Hi, Since Carl has kindly provided us with fax support for CAPI based cards, we have been using it with much success. Today I have modified app_capiFax so that it now supports a dynamic CSID. The following example uses the DNID created by chan_capi on an AVM Fritz! card. * Receive a fax with CAPI API. * Usage : capiAnswerFax2(path_output_file.SFF|stationID) * * This function can be

Hello, I created a new application for myself called Dialtone() by modifing res/res_indications.c file. It can be used as such: exten => s,4,Dialtone(30|${CALLERIDNUM}) exten => s,5,Playback(time-exceeded) exten => s,6,Goto(s|1) It will stutter if you have new voicemail and you have passed the mailbox number as I did above. It will stop dialtone the moment you press a key

I'm trying to clean up some notices/warnings that are repeatedly logged in *.Any Help would be appreciated as I'm not sure of the cause /solution. Here are the errors: Nov 17 15:53:38 WARNING[1217602880]: File chan_zap.c, Line 1321 (zt_call): cidspill already exists?? +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ /* Don't send audio while on hook, until the call

I am trying to write a customized app using C that would fetch voice file from SQL Server 2000 using ODBC and FREETDS. Currently I am only able to fetch first 63 KB chunk from the DB, and not able to fetch the rest of the file, below is the code that i am using to do so, fd = open(fullpath, O_RDWR | O_CREAT | O_TRUNC, 0770); if (fd < 0) { ast_log(LOG_WARNING, "Failed to write

I am experiencing a change in behaviour of my Queues in 1.4.9 vs 1.4.8. I do not pass the 'n' option to any call to Queue() in my dialplan. Yet since I upgraded to 1.4.9, I have occasionally seen this on my console: -- Nobody picked up in 20000 ms -- Exiting on time-out cycle That log message "Exiting on time-out cycle" is exclusive to the logic in app_queue meant to

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, Having installed postgresql-devel-7.4-0.3 and postgresql-libs-7.4-0.3 I'm having probs. compiling cdr_pgsql, can anyone offer any pointers as to what I might be missing? I'm hoping I've just missed out something like postgresql-wibblewobble-7.4-0.3 or something ... Below is the result of a make in the cdr source dir which may help those of you in the know thanks... Andy

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

If anyone is interested ... just in case! :-)... I have tried to write , based on the cdr_mysql.so module, an Sybase module. To compile you can use something like that: export SYBPLATFORM=linux export SYBASE=/opt/sybase cc -I$SYBASE/include -c -o cdr_sybase.o cdr_sybase.c cc -shared -Xlinker -x -o cdr_sybase.so cdr_sybase.o -lsybdb -lm -L$SYBASE/lib (anyone could write the corect Makefile

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

http://asterisk.bkw.org/diff/cdr_odbc.diff Now this should fix it the proper way. bkw PS: Thanks for the info klasstek! > -----Original Message----- > From: asterisk-dev-admin@lists.digium.com [mailto:asterisk-dev- > admin@lists.digium.com] On Behalf Of Pablo Endres > Sent: Wednesday, May 19, 2004 3:30 PM > To: asterisk-dev@lists.digium.com > Subject: RE: [Asterisk-Dev]