friendica (DFRN) - Link to source

OpenWeatherMap currently blocked due to spam
I currently get these lines in my logfile:
Feb 23 05:08:54 zulu289 postfix/smtp[18946]: 39F0028004A: to=<crm@openweathermap.org>, relay=aspmx.l.google.com[142.250.13.27]:25, delay=1, delays=0.08/0.02/0.76/0.16, dsn=2.1.5, status=deliverable (250 2.1.5 OK k14-20020a5d428e000000b002c54d2fc48csi12193711wrq.1041 - gsmtp)
Feb 23 05:08:59 zulu289 postfix/smtpd[12523]: NOQUEUE: reject: RCPT from mail-ed1-f47.google.com[209.85.208.47]: 554 5.7.1 Service unavailable; Client host [209.85.208.47] blocked using dnsbl.sorbs.net; Currently Sending Spam See: http://www.sorbs.net/lookup.shtml?209.85.208.47; from=<crm@openweathermap.org> to=<roland@mxchange.org> proto=ESMTP helo=<mail-ed1-f47.google.com>
Feb 23 05:16:14 zulu289 postfix/smtpd[19566]: NOQUEUE: reject: RCPT from mail-wr1-f53.google.com[209.85.221.53]: 554 5.7.1 Service unavailable; Client host [209.85.221.53] blocked using dnsbl.sorbs.net; Currently Sending Spam See: http://www.sorbs.net/lookup.shtml?209.85.221.53; from=<crm@openweathermap.org> to=<roland@mxchange.org> proto=ESMTP helo=<mail-wr1-f53.google.com>
Feb 23 05:32:02 zulu289 postfix/smtpd[20057]: NOQUEUE: reject: RCPT from mail-wm1-f49.google.com[209.85.128.49]: 554 5.7.1 Service unavailable; Client host [209.85.128.49] blocked using dnsbl.sorbs.net; Currently Sending Spam See: http://www.sorbs.net/lookup.shtml?209.85.128.49; from=<crm@openweathermap.org> to=<roland@mxchange.org> proto=ESMTP helo=<mail-wm1-f49.google.com>

So in case you wonder why you are not getting any mails from #OpenWeatherMap, that is the reason. What I did here was, that I added crm@openweathermap.org to a whitelist:
crm@openweathermap.org OK
And the list is registered in /etc/postfix/main.cf:
check_sender_access hash:/etc/postfix/maps/sender_ok
Just to share this with you!
#openweathermap

friendica (DFRN) - Link to source

Upgrade of invidious (PostgreSQL) database from 11 to 13 was easy!

I just wanted to share with you how I upgraded my #PostreSQL 11 database (mainly it stores my #Invidious instance) to 13 on my #Devuan box (everything needs to be done as root!).


  1. Stop both clusters, very easy: /etc/init.d/postgresql stop
  2. Backup old 13 directory (empty database in my case) just in case: cd /var/lib/postgresql/ && mv 13 13.previous
  3. Same goes for configuration files: cd /etc/postgresql/ && mv 13 13.previous
  4. Now just run the upgrade command: pg_upgradecluster 11 main
  5. It will take some time, but that's normal here. Your 13 cluster is already running after this step and 11 is offline.
  6. So it is time to backup all and remove 13.previous directories as the upgrade was a success. You can do this by renaming 11 to 11.backup or tar czvf 11.tar.gz /etc/postgresql/11/ /var/lib/postgresql/11/ it away.

Now only one cluster (13) is running here:
PostgreSQL version: 13.8 (Debian 13.8-0+deb11u1) through PHP extension PgSQL

#Devuan #invidious #PostreSQL
⇧