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
- Contabilidad
- Inventario
- PoS
- Project
- MRP
Se marcó esta pregunta
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
¿Le interesa esta conversación? ¡Participe en ella!
Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.
InscribirsePublicaciones relacionadas | Respuestas | Vistas | Actividad | |
---|---|---|---|---|
|
0
mar 16
|
5092 | ||
|
4
dic 23
|
22072 | ||
|
0
dic 18
|
5492 | ||
|
2
nov 24
|
4867 | ||
|
6
dic 22
|
15283 |
See odoo configuration file: http://learnopenerp.blogspot.com/2019/10/odoo-configuration-file.html