AW: BCC not shown

2018-02-12 Thread Christian Röser - PELMA 
And now the log attached in some human readable format...


Von: Janos SUTO [mailto:s...@acts.hu] 
Gesendet: Montag, 12. Februar 2018 20:26
An: Piler User 
Betreff: Re: BCC not shown

Er, I'd like to correct myself. Your bcc address is the same as the to/from 
address.
However, the gui applies an email address filter for the search query. If you 
know what message you should see (but you don't) then check it in the rcpt 
table. You should see your email address as well.
The id in rcpt table is the same as the id in the metadata table. You can get 
the id of the given message if you hover the mouse on the download link in the 
lower preview pane.
Janos

From: "Christian Röser - PELMA" 
Sent: Mon Feb 12 18:47:03 GMT+01:00 2018
To: Piler User 
Subject: AW: BCC not shown


Hello Janos,

now I'm a bit confused, is my bcc address not the same as my "normal" address? 
Here is the query with no search term:

sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHEREMATCH(' 
(@from cXroeserXsaftigXnet | @to cXroeserXsaftigXnet) ') ORDER BY `sent` DESC 
LIMIT 0,20 OPTION max_matches=1000' in 0.00 s, 14 hits, 14 total found

For the tests the user was created manually, I only entered the email address, 
username, full name, domain and password. 




Von: Janos SUTO [mailto:s...@acts.hu] 
Gesendet: Montag, 12. Februar 2018 17:44
An: Piler User 
Betreff: Re: BCC not shown

Hello Christian,
check the Sphinx query in the mail log. I suspect that your bcc address is not 
in the query. 
The fix depends on what authentication you are using.

Janos


From: "Christian Röser - PELMA" 
Sent: Mon Feb 12 17:37:09 GMT+01:00 2018
To: Piler User 
Subject: BCC not shown




Hello,

I need some help. Today I made some tests with my piler installation and I 
found a problem that drives me crazy - but I assume there could be simple 
configuration problem. Messages I receive as bcc are not shown in the search 
results.

I checked if the exchange server behaves correctly, here seems everything fine. 
The system generates two e-mails, one for the normal recipient and a separate 
one for the bcc recipient. Piler receive both e-mails, stores the first one and 
recognizes for the second e-mail that it have the same message-id. In the 
metadata table exists an entry and in the rcpt table two entries for this id. 
Nevertheless only in the search results of the "normal" recipient the message 
is shown.

Is the some parameter missing?

Best regards,
Christian


Feb 12 22:29:36 mailpiler piler-smtp[549]: connected from 10.194.0.2:16698 on 
descriptor 6 (active connections: 1)
Feb 12 22:29:36 mailpiler piler-smtp[549]: [54B blob data]
Feb 12 22:29:36 mailpiler piler-smtp[549]: [77B blob data]
Feb 12 22:29:36 mailpiler piler-smtp[549]: [46B blob data]
Feb 12 22:29:36 mailpiler piler-smtp[549]: sent: 250 Ok
Feb 12 22:29:36 mailpiler piler-smtp[549]: [67B blob data]
Feb 12 22:29:36 mailpiler piler-smtp[549]: sent: 250 Ok
Feb 12 22:29:36 mailpiler piler-smtp[549]: [27B blob data]
Feb 12 22:29:36 mailpiler piler-smtp[549]: sent: 354 Send mail data; end it 
with .
Feb 12 22:29:36 mailpiler piler-smtp[549]: received: 5VQK1KDSHAENMIU1, from=, 
size=8361, client=10.194.0.2
Feb 12 22:29:36 mailpiler piler-smtp[549]: sent: 250 OK <5VQK1KDSHAENMIU1>
Feb 12 22:29:36 mailpiler piler-smtp[549]: [27B blob data]
Feb 12 22:29:36 mailpiler piler-smtp[549]: sent: 221 
mailpiler.saffig.saftig.net Goodbye
Feb 12 22:29:36 mailpiler piler-smtp[549]: disconnected from 10.194.0.2 on 
descriptor 6 (0 active connections)
Feb 12 22:29:37 mailpiler piler[554]: 40005a82074b237e7e9400cba0225cf3: 
journal rcpt: 'i...@saftig.net '
Feb 12 22:29:37 mailpiler piler[554]: 40005a82074b237e7e9400cba0225cf3: 
hdr_len: 594, offset: 3
Feb 12 22:29:37 mailpiler piler[554]: 40005a82074b237e7e9400cba0225cf3: 
touch 1d144d5a090b040ea90a909a1b06cf8b7b81d96e1b88e0d01c8949ead45a887b OK 
(<20180212212922.14342101...@smtp02.mail.de>)
Feb 12 22:29:37 mailpiler piler[554]: 40005a82074b237e7e9400cba0225cf3: 
stored '40005a82074b237e7e9400cba0225cf3.m' 8361/3896 bytes
Feb 12 22:29:37 mailpiler piler[554]: 40005a82074b237e7e9400cba0225cf3: 
stored 1 recipients, rc=0
Feb 12 22:29:37 mailpiler piler[554]: 40005a82074b237e7e9400cba0225cf3: 
stored metadata, rc=0
Feb 12 22:29:37 mailpiler piler[554]: 1/5VQK1KDSHAENMIU1: 
40005a82074b237e7e9400cba0225cf3, size=8361/3896, attachments=0, 
reference=, message-id=<20180212212922.14342101...@smtp02.mail.de>, 
retention=4000, folder=0, delay=0.0219, status=stored
Feb 12 22:29:45 mailpiler piler-smtp[549]: connected from 10.194.0.2:16706 on 
descriptor 6 (active connections: 1)
Feb 12 22:29:45 mailpiler piler-smtp[549]: [54B blob data]
Feb 12 22:29:45 mailpiler piler-smtp[549]: [77B blob data]
Feb 12 22:29:45 mailpiler piler-smtp[549]: [46B blob data]
Feb 12 22:29:45 mailpiler

AW: BCC not shown

2018-02-12 Thread Christian Röser - PELMA 
Hello Janos,

now I'm a bit confused, is my bcc address not the same as my "normal" address? 
Here is the query with no search term:

sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHEREMATCH(' 
(@from cXroeserXsaftigXnet | @to cXroeserXsaftigXnet) ') ORDER BY `sent` DESC 
LIMIT 0,20 OPTION max_matches=1000' in 0.00 s, 14 hits, 14 total found

For the tests the user was created manually, I only entered the email address, 
username, full name, domain and password. 




Von: Janos SUTO [mailto:s...@acts.hu] 
Gesendet: Montag, 12. Februar 2018 17:44
An: Piler User 
Betreff: Re: BCC not shown

Hello Christian,
check the Sphinx query in the mail log. I suspect that your bcc address is not 
in the query. 
The fix depends on what authentication you are using.

Janos

From: "Christian Röser - PELMA" 
Sent: Mon Feb 12 17:37:09 GMT+01:00 2018
To: Piler User 
Subject: BCC not shown




Hello,

I need some help. Today I made some tests with my piler installation and I 
found a problem that drives me crazy - but I assume there could be simple 
configuration problem. Messages I receive as bcc are not shown in the search 
results.

I checked if the exchange server behaves correctly, here seems everything fine. 
The system generates two e-mails, one for the normal recipient and a separate 
one for the bcc recipient. Piler receive both e-mails, stores the first one and 
recognizes for the second e-mail that it have the same message-id. In the 
metadata table exists an entry and in the rcpt table two entries for this id. 
Nevertheless only in the search results of the "normal" recipient the message 
is shown.

Is the some parameter missing?

Best regards,
Christian

Re: BCC not shown

2018-02-12 Thread Janos SUTO 
Hello Christian,

check the Sphinx query in the mail log. I suspect that your bcc address is not 
in the query.

The fix depends on what authentication you are using.


Janos


 Original Message 
From: "Christian Röser - PELMA" 
Sent: Mon Feb 12 17:37:09 GMT+01:00 2018
To: Piler User 
Subject: BCC not shown



Hello,

I need some help. Today I made some tests with my piler installation and I 
found a problem that drives me crazy - but I assume there could be simple 
configuration problem. Messages I receive as bcc are not shown in the search 
results.

I checked if the exchange server behaves correctly, here seems everything fine. 
The system generates two e-mails, one for the normal recipient and a separate 
one for the bcc recipient. Piler receive both e-mails, stores the first one and 
recognizes for the second e-mail that it have the same message-id. In the 
metadata table exists an entry and in the rcpt table two entries for this id. 
Nevertheless only in the search results of the "normal" recipient the message 
is shown.

Is the some parameter missing?

Best regards,
Christian

AW: timestamp feature

2018-02-12 Thread Christian Röser - PELMA 
Hi,

thanks for your explanations. Today I tested the timestamp service and deleting 
seems to be no problem. I assumed that piler generates every time the hash from 
the stored files but it uses the stored hashes from the database and these 
entries are not deleted when an email is purged - so everything is fine. 

Best regards,
Christian





Von: Frank Schmitz [mailto:fs_2...@yahoo.de] 
Gesendet: Mittwoch, 7. Februar 2018 15:09
An: Piler User 
Betreff: Re: timestamp feature

Hi,

actually you can choose which way piler uses timestamps. If you want, you can 
use a different timestamp for each incoming mail.
This strategy might prove quite costly though, since most TSAs bill you for 
each timestamp they issue to you (And you won't know how much they charge you 
each day beforehand).

The other way is to use one timestamp for all incoming mails within a specified 
timeframe (every 1/2/3 hours, every hour from 09:00 to 18:00 and so on).
This way, you know beforehand how many timestamps you will need per day and how 
much that will cost you.
When I set this up, I chose a TSA (http://tsa.safecreative.org/) that gives 
away 5 free timestamps per day and I configured piler to create timestamps 
every 2 hours from 9:00 to 17:00 (business hours) -> No costs and still tamper 
proof according to german law (revisionssicher/GDPR).

Regarding your question about deleting a mail:
Timestamps are stored in a different DB table than emails.
They have their own ID and they also store the range of email IDs this 
timestamp is valid for.
In another table you'll find all mails with their unique IDs.

Even though I never tried it (different setup), you should be able to delete 
individual mails without a problem, since the timestamp is not stored within 
the mail itself. Instead the timestamp "knows" which mails it's valid for.

Hope that helps,
Frank

Christian Röser - PELMA  schrieb am 10:56 Mittwoch, 
7.Februar 2018:

Hello,
 
I have some questions about the timestamping feature. As far as I understand 
from this post 
https://www.mail-archive.com/piler-user@list.acts.hu/msg00785.html piler 
collects a bunch of mails, generates a hash for all of them and then this hash 
is signed by the tsa server. To verify a single mail, piler looks up what hash 
belongs to this e-mail, what other e-mails where involved, computes the hash 
for all of them and then compares this hash with the signed hash. Am I right?
 
Now I want (have to) use the delete feature of piler. For example in Germany 
you have to delete job applications after some time. Although we have a 
separate e-mail address for such stuff, which will not be archived, it happens 
from time to time that someone sends a mail to the a general address like 
info@. Now german law tells me that I have to delete such mails.
 
What does that mean for the timestamp feature? If I delete a mail, that message 
is no longer available for the hash computing. Does that mean that the 
verification for a some mails or – if I use the unit way – some hundred or 
thousand emails fails? Do I have get a stamp for every single mail? Is this 
even possible? Or exists there some magic in piler to prevent this? 
 
Best regards,
Christian