Odoo Help

0

0
2 Answers
4
Avatar

Mohamed Elbagoury อียิปต์

--Mohamed Elbagoury--
10282
| 7 5 9
Cairo, อียิปต์
--Mohamed Elbagoury--
A well-known ERP Consultant & Trainer in MENA region with 20k connections in LinkedIn and 70k in Facebook , I involved in 28 Projects in Egypt , 7 Projects in Qatar , 6 Projects in Saudi Arabia , 3 Projects in United Arab Emirates , 3 Projects in Libya and 1 Project in Iraq , Successfully implemented ERP (onsite and on cloud) with complex Accounting , warehouse , payroll , Contracting and MRP configurations for more than 30 large companies such as (XERVON , SHIN SHIN Electronics Egypt , Panasonic Electronics Egypt , Heinz, Pharos Holding ,Universal Uniback … etc.. ) , I'm Specialist in (Odoo , Delta ERP ,Oracle E-Business Suite , SAP , Microsoft Dynamics (AX,NAV) ) , if you need consultation or you have any questions about ERP systems please don't hesitate to call me +201090091089 (WhatsApp)

Mohamed Elbagoury อียิปต์
10/11/19 04:32

Please make sure you made all the configuration like the following: 

By default, PostgreSQL only allows connection over UNIX sockets and loopback connections (from “localhost”, the same machine the PostgreSQL server is installed on).

UNIX socket is fine if you want Odoo and PostgreSQL to execute on the same machine, and is the default when no host is provided, but if you want Odoo and PostgreSQL to execute on different machines 1 it will need to listen to network interfaces 2, either:

  • Only accept loopback connections and use an SSH tunnel between the machine on which Odoo runs and the one on which PostgreSQL runs, then configure Odoo to connect to its end of the tunnel
  • Accept connections to the machine on which Odoo is installed, possibly over ssl (see PostgreSQL connection settings for details), then configure Odoo to connect over the network
  • Allow tcp connection on localhost
  • Allow tcp connection from 192.168.1.x network

in /etc/postgresql/9.5/main/pg_hba.conf set:

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
host    all             all             192.168.1.0/24          md5

in /etc/postgresql/9.5/main/postgresql.conf set:

listen_addresses = 'localhost,192.168.1.2'
port = 5432
max_connections = 80

Out of the box, Odoo connects to a local postgres over UNIX socket via port 5432. This can be overridden using the database options when your Postgres deployment is not local and/or does not use the installation defaults.

The packaged installers will automatically create a new user (odoo) and set it as the database user.

  • The database management screens are protected by the admin_passwd setting. This setting can only be set using configuration files, and is simply checked before performing database alterations. It should be set to a randomly generated value to ensure third parties can not use this interface.
  • All database operations use the database options, including the database management screen. For the database management screen to work requires that the PostgreSQL user have createdb right.
  • Users can always drop databases they own. For the database management screen to be completely non-functional, the PostgreSQL user needs to be created with no-createdb and the database must be owned by a different PostgreSQL user.

    Warning

    the PostgreSQL user must not be a superuser

  • connect to a PostgreSQL server on 192.168.1.2
  • port 5432
  • using an ‘odoo’ user account,
  • with ‘pwd’ as a password
  • filtering only db with a name beginning with ‘mycompany’

in /etc/odoo.conf set:

[options]
admin_passwd = mysupersecretpassword
db_host = 192.168.1.2
db_port = 5432
db_user = odoo
db_password = pwd
dbfilter = ^mycompany.*$

Ask a Question
Writer
ป้ายกำกับ
Keep Informed
1 ผู้ติดตาม
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register
Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now