kimai2:apache & EasyBackup don't work together - database not found #450

axel1202 · 2023-01-09T09:42:37Z

axel1202
Jan 9, 2023

Describe the bug
I am not sure, where to address this issue - either kaimai:apache or EasyBackup plugin.

When setting up kimai in Docker with 2 containers for the mysql-db and kimai:apache, EasyBackup complains, that it can't find the mysql and mysqldump commands / tools.

So I derived a new image from kimai:apache, where I additionally installed said tools. I did that the lazy way - logged into the running container, installed mysql client tools and then just creted a new image of that container (localimages/kimai) and restarted everything using this new image - obviously works hunky-dory, because then the plugin status showed OK:

Despite of that seemingly good status running a restore then throws a huge amount of warnings and errors (see below), among others stating, that the specified db is unknown:

[2023-01-08 17:55:12] ERROR: ERROR 2005 (HY000): Unknown MySQL server host 'sqldb/kimai' (-2)

This is especially confusing, as the status check (see screenshot above) marks the database as OK...

This seems to be the main problem.

Furthermore there are a lot of access permission errors, some of which referr to directories NOT related to volumes mounted from outside:

[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/config/packages/local.yaml' to '511'.

and mainly referring to file permissions within the mounted volumes:

[2023-01-08 17:55:12] INFO: '/opt/kimai/var/plugins/EasyBackupBundle/.php_cs.dist' is not writable.
[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/var/plugins/.gitkeep' to '511'.

this certainly might be solvable by setting the proper permissions, but I am not sure what those would look like.

To Reproduce
Steps to reproduce the behaviour:

System running
upload the backup-zip to directory on mounted volume
backup zip shows up in EasyBackup list of available backups
try to restore backup
tons of errors :-)

Desktop (please complete the following information):

OS: Linux Mint 20.3 Una (5.4.0-135-generic)
Docker version: 20.10.22, build 3a2c30b
Docker compose version: --> portainer-ce 2.16.2

Command used to run the container

it is run as portainer stack

Docker compose file (with passwords redacted)
(portainer stack definition)

version: '3.5'
services:

  sqldb:
    container_name: "sqldb"
    image: mysql:5.7
    volumes:
      - /fileserver/daten/docker/volumes/somenamespace/kimai2/mysql:/var/lib/mysql
    environment:
      - MYSQL_DATABASE=kimai
      - MYSQL_USER=***
      - MYSQL_PASSWORD=***
      - MYSQL_ROOT_PASSWORD=***
    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

  kimai:
    container_name: "kimai"
    depends_on: 
      - sqldb
    image: localimages/kimai
    volumes:
      - /fileserver/daten/docker/volumes/somenamespace/kimai2/var:/opt/kimai/var
    ports:
      - 8001:8001
    environment:
      - ADMINMAIL=***@***
      - ADMINPASS=***
      - DATABASE_URL=mysql://***:***@sqldb/kimai
      - TRUSTED_HOSTS=nginx,localhost,127.0.0.1,more,private,hosts,here
    restart: unless-stopped

directory structure of mounted volumes as seen from the volumes' host

kimai2/
├── [drwxrwxrwx 999      root    ]  mysql
│   ├── [drwxr-x--- 999      docker  ]  kimai
│   ├── [drwxr-x--- 999      docker  ]  mysql
│   ├── [drwxr-x--- 999      docker  ]  performance_schema
│   └── [drwxr-x--- 999      docker  ]  sys
└── [drwxrwxrwx root     root    ]  var
    ├── [drwxr-xr-x www-data www-data]  cache
    │   ├── [drwxr-xr-x www-data www-data]  pro_
    │   ├── [drwxr-xr-x www-data www-data]  pro~
    │   │   └── [drwxr-xr-x www-data www-data]  pools
    │   └── [drwxr-xr-x www-data www-data]  prod
    │       ├── [drwxr-xr-x www-data www-data]  ContainerGTQvi3z
    │       ├── [drwxr-xr-x www-data www-data]  doctrine
    │       ├── [drwxr-xr-x www-data www-data]  jms_serializer
    │       ├── [drwxr-xr-x www-data www-data]  pools
    │       ├── [drwxr-xr-x www-data www-data]  translations
    │       └── [drwxr-xr-x www-data www-data]  twig
    ├── [drwxr-xr-x www-data www-data]  data
    ├── [drwxr-xr-x www-data www-data]  easy_backup
    ├── [drwxr-xr-x www-data www-data]  log
    └── [drwxr-xr-x www-data www-data]  plugins
        └── [drwxr-xr-x www-data www-data]  EasyBackupBundle
            ├── [drwxr-xr-x www-data www-data]  Configuration
            ├── [drwxr-xr-x www-data www-data]  Controller
            ├── [drwxr-xr-x www-data www-data]  DependencyInjection
            ├── [drwxr-xr-x www-data www-data]  EventSubscriber
            └── [drwxr-xr-x www-data www-data]  Resources

the log from EasyBackup

[2023-01-08 17:55:12] INFO: --- S T A R T   R E S T O R E ---
[2023-01-08 17:55:12] INFO: Start unzipping '/opt/kimai/var/easy_backup/2023-01-08_184202.zip' to '/opt/kimai/var/easy_backup/2023-01-08_184202/'.
[2023-01-08 17:55:12] INFO: Extracting to '/opt/kimai/var/easy_backup/2023-01-08_184202/'.
[2023-01-08 17:55:12] INFO: Start restoring MySQL dump.
[2023-01-08 17:55:12] ERROR: ERROR 2005 (HY000): Unknown MySQL server host 'sqldb/kimai' (-2)
[2023-01-08 17:55:12] INFO: Restored MySQL database.
[2023-01-08 17:55:12] INFO: Start restoring files and dirs.
[2023-01-08 17:55:12] INFO: Blacklist of files not to move: database_dump.sql, manifest.json
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/.env' (Permissions: 0644) to '/opt/kimai/.env' (Permissions: 0644).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/config/packages/local.yaml' (Permissions: 0644) to '/opt/kimai/config/packages/local.yaml' (Permissions: 0).
[2023-01-08 17:55:12] INFO: '/opt/kimai/config/packages/local.yaml' is not writable.
[2023-01-08 17:55:12] INFO: Trying to change the file permissions of '/opt/kimai/config/packages/local.yaml' to '511' automatically.
[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/config/packages/local.yaml' to '511'.
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/templates/invoice/actions.html.twig' (Permissions: 0644) to '/opt/kimai/templates/invoice/actions.html.twig' (Permissions: 0644).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/templates/invoice/document_upload.html.twig' (Permissions: 0644) to '/opt/kimai/templates/invoice/document_upload.html.twig' (Permissions: 0644).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/templates/invoice/index.html.twig' (Permissions: 0644) to '/opt/kimai/templates/invoice/index.html.twig' (Permissions: 0644).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/templates/invoice/layout.html.twig' (Permissions: 0644) to '/opt/kimai/templates/invoice/layout.html.twig' (Permissions: 0644).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/templates/invoice/renderer/company.docx' (Permissions: 0644) to '/opt/kimai/templates/invoice/renderer/company.docx' (Permissions: 0644).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/templates/invoice/renderer/default.html.twig' (Permissions: 0644) to '/opt/kimai/templates/invoice/renderer/default.html.twig' (Permissions: 0644).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/templates/invoice/renderer/freelancer.html.twig' (Permissions: 0644) to '/opt/kimai/templates/invoice/renderer/freelancer.html.twig' (Permissions: 0).
[2023-01-08 17:55:12] INFO: '/opt/kimai/templates/invoice/renderer/freelancer.html.twig' is not writable.
[2023-01-08 17:55:12] INFO: Trying to change the file permissions of '/opt/kimai/templates/invoice/renderer/freelancer.html.twig' to '511' automatically.
[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/templates/invoice/renderer/freelancer.html.twig' to '511'.
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/templates/invoice/renderer/freelancer_old.html.twig' (Permissions: 0644) to '/opt/kimai/templates/invoice/renderer/freelancer_old.html.twig' (Permissions: 0).
[2023-01-08 17:55:12] INFO: '/opt/kimai/templates/invoice/renderer/freelancer_old.html.twig' is not writable.
[2023-01-08 17:55:12] INFO: Trying to change the file permissions of '/opt/kimai/templates/invoice/renderer/freelancer_old.html.twig' to '511' automatically.
[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/templates/invoice/renderer/freelancer_old.html.twig' to '511'.
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/templates/invoice/renderer/timesheet.html.twig' (Permissions: 0644) to '/opt/kimai/templates/invoice/renderer/timesheet.html.twig' (Permissions: 0644).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/templates/invoice/template_edit.html.twig' (Permissions: 0644) to '/opt/kimai/templates/invoice/template_edit.html.twig' (Permissions: 0644).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/templates/invoice/templates.html.twig' (Permissions: 0644) to '/opt/kimai/templates/invoice/templates.html.twig' (Permissions: 0644).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/data/.gitkeep' (Permissions: 0644) to '/opt/kimai/var/data/.gitkeep' (Permissions: 0).
[2023-01-08 17:55:12] INFO: '/opt/kimai/var/data/.gitkeep' is not writable.
[2023-01-08 17:55:12] INFO: Trying to change the file permissions of '/opt/kimai/var/data/.gitkeep' to '511' automatically.
[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/var/data/.gitkeep' to '511'.
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/data/kimai_test.sqlite' (Permissions: 0644) to '/opt/kimai/var/data/kimai_test.sqlite' (Permissions: 0).
[2023-01-08 17:55:12] INFO: '/opt/kimai/var/data/kimai_test.sqlite' is not writable.
[2023-01-08 17:55:12] INFO: Trying to change the file permissions of '/opt/kimai/var/data/kimai_test.sqlite' to '511' automatically.
[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/var/data/kimai_test.sqlite' to '511'.
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/invoices/Basti.html.twig' (Permissions: 0644) to '/opt/kimai/var/invoices/Basti.html.twig' (Permissions: 0).
[2023-01-08 17:55:12] INFO: '/opt/kimai/var/invoices/Basti.html.twig' is not writable.
[2023-01-08 17:55:12] INFO: Trying to change the file permissions of '/opt/kimai/var/invoices/Basti.html.twig' to '511' automatically.
[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/var/invoices/Basti.html.twig' to '511'.
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/invoices/Basti.html.twig.original' (Permissions: 0644) to '/opt/kimai/var/invoices/Basti.html.twig.original' (Permissions: 0).
[2023-01-08 17:55:12] INFO: '/opt/kimai/var/invoices/Basti.html.twig.original' is not writable.
[2023-01-08 17:55:12] INFO: Trying to change the file permissions of '/opt/kimai/var/invoices/Basti.html.twig.original' to '511' automatically.
[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/var/invoices/Basti.html.twig.original' to '511'.
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/invoices/Vorlage_Kleinunternehmer.docx' (Permissions: 0644) to '/opt/kimai/var/invoices/Vorlage_Kleinunternehmer.docx' (Permissions: 0).
[2023-01-08 17:55:12] INFO: '/opt/kimai/var/invoices/Vorlage_Kleinunternehmer.docx' is not writable.
[2023-01-08 17:55:12] INFO: Trying to change the file permissions of '/opt/kimai/var/invoices/Vorlage_Kleinunternehmer.docx' to '511' automatically.
[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/var/invoices/Vorlage_Kleinunternehmer.docx' to '511'.
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/invoices/test.docx' (Permissions: 0644) to '/opt/kimai/var/invoices/test.docx' (Permissions: 0).
[2023-01-08 17:55:12] INFO: '/opt/kimai/var/invoices/test.docx' is not writable.
[2023-01-08 17:55:12] INFO: Trying to change the file permissions of '/opt/kimai/var/invoices/test.docx' to '511' automatically.
[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/var/invoices/test.docx' to '511'.
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/.gitkeep' (Permissions: 0644) to '/opt/kimai/var/plugins/.gitkeep' (Permissions: 0).
[2023-01-08 17:55:12] INFO: '/opt/kimai/var/plugins/.gitkeep' is not writable.
[2023-01-08 17:55:12] INFO: Trying to change the file permissions of '/opt/kimai/var/plugins/.gitkeep' to '511' automatically.
[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/var/plugins/.gitkeep' to '511'.
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/.gitignore' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/.gitignore' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/.php_cs.dist' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/.php_cs.dist' (Permissions: 0).
[2023-01-08 17:55:12] INFO: '/opt/kimai/var/plugins/EasyBackupBundle/.php_cs.dist' is not writable.
[2023-01-08 17:55:12] INFO: Trying to change the file permissions of '/opt/kimai/var/plugins/EasyBackupBundle/.php_cs.dist' to '511' automatically.
[2023-01-08 17:55:12] ERROR: Failed to change permissions of '/opt/kimai/var/plugins/EasyBackupBundle/.php_cs.dist' to '511'.
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/Configuration/EasyBackupConfiguration.php' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/Configuration/EasyBackupConfiguration.php' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/Controller/EasyBackupController.php' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/Controller/EasyBackupController.php' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/DependencyInjection/Configuration.php' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/DependencyInjection/Configuration.php' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/DependencyInjection/EasyBackupExtension.php' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/DependencyInjection/EasyBackupExtension.php' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/EasyBackupBundle.php' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/EasyBackupBundle.php' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/EventSubscriber/MenuSubscriber.php' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/EventSubscriber/MenuSubscriber.php' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/EventSubscriber/SystemConfigurationSubscriber.php' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/EventSubscriber/SystemConfigurationSubscriber.php' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/LICENSE' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/LICENSE' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/Readme.md' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/Readme.md' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/Resources/config/routes.yaml' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/Resources/config/routes.yaml' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/Resources/config/services.yaml' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/Resources/config/services.yaml' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/Resources/translations/flashmessages.de.xlf' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/Resources/translations/flashmessages.de.xlf' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/Resources/translations/flashmessages.en.xlf' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/Resources/translations/flashmessages.en.xlf' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/Resources/translations/messages.de.xliff' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/Resources/translations/messages.de.xliff' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/Resources/translations/messages.en.xliff' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/Resources/translations/messages.en.xliff' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/Resources/translations/system-configuration.de.xliff' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/Resources/translations/system-configuration.de.xliff' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/Resources/translations/system-configuration.en.xliff' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/Resources/translations/system-configuration.en.xliff' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/Resources/views/index.html.twig' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/Resources/views/index.html.twig' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/composer.json' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/composer.json' (Permissions: 0755).
[2023-01-08 17:55:12] INFO: Copying '/opt/kimai/var/easy_backup/2023-01-08_184202/var/plugins/EasyBackupBundle/screenshot.jpg' (Permissions: 0644) to '/opt/kimai/var/plugins/EasyBackupBundle/screenshot.jpg' (Permissions: 0644).
[2023-01-08 17:55:12] INFO: Remove temp dir '/opt/kimai/var/easy_backup/2023-01-08_184202/'.

kevinpapst · 2023-01-09T10:46:11Z

kevinpapst
Jan 9, 2023
Collaborator

Looks like a problem of EasyBackupBundle to me, maybe it is just not docker compatible.
I don't see anything that is docker related. Maybe the unknown database issues, but then: if Kimai works and the bundle doesn't...

0 replies

axel1202 · 2023-01-09T12:49:38Z

axel1202
Jan 9, 2023
Author

Looks like a problem of EasyBackupBundle to me, maybe it is just not docker compatible. I don't see anything that is docker related. Maybe the unknown database issues, but then: if Kimai works and the bundle doesn't...

yeah - obviously the kimai contaienr itself has no problem connecting to the mysql container, the given database connect string user@pass@mysql/kimai should be correct as well... so, I dont get it :-) maybe the EasyBackup-Dev gets note of this post here...

Thanks fpr the quick reply anyways

0 replies

kevinpapst · 2023-01-09T14:14:21Z

kevinpapst
Jan 9, 2023
Collaborator

We can give him a ping @mxgross - do you have any idea?

0 replies

mxgross · 2023-01-09T16:33:55Z

mxgross
Jan 9, 2023

Hi, unfortunately I cannot have a deeper look at it currently.
I did not yet test it in docker but I can imagine that there are a few problems in my bundle regarding docker.
I will put this in my reminder and hope I can start analyzing it next weekend.

0 replies

axel1202 · 2023-01-10T15:28:07Z

axel1202
Jan 10, 2023
Author

We can give him a ping @mxgross - do you have any idea?

He already replied :-) in a way... ;-)

0 replies

axel1202 · 2023-01-10T15:28:49Z

axel1202
Jan 10, 2023
Author

Hi, unfortunately I cannot have a deeper look at it currently. I did not yet test it in docker but I can imagine that there are a few problems in my bundle regarding docker. I will put this in my reminder and hope I can start analyzing it next weekend.

That'd be nice - no hurry... Would be nice, if we could run that dockerized at some time :-)

0 replies

tobybatch · 2023-01-10T16:57:45Z

tobybatch
Jan 10, 2023
Maintainer

I will take a look at this when I get a chance, but the containerised applications are running in their own little network, where sqldb should resolve to the DB host.

I can't easily see why it wouldn't work

0 replies

tobybatch · 2023-01-13T21:23:06Z

tobybatch
Jan 13, 2023
Maintainer

Can you add

   ports:
      - 3036:3036

to the db container and see if you can connect to it directly?

0 replies

axel1202 · 2023-01-14T08:54:47Z

axel1202
Jan 14, 2023
Author

Can you add
   ports:
      - 3036:3036
to the db container and see if you can connect to it directly?

Works a treat from outside...

-- as well as from inside the kimai container:

:-)

0 replies

tobybatch · 2023-01-22T10:24:57Z

tobybatch
Jan 22, 2023
Maintainer

So I think the issue in the plugin. I'm going to convert this into a discussion rather than an issue with the kimai container.

1 reply

axel1202 Jan 30, 2023
Author

yes - that seems resonable - doesn't help me with migrating a friend's installation to a different server though. :-) qre you just using the database as single place for persisting everything - as in configuration data and business data, or are there additional configuration files and alike, that are required, when migrating an exisiting system to a different server? if there was the opportuinityx to just dump and reimport the database, that might also be a way.

regards

axel

mxgross · 2023-05-15T15:43:56Z

mxgross
May 15, 2023

Hi, I released a new version of EasyBackup, compatible with Kimai 2 > 2.0.0
Could you please test it again. I also changed some parameter handling of the restore functionality.

I think the problem here was, that the database URL was not interpreted right.

Please test again with my latest 'main' branch and give feedback, thanks.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

kimai2:apache & EasyBackup don't work together - database not found #450

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 11 comments 1 reply

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

Select a reply

kimai2:apache & EasyBackup don't work together - database not found #450

axel1202 Jan 9, 2023

Replies: 11 comments · 1 reply

kevinpapst Jan 9, 2023 Collaborator

axel1202 Jan 9, 2023 Author

kevinpapst Jan 9, 2023 Collaborator

mxgross Jan 9, 2023

axel1202 Jan 10, 2023 Author

axel1202 Jan 10, 2023 Author

tobybatch Jan 10, 2023 Maintainer

tobybatch Jan 13, 2023 Maintainer

axel1202 Jan 14, 2023 Author

tobybatch Jan 22, 2023 Maintainer

axel1202 Jan 30, 2023 Author

mxgross May 15, 2023

axel1202
Jan 9, 2023

Replies: 11 comments 1 reply

kevinpapst
Jan 9, 2023
Collaborator

axel1202
Jan 9, 2023
Author

kevinpapst
Jan 9, 2023
Collaborator

mxgross
Jan 9, 2023

axel1202
Jan 10, 2023
Author

axel1202
Jan 10, 2023
Author

tobybatch
Jan 10, 2023
Maintainer

tobybatch
Jan 13, 2023
Maintainer

axel1202
Jan 14, 2023
Author

tobybatch
Jan 22, 2023
Maintainer

axel1202 Jan 30, 2023
Author

mxgross
May 15, 2023