1 Topic by chris (edited by chris 2013-11-13 16:58:45)

  • chris
  • Member
  • Offline
  • From: Australia
  • Registered: 2013-11-02
  • Posts: 30

Topic: DateStamp

==== Required information ====
- iRedMail version: 0.8.5-PRO
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Centos 6
- Related log if you're reporting an issue:
====

Having a time stamp issue. My server is set to Australia/Sydney and all the logs show the correct time and date. When I use the Pro panel and look at the time stamp it reports a different time. This makes it hard to quickly look up a clients issue due to time being out of sync with system.

Outputs:

mysql -e "SELECT @@global.time_zone;"

+--------------------+
| @@global.time_zone |
+--------------------+
| SYSTEM             |
+--------------------+

date
Wed Nov 13 19:53:02 EST 2013

mysql -e "SELECT NOW();" -p
Enter password:
+---------------------+
| NOW()               |
+---------------------+
| 2013-11-13 19:53:44 |
+---------------------+

Date in Panel 2013-11-13 08:52:18

What am i missing ??

Thank you.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by cts.cobra

  • cts.cobra
  • Member
  • Offline
  • Registered: 2013-10-11
  • Posts: 22

Re: DateStamp

chris wrote:

==== Required information ====
- iRedMail version: 0.8.5-PRO
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Centos 6
- Related log if you're reporting an issue:
====

Having a time stamp issue. My server is set to Australia/Sydney and all the logs show the correct time and date. When I use the Pro panel and look at the time stamp it reports a different time. This makes it hard to quickly look up a clients issue due to time being out of sync with system.

Outputs:

mysql -e "SELECT @@global.time_zone;"

+--------------------+
| @@global.time_zone |
+--------------------+
| SYSTEM             |
+--------------------+

date
Wed Nov 13 19:53:02 EST 2013

mysql -e "SELECT NOW();" -p
Enter password:
+---------------------+
| NOW()               |
+---------------------+
| 2013-11-13 19:53:44 |
+---------------------+

Date in Panel 2013-11-13 08:52:18

What am i missing ??

Thank you.


I have the sam issue but i changed the
LOCAL_TIMEZONE = 'GMT+01:00'
( put your GMT ) in /var/www/iredadmin/libs/settings.py and restart httpd .
But i would liked to know if there is automatic way so i dont need to change it durring summer time manualy .

3 Reply by chris

  • chris
  • Member
  • Offline
  • From: Australia
  • Registered: 2013-11-02
  • Posts: 30

Re: DateStamp

Thank you, worked a treat smile