SQLite Forum

Forum emails are all going to the SPAM folder
Login

Forum emails are all going to the SPAM folder

(1) By jose isaias cabrera (jicman) on 2020-03-13 13:11:02 [link] [source]

Greetings.

I use outlook.com because that is the only email allowed at work. But, I am having a real tough time having to click on every sqlite-forum email as Not SPAM, which makes this a bad situation. I email outlook.com and they said that I need to add the address of the forum to my address book, but, the problem is that every email has a different address like noreplyxxxxxxxxx@sqlite.org (Where xxxxxxxxx is some unique hex string). Is there a setting that could have these emails come from one email address (ie. noreply@sqlite.org or noreply-sqlite-forum@sqlite.org) rather than the noreplyxxxxxxxxx@sqlite.org hex'ed email? Thanks.

josé

(2) By Warren Young (wyoung) on 2020-03-13 13:59:12 in reply to 1 [link] [source]

This feels like a diagnosis without evidence. Why do you believe the hex noise in the reply-to email is the reason that Outlook.com is marking these messages as SPAM?

There are many other possible reasons.

I suggest that you investigate the situation with Outlook.com tech support before proposing solutions. The proper solution may be something else entirely. Emails from SQLite.org don't appear to be using DKIM, for example, and Outlook.com may be downgrading all email that lack DKIM signatures.

(...Which is one of many reasons why "just make Fossil forums support inbound email" is a trivial response to a non-trivial problem.)

(3) By Richard Hipp (drh) on 2020-03-13 14:04:44 in reply to 1 [link] [source]

Is there a setting that could have these emails come from one email address

No. The noreplyXXXXXXXXXXXXX@sqlite.org is deliberately different for each forum participant. it has to be this way.

The From: field of the email looks something like this:

     From: "Sender Name" <sender-email@domain.com>

Many email readers assum that the "Sender Name" and the email address form a one-to-one mapping. (Gmail is like this, for example.) If multiple emails arrive with different "Sender Name"s but the same email address, that creates great confusions. On the other hand, we don't want to transmit the forum participant's actual email address, for privacy reasons. Hence, the sender email address is a noreplyXXXXXXXXXXXXXX@sqlite.org that is unique for each forum participant.

Can you not configure outlook to allow in a pattern of emails?

(4) By Huỳnh Trần Khanh (huynhtrankhanh1) on 2020-03-13 14:11:53 in reply to 3 [source]

GitHub has been sending out emails from a single address for years and that works for me. I don't think this forum should be any different.

If multiple emails arrive with different "Sender Name"s but the same email address, that creates great confusions.

Care to elaborate? My client, the Gmail web interface, is doing fine.

(5) By Richard Hipp (drh) on 2020-03-13 14:25:48 in reply to 4 [link] [source]

Presumably GitHub does not include the name of the person who submitted the post in the From: line. I don't use GitHub, but my guess is that message from GitHub always "From: GitHub <noreply@github.com>" or similar. Is that not the case?

The problem that this Forum is trying to solve is including the name of the person who posted the message in the From: line without revealing that person's email address.

(6) By Huỳnh Trần Khanh (huynhtrankhanh1) on 2020-03-13 14:28:18 in reply to 5 [link] [source]

Not the case. The emails being sent out also include the names.

(7) By Warren Young (wyoung) on 2020-03-13 14:30:10 in reply to 6 [link] [source]

Not for anonymous posters, they don't.

(8) By Huỳnh Trần Khanh (huynhtrankhanh1) on 2020-03-13 14:33:21 in reply to 7 [link] [source]

I don't think there is a way to post anonymously on GitHub, or am I missing something?

(9) By Richard Hipp (drh) on 2020-03-13 14:50:11 in reply to 6 [link] [source]

Well then, if you can figure out what email-header magic GitHub it using to make that happen, please let me know and I will try to implement the same in this forum. Perhaps just post the raw text of some GitHub messages here so that we can see them.

(10) By Huỳnh Trần Khanh (huynhtrankhanh1) on 2020-03-13 15:03:00 in reply to 9 [link] [source]

