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
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Kế toán
- Tồn kho
- PoS
- Project
- MRP
Câu hỏi này đã bị gắn cờ
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
Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng kýBài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
---|---|---|---|---|
|
0
thg 3 16
|
5096 | ||
|
4
thg 12 23
|
22076 | ||
|
0
thg 12 18
|
5496 | ||
|
2
thg 11 24
|
4877 | ||
|
6
thg 12 22
|
15294 |
See odoo configuration file: http://learnopenerp.blogspot.com/2019/10/odoo-configuration-file.html