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
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
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
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
0
Mar 16
|
3987 | ||
|
4
Dec 23
|
20812 | ||
|
0
Dec 18
|
4519 | ||
|
2
Nov 24
|
3129 | ||
|
6
Dec 22
|
13558 |
See odoo configuration file: http://learnopenerp.blogspot.com/2019/10/odoo-configuration-file.html