<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
<div name="messageBodySection" style="font-size: 14px; font-family: -apple-system, BlinkMacSystemFont, sans-serif;">glad you solved</div>
<div name="messageSignatureSection" style="font-size: 14px; font-family: -apple-system, BlinkMacSystemFont, sans-serif;"><br />
Ciao<br />
Francesco</div>
<div name="messageReplySection" style="font-size: 14px; font-family: -apple-system, BlinkMacSystemFont, sans-serif;">Il 15 gen 2019, 13:09 +0100, Julierme Pinheiro <juliermeopensourcedeveloper@gmail.com>, ha scritto:<br />
<blockquote type="cite" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #1abc9c;">
<div dir="ltr">
<div>Hi Francesco,</div>
<div><br /></div>
<div>I got it. I do not know if makes sense. GeoNode-Project@2.7 had HOST:'db' in its local_settings. In my case, in order to have GeoNode -Project working after setting docker-compose.override.yml to 172.21.14.02, I had to change from HOST: 'localhost' to HOST: 'db'.Now, it is working.<br /></div>
<div><br /></div>
<div>I appreciated your time and patience</div>
<div><br /></div>
<div>Kind regards</div>
<div><br /></div>
<div>Julierme<br /></div>
</div>
<br />
<div class="gmail_quote">
<div dir="ltr">On Mon, Jan 14, 2019 at 7:46 PM Francesco Bartoli <<a href="mailto:xbartolone@gmail.com">xbartolone@gmail.com</a>> wrote:<br /></div>
<blockquote class="gmail_quote" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #e67e22;">
<div>
<div name="messageBodySection">Right but I believe that is optional, and if applied you have to make sure to understand what are the consequences in overriding some variables of base settings.</div>
<div name="messageSignatureSection"><br />
Ciao<br />
Francesco</div>
<div name="messageReplySection">Il 14 gen 2019, 22:35 +0100, Julierme Pinheiro <<a href="mailto:juliermeopensourcedeveloper@gmail.com" target="_blank">juliermeopensourcedeveloper@gmail.com</a>>, ha scritto:<br />
<blockquote type="cite" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #3498db;">
<div dir="ltr">
<div dir="ltr">
<div>Hi Francesco,</div>
<div><br /></div>
<div>I went through step 4 and 5 because there is note on the guide(<a href="https://github.com/GeoNode/geonode-project/tree/2.8" target="_blank">https://github.com/GeoNode/geonode-project/tree/2.8</a>): that says:</div>
<div><br /></div>
<div>
<p>Run docker-compose to start it up (get a cup of coffee or tea while you wait)</p>
<p><b>2 - Remember to update "wsgi.py" in case you are using "local_settings" vim my_geonode/wsgi.py --> os.environ.setdefault("DJANGO_SETTINGS_MODULE", "my_geonode.local_settings")</b></p>
<p>I appreciated your time</p>
<p><br /></p>
<p>Julierme<br /></p>
<p><b></b></p>
<p><b><br /></b></p>
</div>
</div>
</div>
<br />
<div class="gmail_quote">
<div dir="ltr">On Mon, Jan 14, 2019 at 7:28 PM Francesco Bartoli <<a href="mailto:xbartolone@gmail.com" target="_blank">xbartolone@gmail.com</a>> wrote:<br /></div>
<blockquote class="gmail_quote" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #d35400;">
<div>
<div name="messageBodySection">Actually I don’t understand why you are doing steps 4. And 5.</div>
<div name="messageSignatureSection"><br />
Ciao<br />
Francesco</div>
<div name="messageReplySection">Il 14 gen 2019, 22:05 +0100, Julierme Pinheiro <<a href="mailto:juliermeopensourcedeveloper@gmail.com" target="_blank">juliermeopensourcedeveloper@gmail.com</a>>, ha scritto:<br />
<blockquote type="cite" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #34495e;">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>... output for docker ps:</div>
<div><br /></div>
<div>0edbae6e9989 geonode/nginx:geoserver "nginx -g 'daemon of…" 6 minutes ago Up 6 minutes 0.0.0.0:80->80/tcp nginx4my_geonode<br />
f71aed729615 my_geonode_django "/usr/src/my_geonode…" 6 minutes ago Restarting (1) 21 seconds ago django4my_geonode<br />
d1307b6eca5a my_geonode_celery "/usr/src/my_geonode…" 6 minutes ago Restarting (1) 59 seconds ago celery4my_geonode<br />
9865b9317a98 geonode/geoserver:2.13.x "/usr/local/tomcat/t…" 6 minutes ago Up 6 minutes 8080/tcp geoserver4my_geonode<br />
b63b3eed5560 geonode/postgis:9.6 "docker-entrypoint.s…" 16 minutes ago Up 6 minutes 5432/tcp db4my_geonode<br />
c70325c1f57e elasticsearch:2.4.1 "/docker-entrypoint.…" 16 minutes ago Up 6 minutes 9200/tcp, 9300/tcp elasticsearch4my_geonode<br />
4412fd012ca9 rabbitmq "docker-entrypoint.s…" 16 minutes ago Up 6 minutes 4369/tcp, 5671-5672/tcp, 25672/tcp rabbitmq4my_geonode<br /></div>
<div><br /></div>
<div>and out put for docker-compose ps</div>
<div><br /></div>
<div>celery4my_geonode /usr/src/my_geonode/entryp ... Restarting <br />
db4my_geonode docker-entrypoint.sh postgres Up 5432/tcp <br />
django4my_geonode /usr/src/my_geonode/entryp ... Restarting <br />
elasticsearch4my_geonode /docker-entrypoint.sh elas ... Up 9200/tcp, 9300/tcp <br />
geoserver4my_geonode /usr/local/tomcat/tmp/entr ... Up 8080/tcp <br />
gsconf4my_geonode /bin/true Exit 0 <br />
nginx4my_geonode nginx -g daemon off; Up 0.0.0.0:80->80/tcp <br />
rabbitmq4my_geonode docker-entrypoint.sh rabbi ... Up 25672/tcp, 4369/tcp, 5671/tcp, 5672/tcp</div>
<div><br /></div>
<div>Kind Regards</div>
<div><br /></div>
<div>Julierme<br /></div>
<div><br /></div>
</div>
</div>
</div>
<br />
<div class="gmail_quote">
<div dir="ltr">On Mon, Jan 14, 2019 at 7:02 PM Julierme Pinheiro <<a href="mailto:juliermeopensourcedeveloper@gmail.com" target="_blank">juliermeopensourcedeveloper@gmail.com</a>> wrote:<br /></div>
<blockquote class="gmail_quote" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #2ecc71;">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>Hi Francesco,</div>
<div><br /></div>
<div>Thank you very much for your reply. After our discussion in here. I started all over again and I will report the installation step by step.</div>
<div><br /></div>
<div>1 - docker-compose down</div>
<div><br /></div>
<div>2 - docker system prune -a</div>
<div><br /></div>
<div>3 - docker-compose.override.yml is in its default pattern<br /></div>
<div><br /></div>
<div>
<pre>version: '2'
services:
django:
environment:
DEBUG: 'True'
GEONODE_LB_HOST_IP: localhost
GEONODE_LB_PORT: 80
SITEURL: <a href="http://localhost/" target="_blank">http://localhost/</a>
ALLOWED_HOSTS: "['localhost']"
GEOSERVER_PUBLIC_LOCATION: <a href="http://localhost/geoserver/" target="_blank">http://localhost/geoserver/</a>
celery:
environment:
DEBUG: 'True'
GEONODE_LB_HOST_IP: localhost
GEONODE_LB_PORT: 80
SITEURL: <a href="http://localhost/" target="_blank">http://localhost/</a>
ALLOWED_HOSTS: "['localhost']"
GEOSERVER_PUBLIC_LOCATION: <a href="http://localhost/geoserver/" target="_blank">http://localhost/geoserver/</a>
geoserver:
environment:
GEONODE_LB_HOST_IP: localhost
GEONODE_LB_PORT: 80
NGINX_BASE_URL:
<br /><br /></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">4 - cp ...my_geonode/local_settings.py.sample my_geonode/local_settings.py<br /><br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">5 - vim ... my_geonode/wsgi.py <br /><br />os.environ.setdefault("DJANGO_SETTINGS_MODULE", "my_geonode.local_settings")<br /><br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">6 - docker-compose build --no-cache<br /><br />7 - docker-compose up -d<br /><br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">8 - docker-compose stop<br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif"><br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">9 - vim docker-compose.override.yml<br /><br /><span style="font-family:monospace,monospace"><font size="1">version: '2'
services:
django:
environment:
DEBUG: 'True'
GEONODE_LB_HOST_IP: 172.21.14.02
GEONODE_LB_PORT: 80
SITEURL: http://<span style="font-family:arial,helvetica,sans-serif"><span style="font-family:monospace,monospace"><font size="1">172.21.14.02</font></span></span>/
ALLOWED_HOSTS: "['<span style="font-family:arial,helvetica,sans-serif"><span style="font-family:monospace,monospace"><font size="1">172.21.14.02</font></span></span>']"
GEOSERVER_PUBLIC_LOCATION: http://<span style="font-family:arial,helvetica,sans-serif"><span style="font-family:monospace,monospace"><font size="1">172.21.14.02</font></span></span>/geoserver/</font>
celery:
environment:
<font size="1">DEBUG: 'True'
GEONODE_LB_HOST_IP: <span style="font-family:arial,helvetica,sans-serif"><span style="font-family:monospace,monospace"><font size="1">172.21.14.02</font></span></span>
GEONODE_LB_PORT: 80
SITEURL: http://<span style="font-family:arial,helvetica,sans-serif"><span style="font-family:monospace,monospace"><font size="1">172.21.14.02</font></span></span>/
ALLOWED_HOSTS: "['<span style="font-family:arial,helvetica,sans-serif"><span style="font-family:monospace,monospace"><font size="1">172.21.14.02</font></span></span>']"
GEOSERVER_PUBLIC_LOCATION: http://<span style="font-family:arial,helvetica,sans-serif"><span style="font-family:monospace,monospace"><font size="1">172.21.14.02</font></span></span>/geoserver/
geoserver:
environment:
GEONODE_LB_HOST_IP: <span style="font-family:arial,helvetica,sans-serif"><span style="font-family:monospace,monospace"><font size="1">172.21.14.02</font></span></span>
GEONODE_LB_PORT: 80
NGINX_BASE_URL:<br /><br /></font></span></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">10 - docker-compose up --build -d<br /><br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">11 - docker ps<br /><br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">12 - docker-compose ps<br /><br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">13 - docker-compose logs -f django<br />django4my_geonode | django.db.utils.OperationalError: could not connect to server: Connection refused<br />django4my_geonode | Is the server running on host "localhost" (127.0.0.1) and accepting<br />django4my_geonode | TCP/IP connections on port 5432?<br />django4my_geonode | could not connect to server: Network is unreachable<br />django4my_geonode | Is the server running on host "localhost" (::1) and accepting<br />django4my_geonode | TCP/IP connections on port 5432?<br /><br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">14 - docker-compose logs -f celery<br /><br />celery4my_geonode | django.db.utils.OperationalError: could not connect to server: Connection refused<br />celery4my_geonode | Is the server running on host "localhost" (127.0.0.1) and accepting<br />celery4my_geonode | TCP/IP connections on port 5432?<br />celery4my_geonode | could not connect to server: Network is unreachable<br />celery4my_geonode | Is the server running on host "localhost" (::1) and accepting<br />celery4my_geonode | TCP/IP connections on port 5432?<br /><br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">I am still having the issue related to database connection.<br /><br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">Kind regards<br /><br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif">Julierme<br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif"><br /><br /></span></pre>
<pre><span style="font-family:arial,helvetica,sans-serif"><br /></span></pre></div>
</div>
</div>
</div>
<br />
<div class="gmail_quote">
<div dir="ltr">On Mon, Jan 14, 2019 at 3:51 PM Francesco Bartoli <<a href="mailto:xbartolone@gmail.com" target="_blank">xbartolone@gmail.com</a>> wrote:<br /></div>
<blockquote class="gmail_quote" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #9b59b6;">
<div>
<div name="messageBodySection" style="font-size:14px;font-family:-apple-system,BlinkMacSystemFont,sans-serif">Some questions inline to figure out your environment.</div>
<div name="messageReplySection" style="font-size:14px;font-family:-apple-system,BlinkMacSystemFont,sans-serif">Il 14 gen 2019, 18:26 +0100, Julierme Pinheiro <<a href="mailto:juliermeopensourcedeveloper@gmail.com" target="_blank">juliermeopensourcedeveloper@gmail.com</a>>, ha scritto:<br />
<blockquote type="cite" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #e74c3c;">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>Hi Francesco,</div>
<div><br /></div>
<div>Thank you very much for your reply.</div>
<div><br /></div>
<div>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:<br /></div>
<div><br /></div>
<div>django4my_geonode | django.db.utils.OperationalError: could not connect to server: No route to host<br />
django4my_geonode | Is the server running on host "localhost" (::1) and accepting<br />
django4my_geonode | TCP/IP connections on port 5432?</div>
<div><br /></div>
<div>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:</div>
<div><br /></div>
<div>django4my_geonode | django.db.utils.OperationalError: could not connect to server: No route to host<br />
django4my_geonode | Is the server running on host "172.21.14.02" and accepting<br />
django4my_geonode | TCP/IP connections on port 5432<br /></div>
<div><br /></div>
<div>The error remains the same.</div>
<div><br /></div>
<div>Yes. db4my_geonode is up and running. And find bellow the outcome for docker-compose ps:</div>
<div><br /></div>
<div>celery4my_geonode /usr/src/my_geonode/entryp ... Restarting <br />
db4my_geonode docker-entrypoint.sh postgres Up 5432/tcp <br />
django4my_geonode /usr/src/my_geonode/entryp ... Restarting <br />
elasticsearch4my_geonode /docker-entrypoint.sh elas ... Up 9200/tcp, 9300/tcp <br />
geoserver4my_geonode /usr/local/tomcat/tmp/entr ... Up 8080/tcp <br />
gsconf4my_geonode /bin/true Exit 0 <br />
nginx4my_geonode nginx -g daemon off; Up 0.0.0.0:80->80/tcp <br />
rabbitmq4my_geonode docker-entrypoint.sh rabbi ... Up 25672/tcp, 4369/tcp, 5671/tcp, 5672/tcp </div>
</div>
</div>
</div>
</div>
</blockquote>
<blockquote type="cite" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #e74c3c;">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><br /></div>
<div>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? </div>
</div>
</div>
</div>
</div>
</blockquote>
<div><br /></div>
<div>Just to avoid confusion here. If your host where you want to navigate GeoNode is 172.21.14.02 then your docker-compose override yaml file should look like:</div>
<div><br /></div>
<div>
<div style="color:rgb(238,255,255);background-color:rgb(38,50,56);font-family:"Fira Code";font-size:13px;line-height:20px;white-space:pre-wrap">
<div>version: '2'<br />
services:<br />
django:<br />
environment:<br />
DEBUG: 'True'<br />
GEONODE_LB_HOST_IP: 172.21.14.02<br />
GEONODE_LB_PORT: 80<br />
SITEURL: <a href="http://172.21.14.02/" target="_blank">http://172.21.14.02/</a><br />
ALLOWED_HOSTS: "['172.21.14.02']"<br />
GEOSERVER_PUBLIC_LOCATION: <a href="http://172.21.14.02/geoserver/" target="_blank">http://172.21.14.02/geoserver/</a><br />
<br />
celery:<br />
environment:<br />
DEBUG: 'True'<br />
GEONODE_LB_HOST_IP: 172.21.14.02<br />
GEONODE_LB_PORT: 80<br />
SITEURL: <a href="http://172.21.14.02/" target="_blank">http://172.21.14.02/</a><br />
ALLOWED_HOSTS: "['172.21.14.02']"<br />
GEOSERVER_PUBLIC_LOCATION: <a href="http://172.21.14.02/geoserver/" target="_blank">http://172.21.14.02/geoserver/</a><br />
<br />
geoserver:<br />
environment:<br />
GEONODE_LB_HOST_IP: 172.21.14.02<br />
GEONODE_LB_PORT: 80<br />
NGINX_BASE_URL:<br /></div>
</div>
</div>
<blockquote type="cite" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #e74c3c;">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div> </div>
</div>
</div>
</div>
</div>
</blockquote>
<blockquote type="cite" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #e74c3c;">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>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!!!! </div>
</div>
</div>
</div>
</div>
</blockquote>
<div>Given that configuration the database container has a different network address because it is running on the internal network established by docker. Therefore from your host machine, I mean the CentOS, it is correct that you are not allowed to reach the db container. If you want to reach that you have to run your psql within the django container in such a way:</div>
<div><br /></div>
<div>psql -h db -U geonode -d geonode (please note that the hostname is right the service name given in the docker-compose file ;) )</div>
<blockquote type="cite" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #e74c3c;">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><br /></div>
<div>Any help on that will be very appreciated.</div>
<div><br /></div>
<div>Kind regards</div>
<div><br /></div>
<div>Julierme<br /></div>
<div><br /></div>
<div> </div>
</div>
</div>
</div>
</div>
</blockquote>
<div>Hope this helps</div>
<blockquote type="cite" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #e74c3c;">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><br /></div>
<div><br /></div>
<div><br /></div>
<div><br /></div>
<div><br /></div>
<div><br /></div>
<div><br /></div>
</div>
</div>
</div>
</div>
<br />
<div class="gmail_quote">
<div dir="ltr">On Mon, Jan 14, 2019 at 1:22 PM Francesco Bartoli <<a href="mailto:xbartolone@gmail.com" target="_blank">xbartolone@gmail.com</a>> wrote:<br /></div>
<blockquote class="gmail_quote" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #1abc9c;">
<div>
<div name="messageBodySection">Hi Julierme,
<div><br /></div>
<div>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?</div>
</div>
<div name="messageReplySection">Il 14 gen 2019, 16:09 +0100, Julierme Pinheiro <<a href="mailto:juliermeopensourcedeveloper@gmail.com" target="_blank">juliermeopensourcedeveloper@gmail.com</a>>, ha scritto:<br />
<blockquote type="cite" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #e67e22;">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>Trying to answer question 3, I ran a test:<br /></div>
<div>psql -h 172.21.14.02 -U geonode -d geonode</div>
<div><br /></div>
<div>psql: could not connect to server: No route to host<br />
Is the server running on host "172.21.14.02" and accepting<br />
TCP/IP connections on port 5432?<br />
<br /></div>
<div>Though <cite>/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.</cite></div>
<div><br /></div>
<div><cite>local all all trust</cite></div>
<div><cite><br /></cite></div>
<div><cite>Any comment on this matter will be very appreciated.</cite></div>
<div><cite><br /></cite></div>
<div><cite>Kind regards<br /></cite></div>
<div><cite><br /></cite></div>
<div><cite>Julierme<br /></cite></div>
<div><br /></div>
</div>
</div>
</div>
<br />
<div class="gmail_quote">
<div dir="ltr">On Mon, Jan 14, 2019 at 12:30 PM Julierme Pinheiro <<a href="mailto:juliermeopensourcedeveloper@gmail.com" target="_blank">juliermeopensourcedeveloper@gmail.com</a>> wrote:<br /></div>
<blockquote class="gmail_quote" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #3498db;">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>Regarding my previous questions:</div>
<div>1 - When installing geonode-project via docker, is postgres configuration set automatically as in <a href="http://docs.geonode.org/en/master/tutorials/install_and_admin/geonode_install/create_geonode_db.html" target="_blank">here</a>?</div>
<div><br /></div>
<div>I think so. Because I found all the databases and user configured into db4my_geonode container.</div>
<div><br /></div>
<div>2 - Could the error in the log file (geonode-project server 172.21.14.02) be related to <cite>pg_hba.conf file (local connections)?</cite></div>
<div><cite><br /></cite></div>
<div><cite>I do not think so. Because looking at /var/lib/postgresql/data/pg_hba.conf in db4my_geonode, the cofiguration is set as:<br /></cite></div>
<div><cite><br /></cite></div>
<div><cite>local all all trust<br /></cite></div>
<div><cite><br /></cite></div>
<div><cite>Within these two answers I should not have gotten any problem by configuring HOST: '172.21.14.02' in local_settings / DATABASES: {...}</cite></div>
<div><cite><br /></cite></div>
<div><cite>I am still thinking about question 3:</cite></div>
<div><cite><br /></cite></div>
<div><cite>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 = {...}?</cite></div>
<div><cite><br /></cite></div>
<div><cite>Thank you for your time in advance</cite></div>
<div><cite><br /></cite></div>
<div><cite>Kind regards</cite></div>
<div><cite><br /></cite></div>
<div><cite>Julierme<br /></cite></div>
<div><br /></div>
<div><br /></div>
</div>
</div>
</div>
<br />
<div class="gmail_quote">
<div dir="ltr">On Mon, Jan 14, 2019 at 12:01 PM Julierme Pinheiro <<a href="mailto:juliermeopensourcedeveloper@gmail.com" target="_blank">juliermeopensourcedeveloper@gmail.com</a>> wrote:<br /></div>
<blockquote class="gmail_quote" style="margin: 5px 5px; padding-left: 10px; border-left: thin solid #d35400;">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>Deal all,</div>
<div><br /></div>
<div>This is not an issue, but a question regarding postgres configuration in GeoNode-Project Docker installation.</div>
<div><br /></div>
<div>I have 2 servers and 1 client server.</div>
<div><br /></div>
<div>Server 1: postgres server - IP: 172.21.14.01</div>
<div></div>
<div></div>
<div><br /></div>
<div> I installed postgres in Server 1 (172.21.14.01) and I configured postgres as in <a href="http://docs.geonode.org/en/master/tutorials/install_and_admin/geonode_install/create_geonode_db.html" target="_blank">here</a>. I created in postgres:</div>
<div><br /></div>
<div>a user: geonode with password osgeo;<br /></div>
<div>a db: geonode owned by geonode user;</div>
<div>a db: geonode_data owned by geonode user;</div>
<div>and so on.</div>
<div><br /></div>
<div>Server 2 (CentOS7): geonode-project server - IP: 172.21.14.02</div>
<div><br /></div>
<div>I installed geonode-project@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.<br /></div>
<div><br /></div>
<div>Client server: my_workstation - IP: 172.21.14.03</div>
<div><br /></div>
<div>GeoNode-Project installation via Docker is successful if I change localhost to 172.21.14.01 (postgres remote server) as in:</div>
<div># Backend<br />
DATABASES = {<br />
'default': {<br />
'ENGINE': 'django.db.backends.postgresql_psycopg2',<br />
'NAME': 'geonode',<br />
'USER': 'geonode',<br />
'PASSWORD': 'geonode',<br />
'HOST': '172.21.14.01',<br />
'PORT': '5432',<br />
'CONN_TOUT': 900,<br />
},<br />
# vector datastore for uploads<br />
'datastore': {<br />
'ENGINE': 'django.contrib.gis.db.backends.postgis',<br />
# 'ENGINE': '', # Empty ENGINE name disables<br />
'NAME': 'geonode_data',<br />
'USER': 'geonode',<br />
'PASSWORD': 'geonode',<br />
'HOST': '172.21.14.01',<br />
'PORT': '5432',<br />
'CONN_TOUT': 900,<br />
}<br />
}<br />
<br /></div>
<div>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:</div>
<div><br /></div>
<div>django4my_geonode | Is the server running on host "172.21.14.45" and accepting<br />
django4my_geonode | TCP/IP connections on port 5432?<br /></div>
<div><br /></div>
<div>django4my_geonode | Is the server running on host "localhost" (::1) and accepting<br />
django4my_geonode | TCP/IP connections on port 5432?<br /></div>
<div><br /></div>
<div>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.<br /></div>
<div><br /></div>
<div>I want to use geonode-project server IP:172.21.14.02. Said that, I came out with the following questions:</div>
<div><br /></div>
<div>1 - When installing geonode-project via docker, is postgres configuration set automatically as in <a href="http://docs.geonode.org/en/master/tutorials/install_and_admin/geonode_install/create_geonode_db.html" target="_blank">here</a>?</div>
<div><br /></div>
<div>2 - Could the error in the log file (geonode-project server 172.21.14.02) be related to <cite>pg_hba.conf file (local connections)?<br /></cite></div>
<div> </div>
<div>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 = {...}?</div>
<div><br /></div>
<div>My apologies for the long e-mail and thank you very much for your time and patience.</div>
<div><br /></div>
<div>Kind regards</div>
<div><br /></div>
<div>Julierme<br /></div>
<div><br /></div>
<div><br /></div>
<div><br /></div>
<div><br /></div>
<div><br /></div>
<div><br /></div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
_______________________________________________<br />
geonode-users mailing list<br />
<a href="mailto:geonode-users@lists.osgeo.org" target="_blank">geonode-users@lists.osgeo.org</a><br />
<a href="https://lists.osgeo.org/mailman/listinfo/geonode-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/geonode-users</a><br /></blockquote>
</div>
</div>
</blockquote>
</div>
</blockquote>
<div></div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</body>
</html>