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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20180104/53ee9764/attachment.html>