Hi, i understand right?
When Mail processed by piler-smtp, then DATE = NOW When Mail processed by pilerimport, then DATE = Date-Tag of Mail-Header ??? that would explain the date problem ... it seems to concern mails i import after running pilerimport i can't use changed main.cf because of other postfix configurations and an autoresponder script.... so the mails answered by autoresponder script would be processed again by postfix, and i have all mails 2 times in piler so i copy them to [email protected] and fetch them with fetchmail as piler-user on piler vm i tried pilerimport with imap ... pilerimport -i 10.27.1.22 -u [email protected] -p Chang3dPwd login failed, server reponse: * BAD [ALERT] Plaintext authentication not allowed without SSL/TLS, but your client did it anyway. If anyone was listening, the password was exposed. A2 NO [PRIVACYREQUIRED] Plaintext authentication disallowed on non-secure (SSL/TLS) connections. Am 25.08.2013 um 22:45 schrieb Christian Vielhauer <[email protected]>: > Hi Janos, > > > Am 25.08.2013 um 22:37 schrieb Janos SUTO <[email protected]>: > >> >> Hello Christian, >> >> On 2013-08-25 21:50, Christian Vielhauer wrote: >>> okay, i have tried with an mail from 22.8.2013. >>> in webui table, it shows date "2013.08.24" >>> in webui mailview, it shows "Date: Thu, 22 Aug 2013 11:31:57 +0200" >> >> >> >>> pilertest 4000....eml gives the following information: >>> ..... >>> sent: 1377163917, delivered-date: 0 >>> hdr len: 1611 >>> body digest: >>> d39d18af8e5b6b0f1cae7f0c3edc8e6d842389a84074c69f8e2923aa9e38504a >>> rules check: (null) >>> retention period: 1598380156 >>> attachments: >>> direction: 3 >>> spam: 0 >>> _________________________________ >>> Timestamp 1377163917 == 22/08/2013 == Date of Header >> >> so far so good >> >>>> Also connect to the piler database, and run the following: >>>> select id, sent, archived from metadata limit 10; >>> I think you mean column arrived, not archived, because archived is not >>> available >> >> yes, you are right >> >> >>> mysql> select id, sent, archived from metadata limit 10; >>> ERROR 1054 (42S22): Unknown column 'archived' in 'field list' >>> mysql> select id, sent, arrived from metadata limit 10; >>> +----+------------+------------+ >>> | id | sent | arrived | >>> +----+------------+------------+ >>> | 1 | 1322122415 | 1377158448 | >>> | 2 | 1323787445 | 1377158448 | >>> | 3 | 1296133257 | 1377158448 | >>> | 4 | 1361173764 | 1377158448 | >>> | 5 | 1325859359 | 1377158450 | >>> | 6 | 1305890031 | 1377158450 | >>> | 7 | 1352987456 | 1377158450 | >>> | 8 | 1248235864 | 1377158450 | >>> | 9 | 1370009806 | 1377158450 | >>> | 10 | 1355389487 | 1377158450 | >>> +----+------------+------------+ >>> 10 rows in set (0.00 sec) >>> Timestamp 1377158448 == 22/08/2013 !!!!! >>> Timestamp 1322122415 == 24/11/2011 !!!!! >> >> >> that's correct >> >> >>> OR from same id as the .eml file: >>> mysql> select id, sent, arrived from metadata where >>> piler_id='40000000521906a80dbfb10400abf0ee5405'; >>> +--------+------------+------------+ >>> | id | sent | arrived | >>> +--------+------------+------------+ >>> | 276928 | 1377371806 | 1377371806 | >>> +--------+------------+------------+ >>> 1 row in set (0.00 sec) >>> Timestamp 1377371806 == 24/08/2013 !!!!! but 22/08/2013 is read by pilertest >> >> >> wait a second. When got an email by smtp, then sent = arrived = <current >> timestamp> >> However when import manually by pilerimport, then sent is usually differ >> from arrived. >> Arrived means when the email arrived the archive. >> >> I also took a spam from back 2006, and imported manually, and the gui shows >> the date >> properly: 2006.09.01. or similar. Also the shown date is computed from the >> "sent" column >> which is fine for you. >> >> Please check model/search/search.php, locate the get_meta_data function, and >> verify that >> it has the following line: >> > > $m['date'] = date(DATE_TEMPLATE, $m['sent']); > > >> $m['date'] = date(DATE_TEMPLATE, $m['sent']); >> >> then check DATE_TEMPLATE in config*php, and finally check the clock and >> timezone of the virtual >> machine. >> > > $config['DATE_TEMPLATE'] = 'Y.m.d'; > > Europe/Budapest but it's same as Berlin ... > > Sun Aug 25 22:43:58 CEST 2013 > > >> Janos >> >> >> > > > Everything looks right ... > > you have got the attached png from previous mail ? > > > > Chris > > > >