I was about to, but hesitated. Now that you've explicitly stated that you want the raw email, here it is.

The links require authentication, you shouldn't be half-tempted to click them to mess with me.

Delivered-To: qcdz9r6wpcbh59+github@gmail.com
Received: by 2002:aca:c287:0:0:0:0:0 with SMTP id s129csp527496oif;
        Fri, 13 Mar 2020 07:49:27 -0700 (PDT)
X-Google-Smtp-Source: ADFU+vsk4WlfB8r+9bI1wBaZnU1un+ZFtL1D/MJUcAUWSjnvfvtwoidt+H9xkxJzlWoP1EadOS7e
X-Received: by 2002:a05:620a:943:: with SMTP id w3mr13780790qkw.85.1584110967280;
        Fri, 13 Mar 2020 07:49:27 -0700 (PDT)
ARC-Seal: i=1; a=rsa-sha256; t=1584110967; cv=none;
        d=google.com; s=arc-20160816;
        b=OpbHzLdOE9CUyMJXkkq4IdHvc5TuY427v9yJYMTplmv5CnO6l5OP/rhvVMeAWFnBST
         fPo5+wwIm+P/s8OCiP4H6kS5DpXO9w9Q0Gt+i1JMHTZ1gBERy4HZuWzI3NttQhj83N9d
         ZfhuVQXoiDMqWwQk2XrmbcrXPauQ1nHDTD6aJbKGe4F/HklSUOxT9pG+L4YXh9B7IIgh
         VAQL4Nzg5v/pdOlskb79SX7SxViOar45GzFc0dT3zPoojfsuFNRzD+YqzWV/VN1xOROM
         1OHD4hdmQgfzTHwtwn6x/x2sYz0s+N+yQ5yKuWRYo2q8XeQa3GbHOb5CTx3HdsrmWqNX
         UbLw==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816;
        h=list-unsubscribe:list-post:list-archive:list-id:precedence
         :content-transfer-encoding:mime-version:subject:references
         :in-reply-to:message-id:cc:to:reply-to:from:date:dkim-signature;
        bh=1lYaBfXriyksM6uyXb1dkrwYpzW43/69nyv/djcW0rc=;
        b=kxPmVoX17z+O9EYEnZndoymZJaeMlyurcI/xY/CR2rJdx9ceOQ/iZMqFoTMVO2rt6e
         SeJWpbTBbUlikSInW8X7oVD/HCr5Depmp5Qc1v250zq1AH9T5oDE772pAgLExvF32+XV
         B92jqp4OSQEUNYNPHT2kp9uNNCBNrlKzd/F3uRvHRqBnyfE02bDA9eEQUZsBou6XfoUR
         PpoFmKpKm1Vfc54fJO/xNLiHEmCywI4WWgxTCroTBO0f9QVC8kV3pe2w6Wyk5J5cOoO/
         hkeEO0ltpnM5Jiu5jBWmV23X+ztg8I4FQDzgX3qAURVkhlEyI89GxGqsVwH8He9ISzeA
         z9+Q==
ARC-Authentication-Results: i=1; mx.google.com;
       dkim=pass (test mode) header.i=@github.com header.s=pf2014 header.b=xPEOviWe;
       spf=pass (google.com: domain of noreply@github.com designates 192.30.252.206 as permitted sender) smtp.mailfrom=noreply@github.com;
       dmarc=pass (p=NONE sp=NONE dis=NONE) header.from=github.com
