コンテンツへスキップ
メニュー
この質問にフラグが付けられました
3 返信
13999 ビュー

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

アバター
破棄
最善の回答

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!



アバター
破棄
最善の回答

Hi,

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

アバター
破棄
最善の回答

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
アバター
破棄
関連投稿 返信 ビュー 活動
0
3月 16
5089
4
12月 23
22072
0
12月 18
5488
2
11月 24
4864
6
12月 22
15279