Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Dump Format invalid #22

Closed
plutocrat opened this issue Jun 15, 2020 · 3 comments
Closed

Dump Format invalid #22

plutocrat opened this issue Jun 15, 2020 · 3 comments
Assignees
Labels
enhancement New feature or request

Comments

@plutocrat
Copy link

Hi,
The dump as produced on an Ubuntu 18 server contained the line
"mysqldump: [Warning] Using a password on the command line interface can be insecure."
At the top of the file, which means that when you try to restore it, it fails with a format error. Removing the line makes restoring the database possible.

Suggestion: An automated restore from the web interface would be useful. Or at least, instructions on how to extract and restore a database from a dump.

@plutocrat
Copy link
Author

Also, stray .env file left in backup directory by extracting a backup, was listed as a backup called .env. Should probably limit listing to *.zip

@mxgross mxgross added the enhancement New feature or request label Jun 16, 2020
@mxgross
Copy link
Owner

mxgross commented Oct 22, 2020

Hello,
as long as there is no restore functionality, use this instruction: https://www.kimai.org/documentation/backups.html
In the chapter "restore" is everything described.

mxgross pushed a commit that referenced this issue Oct 31, 2020
@mxgross mxgross self-assigned this Oct 31, 2020
@mxgross
Copy link
Owner

mxgross commented Oct 31, 2020

Hello @plutocrat,
I fixed the detection for zip files in the dev branch and will be merged to master soon.

For the problem with the mysqldump warning you could do me a favor and test if the warning disappears when you add this in the file kimai2\var\plugins\EasyBackupBundle\Controller\EasyBackupController.php
mysqldump_warning_prevention
I forgot the square brackets around the 'Warning' in the screenshot, you may need to add them too.

| grep -v '[Warning]: Using a password'

I cannot test it myself at the moment because it does not appear in my environment.

Please tell me if this will help.
Thanks,
Max

mxgross added a commit that referenced this issue Nov 4, 2020
#22 Prevent warnings from being logged into the sql dump
mxgross pushed a commit that referenced this issue Nov 4, 2020
mxgross added a commit that referenced this issue Nov 4, 2020
@mxgross mxgross closed this as completed Nov 10, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants