[GeoNode-users] GeoNode-Project Docker Postgres Access

[Julierme Pinheiro]

Deal all,

This is not an issue, but a question regarding postgres configuration in
GeoNode-Project Docker installation.

I have 2 servers and 1 client server.

Server 1: postgres server - IP: 172.21.14.01

 I installed postgres in Server 1 (172.21.14.01) and I configured postgres
as in here
<http://docs.geonode.org/en/master/tutorials/install_and_admin/geonode_install/create_geonode_db.html>.
I created in postgres:

a user: geonode with password osgeo;
a db: geonode owned by geonode user;
a db: geonode_data owned by geonode user;
and so on.

Server 2 (CentOS7): geonode-project server - IP: 172.21.14.02

I installed geonode-project at 2.8 via Docker in server 2 and changed
localhost to 172.21.14.02 in docker-compose.override.yml file in order to
access the geonode site from the client server.

Client server: my_workstation - IP: 172.21.14.03

GeoNode-Project installation via Docker is successful if I change localhost
to 172.21.14.01 (postgres remote server) as in:
# Backend
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'geonode',
        'USER': 'geonode',
        'PASSWORD': 'geonode',
        'HOST': '172.21.14.01',
        'PORT': '5432',
        'CONN_TOUT': 900,
    },
    # vector datastore for uploads
    'datastore': {
        'ENGINE': 'django.contrib.gis.db.backends.postgis',
        # 'ENGINE': '', # Empty ENGINE name disables
        'NAME': 'geonode_data',
        'USER': 'geonode',
        'PASSWORD': 'geonode',
        'HOST': '172.21.14.01',
        'PORT': '5432',
        'CONN_TOUT': 900,
    }
}

However if I configure HOST:'172.21.14.02' or HOST: 'localhost',
geonode-project django and celery container will not go up and the log file
says respectively for HOST:'172.21.14.02' and HOST: 'localhost'
configuration:

django4my_geonode |     Is the server running on host "172.21.14.45" and
accepting
django4my_geonode |     TCP/IP connections on port 5432?

django4my_geonode |     Is the server running on host "localhost" (::1) and
accepting
django4my_geonode |     TCP/IP connections on port 5432?

Though geonode-project installation is successful, by using postgres remote
server IP: 172.21.14.01, configured manually, I do not want to use it.

I want to use geonode-project server IP:172.21.14.02.  Said that, I came
out with  the following questions:

1 - When installing geonode-project via docker, is postgres configuration
set automatically as in here
<http://docs.geonode.org/en/master/tutorials/install_and_admin/geonode_install/create_geonode_db.html>
?

2 - Could the error in the log file (geonode-project server 172.21.14.02)
be related to  pg_hba.conf file (local connections)?

3 - Is there any postgres (geonode/postgis container) configuration in
geonode-project server 172.21.14.02 that I must do, before using it as HOST
value in local_settings / DATABASES = {...}?

My apologies for the long e-mail and thank you very much for your time and
patience.

Kind regards

Julierme
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20190114/a0393aec/attachment.html>