The page could not be found on the server or you may not be allowed to view it

[pj0_08]

I have installed nextcloud docker aio version. I have disabled domain authentication and nginx is proxying forwarded requests from other nginx servers to :11000. However, after completing all the setup, I got the initial admin username and password from the AIO settings tab (I set it to port 8443) and when I try to connect, I get a 404 response code with the error 'The page could not be found on the server or you may not be allowed to view it.

server {
listen 444 ssl proxy_protocol;
client_max_body_size 0;
server_name ;

    ssl_certificate <cert>;
    ssl_certificate_key <key>;
    include /etc/nginx/conf.d/realip_prv.conf;
    location / {
            proxy_set_header Upgrade $http_upgrade;
            #proxy_set_header X-Real-IP $remote_addr;
            #proxy_set_header X-Forwarded-For $remote_addr;
            proxy_set_header Connection "upgrade";
            proxy_set_header Host $host;
            proxy_set_header X-Forwarded-For $remote_addr;
            proxy_set_header X-Forwarded-Port $server_port;
            proxy_set_header X-Forwarded-Scheme $scheme;
            proxy_set_header X-Forwarded-Proto $scheme;
            proxy_set_header X-Real-IP $remote_addr;
            proxy_set_header Accept-Encoding "";
            proxy_http_version 1.1;

#proxy_ssl_verify off;
proxy_pass http://127.0.0.1:11000$request_uri/;
}
}

[szaimen]

Hi, can you compare the config with all-in-one/reverse-proxy.md at main · nextcloud/all-in-one · GitHub?

[pj0_08]

I just discovered the ‘/var/www/data/nextcloud.log’ file of the aio-nextcloud container and it shows the following error

{“reqId”:“cVeOHqJZ7kyWTJqRi6ZF”,“level”:3,“time”:“2024-09-21T19:31:57+00:00”,“remoteAddr”:“”,“user”:“admin”,“app”:“PHP”,“method”:“”,“url”:“–”,“message”:“fopen(/var/www/html/config/config.php): Failed to open stream: No such file or directory at /var/www/html/lib/private/Config.php#221”,“userAgent”:“–”,“version”:“29.0.6.1”,“data”:{“app”:“PHP”}} {“reqId”:“F5caoirnBnnvETspdJ78”,“level”:3,“time”:“2024-09-21T19:34:43+00:00”,“remoteAddr”:“”,“user”:“–”,“app”:“core”,“method”:“”,“url”:“–”,“message”:“Error while running background job OCA\DAV\BackgroundJob\EventReminderJob (id: 19, arguments: null)”,“userAgent”:“–”,“version”:“30.0.0.14”,“exception”:{“Exception”:“Doctrine\DBAL\Exception\DriverException”,“Message”:“An exception occurred while executing a query: SQLSTATE[42803]: Grouping error: 7 ERROR: column “cr.id” must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT “cr”., “co”.“calendardata”, “c”.“displayname”, “c”.“…\n ^”,“Code”:7,“Trace”:[{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1943,“function”:“convert”,“class”:“Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter”,“type”:“->”,“args”:[[“Doctrine\DBAL\Driver\PDO\Exception”],[“Doctrine\DBAL\Query”]]},{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1885,“function”:“handleDriverException”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”,“args”:[[“Doctrine\DBAL\Driver\PDO\Exception”],[“Doctrine\DBAL\Query”]]},{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1106,“function”:“convertExceptionDuringQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”,“args”:[[“Doctrine\DBAL\Driver\PDO\Exception”],"SELECT “cr”. , “co”.“calendardata”, “c”.“displayname”, “c”.“principaluri”, “cr”.“notification_date”, “cr”.“event_hash”, “cr”.“type” FROM “oc_calendar_reminders” “cr” INNER JOIN “oc_calendarobjects” “co” ON “cr”.“object_id” = “co”.“id” INNER JOIN “oc_calendars” “c” ON “cr”.“calendar_id” = “c”.“id” WHERE “cr”.“notification_date” <= ? GROUP BY “cr”.“event_hash”, “cr”.“notification_date”, “cr”.“type””,[1726947283],[2]]},{“file”:“/var/www/html/lib/private/DB/Connection.php”,“line”:415,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”,“args”:["SELECT “cr”., “co”.“calendardata”, “c”.“displayname”, “c”.“principaluri”, “cr”.“notification_date”, “cr”.“event_hash”, “cr”.“type” FROM “oc_calendar_reminders” “cr” INNER JOIN “oc_calendarobjects” “co” ON “cr”.“object_id” = “co”.“id” INNER JOIN “oc_calendars” “c” ON “cr”.“calendar_id” = “c”.“id” WHERE “cr”.“notification_date” <= ? GROUP BY “cr”.“event_hash”, “cr”.“notification_date”, “cr”.“type”“,[1726947283],[2],null]},{“file”:”/var/www/html/lib/private/DB/ConnectionAdapter.php",“line”:50,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:“->”,“args”:["SELECT “cr”. , “co”.“calendardata”, “c”.“displayname”, “c”.“principaluri”, “cr”.“notification_date”, “cr”.“event_hash”, “cr”.“type” FROM “oc_calendar_reminders” “cr” INNER
…(Omitted)

[pj0_08]

Attempting to connect with ‘/’ results in a 302 redirect to ‘/login’ followed by a 404 error.

[pj0_08]

It’s pretty much the same, I used the following docker command.

sudo docker run
–init
–sig-proxy=false
–name nextcloud-aio-mastercontainer
–restart always
–publish 8443:8080
-e APACHE_PORT=11000
-e APACHE_IP_BINDING=0.0.0.0
–volume nextcloud_aio_mastercontainer:/mnt/docker-aio-config
–volume /var/run/docker.sock:/var/run/docker.sock:ro
nextcloud/all-in-one:latest

NGINX runs outside of Docker, and is a proxy connection from the NGINX server with requests forwarded from external servers. (proxy_pass http://127.0.0.1:11000)

(external nginx) > (server nginx (outside docker)) > :11000 (aio docker)