Hi all,
 
I have a problem I've not seen before.  My Asterisk server stores CDR's via 
mysql, and I'm getting duplicate records.
 
For example:
 
mysql> select uniqueid,count(*) from cdr  group by uniqueid having count(*)>1;
+--------------------------+----------+
| uniqueid                 | count(*) |
+--------------------------+----------+
| server12-1515090905.2182 |        5 |
| server12-1515091190.2215 |        3 |
+--------------------------+----------+
2 rows in set (0.68 sec)
 
 
If I query for each uniqueid, I see that the records are identical.  I have a 
Perl script that goes through and removes the duplicates.  Otherwise, EVERY CDR 
would be duplicated.
 
Now, my Asterisk server was configured with multiple CDR backends, but I 
unloaded those modules.  Here is what I have configured during run-time:
 
*CLI> cdr show status
 
Call Detail Record (CDR) settings
----------------------------------
  Logging:                    Enabled
  Mode:                       Simple
  Log unanswered calls:       No
  Log congestion:             No
 
* Registered Backends
  -------------------
    cdr-custom
    Adaptive ODBC
 
Any ideas would be appreciated.
 
 
 
-- 
Mike Diehl                                
Diehlnet Communications, LLC.     
Sales: (800) 254-6105               
Support: (505) 903-5700                 
Fax: (505) 903-5701                      
 


-- 
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
      https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to