Automatic Database Backup To Local Server, Remote Server, Google Drive, Dropbox, Onedrive, Nextcloud and Amazon S3

by
Odoo 33
v 15.0 Third Party 7375
Download for v 15.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 1387
Technical Name auto_database_backup
LicenseLGPL-3
Websitehttps://www.cybrosys.com
Versions 12.0 13.0 14.0 15.0 16.0 17.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 1387
Technical Name auto_database_backup
LicenseLGPL-3
Websitehttps://www.cybrosys.com
Versions 12.0 13.0 14.0 15.0 16.0 17.0
Community
Enterprise

Automatic Database Backup To Local Server, Remote Server, Google Drive, Dropbox, Onedrive, Nextcloud and Amazon S3

This Module Helps To Generate Backup Of Databases.

Explore This Module

Overview

This module helps to generate backups of your databases automatically on regular interval of times. The generated backups can be stored into local storage, ftp server, sftp server, dropbox,nextcloud, Google Drive or Onedrive and Amazon S3. User can enable auto remove option to automatically delete old backups. User can enable email notification to be notified about the success and failure of the backup generation and storage. Using Automatic Database Backup module user can generate and store database backups to multiple location.

This module uses an external python dependency 'dropbox'.Before installing the module install the python package first.The required python package can be installed using the following command,
pip install dropbox

This module uses an external python dependency 'nextcloud'.Before installing the module install the python package first.The required python package can be installed using the following command,
pip install pyncclient

This module uses an external python dependency 'nextcloud-api-wrapper'.Before installing the module install the python package first.The required python package can be installed using the following command,
pip install nextcloud-api-wrapper

This module uses an external python dependency 'Boto3'.Before installing the module install the python package first.The required python package can be installed using the following command,
pip install boto3

This module uses an external python dependency 'paramiko'.Before installing the module install the python package first.The required python package can be installed using the following command,
pip install paramiko

Features

Generate Database Backups on regular intervals
Store Backup to Dropbox
Store Backup to Onedrive
Notify user on success and failure of backup generation
Store Backup to Remote Server
Store Backup to Nextcloud
Store Backup to Amazon S3
Generated backup can be stored to Google Drive
Automatically remove old backups

Screenshots

Database Backup Configuration Menu

Go to Setting --> Technical --> Backup Configuration to configure backups

Create New Database Backup Configuration

Enter the Database Name and Master Password. Specify Backup Destination. Enter the backup directory path, if directory does not exist new directory will be created.

Store Backup to Remote SFTP Server

Select Backup Destination as SFTP, enter credentials. "TEST CONNECTION" button to check whether the connection is successful.

Store Backup to Remote FTP Server

Select Backup Destination as FTP, enter credentials. "TEST CONNECTION" button to check whether the connection is successful.

Store Backup to Google Drive

You'll need to create a new Google API project and enabling the Google Drive API, Go to the Google API Console and log into your account. While creating the project, for the Redirect URI restrictions, copy your Odoo database URI followed by /google_drive/authentication. Example:

ENABLE API AND SERVICES

ENABLE GOOGLE DRIVE API

Create Credentials, Follow the steps, select Website application for the Application Type.

Under the Authorized JavaScript Origins section, click + Add URI and type your company's Odoo URL address. Under the Authorized redirect URIs section, click + Add URI and type your company's Odoo URL address followed by /google_drive/authentication. After all the steps are completed, A Client ID and Client secret will be given, copy the credentials

Go to the "OAuth consent screen", then Test users and click on 'ADD USERS' then add the user.

You can get the drive folder id from the url of the drive folder.

Configure Backup, Copy Client ID and Client Secret from Google Drive API Credentials and paste into their respective fields.

Setup Token, it will be redirected to an authorization page.


Reset the token if required by clicking on the "Reset Token"

Store Backup to Dropbox

To get the app key and secret key go to the App Console. Create a new app

Once you created the App , you can get the App key and App Secret as seen in the screenshot Choose your app's permission (files.content.write and files.content.read permissions required).then click on Submit Choose Dropbox as that of the backup destination. Enter the app secret and key and dropbox Folder.

Click on the Setup Token

Get the Authorization Code and click confirm.

Reset the refresh token if required by clicking on the "Reset Token"

Store Backup to Onedrive

Select Backup Destination as OneDrive. Enter the App key and App secret. you'll need to register a new app in the Microsoft Azure portal. While registering the app for the Redirect URI restrictions, copy your Odoo database URI followed by /onedrive/authentication. Example:

Copy the Client ID

Generate Client Secret.

Get OneDrive folder ID, where need to store the backup files.

Configure the Backup

Setup Token, it will be redirected to an authorization page.

Reset the token if required by clicking on the "Reset Token"

Store Backup to Nextcloud

To Create an account in Nextcloud go to https://nextcloud.com/sign-up/, Enter Your Email Address and Sign up .

You will be redirected to the page as shown in the screenshot, and it will ask you enter your email and password for the Nextcloud.

