Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
3 Odpowiedzi
14104 Widoki

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

Awatar
Odrzuć
Najlepsza odpowiedź

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!



Awatar
Odrzuć
Najlepsza odpowiedź

Hi,

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

Awatar
Odrzuć
Najlepsza odpowiedź

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
Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
0
mar 16
5183
4
gru 23
22138
0
gru 18
5613
2
lis 24
4988
6
gru 22
15403