Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
docker_notes:docker-nextcloud [2024-04-27 Sat wk17 12:48] – [Nextcloud Container] baumkpdocker_notes:docker-nextcloud [2025-04-11 Fri wk15 06:23] (current) – [Incorrect row format found in your database] baumkp
Line 11: Line 11:
  
 =====Nextcloud with supervisord===== =====Nextcloud with supervisord=====
-The base [[https://hub.docker.com/_/nextcloud|Nextcloud]] image does not support cron.  So it needs to be added, for the nextcloud-fpm.alpine version see [[https://github.com/nextcloud/docker/tree/master/.examples/dockerfiles/cron/fpm-alpine|github nextcloud docker fpm-apline cron dockerfile examples]]+The base [[https://hub.docker.com/_/nextcloud|Nextcloud]] image does not directly support cron.  So it needs to be added, for the nextcloud-fpm.alpine version see [[https://github.com/nextcloud/docker/tree/master/.examples/dockerfiles/cron/fpm-alpine|github nextcloud docker fpm-apline cron dockerfile examples]] 
 + 
 +++tl;dr;|Today (2024-04-27) after upgrading to Nextcloud 29 I finally got rid of all my administration security and setup page warnings and errors. This included some issues with nginx configuration that magically went away with version 29 and adding imagemagick-svg to the image as just noted. As well as cleaning up [[https://wiki.kptree.net/doku.php?id=docker_notes:docker-nextcloud#file_integrity_check|file integrity error messages]].  This is the first time since moving to Nextcloud on Docker and quite some time before that.++ 
 + 
 +As docker adminstartion warns about missing php imagemagick-svg support I also added the Apline package to the updated image to rectify this warning.   
 + 
 +++++ Dockerfile| 
 +<code yaml>#FROM nextcloud:stable-fpm-alpine 
 +FROM nextcloud:fpm-alpine 
 +# See https://hub.docker.com/_/nextcloud/  
 +#   stable-fpm-alpine or production-fpm-alpine give the  
 +#   latest stable / production version versus fpm-alpine 
 +#   that give the latest release 
 + 
 +RUN apk add --no-cache imagemagick-svg supervisor \ 
 +  && mkdir /var/log/supervisord /var/run/supervisord 
 + 
 +COPY supervisord.conf / 
 + 
 +ENV NEXTCLOUD_UPDATE=1 
 + 
 +CMD ["/usr/bin/supervisord", "-c", "/supervisord.conf"]</code> 
 +++++ 
 + 
 +++++supervisord.conf| 
 +<code yaml>[supervisord] 
 +nodaemon=true 
 +logfile=/var/log/supervisord/supervisord.log 
 +pidfile=/var/run/supervisord/supervisord.pid 
 +childlogdir=/var/log/supervisord/ 
 +logfile_maxbytes=50MB                           ; maximum size of logfile before rotation 
 +logfile_backups=10                              ; number of backed up logfiles 
 +loglevel=error 
 + 
 +[program:php-fpm] 
 +stdout_logfile=/dev/stdout 
 +stdout_logfile_maxbytes=0 
 +stderr_logfile=/dev/stderr 
 +stderr_logfile_maxbytes=0 
 +command=php-fpm 
 + 
 +[program:cron] 
 +stdout_logfile=/dev/stdout 
 +stdout_logfile_maxbytes=0 
 +stderr_logfile=/dev/stderr 
 +stderr_logfile_maxbytes=0 
 +command=/cron.sh</code> 
 +++++ 
 +++++docker-compose.yml| 
 +<code yaml>--- 
 +services: 
 +  app: 
 +    build: ./ 
 +    image: nextcloud-fpm-cron:latest 
 +#    image: nextcloud:fpm-alpine 
 +    restart: always 
 +    depends_on: 
 +      - db 
 +      - redis 
 +    volumes: 
 +      - /mnt/docker_store/nextcloud/data/html/data:/var/www/html/data 
 +      - /mnt/docker_store/nextcloud/data/html/custom_apps:/var/www/html/custom_apps 
 +      - /mnt/docker_store/nextcloud/data/html/config:/var/www/html/config 
 +      - /mnt/docker_store/nextcloud/data/html/themes:/var/www/html/themes 
 +    networks: 
 +      - proxy 
 +    environment: 
 +      - MYSQL_PASSWORD=kpb1670 
 +      - MYSQL_DATABASE=nextcloud 
 +      - MYSQL_USER=nextcloud 
 +      - MYSQL_HOST=db 
 +      - REDIS_HOST=redis 
 + 
 +  db: 
 +    image: mariadb:11.3 
 +    restart: always 
 +    command: --transaction-isolation=READ-COMMITTED --log-bin=binlog --binlog-format=ROW 
 +    volumes: 
 +      - /mnt/docker_store/nextcloud/data/db:/var/lib/mysql 
 +    environment: 
 +      - MYSQL_ROOT_PASSWORD=kpb8487 
 +      - MYSQL_PASSWORD=kpb1670 
 +      - MYSQL_DATABASE=nextcloud 
 +      - MYSQL_USER=nextcloud 
 +      - MARIADB_AUTO_UPGRADE=1 
 +    networks: 
 +      - proxy 
 + 
 +  redis: 
 +    image: redis:alpine 
 +    restart: always 
 +    networks:  
 +      - proxy 
 + 
 +  web: 
 +    image: nginx 
 +    restart: always 
 +    ports: 
 +      - 8180:80 
 +    depends_on: 
 +      - app 
 +    volumes: 
 +      - ./nginx.conf:/etc/nginx/nginx.conf:ro 
 +    volumes_from: 
 +      - app 
 +    networks: 
 +      - proxy 
 +  
 +volumes: 
 +  nextcloud: 
 +  db: 
 + 
 +networks: 
 +  proxy: 
 +    external: true 
 +</code> 
 +++++
 ====RedirectRegex==== ====RedirectRegex====
 I get a redirect error in Nextcloud that I have not been able to track down to date.  Does not seem much info in this on the net, and the little there is also indicates a problem without and easy solution.  Nextcloud main support looks Apache web server based with little Nginx support and even less Traefik support. I get a redirect error in Nextcloud that I have not been able to track down to date.  Does not seem much info in this on the net, and the little there is also indicates a problem without and easy solution.  Nextcloud main support looks Apache web server based with little Nginx support and even less Traefik support.
Line 38: Line 154:
 ====Installing and Using MariaDB via Docker==== ====Installing and Using MariaDB via Docker====
 [[https://mariadb.com/kb/en/installing-and-using-mariadb-via-docker/|Installing and Using MariaDB via Docker]] [[https://mariadb.com/kb/en/installing-and-using-mariadb-via-docker/|Installing and Using MariaDB via Docker]]
-[[start]]+ 
 +====Incorrect row format found in your database==== 
 +First step is to backup database. 
 +  *[[https://help.nextcloud.com/t/upgrade-to-nextcloud-hub-10-31-0-0-incorrect-row-format-found-in-your-database/218366/8|Nextcloud Incorrect row format found in your database]] 
 +  *[[https://techoverflow.net/2025/03/12/how-to-convert-nextcloud-mariadb-mysql-tables-to-row-format-dynamic/|How to convert Nextcloud MariaDB/MySQL tables to ROW_FORMAT=Dynamic]]
  
 ====logging==== ====logging====
Line 443: Line 563:
   *[[https://docs.nextcloud.com/server/latest/admin_manual/office/configuration.html#wopi-settings|Nextcloud Office App Settings]]   *[[https://docs.nextcloud.com/server/latest/admin_manual/office/configuration.html#wopi-settings|Nextcloud Office App Settings]]
  
 +=====Whiteboard App=====
 +The official whiteboard app for Nextcloud. It allows users to create and share whiteboards with other users and collaborate in real-time.
 +  *[[https://github.com/nextcloud/whiteboard|Nextcloud Whiteboard]]
 =====Other Possible Apps/Images===== =====Other Possible Apps/Images=====
   *[[https://crazymax.dev/diun/|Diun]] is a tool to notify if docker images have been updated. (Reportedly better than automatic updates such as watchtower.)   *[[https://crazymax.dev/diun/|Diun]] is a tool to notify if docker images have been updated. (Reportedly better than automatic updates such as watchtower.)