Aborted connection to db 'unconnected' user 'unauthenticated'

[jords94]

Hi all,

I am trying to deploy nginx proxy manager via Portainer docker contains on my Pi 4.

System and OS info

Raspberry Pi 4 running Raspbian 10

Docker Version

Client: Docker Engine - Community

Version: 20.10.14

API version: 1.41

Go version: go1.16.15

Git commit: a224086

Built: Thu Mar 24 01:48:21 2022

OS/Arch: linux/arm

Context: default

Experimental: true

Server: Docker Engine - Community

Engine:

Version: 20.10.14

API version: 1.41 (minimum version 1.12)

Go version: go1.16.15

Git commit: 87a90dc

Built: Thu Mar 24 01:46:07 2022

OS/Arch: linux/arm

Experimental: false

containerd:

Version: 1.5.11

GitCommit: 3df54a852345ae127d1fa3092b95168e4a88e2f8

runc:

Version: 1.0.3

GitCommit: v1.0.3-0-gf46b6ba

docker-init:

Version: 0.19.0

GitCommit: de40ad0

Here's my docker compose yml file:

version: '3'

services:

app:

image: 'jc21/nginx-proxy-manager:latest'

restart: unless-stopped

ports:

- '80:80'

- '81:81'

- '443:443'

environment:

DB_MYSQL_HOST: "db"

DB_MYSQL_PORT: 3306

DB_MYSQL_USER: “npm”

DB_MYSQL_PASSWORD: “npm"

DB_MYSQL_NAME: "npm"

volumes:

- ./data:/data

- ./letsencrypt:/etc/letsencrypt

db:

image: 'yobasystems/alpine-mariadb:10.4.17'

restart: unless-stopped

environment:

MYSQL_ROOT_PASSWORD: ‘npm'

MYSQL_DATABASE: 'npm'

MYSQL_USER: ‘npm'

MYSQL_PASSWORD: ‘npm'

volumes:

- ./data/mysql:/var/lib/mysql



config.json file:

{

"database": {

"engine": "mysql",

"host": "db",

"name": "npm",

"user": “npm”,

"password": "npm",

"port": 3306

}

}

With deploying the above I am getting 502 gateway errors when trying to log into npm for the first time. I'm getting the following repetitive logs:

nginx_db_1 logs:

2022-04-24 11:45:09 418 [Warning] Aborted connection 418 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.2' (This connection closed normally without authentication)
nginx_app_1 logs:
[4/24/2022] [11:45:31 AM] [Global ] › ✖ error Packets out of order. Got: 1 Expected: 0
I've switched between yobasystems and jc21 for the db server but still are struggling with authentication issues with db login. Does anyone have any suggestions as to how to fix this?

Thanks