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
- Akuntansi
- Inventaris
- PoS
- Project
- MRP
Pertanyaan ini telah diberikan tanda
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
Menikmati diskusi? Jangan hanya membaca, ikuti!
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
DaftarPost Terkait | Replies | Tampilan | Aktivitas | |
---|---|---|---|---|
|
0
Mar 16
|
5094 | ||
|
4
Des 23
|
22074 | ||
|
0
Des 18
|
5493 | ||
|
2
Nov 24
|
4870 | ||
|
6
Des 22
|
15285 |
See odoo configuration file: http://learnopenerp.blogspot.com/2019/10/odoo-configuration-file.html