similar to: cdr_adaptive_odbc and custom rdms fields

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

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

Hello all, I have all configurations done and cdr_odbc works fine. However, cdr_adaptive_odbc doesn't work and I get the following error: relocation error: /usr/lib/libmyodbc3-3.51.26.so: symbol strmov, version libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time reference Please suggest any hints as to how I can rectify the issue. Thanks. -------------- next part

You can compile this code into Asterisk 1.4 to give you the ability to write custom data for up to 20 fields. The field names in the code must match the field names in the cdr db table. ENJOY!!!! Dave -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20081126/6418d408/attachment.htm -------------- next

Hi All I have dozens of these messages on CLI complaining about database connection and error writing CDR to disk. The curious thing is I can find them all inside the database. I "selected" them using uniqueid and manually compared each column with the cdr_adaptive_odbc.c error line. "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both returned OK for

Hello, This is a update on the current status of Asterisk in Debian. Apologies for the really long mail, it is targetted both to users and maintainers :) I'm Ccing asterisk-users as a one-time thing; users that are interested can subscribe to our list[1] for updates to prevent noise on a non-Debian list. Please Cc pkg-voip-maintainer on replies. 1:

On Sat, 25 Apr 2015 17:11:34 +0200 jg <webaccounts173 at jgoettgens.de> wrote: > > > Hi All > > > > I have dozens of these messages on CLI complaining about database > > connection and error writing CDR to disk. > > > > The curious thing is I can find them all inside the database. > > I "selected" them using uniqueid and manually

Thank you, but unixodbc and odbcinst are installed... end even unixodbc-dev But I get the same need for "generic odbc(E)". On 17/04/2017 10:48, Marcelo Terres wrote: > You need unixodbc and odbcinst packages too, to configure the odbc. > > []s > Marcelo H. Terres <mhterres at gmail.com> > IM: mhterres at jabber.mundoopensource.com.br >

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've searched the depths of the resources on the internet; however I'm having trouble deploying a pxeboot solution via pxelinux. So far what I have successfully implemented in my infrastructure is a successful pxeboot setup for FreeBSD ( without the use of pxelinux ). I'd ultimately like to have a solution that will allow me to choose a network install of various Unix-like

Hi all, I use astersk 11.7.0 on Ubuntu 12.04.01 TLS (i386). I use cdr_adaptive_odbc to write CDR to my MySQL's cdr table. After my testing, this scenario is working well. After a long idle time, I didn't make any call to the asterisk server. When I try to make a call again after 8 hours, I found that the cdr lost. It cannot be inserted to cdr table. Also, I could not find the insert CDR

There will be a brief outage of servers hosting Asterisk services on Saturday, August 28, 2010 between 10am and 11am for maintenance. These services include the following sites: * packages.asterisk.org * svn.digium.com * svn.asterisk.org * svncommunity.digium.com * issues.asterisk.org * reviewboard.asterisk.org * svnview.digium.com * downloads.digium.com * downloads.asterisk.org

There will be a brief outage of servers hosting Asterisk services on Saturday, August 28, 2010 between 10am and 11am for maintenance. These services include the following sites: * packages.asterisk.org * svn.digium.com * svn.asterisk.org * svncommunity.digium.com * issues.asterisk.org * reviewboard.asterisk.org * svnview.digium.com * downloads.digium.com * downloads.asterisk.org

Hi all, I'm looking for some rudimentary insight on GotoIf() which seems to be failing on me in my dial plan. All I basically wish to do is block a particular caller. Sounds easy enough, but my ternary operator/plan currently is not properly being implemented. Can anyone spot where I'm being a momo? All extensions get forwarded to the following macro: [macro-forward] ; arg1 = phone

Hi to all, I actually have an asterisk server configured to write CDR mysql records in the same machine (localhost), but I want to write this records to another machine also in mysql at the same time, It is possible? It means that I want save the records in both machines. Thanks in advance. Ricardo Melendez -------------- next part -------------- An HTML attachment was scrubbed... URL:

I have two version 1.6 Asterisks running. One is a small hobbyist thing just at home, and the other is handling calls for several customers. On both, I have added the line exten => h,1,Set(CDR(hangupcause)=${HANGUPCAUSE}) to all relevant contexts. On my little hobbyist box this works perfectly; all calls have their hangupcauses recorded with cdr_adaptive_odbc and cdr_custom. On the

I use debian stretch and I have installed unixodbc-dev but I have a dependency on genreric_odbc in make menuselect What am I missing ? Is there an howto ? Thanks PX

Hello, I have a setup with asterisk 16.8.0, I'm facing a problem where calls that fail (CONGESTION) don't have filled in some extra fields we add to the CDRs in the database. We use cdr_adaptive_odbc with MySQL as backend. To simplify the scenario: [sub-hanguphandler] exten => s,1,Set(CDR(foo)=${bar}) same => n,Return() [default] exten => _X.,1,NoOp(New test call) same =>

Hello guys, I need to be able to throw cdrs on more than one servers at a time. Please let me know how this can be done. Thanks