similar to: Newbee, help with cdr/odbc/mysql logging problem

Both of our production asterisk servers are dumping core when making writes to our cdr tables. Here is a backtrace of the problems we are having: #0 0x00447b1f in tdserror (tds_ctx=0x1, tds=0xb7938c90, msgno=20004, errnum=9) at util.c:347 347 if (tds_ctx && tds_ctx->err_handler) { (gdb) bt #0 0x00447b1f in tdserror (tds_ctx=0x1, tds=0xb7938c90, msgno=20004, errnum=9) at

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

-----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of jg Sent: Monday, July 06, 2015 4:14 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR in an MySQL-Database > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database.

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 was just going through my call records ( stored in mysql database by cdr_MYSQL module ) and saw a record having duration = 0 and billsec of more than 50 seconds . I did a query on cdr where duration < billsec and saw that there were infact some 250 records with duration less than billsecond ( table had around 4,00,000 records) . Did anyone came across this ? I also checked csv files and they

Hi list! I'd like to save all information about calls (CDR) in a MySQL-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no

Hi; I have problem inserting cdr to mysql,Asterisk has logged to asteriskcdrdb successfully.It says: Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:178 mysql_log: cdr_mysql: inserting a CDR record. Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:197 mysql_log: cdr_mysql: SQL command as follows: INSERT INTO cdr

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

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 All, I have been running a environment with asterisk 1.4.20.1 for some time now with no issue but have recently added some extra functionality (enabled call recording via MixMonitor) and ran into some deadlock issues which seem to be well documented with earlier 1.4.x releases so have decided to take the plunge and upgrade. I decided to start testing with 1.6.2 but have run into a couple

Hi, We are running asterisk 1.2.16 and need to connect two channels which are already established. We are currently using app_meetme to achieve that, but we are sometimes unhappy, as app_meetme provides functionality that produces load that we do not need in our two party conferences. I figured out that there is an alternative called app_changrab.

> Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database. > I created the DB and a user for Asterisk on a separate server, then I > configured my cdr_mysql.conf so: > > [global] > hostname=192.168.10.3 > dbname=asterisk > table=cdr > password=MYSECRET > user=asterisk > port=3306 > > and my cdr.conf so: > >

Hi all, I need 2 CDR Records of below 2 numbers for outgoing calls, detail is given as below: *96XXXXXXXX88XXXXXXXX* *=> Call file : outbound call generate through below file* Test.call ====== Channel: local/s at outgoing/n WaitTime: 45 Context: outgoing_ivrs Extension: s Priority: 1 Set: contact_no=96XXXXXXXX extensions.conf ============ [outgoing] exten => s,1,NoOP(----- First LEG

Hello, We have finally upgraded to Asterisk 1.4, however we've run into two issues that weren't occurring before the upgrade. Issue #1: We're an outgoing call center and need to record all calls. We use the uniqueid field in the CDR to match with the recording, which we labeled with {UNIQUEID} in MixMonitor. For some reason, the uniqueid is not correct in the CDR. Here is the

Luca Bertoncello wrote: > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database. > I created the DB and a user for Asterisk on a separate server, then I > configured my cdr_mysql.conf so: > > [global] > hostname=192.168.10.3 > dbname=asterisk > table=cdr > password=MYSECRET > user=asterisk > port=3306 > > and my

Hello Asterisk-Users, For some reason my CDR records for disposition and billsec are not working correctly. I always receive a 0 for billsec and the disposition is always at "NO ANSWER', even when I grab the calls. I experience this with Asterisk 1.6.0.1 and Asterisk 1.4.22. Here is information on how I do the call: -----------------------------------------------------------------

Can someone tell me what I am doing wrong? Why doesn't CDR(duration) or CDR(billsec) return the correct values? cdr.conf endbeforehexten=yes extensions.conf [macro-Dial] ; ${ARG1} - Dial String exten => s,1,Dial(${ARG1},,M(post-dial)) exten => h,1,NoOp(Call was hung up - ${CDR(duration)} seconds long, billed for ${CDR(billsec)} seconds) The log shows: -- Executing [h

> 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

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