Return-Path: <noreply@github.com>
Received: from out-23.smtp.github.com (out-23.smtp.github.com. [192.30.252.206])
        by mx.google.com with ESMTPS id t6si386373qvx.212.2020.03.13.07.49.27
        for <qcdz9r6wpcbh59+github@gmail.com>
        (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
        Fri, 13 Mar 2020 07:49:27 -0700 (PDT)
Received-SPF: pass (google.com: domain of noreply@github.com designates 192.30.252.206 as permitted sender) client-ip=192.30.252.206;
Authentication-Results: mx.google.com;
       dkim=pass (test mode) header.i=@github.com header.s=pf2014 header.b=xPEOviWe;
       spf=pass (google.com: domain of noreply@github.com designates 192.30.252.206 as permitted sender) smtp.mailfrom=noreply@github.com;
       dmarc=pass (p=NONE sp=NONE dis=NONE) header.from=github.com
Received: from github-lowworker-2300405.va3-iad.github.net (github-lowworker-2300405.va3-iad.github.net [10.48.17.39]) by smtp.github.com (Postfix) with ESMTP id 1684A660770 for <qcdz9r6wpcbh59+github@gmail.com>; Fri, 13 Mar 2020 07:49:27 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=github.com; s=pf2014; t=1584110967; bh=1lYaBfXriyksM6uyXb1dkrwYpzW43/69nyv/djcW0rc=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:List-ID:
	 List-Archive:List-Post:List-Unsubscribe:From; b=xPEOviWeKdtsHzdtSfRb+TkYeh6sjGSRTzZ/AK1J9I3vc1xwxIIMw3jhL52/cnVVQ
	 VmD8NoKCl5fucx+eCPHszJLO/qI+BBMyrjqieb1BzN85DCbF2mOlVrORsmAE9xJYiv
	 yqga2D/TvfiVLts+9nkjjcQBmtKUaE63ddiIDFdw=
Date: Fri, 13 Mar 2020 07:49:27 -0700
From: sjud <notifications@github.com>
Reply-To: "rust-lang/rust" <reply+AOW6J35O3RZUNYNJAFHLN6F4O57HPEVBNHHCEU5A5Q@reply.github.com>
To: "rust-lang/rust" <rust@noreply.github.com>
Cc: Subscribed <subscribed@noreply.github.com>
Message-ID: <rust-lang/rust/pull/69723/c598756376@github.com>
In-Reply-To: <rust-lang/rust/pull/69723@github.com>
References: <rust-lang/rust/pull/69723@github.com>
Subject: Re: [rust-lang/rust] Added doc on keyword Pub. (#69723)
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary="--==_mimepart_5e6b9d776944_cce3fe55bacd96c1450dc"; charset=UTF-8
Content-Transfer-Encoding: 7bit
Precedence: list
X-GitHub-Sender: sjud
X-GitHub-Recipient: huynhtrankhanh
X-GitHub-Reason: subscribed
List-ID: rust-lang/rust <rust.rust-lang.github.com>
List-Archive: https://github.com/rust-lang/rust
List-Post: <mailto:reply+AOW6J35O3RZUNYNJAFHLN6F4O57HPEVBNHHCEU5A5Q@reply.github.com>
List-Unsubscribe: <mailto:unsub+AOW6J35O3RZUNYNJAFHLN6F4O57HPEVBNHHCEU5A5Q@reply.github.com>, <https://github.com/notifications/unsubscribe/AOW6J33OHJRITQRMS66YSULRHJBXPANCNFSM4LB6Z4LA>
X-Auto-Response-Suppress: All
X-GitHub-Recipient-Address: qcdz9r6wpcbh59+github@gmail.com

----==_mimepart_5e6b9d776944_cce3fe55bacd96c1450dc
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hi, Mark. Thanks so much for your help!
I am not very familiar with git, and have been mostly using the browser. In my next pull request I'll definitely be using the terminal more, but if you could help me rebase this one I'd appreciate it.


-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/rust-lang/rust/pull/69723#issuecomment-598756376
----==_mimepart_5e6b9d776944_cce3fe55bacd96c1450dc
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<p></p>
<p>Hi, Mark. Thanks so much for your help!<br>
I am not very familiar with git, and have been mostly using the browser. In my next pull request I'll definitely be using the terminal more, but if you could help me rebase this one I'd appreciate it.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/rust-lang/rust/pull/69723#issuecomment-598756376">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AOW6J374CXWXHSXJ2GIAGA3RHJBXPANCNFSM4LB6Z4LA">unsubscribe</a>.<img src="https://github.com/notifications/beacon/AOW6J37ULBZM46JG4FM2MT3RHJBXPA5CNFSM4LB6Z4LKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEOYEYGA.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/rust-lang/rust/pull/69723#issuecomment-598756376",
"url": "https://github.com/rust-lang/rust/pull/69723#issuecomment-598756376",
"name": "View Pull Request"
},
"description": "View this Pull Request on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>
----==_mimepart_5e6b9d776944_cce3fe55bacd96c1450dc--

(11) By Kees Nuyt (knu) on 2020-03-14 00:05:32 in reply to 1 [link] [source]

> I email outlook.com and they said that I need to add the
> address of the forum to my address book, but, the problem
> is that every email has a different address like
> noreplyxxxxxxxxx@sqlite.org

You could try to add the envelope-from address  root@sqlite.org
to your address book. That address is the permitted sender.

I don't know about outlook, but my email provider recognizes the SPF :

Received-SPF: pass (filter02asd2.se.isp-net.nl: domain of sqlite.org designates 45.33.6.223 as permitted sender) client-ip=45.33.6.223; envelope-from=root@sqlite.org; helo=sqlite.org;
X-SPF-Result: filter02asd2.se.isp-net.nl: domain of sqlite.org designates 45.33.6.223 as permitted sender

HTH

-- 
Kees Nuyt

(12) By Stephan Beal (stephan) on 2020-03-14 13:55:08 in reply to 3 [link] [source]

The noreplyXXXXXXXXXXXXX@sqlite.org is deliberately different for each forum participant.

Speculation on my part, based on the pasted-in github mail: perhaps adding a '+' between noreply and the hex digits may help?

Some info about that convention:

(13) By Huỳnh Trần Khanh (huynhtrankhanh1) on 2020-03-14 16:07:32 in reply to 12 [link] [source]

The pasted GitHub email doesn't do that. The tag is in the Reply-To address, which is something completely different: it indicates the issue/pull request to which the comment should be sent.

(14) By David Raymond (dvdraymond) on 2020-03-16 13:14:04 in reply to 11 [link] [source]

For the mailing list, the headers had
Sender: sqlite-users <sqlite-users-bounces@mailinglists.sqlite.org>

and in Outlook for me they would show up as "sqlite-users on behalf of ..." and making a rule just for things from the sqlite-users address worked fine without needing to do any fancy searching or such.

Forum emails don't seem to have that sender line anywhere. Maybe just putting that back would be the simplest solution.

(15) By Tim Streater (Clothears) on 2020-03-16 13:44:06 in reply to 14 [link] [source]

Make a rule:

Subject starts with [sqlite

and that will work with forum stuff and list stuff.

(16) By Kees Nuyt (knu) on 2020-03-16 19:14:00 in reply to 14 [link] [source]

For the mailing list, the headers had Sender: sqlite-users sqlite-users-bounces@mailinglists.sqlite.org

...

Forum emails don't seem to have that sender line anywhere. Maybe just putting that back would be the simplest solution.

That sounds like a very good idea!

-- 
Regards,

Kees Nuyt

(17) By Richard Hipp (drh) on 2020-03-16 19:48:07 in reply to 16 [link] [source]

I uploaded a change to make this happen. I don't know if it will work or not. It might make things worse. The only thing I know to do is try it and see. The new changes is live. Y'all let me know if it makes a difference for better or for worse. I can always back out the change, if needed.

(18) By Tim Streater (Clothears) on 2020-03-16 21:09:26 in reply to 17 [link] [source]

On 16 Mar 2020, at 19:14, Kees Nuyt noreply932f1faf5@sqlite.org wrote:

Forum post by knu on 2020-03-16 19:14:00 https://sqlite.org/forum/forumpost/4f5bbc9971

For the mailing list, the headers had Sender: sqlite-users sqlite-users-bounces@mailinglists.sqlite.org

...

Forum emails don't seem to have that sender line anywhere. Maybe just putting that back would be the simplest solution.

That sounds like a very good idea!

No need. Mails from the list have subject line starting with: [sqlite] while those from the forum have a subject line starting with [sqlite-forum]

Pretty simple to filter on [sqlite , which is what I do. The filter marks them as not-spam and sends them into my sqlite mailbox.