similar to: cdr_adaptive_odbc

I upgraded a web server from CentOS 5.9 to 5.10. The instructions also indicate that MySQL 5.0 is no longer supported so I followed the instructions to upgrade to 5.5. Everything seems to be working so I tried to remove MySQL 5.0 and MySQL 5.1. It seems there are still dependencies on MySQL 5.0: [root at w3 ~]# rpm -e mysql51-mysql-libs-5.1.70-1.el5 mysql-server-5.0.95-5.el5_9

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

Hello All, I am trying to upgrade MySQL on CentOS 4.5 but having a hard time. I need to go from MySQL 4.1 to 5. I downloaded the following two files: mysql-server-5.0.58-1.el4.centos.i386.rpm mysql-5.0.48-2.el4.centos.i386.rpm I tried to do: yum install mysql-server-5.0.58-1.el4.centos.i386.rpm And get: Setting up Install Process Setting up repositories Reading repository metadata in from

A recent update to postfix mysql errors on my cOS 4.5 system with complaints about missing dependencies libmysqlclient.so.15 and libpq.so.4. Have I messed up again? Details: CentOS45[root at mail ~]# yum update Setting up Update Process Setting up repositories Reading repository metadata in from local files Reducing CentOS.Karan.Org-EL4 - Stable to included packages only Finished Excluding

I'm running 1.6.2.13 and need to record a small number of custom values use cdr_odbc and cdr_adaptive_odbc, and only the custom fields. The good news is that the custom records are being stored in the database as desired. The bad news is that I get three sets of warnings/notice about 'SQL Exec Direct failed' and dropping then reconnecting the database handle. I traced the SQL calls

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

Hi all, I am having trouble getting cdr_adaptive_odbc to work. I have correctly configured the odbc drivers and dsn (I have tested this by connecting directly using isql). I have also configured /etc/asterisk/cdr_adaptive_odbc.conf like so: [test-asterisk] connection=test-asterisk-odbc table=cdr I have tested the ODBC connection test-asterisk-odbc and it works correctly However when I try to

Hi, I compiled Asterisk 10.7.0 with gcc-4.5.3 and at runtime I'm getting these warnings: loader.c: Error loading module 'chan_dahdi.so': /usr/lib/asterisk/modules/chan_dahdi.so: undefined symbol: ast_smdi_interface_unref loader.c: Error loading module 'app_stack.so': /usr/lib/asterisk/modules/app_stack.so: undefined symbol: ast_agi_unregister loader.c: Error loading module

Hi folks, I was recently made aware that the only way to currently set custom fields in a relational database for CDR is via the experimental cdr_adaptive_odbc drivers found here: http://svncommunity.digium.com/view/tilghman/branches/1.4/cdr_adaptive_odbc.c?view=log I had no problem compiling the driver, and copied the module to /usr/lib/asterisk/modules on my box and setup

Hello: Does anyone have any idea how resolve this error on my server to install postfix with mysql support? Dedicated Server with CentOS 5.7 64 Bit. I get this dependency information when trying to use the command yum-y install postfix Error: Missing Dependency: libmysqlclient.so.15()(64bit) is needed by package 2:postfix-2.3.3-2.3.centos.mysql_pgsql.x86_64 (centosplus) Error: Missing

Hi, all Sorry for null subject last mail. I use Ubuntu 12.04.01 TLS and install asterisk 11.7.0 (tar.gz downloaded from asterisk.org). We named it "Asterisk11". I want to generate a call file to /var/spool/asterisk/outgoing. This call will dial out to Local Channel and return to some Extens. Then Asterisk11 will generate a CDR records to MySQL's cdr table(in database

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:

OK, i've found php-5 RPMs in the centosplus dir on mirrors. Sorry for my ignorance, but what's the difference between php-5.1.6-1.2.1.centos.x86_64.rpm and php-5.1.6-3.el4s1.5.x86_64.rpm ? There's other such examples in the same dir. Anyway, i opted to try installing the "el4" variety, along with the comparable RPM for php-mysql, but --after satisfying other

hi, I'm working with asterisk on a project and I found a problem with cdr_odbc. As we know, after answering each call a cdr event is raised which is saved in cdr_csv and cdr_odbc. but here my point is on cdr_odbc. some information, including start_time and end_time is given by cdr event but the problem is that these two information(start_time and end_time) is not getting save in cdr_odbc. I

Building from the source RPM I get an error mISDNuser-devel is needed I was able to obtain all the other build dependencies from EPEL 6, but that one doesn't appear to existing in EPEL or in packages.asterisk.org I then tried adding --nodeps to the rpmbuild command: rpmbuild --rebuild --nodeps asterisk-11.4.0-1_centos6.src.rpm Running as a normal user, the build fails on the line

"In computer software standards and documentation, the term deprecation = is=20 applied to software features that are superseded and should be avoided.=20 Although deprecated features remain in the current version, their use = may=20 raise warning messages recommending alternate practices, and deprecation = may indicate that the feature will be removed in the future. Features = are=20

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

Hi guys, Having issue with getting CDR to write to MS-SQL via ODBC. > cdr_odbc: Connected to freetds-connector > cdr_odbc: Error in PREPARE -1 > cdr_odbc: Query FAILED Call not logged! == Spawn extension (cisco, ##########, 2) exited non-zero on 'IAX2/astYYYY-507 Isql test: [xxx at YYYY asterisk]# isql freetds-connector XXXXXXX YYYYYYYYY

Hello list! I?m having an issue when reloading Asterisk, I?ve had this problem in Asterisk 1.6.1.6 so I upgrade to 1.6.2.1 version, but I still have the same error. For example, I send a "reload" in Asterisk CLI and this is the output: isb152*CLI> reload == Parsing '/etc/asterisk/extconfig.conf': == Found == Parsing '/etc/asterisk/manager.conf': == Found