Unable to Backup mariadb

[TrueBankai416]

Issue filing prerequisites

• I've checked the documentation.
• I've looked for similar issues both Open and Closed.
• I've tried clearing both cache and cookies in my browser or tried opening the app in the Incognito/InPrivate window.

Related:
InvoiceShelf/InvoiceShelf#477

Describe the bug

When trying to backup either full or database i get error

The dump process failed with a none successful exitcode. Exitcode ======== 127: Command not found Output ====== <no output> Error Output ============ sh: mysqldump: not found

Steps to Reproduce the issue

1. Login
2. Navigate to Settings
3. Select Backup
4. Choose backup option Full or only-db

Expected behaviour

Preform database backup

Actual behaviour

throws error due to the image not having the mysql client installed

Docker

• App running in Docker Container.
• Docker container running behind Reverse proxy.

InvoiceShelf version

2.2.0-alpha2

PHP version

v8.3.25

Database type

MariaDB

Database version

v10.11

Web Browser

FireFox

Server OS

Ubuntu LXC on Proxmox

Reverse-proxy logs

N/A

Laravel/PHP logs

InvoiceShelf/docs#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
InvoiceShelf/InvoiceShelf#88 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(208): Illuminate\\Http\\Middleware\\ValidatePostSize->handle()
InvoiceShelf/InvoiceShelf#89 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
InvoiceShelf/InvoiceShelf#90 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(208): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
InvoiceShelf/InvoiceShelf#91 /var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
InvoiceShelf/InvoiceShelf#92 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(208): Illuminate\\Http\\Middleware\\HandleCors->handle()
InvoiceShelf/InvoiceShelf#93 /var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
InvoiceShelf/InvoiceShelf#94 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(208): Illuminate\\Http\\Middleware\\TrustProxies->handle()
InvoiceShelf/InvoiceShelf#95 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
InvoiceShelf/InvoiceShelf#96 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(208): Illuminate\\Foundation\\Http\\Middleware\\InvokeDeferredCallbacks->handle()
InvoiceShelf/InvoiceShelf#97 /var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php(26): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
InvoiceShelf/InvoiceShelf#98 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(208): Illuminate\\Http\\Middleware\\ValidatePathEncoding->handle()
InvoiceShelf/InvoiceShelf#99 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(126): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
InvoiceShelf/InvoiceShelf#100 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then()
InvoiceShelf/InvoiceShelf#101 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
InvoiceShelf/InvoiceShelf#102 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1219): Illuminate\\Foundation\\Http\\Kernel->handle()
InvoiceShelf/InvoiceShelf#103 /var/www/html/public/index.php(17): Illuminate\\Foundation\\Application->handleRequest()
#104 {main}
"}

[TrueBankai416]

I can install the client into the image by running

sudo docker exec -it -u root invoiceshelf apk add --no-cache mariadb-client

however i then get error

Error

The dump process failed with a none successful exitcode. Exitcode ======== 2: Misuse of shell builtins Output ====== <no output> Error Output ============ mysqldump: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb-dump' instead mysqldump: Got error: 2026: "TLS/SSL error: SSL is required, but the server does not support it" when trying to connect 

I can get around the Deprecated program name warning by running mariadb-dump directly in the invoiceshelf container but the SSL error still persists

[TrueBankai416]

sorry didnt see this Issue
InvoiceShelf/InvoiceShelf#477

[rihards-simanovics]

Hmm, all right, I see, this must be an image dependencies regression. Darko recently updated the Docker image base for Docker, and this likely removed a bunch of packages that are needed for creating backups of the SQL. As you are running in Docker, I will move this issue over to that repo.

[rihards-simanovics]

@TrueBankai416 I've transferred the issue to the Docker repo now, so it's easier to track.

[rihards-simanovics]

@gdarko, I haven't had the time to analyse the new Dockerfile. Are we able to add back the MySQL client and PostgreSQL client tools, as those are needed to create a DB dump, which is part of the backup zip file?