Support tool Odoo app: 4b764e10-cf55-a52a-341e-f22490727ccd

pjguerra 2020-05-13 04:33:47 UTC #1

Keywords: Odoo - AWS - Technical issue - Other
bnsupport ID: 4b764e10-cf55-a52a-341e-f22490727ccd
Description:
I follow the instructions step by step to restore a database:
https://docs.bitnami.com/aws/apps/odoo/administration/backup-restore-postgresql/
But gor error and couldn't access my DB ater that

davidg 2020-05-13 09:10:28 UTC #2

Hello @pjguerra,

I think this is the same issue that this case, right? Please, only open new cases for different issues.

The team will check your issue and reply to you soon.

Regards

pjguerra 2020-05-13 13:22:01 UTC #3

No, its different server, different issue.
Las ticket was issue 4d3aefbe-37ba-d823-b468-b23c50845bc8 on my mac
This ticket is issue: 4b764e10-cf55-a52a-341e-f22490727ccd in AWS cloud
server

Im ready to start using it so I was configuring it but got this problem.
Completely different servers.

davidg 2020-05-14 09:15:51 UTC #4

Ok, thanks for clarifying it.

In your support tool output I can see this:

-----------------------------------
Get the ctlscript status
-----------------------------------
Running: ./ctlscript.sh status
In: /opt/bitnami

Output:

apache already running
odoo_gevent not running
odoo_background_worker not running
postgresql already running

Could you try to execute this command?:

sudo /opt/bitnami/ctlscript.sh start odoo_background_worker

Verify if the service is properly started:

sudo /opt/bitnami/ctlscript.sh status odoo_background_worker

pjguerra 2020-05-15 12:54:02 UTC #5

Hi
I have tried executing this command:
sudo /opt/bitnami/ctlscript.sh start odoo_background_worker

and the output was:
/opt/bitnami/apps/odoo/scripts/odoo_background_worker.sh :
odoo_background_worker could not be started

jariza 2020-05-19 07:43:39 UTC #6

Hi @pjguerra

Your /opt/bitnami/apps/odoo/log/production.log log is filled with errors like the one below:

2020-05-13 04:23:36,419 3438 INFO ? odoo: database: bn_odoo@127.0.0.1:5432
2020-05-13 04:23:36,420 3438 INFO ? odoo.sql_db: Connection to the database failed

Could you check if the database credentials available at /opt/bitnami/apps/apps/odoo/conf/odoo-server.conf are the same ones you created while restoring the database backup?

Best regards,

Juan Ariza

pjguerra 2020-05-19 22:42:46 UTC #7

I don't know how to check that.

I can give you the data of odoo-server.conf:

[options]
addons_path = /opt/bitnami/apps/odoo/lib/odoo-13.0.post20200415-py3.7.egg/odoo/addons
admin_passwd = xx
csv_internal_sep = ,
data_dir = /opt/bitnami/apps/odoo/data
db_host = 127.0.0.1
db_maxconn = 64
db_name = bitnami_odoo
db_password = xx
db_port = 5432
db_sslmode = prefer
db_template = template0
db_user = bn_odoo
dbfilter = .*
demo = {}
email_from = user@example.com
geoip_database = /usr/share/GeoIP/GeoLite2-City.mmdb
http_enable = True
http_interface =
http_port = 8069
import_partial =
limit_memory_hard = 2684354560
limit_memory_soft = 2147483648
limit_request = 8192
limit_time_cpu = 60
limit_time_real = 120
limit_time_real_cron = -1
list_db = True
log_db = False
log_db_level = warning
log_handler = :INFO
log_level = info
logfile = /opt/bitnami/apps/odoo/log/production.log
longpolling_port = 8072
max_cron_threads = 2
osv_memory_age_limit = 1.0
osv_memory_count_limit = False
pg_path = /opt/bitnami/postgresql/bin
pidfile =
proxy_mode = False
reportgz = False
screencasts =
screenshots = /tmp/odoo_tests
server_wide_modules = base,web
smtp_password = False
smtp_port = 25
smtp_server = localhost
smtp_ssl = False
smtp_user = False
syslog = False
test_enable = False
test_file =
test_tags = None
translate_modules = ['all']
unaccent = False
upgrade_path =
without_demo = 1
workers = 0

Can you see something there that shouldn't be there?

jariza 2020-05-20 06:35:54 UTC #8

Hi @pjguerra

