piler GUI date display versus mail header

[Dave Dmytriw]

I happened to notice what looks like a bug in the displayed date in the piler GUI versus the actual email header.

The display date changed from 2013.08.15 to 2013.8.16 at what looks like 1600 hrs MTN time.

What I mean is an email with the following Date information

Date: Thu, 15 Aug 2013 15:57:17 -0600 shows as 2013.08.15

while

Date: Thu, 15 Aug 2013 16:12:49 -0600 shows as 2013.8.16

Am I possibilly missing a localization setting somewhere ?

[Janos SUTO]

Can you show me a screenshot where you can see the biased date?

[Dave Dmytriw]

screenshots

[Janos SUTO]

OK, thanks. Please download the problematic email with the wrong date. Note the filename, it's 4000000xxxxxx.eml.

Then connect to the database (mysql -u piler -p piler), and execute the following:

select * from metadata where piler_id='4000000xxxxxx';

(replace 4000000xxxxxx with the actual piler id). Also please grep DATE_TEMPLATE config*php in the documenroot (/var/www/piler or similar) to check that the date format is correct.

[Dave Dmytriw]

Thanks Janos

Little hard to format...

mysql> select * from metadata where piler_id='40000000520d526c283beb4c0077734b2654'; +------+--------------------------------+--------------------+-------------------------------+------+------------+------------+------------+---------+--------+------+-----------+-------------+--------------------------------------+------------------------------------------------------+-----------+------------------------------------------------------------------+------------------------------------------------------------------+------------------------------------------------------------------+ | id | from | fromdomain | subject | spam | arrived | sent | retained | deleted | size | hlen | direction | attachments | piler_id | message_id | reference | digest | bodydigest | vcode | +------+--------------------------------+--------------------+-------------------------------+------+------------+------------+------------+---------+--------+------+-----------+-------------+--------------------------------------+------------------------------------------------------+-----------+------------------------------------------------------------------+------------------------------------------------------------------+------------------------------------------------------------------+ | 1270 | [e-mail] | blahblah.com | 13blahblah | 0 | 1376604770 | 1376604770 | 1597529570 | 0 | 402011 | 1360 | 0 | 1 | 40000000520d526c283beb4c0077734b2654 | 00e301ce9a04$93ebbd90$bbc338b0$@blahblah.com | | b2f21a5e4a5a3676a641a95914cfa609ad3dd361fcb2e6eb2f1f32c812e6dcc3 | 85fd84108be1cf2f209513a520f79a36605983cba7dbaa66d168d035341cb721 | 1d0ebe4b18bb9b0e29ce1f2452602d863979ae8738dc099663793dd6a133107d | +------+--------------------------------+--------------------+-------------------------------+------+------------+------------+------------+---------+--------+------+-----------+-------------+--------------------------------------+------------------------------------------------------+-----------+------------------------------------------------------------------+------------------------------------------------------------------+------------------------------------------------------------------+ 1 row in set (0.00 sec)

---

grep DATE_TEMPLATE config* config.php:$config['DATE_TEMPLATE'] = 'Y.m.d';

Hope this helps.

[Janos SUTO]

It's ok, I was interested mostly in the "sent" field. It's interesting however, that perl -e 'print scalar localtime(1376604770);' says, it's Fri Aug 16 00:12:50 2013.

Could you show me all the Received header lines from the email header?

[Dave Dmytriw]

Received: from localhost (localhost.localdomain [127.0.0.1]) by blah.blah.com (Postfix) with ESMTP id 7A98FB41513 for <blah.blah.com>; Thu, 15 Aug 2013 16:12:50 -0600 (MDT) X-Virus-Scanned: Debian amavisd-new at blah.blah.com Received: from blah.blah.com ([127.0.0.1]) by localhost (blah.blah.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id gH1+y+mD5MFs for <blah.blah.com>; Thu, 15 Aug 2013 16:12:49 -0600 (MDT) Received: from 012PC (blah.blah.com) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: blah.blah.com) by blah.blah.com (Postfix) with ESMTPSA id 90775B414C6 for <blah.blah.com>; Thu, 15 Aug 2013 16:12:49 -0600 (MDT

[Janos SUTO]

OK, one more last thing: please grep the mail log entries related to this email from the mail log, eg.

grep 40000000520d526c283beb4c0077734b2654 /var/log/maillog

[Dave Dmytriw]

Thanks Janos - here you go

grep 40000000520d526c283beb4c0077734b2654 /var/log/mail.log Aug 15 16:12:51 server postfix/smtp[8442]: 7A98FB41513: to=[e-mail], relay=blah.archive[192.168.0.11]:25, delay=0.52, delays=0.11/0.01/0.05/0.35, dsn=2.0.0, status=sent (250 Ok 40000000520d526c283beb4c0077734b2654 [e-mail]) Aug 15 16:12:51 server piler[13687]: 40000000520d526c283beb4c0077734b2654: from=blah.com, size=402011, reference=, message-id=00e301ce9a04$93ebbd90$bbc338b0$@blah.com, retention=2557, delay=0.09, delays=0.06/0.01/0.00/0.02/0.00/0.00

[Dave Dmytriw]

I think your result for perl -e 'print scalar localtime(1376604770) is for your timezone and not mine :)

[Dave Dmytriw]

Janos, found this link that might explain it ...

http://stackoverflow.com/questions/753346/how-do-i-set-the-timezone-for-perls-localtime

[Janos SUTO]

Wait a second: what's the value of $config['TIMEZONE'] in config*.php?

If it's Europe/Budapest, then change it to your timezone.

[Dave Dmytriw]

oopsi , my bad.

Yes, TIMEZONE setting was unchanged...

Sorry - resolved.

[Janos SUTO]

no problem, I'm glad that it's fixed now.