SQLite Forum

can not subscribe
Login

can not subscribe

(1) By anonymous on 2020-04-15 12:58:38 [link]

Dear SQliters,

This is not an SQLite question. Since transition to the forum, I tried to subscribe and failed. I did not receive email from the forum. I tried to email to Richard directly and email bounced. Something is blacklisted. The bounce email had some links to follow (office 365 delist portal), and I did, but it is "unable to submit request right now". What a joke. Can anyone suggest what to do?

Thank you,

Roman

(2) By Richard Hipp (drh) on 2020-04-15 13:26:09 in reply to 1 [link]

Specifically, the Outlook email server upon which Roman gets his email
has blacklisted the 45.33.6.223 IP address, which is the IP address of
the machine that hosts the Fossil forum.

(3.1) By jose isaias cabrera (jicman) on 2020-04-15 14:19:54 edited from 3.0 in reply to 1

I have been trying to [tell](https://sqlite.org/forum/forumpost/2e64506761a9943294f148c3f59689d3882dc9efeca0d07eb2486305d1593aaa) you folks that outlook has sqlite site blocked.  I have an email with @outlook.com and none of these get to my inbox.  They go to the spam folder.  I have written rules, I have set the from address to safe senders, nothing works. I had to go back to yahoo to get your emails. 

I also had 3 different support request with microsoft, and they all asked me to ask Mr. Hipps to contact them.  I said, "That man has no time to be dealing with you guys.  You need to talk to your technical folks and tell them that the SQLite site is being blacklisted."  Nothing was done.  So, I am now back to yahoo because of Microsoft blacklisting the sqlite IP.

josé

(4) By TripeHound on 2020-04-15 14:50:26 in reply to 3.1 [link]

I had a similar problem with a week-and-a-bit ago: a regular group email that I send, and had been working for several years, bounced for Outlook-related addresses (@live.co.uk and @hotmail.com), with Outlook saying:

```
550 5.7.1 Unfortunately, messages from [www.xxx.yyy.zzz] weren't sent. Please contact your Internet service provider since part of their network is on our block list (S3150). You can also refer your provider to http://mail.live.com/mail/troubleshooting.aspx#errors. [AM6EUR05FT014.eop-eur05.prod.protection.outlook.com]
```

I had to get my ISP to "de-list [the IP of their mail server] from [Outlook's] blocklist", so I strongly suspect Richard, as the owner/maintainer of the IP-address sending SQLite's emails will have to do the same.

(5) By Richard Hipp (drh) on 2020-04-15 15:06:18 in reply to 3.1 [link]

The bounce message in the sqlite.org server mail log says:

> To request removal from this list please visit https://sender.office.com/ and follow the directions.

I did this.  The page wants an email address for verification and the IP
address to be unblocked.  I entered both.  An email was sent (to drh@sqlite.org)
which went into spam, but I was able to dig it out.  The text said
(literally):

> please confirm your email address by clicking the following link: Confirm your email address

With no hyperlink.  So I had to dig into the email source text to find the
original message:

~~~~
----boundary_1_2e3f11f4-1877-4e8f-aad1-6998e14dc347
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: base64

PGh0bWw+PGhlYWQ+PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0
L2h0bWw7IGNoYXJzZXQ9dXMtYXNjaWkiIC8+PC9oZWFkPjxib2R5PjxpbWcgc3JjPSJjaWQ6SGVh
ZGVySW1hZ2UiIC8+PGJyIC8+PHA+VGhhbmsgeW91IGZvciBzdWJtaXR0aW5nIGEgcmVxdWVzdCB0
byBkZWxpc3QgYW4gSVAgYWRkcmVzcy4gVG8gY29tcGxldGUgdGhlIHByb2Nlc3MsIHBsZWFzZSBj
b25maXJtIHlvdXIgZW1haWwgYWRkcmVzcyBieSBjbGlja2luZyB0aGUgZm9sbG93aW5nIGxpbms6
IDxhIGhyZWY9Imh0dHBzOi8vc2VuZGVyLm9mZmljZS5jb20vRGVsaXN0L0RlbGlzdElQP2VtYWls
PWRyaCU0MHNxbGl0ZS5vcmcmYW1wO2lwPTQ1LjMzLjYuMjIzJmFtcDt0dGw9NjM3MjI1NjExMDg4
MDAzMDg2JmFtcDt0b2tlbj1KbGFNd0JyNnhtT3RjWFRLJTJieDY5V3hXRU95S29yTWZZODFiajg4
ak1ZeTQlM2QiPkNvbmZpcm0geW91ciBlbWFpbCBhZGRyZXNzPC9hPjxiciAvPjwvcD48cD4qKk5P
VEUgLSBQbGVhc2UgZG8gbm90IHJlc3BvbmQgdG8gdGhpcyBlbWFpbC4gSXQncyBzZW50IGZyb20g
YW4gdW5tb25pdG9yZWQgYWRkcmVzcy4qKjwvcD48L2JvZHk+PC9odG1sPg==
----boundary_1_2e3f11f4-1877-4e8f-aad1-6998e14dc347
~~~~

Decoding the base64 yields some HTML:

~~~~
<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /></head><body><img src="cid:HeaderImage" /><br /><p>Thank you for submitting a request to delist an IP address. To complete the process, please confirm your email address by clicking the following link: <a href="https://sender.office.com/Delist/DelistIP?email=drh%40sqlite.org&amp;ip=45.33.6.223&amp;ttl=637225611088003086&amp;token=JlaMwBr6xmOtcXTK%2bx69WxWEOyKorMfY81bj88jMYy4%3d">Confirm your email address</a><br /></p><p>**NOTE - Please do not respond to this email. It's sent from an unmonitored address.**</p></body></html>
~~~~

I put that HTML into a file on disk, then brought up the file in
a web-browser, thus gives me the hyperlink.  I click on
the link.  Then the page tells me:

> The IP address in question is not currently blocked in our system.

(Sigh....)

(6) By Kees Nuyt (knu) on 2020-04-15 22:21:08 in reply to 3.1 [link]

>  I have an email with @outlook.com and none of these get to my inbox. They go to the spam folder.

That would mean sqlite.org is not blocked completely at the IP level, mail is apparently accepted by outlook.com.

>  I have written rules, I have set the from address to safe senders, nothing works.

Also weird. There are two addresses you would havbe to mark as trusted (or put in your address book : 

The sender address ```sqlite-forum@sqlite.org```
and the envelope-from address: ```root@sqlite.org```

I'm glad my mail-provider-for-mailing-lists-and-notifications doesn't cause that kind of trouble.

~~~text
-- 
Regards,
Kees Nuyt
~~~

(7) By jose isaias cabrera (jicman) on 2020-04-15 22:30:43 in reply to 6 [link]

>Also weird. There are two addresses you would havbe to mark as trusted (or put in your address book :
>
>The sender address
>
>sqlite-forum@sqlite.org
>and the envelope-from address:
>root@sqlite.org

These were added, and I even sent 3 different emails content to the last guy I exchanged emails with.  So, there was definitely a problem.  I had rules that he asked me to create, and that didn't work either. Long story, and lots of wasted effort with MS.

josé

(8) By luuk on 2020-04-16 06:10:34 in reply to 5 [link]

https://docs.microsoft.com/en-us/microsoft-365/security/office-365-security/use-the-delist-portal-to-remove-yourself-from-the-office-365-blocked-senders-lis?view=o365-worldwide

it has a link to:

https://sender.office.com/  "Office 365 Anti-Spam IP Delist Portal"

It's a 3-step process (send verification / confirm email address / Delist IP )