Unable to issue email notifications

[ilikemyfto]

I have tried to issue email notifications and used email providers such as gmail, maligun and Virginmedia to no avail. I have set notifications to trigger on: Notify on every speedtest run and Notify on threshold failures.

Attached is a copy of todays logs taken from Portainer and a copy of the Stack. I have also attached a copy of a Python program which I have used to show that the username and password used for the gmail account works.
_speedtest-tracker_logs.txt
_speedtest-tracker-db-1_logs.txt
Stacks>speedtest-tracker.docx
import smtplib.docx

Otherwise the program is a fantastic project, over the weekend it really showed the effects of the storm.

Thanks for any help given.

[alexjustesen]

@ilikemyfto can you share your environment variables you're setting either when starting the container or in your docker-compose.yml file?

[ilikemyfto]

Hi Alex
Thank you for taking a look at this, I have to admit I'm not very savvy using Docker, though I feel pleased to have got thus far. I loaded the project after watching a YouTube video by BD Tech - Internet SpeedTest Tracker on Docker - 2022 Edition. To my delight it worked straight off the cuff. It was installed directly into Portainer using a Stack, I think this is equal to the docker compose, (not sure) but the env was as follows after inserting the Mail commands:-
version: '3.3'
services:
speedtest-tracker:
container_name: speedtest-tracker
ports:
- '8080:80'
- '8443:443'
environment:
- PUID=1000
- PGID=1000
- DB_CONNECTION=mysql
- DB_HOST=db
- DB_PORT=3306
- DB_DATABASE=speedtest_tracker
- DB_USERNAME=speedy
- DB_PASSWORD=password
- MAIL_MAILER=smtp
- MAIL_HOST=smtp.gmail.com
- MAIL PORT=465
- MAIL USERNAME=r***********@virginmedia.com
- MAIL PASSWORD=a****-b****-v****-s****
- MAIL_FROM_NAME="${APP_NAME}"
- APP_DEBUG=true
- TZ=UTC
volumes:
- '/home/pi/speedtest:/config'
image: 'ghcr.io/alexjustesen/speedtest-tracker:latest'
restart: unless-stopped
depends_on:
- db
db:
image: mariadb:10
restart: always
environment:
- MARIADB_DATABASE=speedtest_tracker
- MARIADB_USER=speedy
- MARIADB_PASSWORD=password
- MARIADB_RANDOM_ROOT_PASSWORD=true
volumes:
- speedtest-db:/var/lib/mysql
volumes:
speedtest-db:

I've blotted out my email with *****.

Logs and any other bits I could download from Portainer are in the txt and docx files contained in my previous post.

I am hosting the Speedtest_tracker on a Raspberry pi4 2gb running the Raspberry OS full 64bit Debian Bullseye.

Apart from not being able to issue notifications the SpeedTest-Tracker works really well and I have enjoyed using it. Also I'm rather please to get programs running in Docker. The pi is also running Pi-Hole and a VPN.

Thanks again.

Kind Regards

Roy

[alexjustesen]

So I think it's because your MAIL_HOST value is incorrect, based on this forum post I think it should be MAIL_HOST=smtp.virginmedia.com.

[ilikemyfto]

Hi Alex. Thank you for pointing out my error, I had been trying to see if it would work with gmail and opps! I omitted to change the - "MAIL USERNAME=" statement back to smtp.virginmedia.com.

I have noticed that when I try the "test email channel" I get the "Test mail notification sent" ok but immediately in the log for [speedtest-tracker-db-1] container I see this message:-

