Steven! Thank you! Will use 64-bit platform for mongodb! I'll tell you this in the google group CDR-Stats - they forgot to mention about it.

From: Steven Ayre <steveayre@gmail.com> To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> Cc: Date: Tue, 8 Jul 2014 14:28:28 +0100 Subject: Re: [Freeswitch-users] mod_cdr_mongodb and not correct start_uepoch (*_uepoch) values Reading the manual I'm guessing you're on a 32bit platform. Running on 64bit would be better as 32bit limits the size of the database.

Integers are 64bit on 64bit platforms, but you can use bigint to get 64bit numbers on a 32bit platform. http://api.mongodb.org/perl/current/MongoDB/DataTypes.html

On 8 July 2014 14:23, Steven Ayre <steveayre@gmail.com> wrote:

...

I think the data type you're using in the database is the problem. 2147483647 is the maximum value you can store in a signed 32bit integer. You're trying to store a larger value so it's truncating it to the maximum possible value. Try a type that uses 64bits.

On 8 July 2014 10:47, Sergey Zhuravlov <4orbit@gmail.com> wrote:

...

hi! I tune cdr-stats now.

Found that in the database mongodb, which stores data from freeswitch with mod_cdr_mongodb strange value

start_epoch ": 1399643826," start_uepoch ": 2147483647 .... "start_stamp": "2014-05-09 13:57:06"

The problem with the value "start_uepoch": 2147483647

This is not true value should be:

<start_epoch> 1399643826 </ start_epoch> <start_uepoch> 1399643826442976 </ start_uepoch>

This is a file from cdr_xml

Someone faced with such behavior mod_cdr_mongodb? HOWTO correct it?

FreeSWITCH Version 1.5.12b+git~20140419T062924Z~f408dae2af~32bit (git f408dae 2014-04-19 06:29:24Z 32bit)

Ubuntu 12.04.4 LTS

_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com

Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com

FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org

-- WBR, Sergey GTALK/JABBER:4orbit@gmail.com