[GeoNode-devel] Layers on Geocode being redirected to localhost after production server migration (Lian Feng (lfeng))
Toni Schönbuchner
toni.schoenbuchner at csgis.de
Tue Aug 14 07:20:15 PDT 2018
Dear Lydia,
> 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?
a vague guess: GeoNode is using sqlite when in development mode.
Is it possible that your setup is still using it instead of postgres?
Start by having a look at your settings.py or local_settings.py (depends on what you´re using).
If you´re sure postgres is in use 'python manage.py sync' could help to create the tables.
best regards,
Toni
-----------------------------------------------
CSGIS
-----------------------------------------------
Kolonnadenstraße 1
04109 Leipzig
-----------------------------------------------
Mobil +49/ (0) 176 6680 3198
Tel +49/ (0) 341 24 04 738
Fax +49/ (0) 341 24 04 73
Web http://csgis.de
-----------------------------------------------
Hinweis gemäß § 33 BDSG
Daten der Verfahrensbeteiligten werden gespeichert. Dieses Dokument ist ausschließlich für den
Adressaten bestimmt. Der Inhalt der E-Mail ist vertraulich. Falls Sie diese E-Mail versehentlich
erhalten haben, rufen Sie uns unter obiger Rufnummer umgehend an und löschen Sie diese Nachricht
von Ihrem Computer. Jegliche Art von Reproduktionen, Verbreitung, Vervielfältigung, Veränderung,
Verteilung und/oder Veröffentlichung dieser E-Mail ist verboten.
> Am 14.08.2018 um 16:11 schrieb geonode-devel-request at lists.osgeo.org:
>
> Send geonode-devel mailing list submissions to
> geonode-devel at lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.osgeo.org/mailman/listinfo/geonode-devel
> or, via email, send a message with subject or body 'help' to
> geonode-devel-request at lists.osgeo.org
>
> You can reach the person managing the list at
> geonode-devel-owner at lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of geonode-devel digest..."
>
>
> Today's Topics:
>
> 1. Re: Layers on Geocode being redirected to localhost after
> production server migration (Lian Feng (lfeng))
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 14 Aug 2018 14:11:05 +0000
> From: "Lian Feng (lfeng)" <lfeng at memphis.edu>
> To: Toni Schönbuchner <toni.schoenbuchner at csgis.de>, Alessio Fabiani
> <alessio.fabiani at geo-solutions.it>
> Cc: geonode-devel <geonode-devel at lists.osgeo.org>
> Subject: Re: [GeoNode-devel] Layers on Geocode being redirected to
> localhost after production server migration
> Message-ID: <1537A9B7-9C0A-4655-83B1-3FF487425758 at memphis.edu>
> Content-Type: text/plain; charset="utf-8"
>
> Dear all,
>
> Thank you so much for all the responses and I appreciate it very much.
>
> 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?
>
> 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.
>
> Thanks again!
>
> Lydia Lian Feng
> Senior Research Software Developer | CAESER
> Center for Applied Earth Science and Engineering Research
>
> [cid:image001.jpg at 01D1B286.94FA79E0]
>
> The University of Memphis
> Wilder Tower Suite 900
> 3675 Alumni Drive
> Memphis, TN 38152<http://www.memphis.edu/emailsignatures/emailsignaturepc.php>
>
> 901.678.<http://www.memphis.edu/emailsignatures/emailsignaturepc.php>5110 | http://strengthencommunities.com/
>
>
> [cid:image002.jpg at 01D1B286.94FA79E0]<https://www.facebook.com/CAESER.UofM>
>
> [cid:image003.jpg at 01D1B286.94FA79E0]<https://twitter.com/CAESER_UofM>
>
>
>
>
> From: Toni Schönbuchner <toni.schoenbuchner at csgis.de>
> Date: Tuesday, August 14, 2018 at 4:59 AM
> To: Alessio Fabiani <alessio.fabiani at geo-solutions.it>
> Cc: "Lian Feng (lfeng)" <lfeng at memphis.edu>, geonode-devel <geonode-devel at lists.osgeo.org>
> Subject: Re: [GeoNode-devel] Layers on Geocode being redirected to localhost after production server migration
>
> +1 Alessio, thanks for your addition!
> And sorry for the many typos, it was early morning ;)
>
> t.
>
> -----------------------------------------------
> CSGIS
>
> -----------------------------------------------
> Kolonnadenstraße 1
> 04109 Leipzig
> -----------------------------------------------
> Mobil +49/ (0) 176 6680 3198
> Tel +49/ (0) 341 24 04 738
> Fax +49/ (0) 341 24 04 73
> Web http://csgis.de
> -----------------------------------------------
>
> Hinweis gemäß § 33 BDSG
> Daten der Verfahrensbeteiligten werden gespeichert. Dieses Dokument ist ausschließlich für den
> Adressaten bestimmt. Der Inhalt der E-Mail ist vertraulich. Falls Sie diese E-Mail versehentlich
> erhalten haben, rufen Sie uns unter obiger Rufnummer umgehend an und löschen Sie diese Nachricht
> von Ihrem Computer. Jegliche Art von Reproduktionen, Verbreitung, Vervielfältigung, Veränderung,
> Verteilung und/oder Veröffentlichung dieser E-Mail ist verboten.
>
>
> Am 14.08.2018 um 10:22 schrieb Alessio Fabiani <alessio.fabiani at geo-solutions.it<mailto:alessio.fabiani at geo-solutions.it>>:
>
> 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.
>
> Also, on production, you should put "DEBUG = False" on Python settings, otherwise you are going to expose an open http-proxy to the world.
>
> Il giorno mar 14 ago 2018 alle ore 07:48 Toni Schönbuchner <toni.schoenbuchner at csgis.de<mailto:toni.schoenbuchner at csgis.de>> ha scritto:
> Dear Lydia,
>
> in case you installed geonode 2.8 via apt-get you can just run
>
> $ geonode-updateip http://geoportal-test.memphis.edu<http://geoportal-test.memphis.edu/>
>
> In case you installed with form github source (with pip and paver)
> Either dump database geonode as sql, search after localhost and replace
> it with you url, and restore the database.
>
> As alternative you can try these sql command (meant to be run from cli)
> https://hastebin.com/ipapejinex.sql<https://hastebin.com/ekodomixuc.sql>
> After using the first two pink tiles should be gone. The rest should
> correct several other fields which have the old url.
>
> best regards,
>
> Toni
>
> -----------------------------------------------
> CSGIS
>
> -----------------------------------------------
> Kolonnadenstraße 1
> 04109 Leipzig
> -----------------------------------------------
> Mobil +49/ (0) 176 6680 3198
> Tel +49/ (0) 341 24 04 738
> Fax +49/ (0) 341 24 04 73
> Web http://csgis.de<http://csgis.de/>
> -----------------------------------------------
>
> Hinweis gemäß § 33 BDSG
> Daten der Verfahrensbeteiligten werden gespeichert. Dieses Dokument ist ausschließlich für den
> Adressaten bestimmt. Der Inhalt der E-Mail ist vertraulich. Falls Sie diese E-Mail versehentlich
> erhalten haben, rufen Sie uns unter obiger Rufnummer umgehend an und löschen Sie diese Nachricht
> von Ihrem Computer. Jegliche Art von Reproduktionen, Verbreitung, Vervielfältigung, Veränderung,
> Verteilung und/oder Veröffentlichung dieser E-Mail ist verboten.
>
>
> Am 14.08.2018 um 00:18 schrieb geonode-devel-request at lists.osgeo.org<mailto:geonode-devel-request at lists.osgeo.org>:
>
> Send geonode-devel mailing list submissions to
> geonode-devel at lists.osgeo.org<mailto:geonode-devel at lists.osgeo.org>
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.osgeo.org/mailman/listinfo/geonode-devel
> or, via email, send a message with subject or body 'help' to
> geonode-devel-request at lists.osgeo.org<mailto:geonode-devel-request at lists.osgeo.org>
>
> You can reach the person managing the list at
> geonode-devel-owner at lists.osgeo.org<mailto:geonode-devel-owner at lists.osgeo.org>
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of geonode-devel digest..."
>
>
> Today's Topics:
>
> 1. Layers on Geocode being redirected to localhost after
> production server migration (Lian Feng (lfeng))
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 13 Aug 2018 22:11:55 +0000
> From: "Lian Feng (lfeng)" <lfeng at memphis.edu<mailto:lfeng at memphis.edu>>
> To: "geonode-devel at lists.osgeo.org<mailto:geonode-devel at lists.osgeo.org>" <geonode-devel at lists.osgeo.org<mailto:geonode-devel at lists.osgeo.org>>
> Subject: [GeoNode-devel] Layers on Geocode being redirected to
> localhost after production server migration
> Message-ID: <C79FD08F-F674-4000-965C-3B7DFB8D310D at memphis.edu<mailto:C79FD08F-F674-4000-965C-3B7DFB8D310D at memphis.edu>>
> Content-Type: text/plain; charset="utf-8"
>
> Dear all,
>
> 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.
>
> 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.
>
> Lydia Lian Feng
> Senior Research Software Developer | CAESER
> Center for Applied Earth Science and Engineering Research
>
> [cid:image001.jpg at 01D1B286.94FA79E0]
>
> The University of Memphis
> Wilder Tower Suite 900
> 3675 Alumni Drive
> Memphis, TN 38152<http://www.memphis.edu/emailsignatures/emailsignaturepc.php>
>
> 901.678.<http://www.memphis.edu/emailsignatures/emailsignaturepc.php>5110 | http://strengthencommunities.com/
>
>
> [cid:image002.jpg at 01D1B286.94FA79E0]<https://www.facebook.com/CAESER.UofM>
>
> [cid:image003.jpg at 01D1B286.94FA79E0]<https://twitter.com/CAESER_UofM>
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180813/62a58ccf/attachment.html>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image001.jpg
> Type: image/jpeg
> Size: 34647 bytes
> Desc: image001.jpg
> URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180813/62a58ccf/attachment.jpg>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image002.jpg
> Type: image/jpeg
> Size: 9111 bytes
> Desc: image002.jpg
> URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180813/62a58ccf/attachment-0001.jpg>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image003.jpg
> Type: image/jpeg
> Size: 9962 bytes
> Desc: image003.jpg
> URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180813/62a58ccf/attachment-0002.jpg>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: geonode_re-route.png
> Type: image/png
> Size: 578003 bytes
> Desc: geonode_re-route.png
> URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180813/62a58ccf/attachment.png>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: geoserver.log
> Type: application/octet-stream
> Size: 332617 bytes
> Desc: geoserver.log
> URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180813/62a58ccf/attachment.obj>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> geonode-devel mailing list
> geonode-devel at lists.osgeo.org<mailto:geonode-devel at lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/geonode-devel
>
>
> ------------------------------
>
> End of geonode-devel Digest, Vol 43, Issue 11
> *********************************************
>
> _______________________________________________
> geonode-devel mailing list
> geonode-devel at lists.osgeo.org<mailto:geonode-devel at lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/geonode-devel
>
>
> --
> ==
> GeoServer
> Professional Services from the experts! Visit <http://goo.gl/it488V>
> http://goo.gl/it488V for more information.
>
> ==
>
> Ing. Alessio Fabiani
> @alfa7691
>
> Founder/Technical Lead
>
>
> GeoSolutions
> S.A.S.
>
> Via di Montramito 3/A
> - 55054 Massarosa
> (LU) - Italy
>
> phone: +39 0584 962313
>
> fax: +39 0584 1660272
>
> mob: +39 331 6233686
>
>
> http://www.geo-solutions.it<http://www.geo-solutions.it/>
>
> http://twitter.com/geosolutions_it
>
> -------------------------------------------------------
> 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.
>
> 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.
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180814/0e459bd2/attachment.html>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image001.jpg
> Type: image/jpeg
> Size: 34643 bytes
> Desc: image001.jpg
> URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180814/0e459bd2/attachment.jpg>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image002.jpg
> Type: image/jpeg
> Size: 9107 bytes
> Desc: image002.jpg
> URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180814/0e459bd2/attachment-0001.jpg>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image003.jpg
> Type: image/jpeg
> Size: 9958 bytes
> Desc: image003.jpg
> URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180814/0e459bd2/attachment-0002.jpg>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: outfile
> Type: application/octet-stream
> Size: 917 bytes
> Desc: outfile
> URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180814/0e459bd2/attachment.obj>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> geonode-devel mailing list
> geonode-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/geonode-devel
>
>
> ------------------------------
>
> End of geonode-devel Digest, Vol 43, Issue 14
> *********************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180814/8f2d6551/attachment-0001.html>
More information about the geonode-devel
mailing list