Issue with "Easybackup" Plugin in Kimai Docker Environment

[tamenmd]

I've been using the Kimai Docker integration, maintained by Toby, for my time tracking needs for quite some time now. However, I recently encountered an issue with the 'Easybackup' plugin that I would really love to get fixed.

Describe the bug
When attempting to use the "Easybackup" plugin within the Kimai Docker environment, I consistently encounter the following error message: In addition to the error message, you can find the corresponding log here:

[2023-09-10 13:25:46] INFO: --- S T A R T   C R E A T I N G   B A C K U P ---
[2023-09-10 13:25:46] INFO: Creating backup dir '/opt/kimai/var/easy_backup/2023-09-10_132546/'.
[2023-09-10 13:25:46] INFO: Creating manifest file '/opt/kimai/var/easy_backup/2023-09-10_132546/manifest.json'.
[2023-09-10 13:25:46] INFO: Get files and dirs to backup.
[2023-09-10 13:25:46] INFO: Start to backup '/opt/kimai/.env'.
[2023-09-10 13:25:46] INFO: It's a file. Start to copy it to '/opt/kimai/var/easy_backup/2023-09-10_132546/.env'.
[2023-09-10 13:25:46] INFO: Start to backup '/opt/kimai/config/packages/local.yaml'.
[2023-09-10 13:25:46] WARNING: Path '/opt/kimai/config/packages/local.yaml' is not existing or not accessable.
[2023-09-10 13:25:46] INFO: Start to backup '/opt/kimai/var/data/'.
[2023-09-10 13:25:46] INFO: It's a directory. Start to mirror it to '/opt/kimai/var/easy_backup/2023-09-10_132546/var/data/'.
[2023-09-10 13:25:46] INFO: Start to backup '/opt/kimai/var/plugins/'.
[2023-09-10 13:25:46] INFO: It's a directory. Start to mirror it to '/opt/kimai/var/easy_backup/2023-09-10_132546/var/plugins/'.
[2023-09-10 13:25:47] INFO: Start to backup '/opt/kimai/var/invoices/'.
[2023-09-10 13:25:47] WARNING: Path '/opt/kimai/var/invoices/' is not existing or not accessable.
[2023-09-10 13:25:47] INFO: Start to backup '/opt/kimai/templates/invoice/'.
[2023-09-10 13:25:47] INFO: It's a directory. Start to mirror it to '/opt/kimai/var/easy_backup/2023-09-10_132546/templates/invoice/'.
[2023-09-10 13:25:47] INFO: Start to backup '/opt/kimai/var/export/'.
[2023-09-10 13:25:47] WARNING: Path '/opt/kimai/var/export/' is not existing or not accessable.
[2023-09-10 13:25:47] INFO: Start to backup '/opt/kimai/templates/export/'.
[2023-09-10 13:25:47] INFO: It's a directory. Start to mirror it to '/opt/kimai/var/easy_backup/2023-09-10_132546/templates/export/'.
[2023-09-10 13:25:47] INFO: Start database backup.
[2023-09-10 13:25:47] INFO: Used database: 'mysql'.
[2023-09-10 13:25:47] ERROR: sh: syntax error: EOF in backquote substitution
[2023-09-10 13:25:47] INFO: No git repository recognized. Expected path: /opt/kimai/var/plugins/EasyBackupBundle/.git

Desktop:

• OS: Debian GNU/Linux 11 (bullseye)
• Docker version: 24.0.6, build ed223bc

Docker compose file (with passwords redacted)
I am using the Docker Compose file provided by Toby, which can be found here. You can see my configuration:

