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.

Sign up for GitHub

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

Jump to bottom

Import of backup fails due to MAriaDB version incompatibility #80

Open
borpin opened this issue Nov 27, 2024 · 0 comments
Open

Import of backup fails due to MAriaDB version incompatibility #80

borpin opened this issue Nov 27, 2024 · 0 comments

Comments

@borpin
Copy link
Contributor

borpin commented Nov 27, 2024

Background - https://community.openenergymonitor.org/t/import-from-archive-fails/27147

Reasons - https://community.openenergymonitor.org/t/import-from-archive-fails/27147/13?u=borpin

Solution;

At backup
Remove the line at backup time with something like mariadb-dump|tail +2.
On Import
Remove the line at import time with something like tail +2|mariadb.

For both, check for the word 'Sandbox' in the first line.
cs-physikus added a commit to cs-physikus/backup that referenced this issue Dec 3, 2024
@cs-physikus
Update emoncms-import.sh
f7daeb8 
Issue: Import of backup fails due to MAriaDB version incompatibility emoncms#80
Description: Some users were not able to restore their own data after system migration.

Solution: added 4 lines of code to remove sanbox mode command from emoncms.sql, if this command was found in the dump file.

Advantage: full import compatibility with older MariaDB versions will be maintained.

Disadvantage: MariaDB security feature "sandbox mode" will be disabled.
@cs-physikus cs-physikus mentioned this issue Dec 3, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@borpin