Hi Christian,
Am 25.08.2013 23:06, schrieb Christian Vielhauer:
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
autoresponder should be use another port to deliver e.g. 10026 like
amavis or dspam, ...
in master.cf you need to add
-o receive_override_options=no_address_mappings
to
localhost:10026 inet n - n - - smtpd
this prevents always_bcc a second time.
Best regards
Karsten
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
!DSPAM:521a71ec93831684611666!
