Nginx tutorial foult

[MrYDeath]

Hi

I dont know what im doing wrong but i cant login , plz help! I`m on Ubuntu server , portainer , and try to start nginx

[S0litaire]

having same issue with this tutorial.

Docker logs git-app-1 :
`❯ Configuring npm user ...
❯ Configuring npm group ...
❯ Checking paths ...
❯ Setting ownership ...
❯ Dynamic resolvers ...
❯ IPv6 ...
Enabling IPV6 in hosts in: /etc/nginx/conf.d

• /etc/nginx/conf.d/default.conf
• /etc/nginx/conf.d/production.conf
• /etc/nginx/conf.d/include/ssl-ciphers.conf
• /etc/nginx/conf.d/include/block-exploits.conf
• /etc/nginx/conf.d/include/force-ssl.conf
• /etc/nginx/conf.d/include/assets.conf
• /etc/nginx/conf.d/include/letsencrypt-acme-challenge.conf
• /etc/nginx/conf.d/include/proxy.conf
• /etc/nginx/conf.d/include/ip_ranges.conf
• /etc/nginx/conf.d/include/resolvers.conf
  Enabling IPV6 in hosts in: /data/nginx
  ❯ Docker secrets ...

---

---

| \ | | _ | / |
| | | |) | |/| |
| |\ | __/| | | |
|| _|| || |_|

User: npm PUID:0 ID:0 GROUP:0
Group: npm PGID:0 ID:0

❯ Starting nginx ...
❯ Starting backend ...
[12/4/2023] [11:38:41 AM] [Global ] › ℹ info Using MySQL configuration
[12/4/2023] [11:38:42 AM] [Global ] › ✖ error ER_HOST_NOT_PRIVILEGED: Host '172.19.0.3' is not allowed to connect to this MariaDB server
[12/4/2023] [11:38:43 AM] [Global ] › ✖ error ER_HOST_NOT_PRIVILEGED: Host '172.19.0.3' is not allowed to connect to this MariaDB server

<< error repeats>>
docker logs git-bd-1:[i] pre-init.d - processing /scripts/pre-init.d/01_secret-init.sh
[i] mysqld not found, creating....
[i] MySQL data directory not found, creating initial DBs
ERROR: 29 File './mysql/' not found (Errcode: 13 "Permission denied")
2023-12-04 11:31:30 0 [ERROR] Aborting
[i] Creating database: npm
[i] with character set: 'utf8' and collation: 'utf8_general_ci'
[i] Creating user: npm with password npm
2023-12-04 11:31:30 0 [Note] Starting MariaDB 10.11.5-MariaDB source revision 7875294b6b74b53dd3aaa723e6cc103d2bb47b2c as process 52
2023-12-04 11:31:30 0 [ERROR] mysqld: Can't create/write to file './ddl_recovery.log' (Errcode: 13 "Permission denied")
2023-12-04 11:31:30 0 [ERROR] DDL_LOG: Failed to create ddl log file: ./ddl_recovery.log
2023-12-04 11:31:30 0 [ERROR] Aborting

MySQL init process done. Ready for start up.

exec /usr/bin/mysqld --user=mysql --console --skip-name-resolve --skip-networking=0
2023-12-04 11:31:30 0 [Note] Starting MariaDB 10.11.5-MariaDB source revision 7875294b6b74b53dd3aaa723e6cc103d2bb47b2c as process 1
2023-12-04 11:31:31 0 [ERROR] mysqld: Can't create/write to file './ddl_recovery.log' (Errcode: 13 "Permission denied")
2023-12-04 11:31:31 0 [ERROR] DDL_LOG: Failed to create ddl log file: ./ddl_recovery.log
2023-12-04 11:31:31 0 [ERROR] Aborting
[i] pre-init.d - processing /scripts/pre-init.d/01_secret-init.sh
[i] mysqld already present, skipping creation
[i] MySQL directory already present, skipping creation
2023-12-04 11:38:38 0 [Note] Starting MariaDB 10.11.5-MariaDB source revision 7875294b6b74b53dd3aaa723e6cc103d2bb47b2c as process 1
2023-12-04 11:38:38 0 [Note] Plugin 'InnoDB' is disabled.
2023-12-04 11:38:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-12-04 11:38:38 0 [ERROR] Could not open mysql.plugin table: "Can't find file: './mysql/plugin.MAI' (errno: 2 "No such file or directory")". Some plugins may be not loaded
2023-12-04 11:38:38 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2023-12-04 11:38:38 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-12-04 11:38:38 0 [Note] Server socket created on IP: '::'.
2023-12-04 11:38:38 0 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
2023-12-04 11:38:38 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2023-12-04 11:38:38 0 [ERROR] Cannot open mysql.event
2023-12-04 11:38:38 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2023-12-04 11:38:38 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2023-12-04 11:38:38 0 [Note] /usr/bin/mysqld: ready for connections.
Version: '10.11.5-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 Alpine Linux
2023-12-04 11:38:42 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.3' (This connection closed normally without authentication)
2023-12-04 11:38:43 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.3' (This connection closed normally without authentication)
`

Solution:

change:
volumes:
- ./data/mysql:/var/lib/mysql
to
volumes:
- ./mysql:/var/lib/mysql

[VoiceLessQ]

this may help:
https://github.com/VoiceLessQ/Docker-nginx-proxy-manager-Fix-Bad-Gateway

[MotoMisch]

Had the same issue. I took another docker-compose-yaml file and then it worked.

version: '3'
services:
app:
image: 'jc21/nginx-proxy-manager:latest'
ports:
- '80:80'
- '81:81'
- '443:443'
environment:
DB_MYSQL_HOST: "db"
DB_MYSQL_PORT: 3306
DB_MYSQL_USER: "123456"
DB_MYSQL_PASSWORD: "aaaaaaa"
DB_MYSQL_NAME: "zzzzzz"
volumes:
- ./data:/data
- ./letsencrypt:/etc/letsencrypt
db:
image: 'jc21/mariadb-aria:latest'
environment:
MYSQL_ROOT_PASSWORD: 'kkkkkkkkkkkkkkkkkkkk'
MYSQL_DATABASE: 'zzzzzz'
MYSQL_USER: '123456'
MYSQL_PASSWORD: 'aaaaaaa'
volumes:
- ./data/mysql:/var/lib/mysql

[xhacks37]

I just put mine into privileged mode on both of the services and it works now