Can't access through Nginx

[Draky50110]

Hello.

Tried to launch koel with docker compose (mysql).
I set a CNAME to reach it.

But can't access at all.

Local IP gives me à 500 error and subdomain can't reach.

Here is my docker compose :

`ervices:
koel:
image: phanan/koel
container_name: koel
networks:
- swag_default
depends_on:
- database
ports:
- 8082:80
environment:
- DB_CONNECTION=mysql
- DB_HOST=database
- DB_USERNAME=koel
- DB_PASSWORD=XXX
- DB_DATABASE=koel
volumes:
- /XXX:/music
- /XXX/covers:/var/www/html/public/img/covers
- XXX:/var/www/html/storage/search-indexes
database:
image: mariadb:10.11
container_name: koel-db
networks:
- swag_default
volumes:
- XXX/db:/var/lib/mysql
environment:
- MYSQL_ROOT_PASSWORD=XXX
- MYSQL_DATABASE=koel
- MYSQL_USER=koel
- MYSQL_PASSWORD=XXX
networks:
swag_default:
external: true
volumes:
db:
driver: local
music:
driver: local
covers:
driver: local
search_index:
driver: local

Koel log :

koel | running docker-php-entrypoint with arguments apache2-foreground
koel | [Mon Jan 27 09:40:58.993221 2025] [so:warn] [pid 7] AH01574: module xsendfile_module is already loaded, skipping
koel | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.9. Set the 'ServerName' directive globally to suppress this message
koel | [Mon Jan 27 09:40:59.016816 2025] [so:warn] [pid 7] AH01574: module xsendfile_module is already loaded, skipping
koel | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.9. Set the 'ServerName' directive globally to suppress this message
koel | [Mon Jan 27 09:40:59.033019 2025] [mpm_prefork:notice] [pid 7] AH00163: Apache/2.4.38 (Debian) PHP/8.1.8 configured -- resuming normal operations
koel | [Mon Jan 27 09:40:59.033053 2025] [core:notice] [pid 7] AH00094: Command line: 'apache2 -D FOREGROUND'
koel | 192.168.1.136 - - [27/Jan/2025:09:41:56 +0000] "GET / HTTP/1.1" 500 2306 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:134.0) Gecko/20100101 Firefox/134.0"
koel | 127.0.0.1 - - [27/Jan/2025:09:45:59 +0000] "GET /sw.js HTTP/1.1" 200 785 "-" "curl/7.64.0"

Koel DB log :

koel-db | 2025-01-27 09:40:58+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.10+mariaubu2204 started.
koel-db | 2025-01-27 09:40:58+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB
koel-db | 2025-01-27 09:40:58+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
koel-db | 2025-01-27 09:40:58+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.10+mariaubu2204 started.
koel-db | 2025-01-27 09:40:59+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
koel-db | 2025-01-27 9:40:59 0 [Note] Starting MariaDB 10.11.10-MariaDB-ubu2204 source revision 3d0fb150289716ca75cd64d62823cf715ee47646 server_uid DH7LCj/iVoJjbF1HC7Nsk7NXsVQ= as process 1
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: Number of transaction pools: 1
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
koel-db | 2025-01-27 9:40:59 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
koel-db | 2025-01-27 9:40:59 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 1
koel-db | 2025-01-27 9:40:59 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: Completed initialization of buffer pool
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: End of log at LSN=46862
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: 128 rollback segments are active.
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: log sequence number 46862; transaction id 14
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
koel-db | 2025-01-27 9:40:59 0 [Note] Plugin 'FEEDBACK' is disabled.
koel-db | 2025-01-27 9:40:59 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
koel-db | 2025-01-27 9:40:59 0 [Note] Server socket created on IP: '0.0.0.0'.
koel-db | 2025-01-27 9:40:59 0 [Note] Server socket created on IP: '::'.
koel-db | 2025-01-27 9:40:59 0 [Note] InnoDB: Buffer pool(s) load completed at 250127 9:40:59
koel-db | 2025-01-27 9:40:59 0 [Note] mariadbd: ready for connections.
koel-db | Version: '10.11.10-MariaDB-ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution

Nginx config :

server {
listen 443 ssl;
listen [::]:443 ssl;

server_name music.*;

include /config/nginx/ssl.conf;

client_max_body_size 0;

# enable for ldap auth (requires ldap-location.conf in the location block)
#include /config/nginx/ldap-server.conf;

# enable for Authelia (requires authelia-location.conf in the location block)
#include /config/nginx/authelia-server.conf;

# enable for Authentik (requires authentik-location.conf in the location block)
#include /config/nginx/authentik-server.conf;

location / {
    # enable the next two lines for http auth
    #auth_basic "Restricted";
    #auth_basic_user_file /config/nginx/.htpasswd;

    # enable for ldap auth (requires ldap-server.conf in the server block)
    #include /config/nginx/ldap-location.conf;

    # enable for Authelia (requires authelia-server.conf in the server block)
    #include /config/nginx/authelia-location.conf;

    # enable for Authentik (requires authentik-server.conf in the server block)
    #include /config/nginx/authentik-location.conf;

    include /config/nginx/proxy.conf;
    include /config/nginx/resolver.conf;
    set $upstream_app koel;
    set $upstream_port 80;
    set $upstream_proto http;
    proxy_pass $upstream_proto://$upstream_app:$upstream_port;

    # REMOVE THIS LINE BEFORE SUBMITTING: Additional proxy settings such as headers go below this line, leave the blank line above.
}

# REMOVE THIS LINE BEFORE SUBMITTING: Some proxies require one or more additional location blocks for things like API or RPC endpoints.
# REMOVE THIS LINE BEFORE SUBMITTING: If the proxy you are making a sample for does not require an additional location block please remove the commented out section below.
# location ~ (/<container_name>)?/api {
#     include /config/nginx/proxy.conf;
#     include /config/nginx/resolver.conf;
#     set $upstream_app <container_name>;
#     set $upstream_port <port_number>;
#     set $upstream_proto <http or https>;
#     proxy_pass $upstream_proto://$upstream_app:$upstream_port;
#
#     # REMOVE THIS LINE BEFORE SUBMITTING: Additional proxy settings such as headers go below this line, leave the blank line above.
# }

}

Any idea ?

[TiredSysOp]

Had the same thing when I set it up and hour ago, it's a bit confusing at first. Add - FORCE_HTTPS=true to the environment section under koel.

[bcurran3]

See my response to #194