Skip to content

Automated database backups from Odoo, both locally and on an FTP server

License

Notifications You must be signed in to change notification settings

michaelhofer-slg/auto_backup

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

1. Prerequisites

This module needs the Python library pysftp, otherwise it cannot be installed and used. Install pysftp through the command sudo pip install pysftp

2. Which version to choose?

Version 15.0 is the latest stable version for this module and is compatible with the latest Odoo version (Odoo 15). The versions 8.0, 9.0, 10.0, 11.0, 12.0 and 13.0 of this module are tested and verified to work for their specific Odoo versions. The master version is the development version and will be for the next Odoo version. The master version is still in testing and contains the newest features, which might still have problems/error.
Tip: At this point the master version is being rewritten to drop the pysftp library need, please don't use this version at this point.
If you need to connect to a remote FTP server on another port than port 22 you should download and install the 9.0, 10.0, 11.0, 12.0, 13.0, 14.0, 15.0 or master version. Version 8 does not support another port than 22.

3. Guide / documentation

Need more help with this module or want a guide about how to set this up?

4. Important information

4.1 limit_time_real parameter

When you've configured your Odoo instance to run with workers you should change the default value of limit_time_real (as this defaults to 120). You can configure the value in /etc/odoo/your_odoo.conf to the appropriate number in case of a large database backup. This is required when max_cron_threads > 0 to avoid worker timeout during the backup.

4.2 list_db parameter

The backup module only used to work when list_db was set to True (or was not configured). Since 28/02/2020 ( https://github.com/Yenthe666/auto_backup/commit/c7d0512a0d0b2d42662831008e7a9316b264f23e) you no longer have to have the database manager enabled and the module can also take backups without it being exposed. If you run the backup module before this commit and want to run it without the database manager being exposed you should update the backup module to the latest version first. It is advised to disable the database manager for security purposes. See https://www.odoo.com/documentation/15.0/setup/deploy.html#database-manager-security for more information about this subject.

4.3 --load / server_wide_modules parameter

In V12, V13 and V14 Odoo will need the values 'base' and 'web' set if you use the --load (or server_wide_modules) parameter. Without these values set you will get a 404 NOT FOUND from the backup module. For more information see Yenthe666#122

4.4 "No matching record found for external id" error

This happens when you've installed - or tried to install - the back-up module without having the dependency pysftp installed. You might need to restart your Odoo instance or even your whole server for Odoo to recognize the Python package.

4.5 Running on Odoo.sh

At the moment this module is not compatible with Odoo.sh.
This is because Odoo.sh does not allow database operations on this level and thus our backup module cannot generate a backup.
There is currently no known workaround for this.

5. Bugs or problems

Please post them here under 'Issues' and I will get back to you as soon as I can!

About

Automated database backups from Odoo, both locally and on an FTP server

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 82.9%
  • HTML 17.1%