CDR uniqueid – across multiple servers?

Home » Asterisk Users » CDR uniqueid – across multiple servers?
Asterisk Users 1 Comment

Hi,

Is there a way to add a uniqueid prefix to each server to make sure that the
CDRs uniqueids are indeed unique across multiple servers? I am using MYSQL
tables to keep these records.

Regards,

Mike

One thought on - CDR uniqueid – across multiple servers?

  • Thank you, just what I was looking for.

    Danny: that`s a good solution, but I wanted something that didn’t depend on
    one more extra script running. I have plenty of those already.

    Mike

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Matt Hamilton
    Sent: Monday, November 21, 2011 3:12 PM

    Mike,

    Just enter a unique “systemname” into asterisk.conf for each box. This
    system identifier is appended to the front of the unique id field in cdr.

    /etc/asterisk/asterisk.conf

    [options]
    systemname=asterisk1

    _____

    Since the MYSQL CDR is not the standard /var/log/asterisk/cdr-csv/Master.csv
    file, but an add_on where uniqueid is just a table field varchar(32), you
    could create an AGI to touch the field during the hangup extension and
    append the servername or a number to the front, so instead of 123456.111 you
    could have server1.123456.111 or you could make a daemon running outside of
    Asterisk to do the same thing.

    [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Mike
    Sent: Monday, November 21, 2011 11:44 AM

    Hi,

    Is there a way to add a uniqueid prefix to each server to make sure that the
    CDRs uniqueids are indeed unique across multiple servers? I am using MYSQL
    tables to keep these records.

    Regards,

    Mike