I have installed OPENERP into the cloud in EC2, which it was a success. Now I am trying to have my DB in RDS (AMAZON), which it accepts postgres as DB. I have tried modify the config file,
; This is the password that allows database operations:
; admin_passwd = admin
db_host = 'postgresql.c8be59frvnrc.us-east-1.rds.amazonaws.com'
db_port = 5432
db_user = openerp
db_password = openerp
db_name = openerp
logfile = /var/log/openerp/openerp-server.log
but when i load the openerp-server, it stills shows "database hostname: localhost" and it doesn't even try to connect to the RDS.
The configuration is very similar to the one when everything in the same server (the EC2). You should point to the RDS dns name (instead IPs) and use the very same user and password you set when you created the RDS instance. In EC2 you can install also the PSQL client to access via command line to your RDS. It's importan to consider the version of the Postgres you installed in the EC2, because RDS it's always updated and it doesn't work if you try to connect with a different version of PSQL client.
I had a problem when backing up the database from the browser (odoo8.0), because previously in EC2 I had PSQL 9.3, while RDS was 9.5, so I had to install postgres 9.5 in the EC2, and also reset the link for pg_dump
pg_dump -> /usr/lib/postgresql/9.5/bin/pg_dump
This is part of the odoo-USER1-server.conf.
[options]; This is the password that allows database operations:
admin_passwd = ADMINPASS_FOR_ODOO
db_host = EXAMPLERDSDNSNAME.ccebtp93ib46.us-west-2.rds.amazonaws.com
db_port = 5432
db_user = USER1
db_password = PASSUSER1
logfile = /var/log/USER1/odoo-USER1-server.log
You can have also have more than one Odoo instance within the same EC2 and the same RDS by setting different configuration files, like odoo1-server.conf, odoo2-server.conf, odooN-server.conf and using different RDS users in each file. The effect is that each odoo enviroment will only see the databases created with that specific user.
I've configured Odoo/OpenERP to work properly with Amazon RDS.
The steps are:
1. Create your Amazon RDS database. In that process, you will provide a Postgres user name + pass and at the end you will be given: an endpoint (server name + port number, default port is 5432)
2. In the Odoo/OpenERP configuration file, write down the parameters below:
db_host = your_endpoint_name_without_port_number_and_without_any_quotes
db_password = your_postgres_passwd
db_port = 5432
3. Restart Odoo to enable these changes.
4. If your Odoo/OpenERP server is an AWS EC2 server, you should note that AWS resolves your db server endpoint with the private IP. Make sure that you add a security rule to your security group that allows the AWS EC2 server to access the RDS server (your db server on Amazon).
That's all! Please upvote this answer if it works for you too. Thanks!
Does anyone work out how to get it sorted? It should be an interesting topic to explore. From the idea of backup in S3, I think there should be some configuration to connect EC2 with DB. For back up in S3, s3cmd is installed. visit here:http://s3tools.org/s3cmd
I searched online and found this: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToPostgreSQLInstance.html
I will try that later.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 1/23/14, 9:40 PM|
|Seen: 4126 times|
|Last updated: 10/3/16, 8:07 PM|