version: '3.5'
services:

  sqldb:
    image: mysql:5.7
    environment:
      - MYSQL_DATABASE=testdatabase
      - MYSQL_USER=testuser
      - MYSQL_PASSWORD=testpassword
      - MYSQL_ROOT_PASSWORD=testrootpassword
    ports:
      - 3336:3306
    volumes:
      - mysql:/var/lib/mysql
    command: --default-storage-engine innodb
    restart: unless-stopped
    healthcheck:
      test: mysqladmin -p$$MYSQL_ROOT_PASSWORD ping -h localhost
      interval: 20s
      start_period: 10s
      timeout: 10s
      retries: 3
    labels:
      - "com.centurylinklabs.watchtower.enable=true"

  nginx:
    image: tobybatch/nginx-fpm-reverse-proxy
    ports:
      - 8001:80
    volumes:
      - public:/opt/kimai/public:ro
    restart: unless-stopped
    depends_on:
      - kimai
    healthcheck:
      test:  wget --spider http://nginx/health || exit 1
      interval: 20s
      start_period: 10s
      timeout: 10s
      retries: 3
    labels:
      - "com.centurylinklabs.watchtower.enable=true"

  kimai: # This is the latest FPM image of kimai
    image: kimai/kimai2:fpm-dev
    environment:
      - ADMINMAIL=mail
      - ADMINPASS=adminpw
      - DATABASE_URL=mysql://testuser:testpassword@sqldb/testdatabse?charset=utf8&serverVersion=5.7
      - TRUSTED_HOSTS=nginx,localhost,127.0.0.1,myurl.from.nginx.reverse.proxy
      - memory_limit=500M
      - MAILER_URL=smtp://mailer:1025
      - MAILER_FROM=kimai@example.com
    volumes:
      - public:/opt/kimai/public
      - /mnt/media/docker/kimai/plugins:/opt/kimai/var/plugins
      # - var:/opt/kimai/var
      # - ./ldap.conf:/etc/openldap/ldap.conf:z
      # - ./ROOT-CA.pem:/etc/ssl/certs/ROOT-CA.pem:z
    restart: unless-stopped
    labels:
      - "com.centurylinklabs.watchtower.enable=true"

  phpmyadmin:
    image: phpmyadmin
    restart: always
    ports:
      - 8081:80
    environment:
      - PMA_ARBITRARY=1
    labels:
      - "com.centurylinklabs.watchtower.enable=true"

  swagger:
    image: swaggerapi/swagger-ui
    ports:
      - 8080:8080
    volumes:
      - ./swagger.json:/swagger.json
    environment:
      - SWAGGER_JSON=/swagger.json
    labels:
      - "com.centurylinklabs.watchtower.enable=true"

  mailer:
    image: schickling/mailcatcher
    ports:
      - "${MAILER_SMTP_PORT:-1025}:1025"
      - "${MAILER_ADMIN_PORT:-1080}:1080"
    labels:
      - "com.centurylinklabs.watchtower.enable=true"


volumes:
    var:
    public:
    mysql:

Additional context
I'm seeking guidance on how to resolve this issue or how to configure the Docker container to include MySQL/mysqldump, allowing the "Easybackup" plugin to function correctly. If anyone has encountered a similar problem or has insights on how to configure the Docker environment to address this, please share your thoughts.

Best regards.

[kevinpapst]

How is that a bug of the Docker image?

Please include image and logs in your issue, not on some external page.

[tobybatch]

@tamenmd Any more info on this?

[tamenmd]

@tobybatch At the moment, unfortunately not. Currently, I am using Proxmox to back up the entire virtual machine, and in case of data loss, I rely on this backup for restoration. I haven't yet figured out how to integrate this plugin into my environment.

[tamenmd]

Hey @tobybatch and @kevinpapst,

Quick update on the 'Easybackup' issue in the Kimai Docker setup:

MySQL/mysqldump Fix: Managed to get MySQL and mysqldump into the container. Made a custom Docker image with this Dockerfile:

FROM kimai/kimai2:fpm-dev

