Nextcloud and pihole on same raspberry pi

I am trying to setup a rpi which can handle both nextcloud and pihole using nginx but it seems i can’t get it to work,

pi@raspberry:~ $ sudo cat /etc/nginx/sites-available/nextcloud 
upstream php-handler {
   # server 127.0.0.1:9000;
    server unix:/run/php/php8.2-fpm.sock;
}

# Set the `immutable` cache control options only for assets with a cache busting `v` argument
map $arg_v $asset_immutable {
    "" "";
    default ", immutable";
}

server {
    listen 80;
    listen [::]:80;
     server_name ***.ts.net;


    # Prevent nginx HTTP Server Detection
    server_tokens off;
      location /admin {
        proxy_pass http://127.0.0.1:80;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    }
    # Enforce HTTPS just for `/nextcloud`
    location /nextcloud {
        return 301 https://$server_name$request_uri;
    }
}

server {
    listen 443      ssl http2;
    listen [::]:443 ssl http2;
    # With NGinx >= 1.25.1 you should use this instead:
    # listen 443      ssl;
    # listen [::]:443 ssl;
    # http2 on;
     server_name ***.ts.net;

    # Path to the root of the domain
    root /var/www;

    ssl_certificate /etc/ssl/certs/nextcloud-selfsigned.crt;
    ssl_certificate_key /etc/ssl/private/nextcloud-selfsigned.key;


    # Prevent nginx HTTP Server Detection
    server_tokens off;

    # Set .mjs and .wasm MIME types
    # Either include it in the default mime.types list
    # and include that list explicitly or add the file extension
    # only for Nextcloud like below:
    include mime.types;
    types {
        text/javascript mjs;
     
    }

    location = /robots.txt {
        allow all;
        log_not_found off;
        access_log off;
    }

    location ^~ /.well-known {
        # The rules in this block are an adaptation of the rules
        # in the Nextcloud `.htaccess` that concern `/.well-known`.

        location = /.well-known/carddav { return 301 /nextcloud/remote.php/dav/; }
        location = /.well-known/caldav  { return 301 /nextcloud/remote.php/dav/; }

        location /.well-known/acme-challenge    { try_files $uri $uri/ =404; }
        location /.well-known/pki-validation    { try_files $uri $uri/ =404; }

        # Let Nextcloud's API for `/.well-known` URIs handle all other
        # requests by passing them to the front-end controller.
        return 301 /nextcloud/index.php$request_uri;
    }
        location /admin {
        proxy_pass http://127.0.0.1:80;
        proxy_buffer_size 16k;
        proxy_buffers 4 32k;
        proxy_busy_buffers_size 64k;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
    }
    location ^~ /nextcloud {
        # set max upload size and increase upload timeout:
        client_max_body_size 512M;
        client_body_timeout 300s;
        fastcgi_buffers 64 4K;

        # Enable gzip but do not remove ETag headers
        gzip on;
        gzip_vary on;
        gzip_comp_level 4;
        gzip_min_length 256;
        gzip_proxied expired no-cache no-store private no_last_modified no_etag auth;
        gzip_types application/atom+xml text/javascript application/javascript application/json application/ld+json application/manifest+json application/rss+xml application/vnd.geo+json application/vnd.ms-fontobject application/wasm application/x-font-ttf application/x-web-app-manifest+json application/xhtml+xml application/xml font/opentype image/bmp image/svg+xml image/x-icon text/cache-manifest text/css text/plain text/vcard text/vnd.rim.location.xloc text/vtt text/x-component text/x-cross-domain-policy;

        # Pagespeed is not supported by Nextcloud, so if your server is built
        # with the `ngx_pagespeed` module, uncomment this line to disable it.
        #pagespeed off;

        # The settings allows you to optimize the HTTP2 bandwidth.
        # See https://blog.cloudflare.com/delivering-http-2-upload-speed-improvements/
        # for tuning hints
        client_body_buffer_size 512k;

        # HSTS settings
        # WARNING: Only add the preload option once you read about
        # the consequences in https://hstspreload.org/. This option
        # will add the domain to a hardcoded list that is shipped
        # in all major browsers and getting removed from this list
        # could take several months.
        #add_header Strict-Transport-Security "max-age=15768000; includeSubDomains; preload;" always;

        # HTTP response headers borrowed from Nextcloud `.htaccess`
        add_header Referrer-Policy                   "no-referrer"       always;
        add_header X-Content-Type-Options            "nosniff"           always;
        add_header X-Frame-Options                   "SAMEORIGIN"        always;
        add_header X-Permitted-Cross-Domain-Policies "none"              always;
        add_header X-Robots-Tag                      "noindex, nofollow" always;
        add_header X-XSS-Protection                  "1; mode=block"     always;

        # Remove X-Powered-By, which is an information leak
        fastcgi_hide_header X-Powered-By;

        # Specify how to handle directories -- specifying `/nextcloud/index.php$request_uri`
        # here as the fallback means that Nginx always exhibits the desired behaviour
        # when a client requests a path that corresponds to a directory that exists
        # on the server. In particular, if that directory contains an index.php file,
        # that file is correctly served; if it doesn't, then the request is passed to
        # the front-end controller. This consistent behaviour means that we don't need
        # to specify custom rules for certain paths (e.g. images and other assets,
        # `/updater`, `/ocs-provider`), and thus
        # `try_files $uri $uri/ /nextcloud/index.php$request_uri`
        # always provides the desired behaviour.
        index index.php index.html /nextcloud/index.php$request_uri;

        # Rule borrowed from `.htaccess` to handle Microsoft DAV clients
        location = /nextcloud {
            if ( $http_user_agent ~ ^DavClnt ) {
                return 302 /nextcloud/remote.php/webdav/$is_args$args;
            }
        }

        # Rules borrowed from `.htaccess` to hide certain paths from clients
        location ~ ^/nextcloud/(?:build|tests|config|lib|3rdparty|templates|data)(?:$|/)    { return 404; }
        location ~ ^/nextcloud/(?:\.|autotest|occ|issue|indie|db_|console)                  { return 404; }

        # Ensure this block, which passes PHP files to the PHP process, is above the blocks
        # which handle static assets (as seen below). If this block is not declared first,
        # then Nginx will encounter an infinite rewriting loop when it prepends
        # `/nextcloud/index.php` to the URI, resulting in a HTTP 500 error response.
        location ~ \.php(?:$|/) {
            # Required for legacy support
            rewrite ^/nextcloud/(?!index|remote|public|cron|core\/ajax\/update|status|ocs\/v[12]|updater\/.+|ocs-provider\/.+|.+\/richdocumentscode(_arm64)?\/proxy) /nextcloud/index.php$request_uri;

            fastcgi_split_path_info ^(.+?\.php)(/.*)$;
            set $path_info $fastcgi_path_info;

            try_files $fastcgi_script_name =404;

            include fastcgi_params;
            fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
            fastcgi_param PATH_INFO $path_info;
            fastcgi_param HTTPS on;

            fastcgi_param modHeadersAvailable true;         # Avoid sending the security headers twice
            fastcgi_param front_controller_active true;     # Enable pretty urls
            fastcgi_pass php-handler;

            fastcgi_intercept_errors on;
            fastcgi_request_buffering off;

            fastcgi_max_temp_file_size 0;
        }

        # Serve static files
        location ~ \.(?:css|js|mjs|svg|gif|ico|jpg|png|webp|wasm|tflite|map|ogg|flac)$ {
            try_files $uri /nextcloud/index.php$request_uri;
            # HTTP response headers borrowed from Nextcloud `.htaccess`
            add_header Cache-Control                     "public, max-age=15778463$asset_immutable";
            add_header Referrer-Policy                   "no-referrer"       always;
            add_header X-Content-Type-Options            "nosniff"           always;
            add_header X-Frame-Options                   "SAMEORIGIN"        always;
            add_header X-Permitted-Cross-Domain-Policies "none"              always;
            add_header X-Robots-Tag                      "noindex, nofollow" always;
            add_header X-XSS-Protection                  "1; mode=block"     always;
            access_log off;     # Optional: Don't log access to assets
        }

        location ~ \.(otf|woff2?)$ {
            try_files $uri /nextcloud/index.php$request_uri;
            expires 7d;         # Cache-Control policy borrowed from `.htaccess`
            access_log off;     # Optional: Don't log access to assets
        }

        # Rule borrowed from `.htaccess`
        location /nextcloud/remote {
            return 301 /nextcloud/remote.php$request_uri;
        }

        location /nextcloud {
            try_files $uri $uri/ /nextcloud/index.php$request_uri;
        }
    }
}

here is config.php

<?php
$CONFIG = array (
  'instanceid' => 'oc5c39ph4rqe',
  'passwordsalt' => 'VZq4yLJIdkBvcbNFl7yNEtdUm/kny6',
  'secret' => 'yZzcUH/EDrYUOUfkbCmRUufKsVacn9xsml3VqatiEDwux0TA',
  'trusted_domains' => 
  array (
    0 => '100.73.164.18',
    1 => 'raspberry.tail68744e.ts.net',
    2 => '192.168.2.17',
    3 => '127.0.0.1',
  ),
  'overwriteprotocol' => 'https',
  'overwritewebroot' => '/nextcloud',
  'overwritehost' => 'raspberry.tail68744e.ts.net',
  'overwrite.cli.url' => 'https://raspberry.tail68744e.ts.net/nextcloud',
  'trusted_proxies' => 
  array (
    0 => '100.73.0.0/10',
  ),
  'remote_ip_header' => 'HTTP_X_REAL_IP',
  'datadirectory' => '/var/www/nextcloud/data',
  'dbtype' => 'mysql',
  'version' => '30.0.6.2',
  'overwritecondaddr' => '',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => 'raspberry',
  'installed' => true,
  'maintenance' => false,
  'force_https' => true,
  'check_for_working_webdav' => false,
  'check_for_working_htaccess' => false,
  'forwarded_for_headers' => 
  array (
    0 => 'HTTP_X_FORWARDED_FOR',
    1 => 'HTTP_X_REAL_IP',
  ),
  'bruteforce.protection.enabled' => false,
  'maintenance_window_start' => '03:00',
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' => 
  array (
    'host' => 'localhost',
    'port' => 6379,
    'timeout' => 0.0,
  ),
  'memories.db.triggers.fcu' => true,
  'memories.exiftool' => '/var/www/nextcloud/apps/memories/bin-ext/exiftool-aarch64-glibc',
  'memories.vod.path' => '/var/www/nextcloud/apps/memories/bin-ext/go-vod-aarch64',
  'memories.exiftool_no_local' => true,
  'enabledPreviewProviders' => 
  array (
    0 => 'OC\\Preview\\Image',
    1 => 'OC\\Preview\\HEIC',
    2 => 'OC\\Preview\\TIFF',
    3 => 'OC\\Preview\\Movie',
  ),
  'memories.ffmpeg_path' => '/usr/bin/ffmpeg',
  'memories.ffprobe_path' => '/usr/bin/ffprobe',
  'memories.vod.disable' => false,
  'memories.vod.ffmpeg' => '/usr/bin/ffmpeg',
  'memories.vod.ffprobe' => '/usr/bin/ffprobe',
  'memories.gis_type' => 1,
  'system' => 
  array (
    'filelocking.enabled' => true,
    'maxBigFileUpload' => 10737418240,
  ),
);

my problem is i can’t get them to work, it is either working nextcloud and borken pihole or working pihole and broken nextcloud, or both just does not work, is this even possible? my stack is nginx and mariadb for nextcloud

pi@raspberry:~ $ sudo tail -f /var/log/nginx/error.log
2025/03/29 15:56:05 [error] 969#969: *2 open() "/usr/share/nginx/html/api/dns/blocking" failed (2: No such file or directory), client: 192.168.2.14, server: raspberry.tail68744e.ts.net, request: "GET /api/dns/blocking HTTP/1.1", host: "192.168.2.17", referrer: "http://192.168.2.17/admin/groups/lists"
2025/03/29 15:56:35 [error] 969#969: *2 open() "/usr/share/nginx/html/api/dns/blocking" failed (2: No such file or directory), client: 192.168.2.14, server: raspberry.tail68744e.ts.net, request: "GET /api/dns/blocking HTTP/1.1", host: "192.168.2.17", referrer: "http://192.168.2.17/admin/groups/lists"
2025/03/29 15:56:51 [error] 969#969: *2 open() "/usr/share/nginx/html/api/info/messages/count" failed (2: No such file or directory), client: 192.168.2.14, server: raspberry.tail68744e.ts.net, request: "GET /api/info/messages/count HTTP/1.1", host: "192.168.2.17", referrer: "http://192.168.2.17/admin/groups/lists"
2025/03/29 15:57:05 [error] 969#969: *2 open() "/usr/share/nginx/html/api/dns/blocking" failed (2: No such file or directory), client: 192.168.2.14, server: raspberry.tail68744e.ts.net, request: "GET /api/dns/blocking HTTP/1.1", host: "192.168.2.17", referrer: "http://192.168.2.17/admin/groups/lists"
2025/03/29 15:57:35 [error] 969#969: *2 open() "/usr/share/nginx/html/api/dns/blocking" failed (2: No such file or directory), client: 192.168.2.14, server: raspberry.tail68744e.ts.net, request: "GET /api/dns/blocking HTTP/1.1", host: "192.168.2.17", referrer: "http://192.168.2.17/admin/groups/lists"
2025/03/29 15:57:51 [error] 969#969: *2 open() "/usr/share/nginx/html/api/info/messages/count" failed (2: No such file or directory), client: 192.168.2.14, server: raspberry.tail68744e.ts.net, request: "GET /api/info/messages/count HTTP/1.1", host: "192.168.2.17", referrer: "http://192.168.2.17/admin/groups/lists"
2025/03/29 15:58:05 [error] 969#969: *2 open() "/usr/share/nginx/html/api/dns/blocking" failed (2: No such file or directory), client: 192.168.2.14, server: raspberry.tail68744e.ts.net, request: "GET /api/dns/blocking HTTP/1.1", host: "192.168.2.17", referrer: "http://192.168.2.17/admin/groups/lists"
2025/03/29 15:58:35 [error] 969#969: *2 open() "/usr/share/nginx/html/api/dns/blocking" failed (2: No such file or directory), client: 192.168.2.14, server: raspberry.tail68744e.ts.net, request: "GET /api/dns/blocking HTTP/1.1", host: "192.168.2.17", referrer: "http://192.168.2.17/admin/groups/lists"
2025/03/29 15:58:51 [error] 969#969: *2 open() "/usr/share/nginx/html/api/info/messages/count" failed (2: No such file or directory), client: 192.168.2.14, server: raspberry.tail68744e.ts.net, request: "GET /api/info/messages/count HTTP/1.1", host: "192.168.2.17", referrer: "http://192.168.2.17/admin/groups/lists"
2025/03/29 15:59:05 [error] 969#969: *2 open() "/usr/share/nginx/html/api/dns/blocking" failed (2: No such file or directory), client: 192.168.2.14, server: raspberry.tail68744e.ts.net, request: "GET /api/dns/blocking HTTP/1.1", host: "192.168.2.17", referrer: "http://192.168.2.17/admin/groups/lists"

you have separated locations /admin and /nextcloud in your nginx config. The error you get is for this path:

/api/dns/blocking

but you have nothing set for /api.

Normally, you should not be short of subdomains, and I’d use one for Nextcloud (nextcloud.example.com), one for the admin-tool (admin.example.com) and then have two separate vhosts in nginx.

For nginx-config this is easier, if you want to move the setup one day it is easier, …

I need to use Tailscale to have external access to my device since my IP-provided modem will not allow me to open a port, and Tailscale only gives devices 1 domain.