Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
3 Risposte
14186 Visualizzazioni

i installed odoo on ubuntu server (AWS) and then i created database locally 
but now i want to configure RDS managed DB with Odoo running on EC2 instance.
how can i do something like that
i read some tutorial but need more explain
thanks

Avatar
Abbandona
Risposta migliore

Hi, 

First do what @FaisalAnsari says:

Go to RDS and create a database in PostgreSQL and configure the server.conf file as the given below

[options]
;This is the password that allows database operations:
;admin_passwd = admin
db_host = rds_endpoint (after creating database you will get rds_endpoint)
db_port = False
db_user = "user name which is created by you to the database"
db_password = "password which is created"
;addons_path = /home/deadpool/workspace/odoo_13_community/custom_addons, /home/deadpool/workspace/odoo_13_community/custom_addons

Then go to the command line and do the following:

1. stop your odoo instance

    ~$ service odoo stop

2. Enable command line for the user odoo

   ~$ chsh -s /bin/bash odoo

3. execute odoo from command line as user odoo

    ~$ runuser -l odoo -c "odoo -i base -d YourRDSDatabase --db_host YourAmazonRDSHost.Address.rds.amazonaws.com -r YourRDSDatabaseUserName -w YourRDSDatabasePassword --stop-after-init"

4. After the initialization finished, start odoo service

    ~$ service odoo start

Troubleshooting:

if odoo doesn't start correctly make sure that the database user in your RDS instance have privileges at least on the database you are using. 

    ~$ psql --host=YourAmazonRDSHost.Address.rds.amazonaws.com --port=5432 --username=YourRDSDatabaseUserName --password --dbname=YourRDSDatabase

and when you are inside postgresql type the following: 

    ~$ grant all privileges on database YourRDSDatabase to YourRDSDatabaseUserName;

    ~$ \q

and try again from step 3.


Hope this help!



Avatar
Abbandona
Risposta migliore

Hi,

Which instance type have you chosen for DB? Was it Was it db.t3.micro?

Avatar
Abbandona
Risposta migliore

Go to RDS and create a database in PostgreSQL and configure the server.conf file as the given below

[options] 
;This is the password that allows database operations:
;admin_passwd = admin
db_host = rds_endpoint (after creating database you will get rds_endpoint)
db_port = False 
db_user = "user name which is created by you to the database"
db_password = "password which is created"
;addons_path = /home/deadpool/workspace/odoo_13_community/custom_addons, /home/deadpool/workspace/odoo_13_community/custom_addons
Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
0
mar 16
5247
4
dic 23
22243
0
dic 18
5663
2
nov 24
5115
6
dic 22
15566