To get the Domain of the Nextcloud.Go to Settings in the Nextcloud and Click on Mobile & desktop. You will see server address Copy link and paste it in your Domain Name.

Select the backup destination as Nextcloud. Enter the Domain Name, UserName, Password and Folder Name where you want to store your backup on the NextCloud server. Check the Connect button to check if the connection is successful.

Every day, a Scheduled Action will take place to store a backup on the Nextcloud Server. The backup will be stored as the folder name provided in the Folder ID field in Odoo.

Store Backup to Amazon S3

To Create an account in Amazon S3 go to https://portal.aws.amazon.com/billing/signup#/start/email, Enter Your Email Address and Sign up .

After you created the account.You need to get the Access Key and Secret Key,To get these go the account Security credentials and go the Access Keys and create new access keys from there you will get Access Key and Secret Key.

Next You need to create a Bucket Folder in the Amazon S3.To do that Go the Services in the top right and go to Storage and S3 as shown in the Screen shot.

To create Bucket folder,Click on the Create bucket Button.

On Creating a Bucket Folder,Check the rules for naming the Bucket folder,and Select the region as well.After that click on the create Bucket Button in the bottom of the page.

You will see the Bucket Folder as shown in the screenshot.

Select Backup Destination as Amazon S3. Enter the Amazon S3 Access Key,Amazon S3 Secret Key,Bucket Name->Bucket folder you have created in the Amazon S3 and the File Name->The Folder You want to store your backup in Amazon S3 Bucket Folder.Test connection button to check whether the connection is successful.

Every day, a Scheduled Action will take place to store a backup on the Amazon S3 Server. The backup will be stored as the folder name provided in the File Name field in Odoo.

Automatically Remove Old Backups

Enable auto remove option, specify number of days to remove backups.

Notify User on Success and Failure of Backup Generation

Enable notify user option, and select a user to notify. An email notification will be sent to the selected user on backup successful and failure.

Successful backup notification email

Notification email when backup generation failed

Scheduled Action For Generating Backup

Enable the 'Automatic database Backup' scheduled action, and set up the execution interval. Based on the scheduled action setup, backups will be generated on regular intervals.

Suggested Products


Our Services

Odoo Customization
Odoo Implementation
Odoo Support
Hire Odoo Developer
Odoo Integration
Odoo Migration
Odoo Consultancy
Odoo Implementation
Odoo Licensing Consultancy

Our Industries

Trading

Easily procure and sell your products

POS

Easy configuration and convivial experience

Education

A platform for educational management

Manufacturing

Plan, track and schedule your operations

E-commerce & Website

Mobile friendly, awe-inspiring product pages

Service Management

Keep track of services and invoice

Restaurant

Run your bar or restaurant methodically

Hotel Management

An all-inclusive hotel management application

Support

Need Help?

Got questions or need help? Get in touch.

odoo@cybrosys.com

WhatsApp

Say hi to us on WhatsApp!

+91 86068 27707

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
All Apps of Cybrosys have Abracadabra
by
fonsecapinzon@gmail.com
on 10/2/23, 9:19 PM

I try install but in first instance tell  Python library not installed: dropbox

Re: All Apps of Cybrosys have Abracadabra
by
Cybrosys Technologies
on 10/3/23, 6:23 AM Author

Say Abracadabra! 
Then run pip3 install dropbox 
this issue will be resolved.


by
Kahina
on 9/27/23, 4:58 AM

The app is not functioning as expected. Despite enabling email notifications, I have not received any emails notifying me of backup failures. Additionally, when attempting to manually trigger the automated action, I encounter the following error message : 

ValueError: : "'


Re:
by
Cybrosys Technologies
on 10/6/23, 1:54 AM Author

The issue couldn't be reproduced. Please share more details, such as the configuration screenshot and full error message to odoo@cybrosys.com


ValueError: <class 'psycopg2.errors.UndefinedColumn'>: "column db_backup_configure.onedrive_client_id does not exist
by
Sera Egypt
on 7/18/23, 4:11 AM

i am trying to run manual backup

it showing me that error

auto_database_backup-15.0.3.1.2

ValueError: psycopg2.errors.UndefinedColumn'>: "column db_backup_configure.onedrive_client_id does not exist
LINE 1: ..."."generated_exception" as "generated_exception", "db_backup...
^
" while evaluating
'model._schedule_auto_backup()'


Re: ValueError: <class 'psycopg2.errors.UndefinedColumn'>: "column db_backup_configure.onedrive_client_id does not exist
by
Cybrosys Technologies
on 7/31/23, 2:47 AM Author

Please download the latest module again and try upgrading the module. If the issue persists, please let us know more about your configurations.


Nice module. I like it.
by
Reto Rayen
on 12/7/22, 8:24 AM

Hello guys. We had setup your module. It works as expected. But it looks like, that the module is not 100% odoo version 15 compliant. From time to time we get always some warning logs.


