Re: [MlMt] is it possible to search on Msg ID or "Warning: Email not available on disk" status ?

[Benny Kjær Nielsen]

On 8 May 2019, at 15:37, Sam Hathaway wrote:


On 8 May 2019, at 0:49, Bill Cole wrote:

Tip: don't let other programs do data violence in the MailMate 
message cache.


That’s not always possible. Antivirus software may remove messages 
that contain malware.


Which kind of makes it malware itself ;-) I wonder if any 
antivirus-software would quarantine an email if it had an antivirus app 
attached...


Joking aside, I don't have any nice solution to this problem. I strongly 
recommend not letting antivirus software do anything to the Messages 
subfolder. Nothing in this folder is executable. MailMate will save 
attachments in another location (currently the Attachments folder) and 
this will still give antivirus software the opportunity to intervene.


If the antivirus software can just list the files matching its checks 
(without removing them) then one could build a list of `Message-ID` 
headers and then use the `message:` URL scheme to open these emails in 
MailMate in order to delete them (one by one).


Ideally, MailMate would detect disappearing files and offer the user to 
act on it -- including deleting them server side. (This would still 
leave MailMate unable to properly clear its database index files.)


--
Benny
https://freron.com/become_a_mailmate_patron/
___
mailmate mailing list
mailmate@lists.freron.com
https://lists.freron.com/listinfo/mailmate

Re: [MlMt] is it possible to search on Msg ID or "Warning: Email not available on disk" status ?

[Michael Dunston]

On 8 May 2019, at 17:33, Randall Gellens wrote:

If you're running the software locally, is it possible to have it 
generate a report that lists something in the message that could be 
then used in a script to have MM delete the messages?


Our IT area now requires Avast, which apparently does have the ability 
to mark headers for incoming mail when the “mail shield” component 
is enabled, but the only option when scans are run manually is to 
quarantine the necessary *.elm files directly by moving them into a 
“chest”.  It does show the full path for files (messages) with 
problems though, which is where I was getting the message ID from.  But 
unfortunately the report with this information appears to be just for 
display of the information, without any ability to export the list of 
files as text or even copy for pasting into something else.  The file 
path data can be copied via a contextual menu, but only for each one 
individually.


In the end I just enabled the Msg Id column, sorted by that, and went 
through the list by visually scanning the Msg Ids to locate the items 
quarantined in the report.   It took longer to do it this way, but 
having the ability to view and sort by Msg Id at least made it possible. 
 Thanks again!



--
-- Michael Dunston
-- Recording and Production
-- School of Performing Arts Music | Theatre | Cinema
-- (540) 231-9942 
___
mailmate mailing list
mailmate@lists.freron.com
https://lists.freron.com/listinfo/mailmate

Re: [MlMt] is it possible to search on Msg ID or "Warning: Email not available on disk" status ?

[Randall Gellens]

I don't know anything about the anti-virus software you're using, so I 
ask: is it possible to have it do something besides deleting/moving the 
message files?  Sometimes, anti-malware software can be integrated into 
mail delivery so that messages are marked (or rejected by the server).  
If you're running the software locally, is it possible to have it 
generate a report that lists something in the message that could be then 
used in a script to have MM delete the messages?


--Randall

On 8 May 2019, at 13:08, Michael Dunston wrote:


On 8 May 2019, at 13:56, Bill Cole wrote:


I did also answer the question. In short: it can't be done.

MM does not actively monitor the existence of message files.


But MM does appear to be internally storing a Msg ID value for each 
message which matches the *.eml file on disk, as these can be enabled 
as a column in View -> Columns and they appear to match the file name 
of the message (in the local file store) as identified by the AV scan. 
 I have tried enabling “Message-Id”, “Message-data-Id”, 
“#Filepath”, “Filename”, “Filename#LC” as searchable 
fields in the Edit -> Find -> Mailbox Search “other” options, but 
none of these seem to be able to find messages by the Msg ID displayed 
by Mailmate or the the *.eml files on disk.  Thanks though.


--
-- Michael Dunston
-- Recording and Production
-- School of Performing Arts Music | Theatre | Cinema
-- (540) 231-9942 
___
mailmate mailing list
mailmate@lists.freron.com
https://lists.freron.com/listinfo/mailmate

___
mailmate mailing list
mailmate@lists.freron.com
https://lists.freron.com/listinfo/mailmate

Re: [MlMt] is it possible to search on Msg ID or "Warning: Email not available on disk" status ?

[Michael Dunston]

On 8 May 2019, at 13:56, Bill Cole wrote:


I did also answer the question. In short: it can't be done.

MM does not actively monitor the existence of message files.


But MM does appear to be internally storing a Msg ID value for each 
message which matches the *.eml file on disk, as these can be enabled as 
a column in View -> Columns and they appear to match the file name of 
the message (in the local file store) as identified by the AV scan.  I 
have tried enabling “Message-Id”, “Message-data-Id”, 
“#Filepath”, “Filename”, “Filename#LC” as searchable fields 
in the Edit -> Find -> Mailbox Search “other” options, but none of 
these seem to be able to find messages by the Msg ID displayed by 
Mailmate or the the *.eml files on disk.  Thanks though.


--
-- Michael Dunston
-- Recording and Production
-- School of Performing Arts Music | Theatre | Cinema
-- (540) 231-9942 
___
mailmate mailing list
mailmate@lists.freron.com
https://lists.freron.com/listinfo/mailmate

