<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Dear Lydia,<div class=""><br class=""></div><div class=""><blockquote type="cite" class="">For the tables in <a href="https://hastebin.com/ipapejinex.sql<https://hastebin.com/ekodomixuc.sql>" class="">https://hastebin.com/ipapejinex.sql<https://hastebin.com/ekodomixuc.sql></a>, none of them seems to be present in the geonode database. Any idea about why is different?</blockquote><br class=""></div><div class="">a vague guess: GeoNode is using sqlite when in development mode.</div><div class="">Is it possible that your setup is still using it instead of postgres? </div><div class=""><br class=""></div><div class="">Start by having a look at your settings.py or local_settings.py (depends on what you´re using).</div><div class="">If you´re sure postgres is in use 'python manage.py sync' could help to create the tables.</div><div class=""><br class=""></div><div class="">best regards,</div><div class=""><br class=""></div><div class="">Toni</div><div class=""><br class=""></div><div class=""><div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class=""><div class="">-----------------------------------------------</div><div class="">CSGIS</div><div class=""><br class=""></div><div class="">-----------------------------------------------</div><div class=""><div class="" style="orphans: 2; widows: 2;">Kolonnadenstraße 1</div><div class="" style="orphans: 2; widows: 2;">04109 Leipzig</div></div><div class="">-----------------------------------------------</div><div class="">Mobil<span class="Apple-tab-span" style="white-space: pre;"> </span>+49/ (0) 176 6680 3198</div><div class="">Tel <span class="Apple-tab-span" style="white-space: pre;"> </span>+49/ (0) 341 24 04 738</div><div class="">Fax <span class="Apple-tab-span" style="white-space: pre;"> </span>+49/ (0) 341 24 04 73</div><div class="">Web<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="http://csgis.de" class="">http://csgis.de</a></div><div class="">-----------------------------------------------</div><div class=""><br class=""></div><div class="">Hinweis gemäß § 33 BDSG</div><div class="">Daten der Verfahrensbeteiligten werden gespeichert. Dieses Dokument ist ausschließlich für den </div><div class="">Adressaten bestimmt. Der Inhalt der E-Mail ist vertraulich. Falls Sie diese E-Mail versehentlich </div><div class="">erhalten haben, rufen Sie uns unter obiger Rufnummer umgehend an und löschen Sie diese Nachricht </div><div class="">von Ihrem Computer. Jegliche Art von Reproduktionen, Verbreitung, Vervielfältigung, Veränderung, </div><div class="">Verteilung und/oder Veröffentlichung dieser E-Mail ist verboten.</div></div></div></div></div></div></div></div></div>
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">Am 14.08.2018 um 16:11 schrieb <a href="mailto:geonode-devel-request@lists.osgeo.org" class="">geonode-devel-request@lists.osgeo.org</a>:</div><br class="Apple-interchange-newline"><div class=""><div class="">Send geonode-devel mailing list submissions to<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span><a href="mailto:geonode-devel@lists.osgeo.org" class="">geonode-devel@lists.osgeo.org</a><br class=""><br class="">To subscribe or unsubscribe via the World Wide Web, visit<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>https://lists.osgeo.org/mailman/listinfo/geonode-devel<br class="">or, via email, send a message with subject or body 'help' to<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>geonode-devel-request@lists.osgeo.org<br class=""><br class="">You can reach the person managing the list at<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>geonode-devel-owner@lists.osgeo.org<br class=""><br class="">When replying, please edit your Subject line so it is more specific<br class="">than "Re: Contents of geonode-devel digest..."<br class=""><br class=""><br class="">Today's Topics:<br class=""><br class=""> 1. Re: Layers on Geocode being redirected to localhost after<br class=""> production server migration (Lian Feng (lfeng))<br class=""><br class=""><br class="">----------------------------------------------------------------------<br class=""><br class="">Message: 1<br class="">Date: Tue, 14 Aug 2018 14:11:05 +0000<br class="">From: "Lian Feng (lfeng)" <lfeng@memphis.edu><br class="">To: Toni Schönbuchner <toni.schoenbuchner@csgis.de>, Alessio Fabiani<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span><alessio.fabiani@geo-solutions.it><br class="">Cc: geonode-devel <geonode-devel@lists.osgeo.org><br class="">Subject: Re: [GeoNode-devel] Layers on Geocode being redirected to<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>localhost after production server migration<br class="">Message-ID: <1537A9B7-9C0A-4655-83B1-3FF487425758@memphis.edu><br class="">Content-Type: text/plain; charset="utf-8"<br class=""><br class="">Dear all,<br class=""><br class="">Thank you so much for all the responses and I appreciate it very much.<br class=""><br class="">Toni, geonode was installed from github source and followed instructions from http://docs.geonode.org/en/master/tutorials/install_and_admin/geonode_install/install_geonode_application.html. After I dumped database geonode as sql, there isn’t anything for localhost. Here is the command I used (pg_dump -h localhost -U geonode > outfile) and output file is attached in the email. For the tables in https://hastebin.com/ipapejinex.sql<https://hastebin.com/ekodomixuc.sql>, none of them seems to be present in the geonode database. Any idea about why is different?<br class=""><br class="">Alessio, I already updated geoserver proxy base url in the danjo admin gui and passwords. I will change debug to False after this issue is resolved.<br class=""><br class="">Thanks again!<br class=""><br class="">Lydia Lian Feng<br class="">Senior Research Software Developer | CAESER<br class="">Center for Applied Earth Science and Engineering Research<br class=""><br class="">[cid:image001.jpg@01D1B286.94FA79E0]<br class=""><br class="">The University of Memphis<br class="">Wilder Tower Suite 900<br class="">3675 Alumni Drive<br class="">Memphis, TN 38152<http://www.memphis.edu/emailsignatures/emailsignaturepc.php><br class=""><br class="">901.678.<http://www.memphis.edu/emailsignatures/emailsignaturepc.php>5110 | http://strengthencommunities.com/<br class=""><br class=""><br class="">[cid:image002.jpg@01D1B286.94FA79E0]<https://www.facebook.com/CAESER.UofM><br class=""><br class="">[cid:image003.jpg@01D1B286.94FA79E0]<https://twitter.com/CAESER_UofM><br class=""><br class=""><br class=""><br class=""><br class="">From: Toni Schönbuchner <toni.schoenbuchner@csgis.de><br class="">Date: Tuesday, August 14, 2018 at 4:59 AM<br class="">To: Alessio Fabiani <alessio.fabiani@geo-solutions.it><br class="">Cc: "Lian Feng (lfeng)" <lfeng@memphis.edu>, geonode-devel <geonode-devel@lists.osgeo.org><br class="">Subject: Re: [GeoNode-devel] Layers on Geocode being redirected to localhost after production server migration<br class=""><br class="">+1 Alessio, thanks for your addition!<br class="">And sorry for the many typos, it was early morning ;)<br class=""><br class="">t.<br class=""><br class="">-----------------------------------------------<br class="">CSGIS<br class=""><br class="">-----------------------------------------------<br class="">Kolonnadenstraße 1<br class="">04109 Leipzig<br class="">-----------------------------------------------<br class="">Mobil +49/ (0) 176 6680 3198<br class="">Tel +49/ (0) 341 24 04 738<br class="">Fax +49/ (0) 341 24 04 73<br class="">Web http://csgis.de<br class="">-----------------------------------------------<br class=""><br class="">Hinweis gemäß § 33 BDSG<br class="">Daten der Verfahrensbeteiligten werden gespeichert. Dieses Dokument ist ausschließlich für den<br class="">Adressaten bestimmt. Der Inhalt der E-Mail ist vertraulich. Falls Sie diese E-Mail versehentlich<br class="">erhalten haben, rufen Sie uns unter obiger Rufnummer umgehend an und löschen Sie diese Nachricht<br class="">von Ihrem Computer. Jegliche Art von Reproduktionen, Verbreitung, Vervielfältigung, Veränderung,<br class="">Verteilung und/oder Veröffentlichung dieser E-Mail ist verboten.<br class=""><br class=""><br class="">Am 14.08.2018 um 10:22 schrieb Alessio Fabiani <alessio.fabiani@geo-solutions.it<mailto:alessio.fabiani@geo-solutions.it>>:<br class=""><br class="">Adding to Toni response, do not forget to change the GeoServer Proxy Base URL from the admin gui and also to change all the default passwords whenever you will deploy this on a production instance.<br class=""><br class="">Also, on production, you should put "DEBUG = False" on Python settings, otherwise you are going to expose an open http-proxy to the world.<br class=""><br class="">Il giorno mar 14 ago 2018 alle ore 07:48 Toni Schönbuchner <toni.schoenbuchner@csgis.de<mailto:toni.schoenbuchner@csgis.de>> ha scritto:<br class="">Dear Lydia,<br class=""><br class="">in case you installed geonode 2.8 via apt-get you can just run<br class=""><br class="">$ geonode-updateip http://geoportal-test.memphis.edu<http://geoportal-test.memphis.edu/><br class=""><br class="">In case you installed with form github source (with pip and paver)<br class="">Either dump database geonode as sql, search after localhost and replace<br class="">it with you url, and restore the database.<br class=""><br class="">As alternative you can try these sql command (meant to be run from cli)<br class="">https://hastebin.com/ipapejinex.sql<https://hastebin.com/ekodomixuc.sql><br class="">After using the first two pink tiles should be gone. The rest should<br class="">correct several other fields which have the old url.<br class=""><br class="">best regards,<br class=""><br class="">Toni<br class=""><br class="">-----------------------------------------------<br class="">CSGIS<br class=""><br class="">-----------------------------------------------<br class="">Kolonnadenstraße 1<br class="">04109 Leipzig<br class="">-----------------------------------------------<br class="">Mobil +49/ (0) 176 6680 3198<br class="">Tel +49/ (0) 341 24 04 738<br class="">Fax +49/ (0) 341 24 04 73<br class="">Web http://csgis.de<http://csgis.de/><br class="">-----------------------------------------------<br class=""><br class="">Hinweis gemäß § 33 BDSG<br class="">Daten der Verfahrensbeteiligten werden gespeichert. Dieses Dokument ist ausschließlich für den<br class="">Adressaten bestimmt. Der Inhalt der E-Mail ist vertraulich. Falls Sie diese E-Mail versehentlich<br class="">erhalten haben, rufen Sie uns unter obiger Rufnummer umgehend an und löschen Sie diese Nachricht<br class="">von Ihrem Computer. Jegliche Art von Reproduktionen, Verbreitung, Vervielfältigung, Veränderung,<br class="">Verteilung und/oder Veröffentlichung dieser E-Mail ist verboten.<br class=""><br class=""><br class="">Am 14.08.2018 um 00:18 schrieb geonode-devel-request@lists.osgeo.org<mailto:geonode-devel-request@lists.osgeo.org>:<br class=""><br class="">Send geonode-devel mailing list submissions to<br class="">geonode-devel@lists.osgeo.org<mailto:geonode-devel@lists.osgeo.org><br class=""><br class="">To subscribe or unsubscribe via the World Wide Web, visit<br class="">https://lists.osgeo.org/mailman/listinfo/geonode-devel<br class="">or, via email, send a message with subject or body 'help' to<br class="">geonode-devel-request@lists.osgeo.org<mailto:geonode-devel-request@lists.osgeo.org><br class=""><br class="">You can reach the person managing the list at<br class="">geonode-devel-owner@lists.osgeo.org<mailto:geonode-devel-owner@lists.osgeo.org><br class=""><br class="">When replying, please edit your Subject line so it is more specific<br class="">than "Re: Contents of geonode-devel digest..."<br class=""><br class=""><br class="">Today's Topics:<br class=""><br class=""> 1. Layers on Geocode being redirected to localhost after<br class=""> production server migration (Lian Feng (lfeng))<br class=""><br class=""><br class="">----------------------------------------------------------------------<br class=""><br class="">Message: 1<br class="">Date: Mon, 13 Aug 2018 22:11:55 +0000<br class="">From: "Lian Feng (lfeng)" <lfeng@memphis.edu<mailto:lfeng@memphis.edu>><br class="">To: "geonode-devel@lists.osgeo.org<mailto:geonode-devel@lists.osgeo.org>" <geonode-devel@lists.osgeo.org<mailto:geonode-devel@lists.osgeo.org>><br class="">Subject: [GeoNode-devel] Layers on Geocode being redirected to<br class="">localhost after production server migration<br class="">Message-ID: <C79FD08F-F674-4000-965C-3B7DFB8D310D@memphis.edu<mailto:C79FD08F-F674-4000-965C-3B7DFB8D310D@memphis.edu>><br class="">Content-Type: text/plain; charset="utf-8"<br class=""><br class="">Dear all,<br class=""><br class="">I installed geonode 2.8 on a 16.04 Ubuntu virtualbox and migrated localhost and localhost:8080 to http://geoportal-test.memphis.edu/ and http://geoportal-test.memphis.edu/geoserver/. I was able to upload three layers in geoserver and layer previews work well for them. However, on geonode UI, GET requests are redirected to localhost (see attached). Also, I noticed I have pink tiles for openstreetmap but not sure if they’re related. geoserver.log file is also attached.<br class=""><br class="">I followed this installation guide http://docs.geonode.org/en/master/tutorials/install_and_admin/geonode_install/index.html. And I have thoroughly googled pink tiles and url redirect issues but haven’t had any luck yet. I would appreciate any help very much! Thanks.<br class=""><br class="">Lydia Lian Feng<br class="">Senior Research Software Developer | CAESER<br class="">Center for Applied Earth Science and Engineering Research<br class=""><br class="">[cid:image001.jpg@01D1B286.94FA79E0]<br class=""><br class="">The University of Memphis<br class="">Wilder Tower Suite 900<br class="">3675 Alumni Drive<br class="">Memphis, TN 38152<http://www.memphis.edu/emailsignatures/emailsignaturepc.php><br class=""><br class="">901.678.<http://www.memphis.edu/emailsignatures/emailsignaturepc.php>5110 | http://strengthencommunities.com/<br class=""><br class=""><br class="">[cid:image002.jpg@01D1B286.94FA79E0]<https://www.facebook.com/CAESER.UofM><br class=""><br class="">[cid:image003.jpg@01D1B286.94FA79E0]<https://twitter.com/CAESER_UofM><br class=""><br class=""><br class=""><br class="">-------------- next part --------------<br class="">An HTML attachment was scrubbed...<br class="">URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180813/62a58ccf/attachment.html><br class="">-------------- next part --------------<br class="">A non-text attachment was scrubbed...<br class="">Name: image001.jpg<br class="">Type: image/jpeg<br class="">Size: 34647 bytes<br class="">Desc: image001.jpg<br class="">URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180813/62a58ccf/attachment.jpg><br class="">-------------- next part --------------<br class="">A non-text attachment was scrubbed...<br class="">Name: image002.jpg<br class="">Type: image/jpeg<br class="">Size: 9111 bytes<br class="">Desc: image002.jpg<br class="">URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180813/62a58ccf/attachment-0001.jpg><br class="">-------------- next part --------------<br class="">A non-text attachment was scrubbed...<br class="">Name: image003.jpg<br class="">Type: image/jpeg<br class="">Size: 9962 bytes<br class="">Desc: image003.jpg<br class="">URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180813/62a58ccf/attachment-0002.jpg><br class="">-------------- next part --------------<br class="">A non-text attachment was scrubbed...<br class="">Name: geonode_re-route.png<br class="">Type: image/png<br class="">Size: 578003 bytes<br class="">Desc: geonode_re-route.png<br class="">URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180813/62a58ccf/attachment.png><br class="">-------------- next part --------------<br class="">A non-text attachment was scrubbed...<br class="">Name: geoserver.log<br class="">Type: application/octet-stream<br class="">Size: 332617 bytes<br class="">Desc: geoserver.log<br class="">URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180813/62a58ccf/attachment.obj><br class=""><br class="">------------------------------<br class=""><br class="">Subject: Digest Footer<br class=""><br class="">_______________________________________________<br class="">geonode-devel mailing list<br class="">geonode-devel@lists.osgeo.org<mailto:geonode-devel@lists.osgeo.org><br class="">https://lists.osgeo.org/mailman/listinfo/geonode-devel<br class=""><br class=""><br class="">------------------------------<br class=""><br class="">End of geonode-devel Digest, Vol 43, Issue 11<br class="">*********************************************<br class=""><br class="">_______________________________________________<br class="">geonode-devel mailing list<br class="">geonode-devel@lists.osgeo.org<mailto:geonode-devel@lists.osgeo.org><br class="">https://lists.osgeo.org/mailman/listinfo/geonode-devel<br class=""><br class=""><br class="">--<br class="">==<br class="">GeoServer<br class="">Professional Services from the experts! Visit <http://goo.gl/it488V><br class="">http://goo.gl/it488V for more information.<br class=""><br class="">==<br class=""><br class="">Ing. Alessio Fabiani<br class="">@alfa7691<br class=""><br class="">Founder/Technical Lead<br class=""><br class=""><br class="">GeoSolutions<br class="">S.A.S.<br class=""><br class="">Via di Montramito 3/A<br class="">- 55054 Massarosa<br class="">(LU) - Italy<br class=""><br class="">phone: +39 0584 962313<br class=""><br class="">fax: +39 0584 1660272<br class=""><br class="">mob: +39 331 6233686<br class=""><br class=""><br class="">http://www.geo-solutions.it<http://www.geo-solutions.it/><br class=""><br class="">http://twitter.com/geosolutions_it<br class=""><br class="">-------------------------------------------------------<br class="">Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.<br class=""><br class="">This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.<br class=""><br class=""><br class="">-------------- next part --------------<br class="">An HTML attachment was scrubbed...<br class="">URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180814/0e459bd2/attachment.html><br class="">-------------- next part --------------<br class="">A non-text attachment was scrubbed...<br class="">Name: image001.jpg<br class="">Type: image/jpeg<br class="">Size: 34643 bytes<br class="">Desc: image001.jpg<br class="">URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180814/0e459bd2/attachment.jpg><br class="">-------------- next part --------------<br class="">A non-text attachment was scrubbed...<br class="">Name: image002.jpg<br class="">Type: image/jpeg<br class="">Size: 9107 bytes<br class="">Desc: image002.jpg<br class="">URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180814/0e459bd2/attachment-0001.jpg><br class="">-------------- next part --------------<br class="">A non-text attachment was scrubbed...<br class="">Name: image003.jpg<br class="">Type: image/jpeg<br class="">Size: 9958 bytes<br class="">Desc: image003.jpg<br class="">URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180814/0e459bd2/attachment-0002.jpg><br class="">-------------- next part --------------<br class="">A non-text attachment was scrubbed...<br class="">Name: outfile<br class="">Type: application/octet-stream<br class="">Size: 917 bytes<br class="">Desc: outfile<br class="">URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180814/0e459bd2/attachment.obj><br class=""><br class="">------------------------------<br class=""><br class="">Subject: Digest Footer<br class=""><br class="">_______________________________________________<br class="">geonode-devel mailing list<br class="">geonode-devel@lists.osgeo.org<br class="">https://lists.osgeo.org/mailman/listinfo/geonode-devel<br class=""><br class=""><br class="">------------------------------<br class=""><br class="">End of geonode-devel Digest, Vol 43, Issue 14<br class="">*********************************************<br class=""></div></div></blockquote></div><br class=""></div></body></html>