<div dir="ltr">I fixed the error on deleting orphan layers: the upload_upload table hasn't 4 attribute: mosaic_time_regex, mosaic_time_value, mosaic_elev_regex and mosaic_elev_value. Adding those columns, I can delete my orphan layers.<div><br></div><div>It may be an issue of geonode migrate command?</div><div><br></div><div>Cheers,</div><div>Annalisa</div></div><div class="gmail_extra"><br><div class="gmail_quote">2017-07-03 12:14 GMT+02:00 Annalisa Schiavon <span dir="ltr"><<a href="mailto:annalisa.schiavon@gmail.com" target="_blank">annalisa.schiavon@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Thanks! <span style="font-size:12.8px"> Yes, if I replace it, it works.</span><div><span style="font-size:12.8px"><br></span><div><span style="font-size:12.8px">For the stale layers, I can't remove them from the admin panel, It gives error! I try to remove from DB, checking dependencies, ok?</span><br></div></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">Thanks again</span></div><div><span style="font-size:12.8px"><br></span></div></div><div class="gmail_extra"><br><div class="gmail_quote"><span class="">2017-07-03 11:31 GMT+02:00 Simone Dalmasso <span dir="ltr"><<a href="mailto:simone.dalmasso@gmail.com" target="_blank">simone.dalmasso@gmail.com</a>></span>:<br></span><div><div class="h5"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Annalisa, layer preview from geoserver seems to have a bug in the url of the preview itself<div>if you right click and copy the url you'll notice it has two "?". if you replace the second one with "&" then should work. This will probably be fixed in next gs releases</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="m_-3288326144488179792h5">2017-07-03 11:21 GMT+02:00 Annalisa Schiavon <span dir="ltr"><<a href="mailto:annalisa.schiavon@gmail.com" target="_blank">annalisa.schiavon@gmail.com</a>></span>:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="m_-3288326144488179792h5"><div dir="ltr">Hi Toni,<div><br></div><div class="gmail_extra"><div class="gmail_quote"><span>2017-07-03 10:07 GMT+02:00 Toni Schönbuchner <span dir="ltr"><<a href="mailto:toni.schoenbuchner@csgis.de" target="_blank">toni.schoenbuchner@csgis.de</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Hi Annalisa,<div><span><br><blockquote type="cite"><div><span style="float:none;display:inline!important">I setted the ip address in geonode-oauth2 in a couple of lines they still</span><br><span style="float:none;display:inline!important">point to "localhost“.</span><br></div></blockquote><div><br></div></span>You could grep your files to see if somewhere localhost is still mentioned:</div><div><br></div><div>grep -rn --include="*.py“ „192.68.31.80" 2>/dev/null </div></div></blockquote><div><br></div></span><div>Ok, but now it seems that localhost should remain in some settings, maybe?</div><span><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div><span><br><br><blockquote type="cite"><div><span style="float:none;display:inline!important">Here it is an example of a wrong preview link:</span><br><a href="http://192.168.31.80/geoserver/geonode/wms?access_token=SFtO1m1uwzKVWzOmJmsQi72nMQyEfi?service=WMS&version=1.1.0&request=GetMap&layers=geonode:v_staz_aria_attive&styles=&bbox=1647277.811,4991070.397,1798213.0,5117620.0&width=768&height=643&srs=EPSG:3003&format=application/openlayers" target="_blank">http://192.168.31.80/geoserver<wbr>/geonode/wms?access_token=SFtO<wbr>1m1uwzKVWzOmJmsQi72nMQyEfi?ser<wbr>vice=WMS&version=1.1.0&request<wbr>=GetMap&layers=geonode:v_staz_<wbr>aria_attive&styles=&bbox=16472<wbr>77.811,4991070.397,1798213.0,5<wbr>117620.0&width=768&height=643&<wbr>srs=EPSG:3003&format=applicati<wbr>on/openlayers</a><br></div></blockquote><div><br></div></span><div>You want the local IP to be a public, right?</div><div>Stupid question. Have you restarted your web servers?</div></div></div></blockquote><div><br></div></span><div>After checking all, I'll have to change it to a domain ... Yes, I've restarted apache and tomcat</div><span><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div><span><br><blockquote type="cite"><div><span style="float:none;display:inline!important">Then, I've some old layers in geonode that doesn't more exists in</span><br><span style="float:none;display:inline!important">geoserver. If I try to remove from geonode ui It fails. Also the "geonode</span><br><span style="float:none;display:inline!important">updatelayers --remove-deleted" fails on those layers</span><br></div></blockquote><div><br></div></span><div>updatelayers has a verbose option. </div><div><a href="http://docs.geonode.org/en/master/tutorials/admin/admin_mgmt_commands/#updatelayers" target="_blank">http://docs.geonode.org/en/mas<wbr>ter/tutorials/admin/admin_mgmt<wbr>_commands/#updatelayers</a></div><div>can you provide a detailed error output?</div><span><br><blockquote type="cite"><div><span style="float:none;display:inline!important">There are geonode commands for clean or syncronize databases? Some docs?</span><br><span style="float:none;display:inline!important">syncdb is now deprecated, right?</span><br></div></blockquote><div><br></div></span><div>I think to remember that from Django 1.9 synchdb is depreceated. Instead migrate</div><div>should work. F.e.:</div><div><br></div><div><pre class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413lang-py m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413prettyprinted m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413prettyprint" style="margin-top:0px;padding:5px;border:0px;font-variant-ligatures:normal;font-variant-numeric:inherit;font-stretch:inherit;font-size:13px;line-height:inherit;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,sans-serif;vertical-align:baseline;width:auto;max-height:600px;overflow:auto;background-color:rgb(239,240,241);color:rgb(57,51,24);word-wrap:normal"><code style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,sans-serif;vertical-align:baseline;white-space:inherit"><span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)">python manage</span><span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)">.</span><span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)">py migrate auth
</span><span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413com" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(133,140,147)"># performs migrations for auth and contenttypes contrib apps</span><span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)">
python manage</span><span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)">.</span><span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)">py migrate </span><span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)">--</span><span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)">run</span><span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413pun" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)">-</span><span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413pln" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(48,51,54)">syncdb
</span><span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413com" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-variant-numeric:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-stretch:inherit;font-size:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;color:rgb(133,140,147)"># creates the rest of the database</span></code></pre><div>I couldn´t find any updated documentation either.</div><div>When searching for things like that I often have a look in pavement.py ;)</div></div><div><a href="https://github.com/GeoNode/geonode/blob/master/pavement.py#L213" target="_blank">https://github.com/GeoNode/geo<wbr>node/blob/master/pavement.py#L<wbr>213</a></div><div><br></div><div><br></div></div></div></blockquote></span><div>Thanks</div><span class="m_-3288326144488179792m_3212425617251374649HOEnZb"><font color="#888888"><div><br></div><div>Annalisa</div></font></span><span><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div><div></div><br><div><div><span style="float:none;display:inline!important"><br></span></div></div><div><span style="float:none;display:inline!important">Cheers,</span></div><div><span style="float:none;display:inline!important"><br></span></div><div><span style="float:none;display:inline!important">Toni</span></div><div><span style="float:none;display:inline!important"><br></span></div><div><span style="float:none;display:inline!important"><br></span></div><div>
<div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"><div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"><div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"><div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"><div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"><div><div style="word-wrap:break-word"><div><div>------------------------------<wbr>-----------------</div><div>CSGIS</div><div><br></div><div>------------------------------<wbr>-----------------</div><div><div>Kolonnadenstraße 1</div><div>04109 Leipzig</div></div><div>------------------------------<wbr>-----------------</div><div>Mobil<span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413Apple-tab-span" style="white-space:pre-wrap"> </span><a href="tel:+49%20176%2066803198" value="+4917666803198" target="_blank">+49/ (0) 176 6680 3198</a></div><div>Tel <span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413Apple-tab-span" style="white-space:pre-wrap"> </span><a href="tel:+49%20341%202404738" value="+493412404738" target="_blank">+49/ (0) 341 24 04 738</a></div><div>Fax <span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413Apple-tab-span" style="white-space:pre-wrap"> </span><a href="tel:+49%20341%20240473" value="+49341240473" target="_blank">+49/ (0) 341 24 04 73</a></div><div>Web<span class="m_-3288326144488179792m_3212425617251374649m_3280339410157275302m_-5072765445453828413Apple-tab-span" style="white-space:pre-wrap"> </span><a href="http://csgis.de" target="_blank">http://csgis.de</a></div><div>------------------------------<wbr>-----------------</div><div><br></div><div>Hinweis gemäß § 33 BDSG</div><div>Daten der Verfahrensbeteiligten werden gespeichert. Dieses Dokument ist ausschließlich für den </div><div>Adressaten bestimmt. Der Inhalt der E-Mail ist vertraulich. Falls Sie diese E-Mail versehentlich </div><div>erhalten haben, rufen Sie uns unter obiger Rufnummer umgehend an und löschen Sie diese Nachricht </div><div>von Ihrem Computer. Jegliche Art von Reproduktionen, Verbreitung, Vervielfältigung, Veränderung, </div><div>Verteilung und/oder Veröffentlichung dieser E-Mail ist verboten.</div></div></div></div></div></div></div></div></div>
</div>
<br><br></div></div></blockquote></span></div><br></div></div>
<br></div></div><span>______________________________<wbr>_________________<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" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/geonode-users</a><br>
<br></span></blockquote></div><span class="m_-3288326144488179792HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div class="m_-3288326144488179792m_3212425617251374649gmail_signature" data-smartmail="gmail_signature">Simone </div>
</font></span></div>
</blockquote></div></div></div><br></div>
</blockquote></div><br></div>