<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="">Hi Eugenio,<div class=""><br class=""></div><div class="">I would need to have a look what is going on. But yes local_settings should override settings.</div><div class="">The correct command for migrations is python manage.py migrate ... (instead of syncdb)</div><div class=""><br class=""></div><div class="">best regards</div><div class=""><br class=""></div><div class="">toni<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">Am 20.03.2020 um 19:58 schrieb Eugenio Trumpy <<a href="mailto:frippe12573@hotmail.com" class="">frippe12573@hotmail.com</a>>:</div><br class="Apple-interchange-newline"><div class=""><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class="">Dear Toni,</div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class=""><br class=""></div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class="">I followed your hints.</div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class="">I put the domain in the ALLOWED_HOSTS and now I visualise the home page.</div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class="">Just a question, I had to put the domain the settings.py file because it didn't work in local_setting.py, why? Don't local_setting override setting.py?</div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class="">Then I modify local_setting.py to set credential to access geonode db.</div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class="">Then I alter the table you suggested and I run python manage.py --syncdb but the number of tables didn't change, is that correct?</div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class="">The geonode home page is visualised but I'm not able to enter with the old administrator credential.</div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class="">I presume there is no connection with the db. Should I use again setting.py instead of local_setting.py?</div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class=""><br class=""></div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class="">Thanks in advance,</div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class=""><br class=""></div><div style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class="">Eugenio</div><div style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><div id="appendonsend" class=""></div><div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;" class=""><br class=""></div><hr tabindex="-1" style="display: inline-block; width: 770.265625px;" class=""><div id="divRplyFwdMsg" dir="ltr" class=""><font face="Calibri, sans-serif" style="font-size: 11pt;" class=""><b class="">Da:</b><span class="Apple-converted-space"> </span>Toni Schönbuchner <<a href="mailto:toni.schoenbuchner@csgis.de" class="">toni.schoenbuchner@csgis.de</a>><br class=""><b class="">Inviato:</b><span class="Apple-converted-space"> </span>giovedì 19 marzo 2020 20:37<br class=""><b class="">A:</b><span class="Apple-converted-space"> </span>Eugenio Trumpy <<a href="mailto:frippe12573@hotmail.com" class="">frippe12573@hotmail.com</a>><br class=""><b class="">Cc:</b><span class="Apple-converted-space"> </span>geonode-users <<a href="mailto:geonode-users@lists.osgeo.org" class="">geonode-users@lists.osgeo.org</a>><br class=""><b class="">Oggetto:</b><span class="Apple-converted-space"> </span>Re: migration suggestions</font><div class=""> </div></div><div class="BodyFragment"><font size="2" class=""><span style="font-size: 11pt;" class=""><div class="PlainText">Dear Eugenio,<br class=""><br class=""><br class="">> • I set the wgsi module in apache2. The geonode is served now with the 'allowed_hosts' error. I think the issue could be related to the settings. In the 2.4 version I remember I set SITE_URL, should I set something similar even in this version?<br class=""><br class="">Allowed hosts is a security mechanism by Django to define Domains that serve your instance.<br class=""><a href="https://docs.djangoproject.com/en/3.0/ref/settings/#allowed-hosts" class="">https://docs.djangoproject.com/en/3.0/ref/settings/#allowed-hosts</a><br class=""><br class="">To overcome an 504 error you can add something like<br class=""><br class="">ALLOWED_HOSTS = ['localhost' '127.0.0.1' 'your <a href="http://domain.com" class="">domain.com</a>']<br class=""><br class="">to your settings.py or local_settings.p However, we all more and more avoid touching the settings file and try to configure everything<br class="">with environment variables. So with a manual setup you can try to add it to your uwsgi config:<br class=""><a href="https://docs.geonode.org/en/master/install/core/index.html#serving-geonode-geoserver-via-nginx" class="">https://docs.geonode.org/en/master/install/core/index.html#serving-geonode-geoserver-via-nginx</a><br class=""><br class="">> • I created a geonode postgresql empty db, while I restored the backup from that I was using in 2.4 version. How I should populate with the new data-schema the geonode metadata db? I remember there was the command python manage.py --syncdb, does still exist? I tried but I got error.<br class=""><br class="">I'm unsure If I correctly understand. But the rough flow looks like:<br class=""><br class=""> • Export your geonode 2.4 Database<br class=""> • Import it to a fresh Database<br class=""> • Be sure to correctly set permissions for your User<br class=""> • Change your settings.py for using the new database and in case the correct user<br class=""> • Fix some inconsistency within your new database. Run f.e. with pgadmin or by psql from console<br class=""> • ALTER TABLE public.layers_layer DROP COLUMN service_id<br class=""> • Run the migrations, this should update your database scheme from 2.4 to 2.10<br class=""> • DJANGO_SETTINGS_MODULE=YOURGEONODE.local_settings django python manage.py migrate --fake-initial<br class=""><br class="">You will need to change those commands to fit your setup further run into errors here and<br class="">there but hopefully this steps help you to find out of the forest.<br class=""><br class="">Cheers,<br class=""><br class="">Toni<br class=""><br class=""><br class="">-----------------------------------------------<br class="">CSGIS<br class=""><br class="">-----------------------------------------------<br class="">Spinnereistraße 7<br class="">Halle 18 04179 Leipzig<br class="">-----------------------------------------------<br class="">Web <span class="Apple-converted-space"> </span><a href="https://csgis.de/" class="">https://csgis.de</a><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<span class="Apple-converted-space"> </span><br class="">Adressaten bestimmt. Der Inhalt der E-Mail ist vertraulich. Falls Sie diese E-Mail versehentlich<span class="Apple-converted-space"> </span><br class="">erhalten haben, rufen Sie uns unter obiger Rufnummer umgehend an und löschen Sie diese Nachricht<span class="Apple-converted-space"> </span><br class="">von Ihrem Computer. Jegliche Art von Reproduktionen, Verbreitung, Vervielfältigung, Veränderung,<span class="Apple-converted-space"> </span><br class="">Verteilung und/oder Veröffentlichung dieser E-Mail ist verboten.</div></span></font></div></div></div></blockquote></div><br class=""></div></body></html>