use with nginx in docker-compose

[alvinlys]

Hi, i been research around the issues & discussions but it seems all the solutions shared so far is not workable for my use cases. Currently im stuck with the following, and getting not found from nginx:

docker-compose.yml

version: "3"

services:
  adminer:
    image: adminer:fastcgi
    container_name: adminer
    restart: always
    ports:
      - "9000:9000"

nginx.conf

server {
    listen 80;

    server_name adminer.test.com; #link to subdomain

    location ~ ^/adminer(/.*$|$) {
        set $upstream_adminer adminer;
        fastcgi_index index.php;
        include /etc/nginx/fastcgi_params;
        fastcgi_param SCRIPT_FILENAME /var/www/html/index.php; # this is the important part
        fastcgi_pass adminer:9000; # host and port goes here
    }
}

adminer.test.com shows me this