On 1/14/18 4:22 PM, Mike Diehl wrote:
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
I have exactly the same problem. All CDRs get duplicated. Using
ODBC and Mariadb on Asterisk 13.8
--
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)8116-9161
--
_____________________________________________________________________
-- 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
