[asterisk-users] Is uniqueid/sequence a safe CDR table primary key ?
Jairo
jairo at intermol.com.br
Tue Jun 11 09:39:22 CDT 2013
Yes, using cdr_adaptive_odbc.conf.
As it is a new table, just changed the name from calldate to start and now
it is inserting the field ok.
Thank you very much for your help.
Best.
2013/6/11 Kevin Larsen <kevin.larsen at pioneerballoon.com>
> Are you using cdr_adaptive_odbc.conf to populate it? If so, there is no
> Asterisk analog to calldate. You would need an alias set up. Mine looks
> like:
>
> alias start => calldate
>
> so that the start of my call is what gets logged to the database as the
> calldate.
>
> Kevin Larsen
>
>
>
> From: Jairo <jairo at intermol.com.br>
> To: Asterisk Users Mailing List - Non-Commercial Discussion <
> asterisk-users at lists.digium.com>,
> Date: 06/11/2013 08:28 AM
> Subject: Re: [asterisk-users] Is uniqueid/sequence a safe CDR
> table primary key ?
> Sent by: asterisk-users-bounces at lists.digium.com
> ------------------------------
>
>
>
> Hello,
>
> Still about CDR and MySQL table, should the calldate field be inserted by
> Asterisk?
>
> This is the table structure we are using, based on Asterisk wiki:
>
> mysql> describe cdr;
>
> +-------------+-----------------------+------+-----+---------------------+----------------+
> | Field | Type | Null | Key | Default |
> Extra |
>
> +-------------+-----------------------+------+-----+---------------------+----------------+
> | id | mediumint(8) unsigned | NO | PRI | NULL |
> auto_increment |
> | calldate | datetime | NO | | 0000-00-00 00:00:00
> | |
> | clid | varchar(80) | NO | |
> | |
> | src | varchar(80) | NO | |
> | |
> | dst | varchar(80) | NO | |
> | |
> | dcontext | varchar(80) | NO | |
> | |
> | channel | varchar(80) | NO | |
> | |
> | dstchannel | varchar(80) | NO | |
> | |
> | lastapp | varchar(80) | NO | |
> | |
> | lastdata | varchar(80) | NO | |
> | |
> | duration | int(11) | NO | | 0
> | |
> | billsec | int(11) | NO | | 0
> | |
> | disposition | varchar(45) | NO | |
> | |
> | amaflags | int(11) | NO | | 0
> | |
> | accountcode | varchar(20) | NO | |
> | |
> | uniqueid | varchar(32) | NO | |
> | |
> | userfield | varchar(255) | NO | |
> | |
> | peeraccount | varchar(20) | NO | |
> | |
> | linkedid | varchar(32) | NO | |
> | |
> | sequence | int(11) | NO | | 0
> | |
>
> +-------------+-----------------------+------+-----+---------------------+----------------+
> 20 rows in set (0.01 sec)
>
> Thank you!
>
>
>
> 2013/6/4 Olivier <*oza_4h07 at yahoo.fr* <oza_4h07 at yahoo.fr>>
> OK, then I'll go with linkedid, uniqueid and sequence number.
>
> Thanks for sharing this on this list
>
>
> 2013/6/3 Matthew Jordan <*mjordan at digium.com* <mjordan at digium.com>>
> On 06/03/2013 11:20 AM, Olivier wrote:
> > Hi,
> >
> > When dealing with CDR SQL tables, I always added an auto-incremented
> > cdr_id key as a primary key, just in case provided uniqueid key went
> wrong.
> >
> > Now I'm facing a situation where I need to insert into a database's
> > table and from the dialplan, a reference to the CDR record which is
> > currently processed.
> >
> > So my questions are:
> >
> > 1. Can uniqueid/sequence (or uniqueid/sequence/calldate) bundle be
> > safely used as CDR's table primary key (ie I cannot have any
> > uniqueid/sequence combination from one CDR record to match a past
> > uniqueid/sequence combination) ?
>
> Possibly. Things to keep in mind:
>
> * You can run into uniqueid collisions across multiple systems if you do
> not specify a system name in asterisk.conf or do not specify a unique
> system name in asterisk.conf.
> * You can run into uniqueid collisions if your system clock goes
> backwards for any reason (the uniqueid for a channel happens to use a
> timestamp for its uniqueness)
>
> Whether or not this is unique enough will be completely dependent on
> your overall system configuration.
>
> In general, the recommended combination that *should* uniquely specify a
> CDR (when configured correctly) is linkedid (which should be enabled and
> added to your schema), uniqueid, and sequence number, with the asterisk
> system name specified.
>
> --
> Matthew Jordan
> Digium, Inc. | Engineering Manager
> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
> Check us out at: *http://digium.com* <http://digium.com/> & *
> http://asterisk.org* <http://asterisk.org/>
>
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by *http://www.api-digital.com*<http://www.api-digital.com/>--
> New to Asterisk? Join us for a live introductory webinar every Thurs:
> *http://www.asterisk.org/hello*<http://www.asterisk.org/hello>
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> *http://lists.digium.com/mailman/listinfo/asterisk-users*<http://lists.digium.com/mailman/listinfo/asterisk-users>
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by *http://www.api-digital.com*<http://www.api-digital.com/>--
> New to Asterisk? Join us for a live introductory webinar every Thurs:
> *http://www.asterisk.org/hello*<http://www.asterisk.org/hello>
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> *http://lists.digium.com/mailman/listinfo/asterisk-users*<http://lists.digium.com/mailman/listinfo/asterisk-users>
>
>
>
> --
> Jairo Molina Jr∴*
> *
> *http://www.intermol.com.br* <http://www.intermol.com.br/> --
>
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by
> http://www.api-digital.com --
>
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>
> http://www.asterisk.org/hello
>
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
> http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
>
--
Jairo Molina Jr∴
http://www.intermol.com.br
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130611/15070b5f/attachment-0001.htm>
More information about the asterisk-users
mailing list