search

mxgross / EasyBackupBundle

Kimai 2 Plugin for easier backups
MIT License
24 stars 6 forks source link

Backup error in shared hosting environment - mysqldump: Got error: 1045 #42

Closed Lu-H closed 2 years ago

Lu-H commented 2 years ago

Hi there!

Thank you very much for your effort you put in to this great plugin! Maybe you could point me in the right direction (again) to solve my problem? Kimai is doing fine, but the mysqldump in the backup routine is not working in my configuration.

The mysqldump via ssh is working fine. Also it is working fine, if I replace the password wildcard --password={password} in the user interface with the actual password. I know it is not the best to do this, but for testing... I do have a pasword that is URL-encoded (in the DATABASE_URL). Could this cause the error?

If I leave the standard command in the ui it throws this error: ERROR: mysqldump: 'mysqldump: Got error: 1045: "Access denied for user 'user1234'@'subdomain.hosting.de' (using password: YES)" when trying to connect'.

Best regards Lukas

mxgross commented 2 years ago

Hi Lukas, yes for now only decoded passwords are compatible. The code just simply extracts the password defined in the connection string.

You can either define the password in the mysqldump command instead of the wildcard (like you already did). Or change your .env file and define the password decoded/clear text.

Best regards Max

mxgross commented 2 years ago

Should be fixed with #44