2010/4/22 Steve Edwards <asterisk....@sedwards.com>: > Un-top-posting... > >> 2010/4/22 Alejandro Recarey <alexreca...@gmail.com>: >>> >>> I am having a curious problem. I use two cdr backends, csv and MySQL. >>> >>> I am finding that the calldate field varies between 3 seconds and 3 >>> minutes between the MySQL database and the CSV files! Is this expected >>> behaviour? I thought they should both use the same timestamp. > > On Thu, 22 Apr 2010, Zhang Shukun wrote: > >> the time in the file cdr is right, as mysql. calldate is the time when >> the record insert into mysql. > > I'm just a 1.2 Luddite, but... > > In cdr_addon_mysql.c: > > localtime_r(&cdr->start.tv_sec,&tm); > strftime(timestr,128,DATE_FORMAT,&tm); > > and then timestr is used to populate the 'calldate' column when the insert > statement is built. > > Which is consistent with my CDRs -- they show the time the call was > started, not some time after the call is finished when the row is inserted > into the database. but in the cdr_mysql.conf, it said as following:
; Older versions of cdr_mysql set the calldate field to whenever the ; record was posted, rather than the start date of the call. This flag ; reverts to the old (incorrect) behavior. Note that you'll also need ; to comment out the "start=calldate" alias, below, to use this. compat=no i use asterisk 1.6.2.1 > > -- > Thanks in advance, > ------------------------------------------------------------------------- > Steve Edwards sedwa...@sedwards.com Voice: +1-760-468-3867 PST > Newline Fax: +1-760-731-3000 > > -- > _____________________________________________________________________ > -- 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 > -- Thanks for your supporting, have a nice day. Sucan -- _____________________________________________________________________ -- 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