Facebooktwittergoogle_plusredditpinterestlinkedin

Hi Everyone,

The purpose of this post is to help you configure your ADempiere or iDempiere PostgreSQL database so that you can connect to it from an external machine. There are a number of reasons why this topic is important. It helps you:

  1. Connect a separate reporting engine like Excel or a business intelligence engine like SpagoBI.
  2. Diagnose and fix a performance or data integrity issue.
  3. Separate your application server and your database for increased performance and scalability.
  4. More…

For reference, here are the instructions for installing iDempiere on a single server. The below instructions assume you have already installed PostgreSQL.

    • Issue: “sudo nano /etc/postgresql/9.1/main/pg_hba.conf”
      • The pg_pha.conf file controls authentication.
    • Add this line to the hosts list: “host  all  all  0.0.0.0/0  md5”.
      • Adding this line tells the system that all databases can be reached by all users from all destinations using the md5 authentication process.
      • You should limit the IP address to trusted sources. 0.0.0.0/0 opens the db to everyone. If you have a strong firewall configured correctly, this point is less important.
    • Issue: “sudo nano /etc/postgresql/9.1/main/postgresql.conf”.
      • The postgresql.conf controls settings for the database.
    • Look for the line “listen_addresses=’localhost'” and change ‘localhost’ to ‘*’.
      • Make sure to also uncomment the line!!! This means remove the # at the beginning.
      • Changing the ‘listen_addresses’ feature to ‘*’ tells the database to listen to all requests – not just the localhost ones.
    • Issue “sudo -u postgres /etc/init.d/postgresql restart” to restart the database.

You do not need to modify the IPTables on Ubuntu on AWS (I did not). Just in case you do, step 5 of this tutorial tells you how. For reference, here is an introduction to iptables.

I hope this helps!!!

ADempiere vs iDempiere vs Openbravo vs Compiere

Please note that ADempiere, iDempiere and Openbravo are forks or copies from Compiere. Therefore, they have similar abilities mentioned above. The biggest difference is that ADempiere and iDempiere are pure open source. There are no features held behind a commercial or paid license.

About Chuck Boecking: I am an ERP educator. I believe that open source ERP have achieved mainstream capabilities, and as a result, more companies can create greater efficiency across their organization. I started using the iDempiere code base in 2003. Back then, it was called Compiere. In 2006, I started my first multi-million dollar installation. Since then, ADempiere has helped me create great success with distribution and manufacturing companies all over the world. My vision of success is to find companies that can best use open source ERP to help them achieve a single, global instance that drives a discontinuous increase in profitability. I believe that organizations win when they own their technology.

If you have questions, comments or concerns, let me know. I definitely want your feedback.

You can contact me by phone using 512.850.6068.

My email is chuck@chuboe.com.

You can complete the form on this page.

Thank you for taking the time. I look forward to speaking with you.

Regards,
Chuck Boecking
http://www.linkedin.com/pub/chuck-boecking/10/970/17b

 

Facebooktwittergoogle_plusredditpinterestlinkedin

One thought on “How to Connect to Your ADempiere or iDempiere Database

Leave a Reply

Your email address will not be published. Required fields are marked *