[GeoNode-users] GeoNode-Project Docker Postgres Access
Julierme Pinheiro
juliermeopensourcedeveloper at gmail.com
Mon Jan 14 09:38:11 PST 2019
Hi Francesco,
Just to emphasize that IP 172.21.14.02 is CenTOS7 VM in which
geonode-project at 2.8 is installed via docker.
I can ping 172.21.14.02 from my workstation, however the connection from my
workstation to the db4my_geonode container in the VM, returns the following:
psql -h 172.21.14.02 -U geonode -d geonode
psql: could not connect to server: No route to host
Is the server running on host "172.21.14.02" and accepting
TCP/IP connections on port 5432?
Regards
Julierme
On Mon, Jan 14, 2019 at 3:26 PM Julierme Pinheiro <
juliermeopensourcedeveloper at gmail.com> wrote:
> Hi Francesco,
>
> Thank you very much for your reply.
>
> I changed the docker-compose.override.yml from localhost to 172.21.14.02
> (Centos7 VM IP running GeoNode-Project installed via docker). After doing
> that, geonode django and celery container logs point to the error:
>
> django4my_geonode | django.db.utils.OperationalError: could not connect to
> server: No route to host
> django4my_geonode | Is the server running on host "localhost" (::1)
> and accepting
> django4my_geonode | TCP/IP connections on port 5432?
>
> Trying to solve this issue, as localhost corresponds to 172.21.14.02, I
> went to local_settings and changed from DATABASES: { HOST: 'localhost' ,
> to DATABASES: { HOST: '172.21.14.02'}, geonode django and celery container
> logs point to the error:
>
> django4my_geonode | django.db.utils.OperationalError: could not connect to
> server: No route to host
> django4my_geonode | Is the server running on host "172.21.14.02" and
> accepting
> django4my_geonode | TCP/IP connections on port 5432
>
> The error remains the same.
>
> Yes. db4my_geonode is up and running. And find bellow the outcome for
> docker-compose ps:
>
> celery4my_geonode /usr/src/my_geonode/entryp ...
> Restarting
> db4my_geonode docker-entrypoint.sh postgres Up
> 5432/tcp
> django4my_geonode /usr/src/my_geonode/entryp ...
> Restarting
> elasticsearch4my_geonode /docker-entrypoint.sh elas ... Up
> 9200/tcp, 9300/tcp
> geoserver4my_geonode /usr/local/tomcat/tmp/entr ... Up
> 8080/tcp
> gsconf4my_geonode /bin/true Exit
> 0
> nginx4my_geonode nginx -g daemon off; Up
> 0.0.0.0:80->80/tcp
> rabbitmq4my_geonode docker-entrypoint.sh rabbi ... Up
> 25672/tcp, 4369/tcp, 5671/tcp, 5672/tcp
>
> In order to access geonode site from my workstation, I am supposed to
> configure DATABASES as HOST:'172.21.14.02'. Am I correct? If so, why the
> database connection has been refused?
>
> Talking to some IT colleagues, they said that I may be having problem
> because, the geonode server IP (172.21.14.02) is in our network, however
> db4my_geonode container IP 172.27.0.6 is out of our network. But as
> docker-compose ps showed the server 172.21.14.02, port 5432 is being used
> by db4my_geonode container. I can not really figure out what is going on!!!!
>
> Any help on that will be very appreciated.
>
> Kind regards
>
> Julierme
>
>
>
>
>
>
>
>
>
>
> On Mon, Jan 14, 2019 at 1:22 PM Francesco Bartoli <xbartolone at gmail.com>
> wrote:
>
>> Hi Julierme,
>>
>> Where are you trying to run the test? Is the container related to the
>> service “db” running? What’s the output of docker-compose ps?
>> Il 14 gen 2019, 16:09 +0100, Julierme Pinheiro <
>> juliermeopensourcedeveloper at gmail.com>, ha scritto:
>>
>> Trying to answer question 3, I ran a test:
>> psql -h 172.21.14.02 -U geonode -d geonode
>>
>> psql: could not connect to server: No route to host
>> Is the server running on host "172.21.14.02" and accepting
>> TCP/IP connections on port 5432?
>>
>> Though /var/lib/postgresql/data/pg_hba.conf is set to trust (see
>> bellow), I can not understand why the connection to postgres is not
>> successful.
>>
>> local all all trust
>>
>> Any comment on this matter will be very appreciated.
>>
>> Kind regards
>>
>> Julierme
>>
>>
>> On Mon, Jan 14, 2019 at 12:30 PM Julierme Pinheiro <
>> juliermeopensourcedeveloper at gmail.com> wrote:
>>
>>> Regarding my previous 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>
>>> ?
>>>
>>> I think so. Because I found all the databases and user configured into
>>> db4my_geonode container.
>>>
>>> 2 - Could the error in the log file (geonode-project server
>>> 172.21.14.02) be related to pg_hba.conf file (local connections)?
>>>
>>> I do not think so. Because looking at
>>> /var/lib/postgresql/data/pg_hba.conf in db4my_geonode, the cofiguration is
>>> set as:
>>>
>>> local all all trust
>>>
>>> Within these two answers I should not have gotten any problem by
>>> configuring HOST: '172.21.14.02' in local_settings / DATABASES: {...}
>>>
>>> I am still thinking about question 3:
>>>
>>> Is there any postgres (db4my_geonode container) configuration in
>>> geonode-project server 172.21.14.02 that I must do, before using it as HOST
>>> value in local_settings / DATABASES = {...}?
>>>
>>> Thank you for your time in advance
>>>
>>> Kind regards
>>>
>>> Julierme
>>>
>>>
>>>
>>> On Mon, Jan 14, 2019 at 12:01 PM Julierme Pinheiro <
>>> juliermeopensourcedeveloper at gmail.com> wrote:
>>>
>>>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>> geonode-users mailing list
>> geonode-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/geonode-users
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20190114/760ce5d8/attachment.html>
More information about the geonode-users
mailing list