RUN apk update && \
    apk add  mysql-client && \
    rm -rf /var/lib/apt/lists/*

Rebuilt with docker build -t custom-kimai . and switched to the custom-kimai image. This seemed to fix the red quotes in EasyBackup.

Backup Issues: Still hitting some errors when trying to backup. Here's the log:

[2023-11-02 13:17:22] INFO: --- S T A R T   C R E A T I N G   B A C K U P ---
[2023-11-02 13:17:22] INFO: Creating backup dir '/opt/kimai/var/easy_backup/2023-11-02_131722/'.
[2023-11-02 13:17:22] INFO: Creating manifest file '/opt/kimai/var/easy_backup/2023-11-02_131722/manifest.json'.
[2023-11-02 13:17:22] INFO: Get files and dirs to backup.
[2023-11-02 13:17:22] INFO: Start to backup '/opt/kimai/.env'.
[2023-11-02 13:17:22] INFO: It's a file. Start to copy it to '/opt/kimai/var/easy_backup/2023-11-02_131722/.env'.
[2023-11-02 13:17:22] INFO: Start to backup '/opt/kimai/config/packages/local.yaml'.
[2023-11-02 13:17:22] WARNING: Path '/opt/kimai/config/packages/local.yaml' is not existing or not accessable.
[2023-11-02 13:17:22] INFO: Start to backup '/opt/kimai/var/data/'.
[2023-11-02 13:17:22] INFO: It's a directory. Start to mirror it to '/opt/kimai/var/easy_backup/2023-11-02_131722/var/data/'.
[2023-11-02 13:17:22] INFO: Start to backup '/opt/kimai/var/plugins/'.
[2023-11-02 13:17:22] INFO: It's a directory. Start to mirror it to '/opt/kimai/var/easy_backup/2023-11-02_131722/var/plugins/'.
[2023-11-02 13:17:22] INFO: Start to backup '/opt/kimai/var/invoices/'.
[2023-11-02 13:17:22] WARNING: Path '/opt/kimai/var/invoices/' is not existing or not accessable.
[2023-11-02 13:17:22] INFO: Start to backup '/opt/kimai/templates/invoice/'.
[2023-11-02 13:17:22] INFO: It's a directory. Start to mirror it to '/opt/kimai/var/easy_backup/2023-11-02_131722/templates/invoice/'.
[2023-11-02 13:17:22] INFO: Start to backup '/opt/kimai/var/export/'.
[2023-11-02 13:17:22] WARNING: Path '/opt/kimai/var/export/' is not existing or not accessable.
[2023-11-02 13:17:22] INFO: Start to backup '/opt/kimai/templates/export/'.
[2023-11-02 13:17:22] INFO: It's a directory. Start to mirror it to '/opt/kimai/var/easy_backup/2023-11-02_131722/templates/export/'.
[2023-11-02 13:17:22] INFO: Start database backup.
[2023-11-02 13:17:22] INFO: Used database: 'mysql'.
[2023-11-02 13:17:22] ERROR: sh: syntax error: EOF in backquote substitution
[2023-11-02 13:17:22] INFO: No git repository recognized. Expected path: /opt/kimai/var/plugins/EasyBackupBundle/.git

Seems like there might be some file or directory issues. Also, the ERROR: sh: syntax error: EOF in backquote substitution bit is weird.

Any thoughts on these?

Thank you

[kevinpapst]

1. I converted this to a discussion, because this is not an issue of the docker image.
2. You might want to discuss that in the EasyBackup repository instead and see if the developer is willing to patch it for Docker compatibiliity
3. I don't see why you use this plugin in the first place. You are capable of building your own docker image. I am certain you are also capable of running both a mysqldump and zip/tar command (to compress the files in your mount points) via crontab.

And lastly: extra pings via @ are not necessary. I don't see how that is justified, considering that this is meither critical nor urgent.

[tamenmd]

Hey, thanks for the feedback. I completely understand where you're coming from. For those who are deeply involved, everything might seem pretty straightforward. However, navigating through different projects, plugins, and platforms can feel like a puzzle sometimes. It's not always crystal clear where to post a question or how to address an issue, especially with so many interconnected parts in Docker. A touch of patience and some guidance can make a huge difference. I truly appreciate all the hard work behind these projects and am doing my best to wrap my head around everything.