(http://192.168.1.96:9000/#!/2/docker/containers/369f542daa7561463e73e05351117a8cc519b37d1ac39c5a097dc096afd773c8)
2023-09-05 14:33:38 29482 [Warning] Aborted connection 29482 to db: 'speedtest_tracker' user: 'speedy' host: '172.19.0.3' (Got an error reading communication packets)

Using a python script with the same from and to email addresses/password works ok.

So I'm stumped. :-(

Kind Regards

Roy

[alexjustesen]

You can probably ignore that warning if emails are making it to your inbox

[ilikemyfto]

But emails don't reach my mailbox,so is the error related?

[ilikemyfto]

I have tried to get the email notifications by using malign as you suggested. The Docker stack is as follows:-

version: '3.3'
services:
    speedtest-tracker:
        container_name: speedtest-tracker
        ports:
            - '8080:80'
            - '8443:443'
        environment:
            - PUID=1000
            - PGID=1000
            - DB_CONNECTION=mysql
            - DB_HOST=db
            - DB_PORT=3306
            - DB_DATABASE=speedtest_tracker
            - DB_USERNAME=speedy
            - DB_PASSWORD=password
            
            - MAIL_DRIVER=smtp
            - MAIL_MAILER=smtp
            - MAIL_HOST=smtp.mailgun.org
            - MAIL PORT=587
            - MAIL USERNAME="postmaster@sandbox********************.mailgun.org"
            - MAIL PASSWORD="8******************************************-081cc153"
            - MAIL_ENCRYPTION=tls
            - MAIL_FROM_NAME="${APP_NAME}"

            - APP_DEBUG=true
            - TZ=UTC
        volumes:
            - '/home/pi/speedtest:/config'
        image: 'ghcr.io/alexjustesen/speedtest-tracker:latest'
        restart: unless-stopped
        depends_on:
            - db
    db:
        image: mariadb:10
        restart: always
        environment:
            - MARIADB_DATABASE=speedtest_tracker
            - MARIADB_USER=speedy
            - MARIADB_PASSWORD=password
            - MARIADB_RANDOM_ROOT_PASSWORD=true
        volumes:
            - speedtest-db:/var/lib/mysql
volumes:
  speedtest-db:

with an email address as per the mailgun authorized recipients.

It still doesn't work.

Do you have any ideas?

Kind Regards

Roy

Edited by @alexjustesen to make the docker-compose.yml file easier to read

[ilikemyfto]

HoHo, I got chucked out of maligun for my previous entry. Opps! However whichever smtp method I use with Speediest_tracker I cannot issue email notifications. that includes virginmedia, gmail and mailgun. I am certain I have used the correct credential because with each SMTP provider I can send a test email using a python script.
So is it just me? or has anyone else got email notifications to word, and if so how did they do it?

[jiriteach]

Can confirm that email notifications work. I use Microsoft 365 for email and relay and no issues with email coming through. Check the logs when you attempt to send a test?

[ilikemyfto]

_speedtest-tracker_logs.txt
_speedtest-tracker-db-1_logs.txt
_MariaDB_logs.txt

Attached are the logs from Containers Speedtest_tracker, Speedtest_tracker-db and MariaDB

Also I confirm that email notifications from Speedtest_tracker does not work on my installation.

Raspberry pi4 2gb loading from 256GB ssd.
Raspbian 64gb OS
Logs are from containers in Portainer.

Thanks

[ilikemyfto]

Still hoping for a suggestion, I've loaded the app with Docker (MariaDB/MySQL), to get the email Notifications running should I have loaded the app another way?

[alexjustesen]

Alright so... couple of things:

1. 587 is the ssl port, if you're using tls use port 465
2. You'll also want to add MAIL_FROM_ADDRESS as an environment variable.

Mailgun config included below to help you along:

MAIL_MAILER: smtp
MAIL_HOST: smtp.mailgun.org
MAIL_PORT: 465
MAIL_USERNAME: "thisuserwasdeleted@mailer.mydomain.com"
MAIL_PASSWORD: "********************************"
MAIL_ENCRYPTION: tls
MAIL_FROM_ADDRESS: "thisuserwasdeleted@mailer.mydomain.com"
MAIL_FROM_NAME: "Speedtest Tracker"