odoo.fields: Field db.backup.configure.onedrive_client_secret: unknown parameter 'compy', if this is an actual parameter you may want to override the method _valid_field_parameter on the relevant model in order to allow it
Re: Nice module. I like it.
by
Cybrosys Technologies
on 2/7/23, 1:24 AM Author

We have updated the module. Please get the latest version


Good application to manage the auto-backup. But Facing issue with office365 onedrive
by
systemsauditor@shkmbk.ae
on 9/2/22, 2:22 AM

But Facing issue with office365 onedrive to map the folder id.


Backup generation of the database ADPM123 has been Failed.

Database Name: ADPM123
Destination: Onedrive
Backup Type: zip

Error Message:
Invalid URL 'None': No schema supplied. Perhaps you meant http://None?



Perfect but
by
Yann JAMMES
on 7/10/22, 5:43 AM

You should inform on the page off the apps that users need to install "dropbox" module on their python environnement for this to install whitout errors

Re: Perfect but
by
Cybrosys Technologies
on 7/11/22, 12:59 AM Author

Thanks for the feedback


We can't install it
by
jean
on 6/28/22, 2:06 PM

Hi when we try to install it, we have an error 

Re: We can't install it
by
Cybrosys Technologies
on 6/29/22, 2:28 AM Author

Could you please share the error with us?
You can send an email to odoo@cybrosys.com


thank you
by
Muhammad Eltyar
on 5/22/22, 6:06 AM



Don't Work
by
rafael.sabino@webvirtual.com.br
on 5/7/22, 6:19 PM

Does not work. It is generating the zeroed database backup script. Without any data.

Re: Don't Work
by
Cybrosys Technologies
on 5/9/22, 1:46 AM Author

Hi, Could you please send more details to odoo@cybrosys.com?
We couldn't find any issues as you mentioned.


Error despite install all required packages
by
BayramKebapEvi
on 11/23/23, 6:52 AM

I installed dropbox and paramiko libraries but it still gives error when trying to install module

Error:

Traceback (most recent call last):
  File "/odoo/odoo15/odoo/odoo/http.py", line 654, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/odoo/odoo15/odoo/odoo/http.py", line 301, in _handle_exception
    raise exception.with_traceback(None) from new_cause
AttributeError: module 'cryptography.utils' has no attribute 'DeprecatedIn37'

When tring to install it doesn't install and gives error like this (Odoo version Community 15)

Re: Error despite install all required packages
by
Cybrosys Technologies
on 12/19/23, 12:03 AM Author

This error can be occurring due to a wrong installation for the cryptography package. 
Please try uninstalling and reinstalling the package.
pip uninstall cryptography
pip install cryptography


by
Håkon Vad
on 10/17/23, 8:04 AM

by
Kahina
on 9/27/23, 5:10 AM

The app is not functioning as expected. Despite enabling email notifications, I have not received any emails notifying me of backup failures. Additionally, when attempting to manually trigger the automated action, I encounter the following error message : 

ValueError: : "'



Compatibility
by
Gustavo Valverde
on 5/26/23, 3:56 PM

Great module. 

Does it work with odoo.sh?

Re: Compatibility
by
Cybrosys Technologies
on 5/28/23, 11:52 PM Author

No, it wont


this is a good module
by
ismael
on 5/20/23, 9:48 PM

This is a good modul but it is  no working with docker container 

Re: this is a good module
by
Cybrosys Technologies
on 6/19/23, 5:19 AM Author

Kindly provide the details of the Backup Destination used for storing the backup, and kindly include error messages present in the log, if there are any. You can write to odoo@cybrosys.com



i cant install module
by
waayeel tech
on 2/16/23, 5:21 AM

i cant install module i am getting this massage "  Unable to install module "auto_database_backup" because an external dependency is not met: Python library not installed: dropbox" 

Re: i cant install module
by
Cybrosys Technologies
on 2/19/23, 11:51 PM Author

You have to install the python dependency package 'dropbox' first.


by
a7med.nor@gmail.com
on 12/20/22, 6:21 PM

Invalid Origin: URIs must not contain a path or end with "/". ADD URI


when i add the URI

Re:
by
Cybrosys Technologies
on 1/24/23, 2:12 AM Author

The http is only valid with localhost. In the Redirect URI, please add your company’s Odoo URL address followed by /onedrive/authentication.If your Odoo URL is https://mycompany.odoo.com then add Redirect URI as https://mycompany.odoo.com/onedrive/authentication.


Automatic Backup to Google Drive
by
Riski Linda Puspita Sari
on 7/12/22, 9:35 PM

I can't do automatic backups on Google Drive, there's no database backed up in my Google Drive folder. does anyone know about this problem? thanks

Re: Automatic Backup to Google Drive
by
Cybrosys Technologies
on 7/13/22, 2:08 AM Author
Please ensure that the Google drive refresh token is set from the general settings and given the correct folderID in the backup configuration.