dokploy icon indicating copy to clipboard operation
dokploy copied to clipboard

Remote database backup fail

Open Silbad opened this issue 11 months ago • 3 comments

To Reproduce

  1. create a mariadb on remote server
  2. param backup on s3
  3. launch backup with dokploy

Current vs. Expected behavior

The backup is create but 0 ko I have this error : 2025-02-09 14:49:29 21 [Warning] Access denied for user 'mydb'@'localhost' (using password: YES) Thanks

Provide environment information

Ubuntu 22.04
Dokploy 0.18.2

Which area(s) are affected? (Select all that apply)

Databases

Are you deploying the applications where Dokploy is installed or on a remote server?

Remote server

Additional context

I tested same configuration on local server, it's work.

Will you send a PR to fix it?

No

Silbad avatar Feb 09 '25 14:02 Silbad

The error says it all, access denied, something's wrong with credentials. Are you able to access the database using mysql CLI or DBeaver?

Cohvir avatar Feb 09 '25 22:02 Cohvir

Neither is the log when I run a database backup with Dokploy

Silbad avatar Feb 09 '25 22:02 Silbad

I cannot reproduce this issue, did you changed the password of the database manually?

Siumauricio avatar Feb 15 '25 20:02 Siumauricio

Nope. For your information, I use Hetzner's S3.

With backup with Dokploy on the same server :

Image

With backup on remote server (After that, I don't know if it's necessarily related) (MariaDB for Directus) :

Image

I'll keep looking on my own

Silbad avatar Feb 22 '25 20:02 Silbad

ok, i run manually a backup, in the logs :

2025-02-22 20:19:49 471 [Warning] Access denied for user 'myappdb'@'localhost' (using password: YES)

Any idea ?

Silbad avatar Feb 22 '25 20:02 Silbad

Did you specify the correct database in the backup? The only way you get empty information is because you wrote a database that doesn't exist.

Siumauricio avatar Mar 07 '25 07:03 Siumauricio

I hope it will be fixed in #1431

Siumauricio avatar Mar 09 '25 07:03 Siumauricio