How do I configure OE when the server starts the dual Nic mode?

How do I configure OE when the server starts the dual Nic mode?

As we all know, in the green OE default configuration, db_host and port should be 127.0.0.1 and 5432, which refer to the address and port of the database (pg) connected to OE.

OK, no problem.

When the server is set to a dual Nic or multiple IP addresses, the problem arises. In this case, OE can be started normally, or PG can, but the 505 error will be prompted when OE is enabled.

Why?

OE points to pg address 127.0.0.1 at this time, and it is not explicitly connected to databases. Of course, if you are willing to manually modify the source code about the database in OE, you can also.

Let's change it. I won't.

I did this:

Step 1: Modify the openerp-server.conf to point to an IP address, which must not be 127.0.0.1.

Step 2: Modify the listening mode in postgresql. conf to all; otherwise, pg will start 127.0.0.1 by default.

Modification content:

#-Connection Settings-listen_addresses = '*'

The listener before modification is as follows:

TCP 127.0.0.1: 5432 0.0.0.0: 0 LISTENING

Step 3: Modify pg_cmd.conf and add the Trust List.

Add content:

Host Database Name: openerp 10.0.3.0/24 trust

Or specify the IP address/32 trust to which the host all points

The modified listener is like this.

TCP 0.0.0.0: 5432 0.0.0.0: 0 LISTENING

OK, start the pg service, start OE again, and log on normally.

-- EOF