As you can see, there are a group of settings which names starts with the db_ prefix:

db_host = 127.0.0.1
db_maxconn = 64
db_name = bitnami_odoo
db_password = xx
db_port = 5432

These are the database settings used by Odoo to access the database. I want you to use a PostgreSQL client and these settings to ensure you can connect to the PostgreSQL service using them (see https://docs.bitnami.com/general/apps/odoo/get-started/connect-postgresql/).

Best regards,

Juan Ariza

pjguerra 2020-05-20 19:34:14 UTC #9

I have access postgres: https://prnt.sc/sklxan as the information here:

But now I really don't know what commands should I use to test the DB. Could you help me giving them to me please?

How do I use this credentials to test PostgreSQL

jariza 2020-05-21 07:09:22 UTC #10

Hi @pjguerra

You need to connect to your Odoo instance via SSH and the execute the command below replacing the YOUR-PASSWORD placeholder with the value you obtained from the odoo-server.conf file:

PGPASSWORD=YOUR-PASSWORD psql -h 127.0.0.1 bitnami_odoo bn_odoo

If the command above shows you any error such as the one below, that means that db settings are not correctly configured in Odoo, and that's the reason why you're facing this issue.

psql.bin: FATAL:  password authentication failed for user "bn_odoo"

If that's the case, you'll have to edit the odoo-server.conf file so the credentials are the same you used when following this guide: https://docs.bitnami.com/aws/apps/odoo/administration/backup-restore-postgresql/
In other words, the db_password, db_user, etc. settings should match the BITNAMI_USER_PASSWORD, USER_NAME, etc. values you used when following the guide.

Best regards,

Juan Ariza

pjguerra 2020-05-24 04:09:22 UTC #11

Hi
I get this: https://prnt.sc/smnzee it seems there is no error.
On YOUR_PASSWORD I enter db_password found on odoo-server.conf (just in case I assume wrong)

Still when trying to access it: http://54.226.29.178 I get 500 internal Server Error. Good news is that when I run sudo /opt/bitnami/ctlscript.sh status all services are running.

jariza 2020-05-25 07:55:21 UTC #12

Hi @pjguerra

Let's try to configure Odoo with "root" access the the PostgreSQL database so it can perform any required action to recover its db.

Using a file editor, edit the properties below in the /opt/bitnami/apps/apps/odoo/conf/odoo-server.conf file:

db_password = XXXXX
db_user = bn_odoo

with the values below, where YYYYY is the database password for the "postgres" user (chek this docs):

db_password = YYYYY
db_user = postgres

Then, restart the services running the command below:

sudo /opt/bitnami/ctlscript.sh restart

Finally, try to access to your site again.

Best regards,

Juan Ariza

pjguerra 2020-05-25 12:27:38 UTC #13

I have enter the file: sudo nano /opt/bitnami/apps/odoo/conf/odoo-server.conf

After that I have modified:

db_password = (the one I get with this command: `sudo cat /home/bitnami/bitnami_credentials`)
db_user = postgres

Restart service
Get this message:

/opt/bitnami/postgresql/scripts/ctl.sh : postgresql  started at port 5432
/opt/bitnami/apps/odoo/scripts/odoo_gevent.sh : odoo_gevent could not be started
/opt/bitnami/apps/odoo/scripts/odoo_background_worker.sh : odoo_background_worker could not be started
Syntax OK
/opt/bitnami/apache2/scripts/ctl.sh : httpd started at port 80

jariza 2020-05-26 07:14:31 UTC #14

Hi @pjguerra

Let's try to understand why odoo_gevent and odoo_background_worker services cannot be started.

Do you see anything new in the /opt/bitnami/apps/odoo/log/production.log?

What do you obtain when you run the commands below?

Manually start odoo_background_worker

sudo su - daemon -s /bin/sh -c "(cd /opt/bitnami/apps/odoo && /opt/bitnami/apps/odoo/bin/odoo-bin -c /opt/bitnami/apps/odoo/conf/odoo-server.conf --max-cron-thread 0 2>&1) &"

Manually start odoo_gevent:

sudo su - daemon -s /bin/sh -c "(cd /opt/bitnami/apps/odoo && /opt/bitnami/apps/odoo/bin/odoo-bin gevent -c /opt/bitnami/apps/odoo/conf/odoo-server.conf --max-cron-thread 0 2>&1) &"

Best regards,

Juan Ariza

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!