How to allow localhost access /web/database/backup

Question

Hi,

We are using list_db=False in my odoo.conf and cron job to do daily backup. I found it impractical to have to reload the odoo config everytime the cron job do a backup.

Currently, we use `list_db=False` to disable the database manager from the world so no one can access it. I would like to know if there is an option to disable the database manager while at the same time give localhost access to send request to /web/database/backup

Aside from manipulating the proxy config.

Sincerely,
Jaso

Jason · Answer

@Ravi Gadhia
I see. Thank you for the answer, I appreciate it although I see Yenthe666's solution to be impractical, hosting the module on the same host, in case of an emergency such as data loss.
The conclusion I have right now there is no option aside using third party. I will be creating a cron job with a bash file and add these line of code.
location /web/database/ {
allow ip;
deny all;
}

Ravi Gadhia · Answer

you can achieve it by list_db=True in config but block the related endpoint at Nginx configuration
so the internet couldn't access it but it's accessible by localhost. this is a tricky solution
Good news is yenthe auto-backup module recently updated and it enables auto-back functionality even list_db=False
https://github.com/Yenthe666/auto_backup/commit/c7d0512a0d0b2d42662831008e7a9316b264f23e [1]

[1] https://github.com/Yenthe666/auto_backup/commit/c7d0512a0d0b2d42662831008e7a9316b264f23e

This question has been flagged

Enjoying the discussion? Don't just read, join in!