asterisk2billing.org
http://forum.asterisk2billing.org/

Wrong time and date in customer CDR
http://forum.asterisk2billing.org/viewtopic.php?f=22&t=5771
Page 1 of 2

Author:  asangio [ Wed Jun 24, 2009 4:30 am ]
Post subject:  Wrong time and date in customer CDR

Hello Areski,

I noticed that version 1.4 is not showing the correct date and time for CDRs under the customer's login.
The administrator shows the corerct time:

2009-06-24 00:10:31

but when I logon as a customer, the same call shows

06/24/2009 16:19:56

I tried changing the time zone for the customer but it does not make any difference. All calls show 14 hours difference in time.
Any suggestions?
Thanks

Author:  areski [ Wed Jun 24, 2009 4:52 pm ]
Post subject:  Re: Wrong time and date in customer CDR

Check the settings :
Server GMT server_GMT GMT-00:00 Define the sever gmt time

/Areski

Author:  asangio [ Wed Jun 24, 2009 6:23 pm ]
Post subject:  Re: Wrong time and date in customer CDR

Hello Areski,

I had that setting correct Server GMT server_GMT GMT-05:00 USA Estearn Standard.
I checked the user setting for time zone and it is in -5:00 as well but the calls still show:

06/24/2009 23:25:10 in the customer interface and 2009-06-24 14:25:10 in the administrator interface.

I restarted asterisk and also rebooted the server but no difference. Is there anything else I have to check?

Thanks

Author:  bgp [ Wed Jun 24, 2009 7:04 pm ]
Post subject:  Re: Wrong time and date in customer CDR

Can you get calldate from mysql directly?
I get similar problem with CDR in customer UI.

Author:  asangio [ Wed Jun 24, 2009 9:13 pm ]
Post subject:  Re: Wrong time and date in customer CDR

Hi bgp,

If I ran a query in Mysql I see the same time I see in the admin interface. The admin interface is showing the correct time, it is the time in the customer interface the one is not displaying correctly.

I assume the system takes the CDR time from the cc_call starttime field and then applies the time zone selected for the customer so that when the customer views his call history this one is displayed correctly for him. If this is the case, it is not working. :shock:

Author:  bgp [ Thu Jun 25, 2009 5:36 am ]
Post subject:  Re: Wrong time and date in customer CDR

Hi, asangio!

In my case calldate in CDR in customer ui displayed correctly only when TIMEZONE key set to GMT for customer. But if i set this key to GMT+03:00 (corresponding to my timezone) calldate in customer ui displayed whith 3 hours shift.
For server, server_GMT key set to GMT+03:00.

Author:  areski [ Thu Jun 25, 2009 4:03 pm ]
Post subject:  Re: Wrong time and date in customer CDR

I made a fix to use SERVER_GMT from the customer panel, see rev 2145.

Yours,
/Areski

Author:  asangio [ Thu Jun 25, 2009 11:16 pm ]
Post subject:  Re: Wrong time and date in customer CDR

Hello Areski,

I downloaded the latest code with the fix and the CDR time is showing correctly on the customer's inteface. It is working great! thanks!

Quick question though, how do I get rid of the PHP Quick Profiler bar that now displays at the bottom of the customer interface?

Thanks
Asangio

Author:  asangio [ Fri Jun 26, 2009 2:15 am ]
Post subject:  Re: Wrong time and date in customer CDR

I figured it out. Here is how to disable it:

In my case the path for the "common" folder is:
/var/www/html/common/lib
Just edit:
customer.defines.php

Change define ("PHP_QUICK_PROFILER", true);

to

define ("PHP_QUICK_PROFILER", false);

Author:  sanjap [ Sat Dec 31, 2011 6:37 am ]
Post subject:  Re: Wrong time and date in customer CDR

I am using version 1.9.4 and I still have this problem. Customer CDR datetime is always wrong even after setting server_GMT and customer timezone correctly.

Author:  deidt [ Thu Apr 05, 2012 5:26 pm ]
Post subject:  Re: Wrong time and date in customer CDR

I am having the same issue on both 1.9.3 and 1.9.4 for certain customers. Any ideas?

Thanks!

Drew

Author:  jansalex [ Fri Jun 01, 2012 10:13 am ]
Post subject:  Re: Wrong time and date in customer CDR

Having same problem on a2billing 1.9.4 in the customer panel.

On admin panel is right.

Author:  vitalinka [ Mon Jul 16, 2012 3:53 pm ]
Post subject:  Re: Wrong time and date in customer CDR

mysql time zone setting the MySQL time zone
Complete the following questions by MySQL to change the database time zone

# Change the time zone to UTC +01:00 (Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna)
mysql_query ("SET time_zone = '+01:00');
 
# Change the global time zone to UTC +01:00 (Requires "SUPER" privilege)
mysql_query ("SET GLOBAL time_zone = '+01:00');

SELECT CURRENT_TIMESTAMP; spend time

Author:  alexvp [ Wed Jun 17, 2015 12:18 am ]
Post subject:  Re: Wrong time and date in customer CDR

Hi,

i have A2Billing v2.0.11 and the issue still in customer panel.

Any update?

Best Regards,

Alex

Author:  vjfromgt [ Sat Jan 16, 2021 11:54 pm ]
Post subject:  Re: Wrong time and date in customer CDR

A2Billing v2.0.4
CDR date in mysql and in admin interface is ahead of system time

+--------------------+
| @@global.time_zone |
+--------------------+
| SYSTEM |
+--------------------+
1 row in set (0.00 sec)

Any ideas?

Page 1 of 2 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/