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. |
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/ |