Spam contacts in recent recipient

Help
1

Hi,
I’m not sure if this is a bug but if I search for a new contact, the suggestion is showing spam recipients. I double check in my archive and I cannot find emails containing this specific emails. Is there a way to clean and remove those suggestions? If this is a bug I can open on the other platform.

Screenshot_20240523_182900
Screenshot_20240523_182900862×379 29.8 KB

2

@boredkollie:

First, welcome to the KDE Plasma Discuss forums!

Assuming that, you’ve either deleted or archived the spam e-Mails then, some of the data which was in the headers of those e-Mails is possibly still stored in the Akonadi database.
The following Akonadi Control CLI command should help to clean such entries from the database assuming that, the concerned e-Mails are no longer stored in any IMAP accounts or, local accounts (including POP3 accounts) –

> akonadictl vacuum

3

Thanks for the warming welcome!

I’m pretty sure I deleted trash and junk folders, and even the search for those email are not returning any result. I search in the full body message, run akonadictl vacuum but they still appear in the suggestion.

4

@boredkollie:

Then, you’ll have to raise a Bug Report – <KDE Bugtracking System>

  • Unfortunately, not the same login as that for this Forum – you have to supply an e-Mail address as the login name for the Bug Reporting system.

PRIVACY NOTICE: KDE Bugtracking System is an open bug tracking system. Activity on most bugs, including email addresses, will be visible to registered users. We recommend using a secondary account or free web email service (such as Gmail, Yahoo, Hotmail, or similar) to avoid receiving spam at your primary email address.

You could try using the “akonadiconsole” to inspect the Akonadi database and determine where those addresses are being locally stored on your system.

Alternatively, use “grep” to search the following ‘~/.local/share/’ directories for those e-Mails –

  • ~/.local/share/local-mail/
  • ~/.local/share/.local-mail.directory/
  • ~/.local/share/akonadi_maildir_resource_?/
  • ~/.local/share/akonadi_imap_resource_?/
5

hey @Franken14679 I’ve been playing with the akonadi console but not an expert querying db. Can you help me trying to debugging? Even if I understand how it works I don’t know the command/process to investigate. Thanks in advance.

6

@boredkollie:

Yes, agreed, the “akonadiconsole” application does need some database expertise – we may quietly forget that suggestion.

Did you use the KMail search function to recursively search all your e-Mail folders – both local and IMAP and POP3 – for any e-Mails containing the Spam addresses?

  • You need to search for the address string in “Anywhere in Headers”.
7

I’ve searched, but no results:

image
image1065×593 42.3 KB

8

@boredkollie:

Then, the addresses are somewhere in a Cache –

  • But, where?? …

The only KMail cache directory I know of is –

~/.cache/kmail2/messagelist/threading/

You could also check the following Local Share directories –

~.local/share/local-mail/
~.local/share/.local-mail.directory/
~.local/share/akonadi_imap_resource_?/
~.local/share/akonadi_maildir_resource_?/
~.local/share/RecentDocuments/
1 Like
9

Thanks, I found it here:

$ grep notification@chiangmaidental.com -r .local/*
grep: .local/share/akonadi/search_db/emailContacts/postlist.glass: binary file matches

can I safely delete it or rebuild the cache?

Edit: I made a backup, restarted akonadi and it was rebuilt, and now the spam addresses aer gone. Thanks for suggesting were to look.

1 Like