Re: [MlMt] is it possible to search on Msg ID or "Warning: Email not available on disk" status ?

[Bill Cole]

On 8 May 2019, at 12:57, Sam Hathaway wrote:

On May 8, 2019 12:02:05 PM "Bill Cole" 
 wrote:



On 8 May 2019, at 9:37, Sam Hathaway wrote:


On 8 May 2019, at 0:49, Bill Cole wrote:


Tip: don't let other programs do data violence in the MailMate
message cache.


That’s not always possible. Antivirus software may remove messages
that contain malware.


I understand that: it's broken by design.


Yes, true, but these are the facts on the ground and it's not 
particularly helpful to tell people "you shouldn't want that" in place 
of answering the question. Sorry, this is a pet peeves of mine.


I did also answer the question. In short: it can't be done.

MM does not actively monitor the existence of message files.

--
Bill Cole
b...@scconsult.com or billc...@apache.org
(AKA @grumpybozo and many *@billmail.scconsult.com addresses)
Not Currently Available For Hire
___
mailmate mailing list
mailmate@lists.freron.com
https://lists.freron.com/listinfo/mailmate

Re: [MlMt] is it possible to search on Msg ID or "Warning: Email not available on disk" status ?

[Bill Cole]

On 8 May 2019, at 9:37, Sam Hathaway wrote:


On 8 May 2019, at 0:49, Bill Cole wrote:

Tip: don't let other programs do data violence in the MailMate 
message cache.


That’s not always possible. Antivirus software may remove messages 
that contain malware.


I understand that: it's broken by design.



--
Bill Cole
b...@scconsult.com or billc...@apache.org
(AKA @grumpybozo and many *@billmail.scconsult.com addresses)
Not Currently Available For Hire
___
mailmate mailing list
mailmate@lists.freron.com
https://lists.freron.com/listinfo/mailmate

Re: [MlMt] is it possible to search on Msg ID or "Warning: Email not available on disk" status ?

[Michael Dunston]

On 8 May 2019, at 9:37, Sam Hathaway wrote:


On 8 May 2019, at 0:49, Bill Cole wrote:

Tip: don't let other programs do data violence in the MailMate 
message cache.


That’s not always possible. Antivirus software may remove messages 
that contain malware.


Basically what I am try to do is use AV software to identify messages in 
my local mail store (about 350k messages), quarantine them, and then use 
MM to delete those messages from the IMAP side so they aren’t 
dowloaded again at some point in the fututre.  Being able to identify 
the messages in MM via a search would make this significantly easier 
than visually scanning the Msg ID column looking for the ones which have 
been quarantined.  Thanks for the responses though.


--
-- Michael Dunston
-- Recording and Production
-- School of Performing Arts Music | Theatre | Cinema
-- (540) 231-9942 
___
mailmate mailing list
mailmate@lists.freron.com
https://lists.freron.com/listinfo/mailmate

Re: [MlMt] is it possible to search on Msg ID or "Warning: Email not available on disk" status ?

[Sam Hathaway]

On 8 May 2019, at 0:49, Bill Cole wrote:

Tip: don't let other programs do data violence in the MailMate message 
cache.


That’s not always possible. Antivirus software may remove messages 
that contain malware.

-sam
___
mailmate mailing list
mailmate@lists.freron.com
https://lists.freron.com/listinfo/mailmate

Re: [MlMt] is it possible to search on Msg ID or "Warning: Email not available on disk" status ?

[Bill Cole]

On 8 May 2019, at 0:03, Michael Dunston wrote:

I am wondering if there is a way to easily identify any and all 
messages which have been quarantined (removed from the local mail 
store outside of MM) so that the messages can be explicitly (manually) 
deleted within Mailmate to delete them in the IMAP side too.   Is it 
possible to search on the message ID, or even better simply find all 
files which have been removed from disk and are now returning the 
“Warning: Email not available on disk” message?  I tried a few of 
the options in the “Other…” category of the custom search, but 
have not yet found something which might do this.  Thank you for any 
tips or suggestions.


Tip: don't let other programs do data violence in the MailMate message 
cache.


The MM search database indexes the message cache but MM can't tell that 
the underlying message file has been deleted until it tries to access it 
and finds nothing. If you need to automate deletion of messages from 
outside of MailMate, it can be scripted.



--
Bill Cole
b...@scconsult.com or billc...@apache.org
(AKA @grumpybozo and many *@billmail.scconsult.com addresses)
NOT Available For Hire
___
mailmate mailing list
mailmate@lists.freron.com
https://lists.freron.com/listinfo/mailmate

[MlMt] is it possible to search on Msg ID or "Warning: Email not available on disk" status ?

[Michael Dunston]

I am wondering if there is a way to easily identify any and all messages 
which have been quarantined (removed from the local mail store outside 
of MM) so that the messages can be explicitly (manually) deleted within 
Mailmate to delete them in the IMAP side too.   Is it possible to search 
on the message ID, or even better simply find all files which have been 
removed from disk and are now returning the “Warning: Email not 
available on disk” message?  I tried a few of the options in the 
“Other…” category of the custom search, but have not yet found 
something which might do this.  Thank you for any tips or suggestions.


--
-- Michael Dunston
-- Recording and Production
-- School of Performing Arts Music | Theatre | Cinema
-- (540) 231-9942 
___
mailmate mailing list
mailmate@lists.freron.com
https://lists.freron.com/listinfo/mailmate