[asterisk-bugs] [Asterisk 0014476]: CDR not recording in DB even if no error persists

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=14476 
====================================================================== 
Reported By:                josephm
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   14476
Category:                   CDR/cdr_odbc
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     assigned
Asterisk Version:           1.4.22 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-02-13 21:58 CST
Last Modified:              2009-02-14 01:31 CST
====================================================================== 
Summary:                    CDR not recording in DB even if no error persists
Description: 
Hi everyone,

my cdr works perfectly when I call from sippeers defined in database
(extconfig.conf)
but when I got a call from mobile, here is the log
Packet2Packet bridging SIP/XXX.XX.XXX.XXX-08930e50 and
SIP/XXXXXX-08937ff8
      > cdr_odbc: Query Successful!
 == Spawn extension (from-mobile, AGI-SUCCESS, 1) exited non-zero on
'SIP/XXX.XX.XXX.XXX-08930e50'
but when i check in my CDR database, no data is saved

Upon cheking the cdr-csv, there is a record with regards to this call..

If the call from mobile is not answered, the record is successfully saved

Please help.. Its urgent

Thanks,

joseph.m

P.S Im using 1.4.22 i want to know what steps i need to do if in case i
need to update to 1.4.23.. what will get affected? is my configurations
still remains?
====================================================================== 

---------------------------------------------------------------------- 
 (0100152) Corydon76 (administrator) - 2009-02-14 01:31
 http://bugs.digium.com/view.php?id=14476#c100152 
---------------------------------------------------------------------- 
My recommendation for you is to download the backport of cdr_adaptive_odbc
and install it.

svn co http://svncommunity.digium.com/svn/tilghman/branches/1.4
cd 1.4
ASTSRC=/path/to/1.4/build/dir make
ASTSRC=/path/to/1.4/build/dir make install

Please review the sample config.  You will probably have to "alias start
=> calldate" in order to map the start field into the calldate column.

I'm actually not all that surprised that you have trouble with cdr_odbc. 
The code is very old and not very fault-tolerant, which is why it has been
rewritten in 1.6 and higher. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-02-14 01:31 Corydon76      Note Added: 0100152                          
======================================================================