[GeoNode-devel] Problems restoring Geonode Data

Rodrigo Esquivel rodrigo.esquivel at gmail.com
Fri Feb 19 10:20:08 PST 2016 

Hi, I tried to go to the layer preview and no layer appeared there, just as
it happens when I going to the Layer itself in geonode.  I can see the
Metadata, but I can not see the layer in the map.  I can download  for
example a csv and  geojson  file of the layer but I can not download a jpeg
file ( it give me the configured datastore error). I also check in the
database and appears data in it. Any other thing I can check out?


Rgds


Rodrigo

On Fri, Feb 19, 2016 at 11:38 AM, Alessio Fabiani <
alessio.fabiani at geo-solutions.it> wrote:

> Rodrigo,
> if you go at the GeoServer > Layer Preview and click
> on geonode:barriosvivienda_3, are you able to see it into the map?
>
> Unfortunately from the logs I cannot see the real cause, but I guess that
> the problem is on the layer.
>
> You can also check if in you Database "geonode_imports" (depending on your
> local_settings.py) there exists a table called "barriosvivienda" and has
> records.
>
> Maybe the issue is caused by the fact the the table somehow is empty.
>
>
>
> Best Regards,
> Alessio Fabiani.
>
> ==
> GeoServer Professional Services from the experts!
> Visit 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://twitter.com/geosolutions_it
>
> -------------------------------------------------------
>
> *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
>
> Le informazioni contenute in questo messaggio di posta elettronica e/o
> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
> darcene notizia via e-mail e di procedere alla distruzione del messaggio
> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
> principi dettati dal D.Lgs. 196/2003.
>
>
>
> The information in this message and/or attachments, is intended solely for
> the attention and use of the named addressee(s) and may be confidential or
> proprietary in nature or covered by the provisions of privacy act
> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
> Code).Any use not in accord with its purpose, any disclosure, reproduction,
> copying, distribution, or either dissemination, either whole or partial, is
> strictly forbidden except previous formal approval of the named
> addressee(s). If you are not the intended recipient, please contact
> immediately the sender by telephone, fax or e-mail and delete the
> information in this message that has been received in error. The sender
> does not give any warranty or accept liability as the content, accuracy or
> completeness of sent messages and accepts no responsibility  for changes
> made after they were sent or for other risks which arise as a result of
> e-mail transmission, viruses, etc.
>
> ---------------------------------------------------------------------
>
> On Fri, Feb 19, 2016 at 5:28 PM, Rodrigo Esquivel <
> rodrigo.esquivel at gmail.com> wrote:
>
>> Hello Alessio: I am sending the log  comprised, hope it can help;  what I
>> made today was to try to open a layer and try to  download a file from it,
>> so you can check the logs dated on Feb 19th, 2016.  Just to give you a
>> context I am running Geonode R 2.01 on Ubuntu 12.04.  I am also sending the
>> data store screenshots in case it can help.  As always,  thanks to you and
>> Simone for your time.
>>
>>
>> Rgds
>>
>>
>> Rodrigo
>>
>> On Fri, Feb 19, 2016 at 10:13 AM, Alessio Fabiani <
>> alessio.fabiani at geo-solutions.it> wrote:
>>
>>> Hi Rodrigo,
>>> if you have admin rights to GeoNode, go to the GeoServer administration
>>> page, click on " Settings > Global " and select "VERBOSE_LOGGING" profile.
>>>
>>> Save and try to make a query again.
>>>
>>> Go back to the GeoServer administration page, click on " GeoServer logs
>>> " and try to catch the Exception Stacktrace. You can also download the
>>> file, compress it and send here in order to take a look.
>>>
>>>
>>> Best Regards,
>>> Alessio Fabiani.
>>>
>>> ==
>>> GeoServer Professional Services from the experts!
>>> Visit 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://twitter.com/geosolutions_it
>>>
>>> -------------------------------------------------------
>>>
>>> *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
>>>
>>> Le informazioni contenute in questo messaggio di posta elettronica e/o
>>> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
>>> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
>>> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
>>> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
>>> darcene notizia via e-mail e di procedere alla distruzione del messaggio
>>> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
>>> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
>>> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
>>> principi dettati dal D.Lgs. 196/2003.
>>>
>>>
>>>
>>> The information in this message and/or attachments, is intended solely
>>> for the attention and use of the named addressee(s) and may be confidential
>>> or proprietary in nature or covered by the provisions of privacy act
>>> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
>>> Code).Any use not in accord with its purpose, any disclosure, reproduction,
>>> copying, distribution, or either dissemination, either whole or partial, is
>>> strictly forbidden except previous formal approval of the named
>>> addressee(s). If you are not the intended recipient, please contact
>>> immediately the sender by telephone, fax or e-mail and delete the
>>> information in this message that has been received in error. The sender
>>> does not give any warranty or accept liability as the content, accuracy or
>>> completeness of sent messages and accepts no responsibility  for changes
>>> made after they were sent or for other risks which arise as a result of
>>> e-mail transmission, viruses, etc.
>>>
>>> ---------------------------------------------------------------------
>>>
>>> On Fri, Feb 19, 2016 at 4:05 PM, Simone Dalmasso <
>>> simone.dalmasso at gmail.com> wrote:
>>>
>>>> There must be something missing the datastore definition. Any error in
>>>> the geoserver datastore admin panel?
>>>>
>>>> 2016-02-19 2:04 GMT+01:00 Rodrigo Esquivel <rodrigo.esquivel at gmail.com>
>>>> :
>>>>
>>>>> Hi Simone, thanks for the advice now the system can download csv files
>>>>> without any problem but still can not display the layer,  Tried to download
>>>>> a kml file or jpg and I have a "not properly configured datastore" error( I
>>>>> think that they are related errors).  Any other place that I have to look
>>>>> at?
>>>>>
>>>>> Best Regards and thanks for your time,
>>>>>
>>>>>
>>>>>
>>>>> Rodrigo
>>>>>
>>>>> On Wed, Feb 17, 2016 at 7:49 AM, Rodrigo Esquivel <
>>>>> rodrigo.esquivel at gmail.com> wrote:
>>>>>
>>>>>> Thanks for your help Simone, I will start from scratch applying what
>>>>>> you wrote me and I will let you know of anything else.
>>>>>>
>>>>>>
>>>>>> Rgds
>>>>>>
>>>>>>
>>>>>>
>>>>>> Rodrigo Esquivel
>>>>>>
>>>>>> On Mon, Feb 15, 2016 at 2:10 AM, Simone Dalmasso <
>>>>>> simone.dalmasso at gmail.com> wrote:
>>>>>>
>>>>>>> in the geoseerver admin, put the correct credentials in the
>>>>>>> definition of the store that geoserver is using to connect to postgres.
>>>>>>> This happens if the postgres password has been changed during the restore.
>>>>>>>
>>>>>>> 2016-02-14 22:50 GMT+01:00 Rodrigo Esquivel <
>>>>>>> rodrigo.esquivel at gmail.com>:
>>>>>>>
>>>>>>>> Just as an update of this issue. I tried to use the geonode
>>>>>>>> database user password generated in the server where the backups are
>>>>>>>> generated in the  server I use as a test but then the application crashes,
>>>>>>>> I checked in the error log of the apache and says "authentication failed".
>>>>>>>>    Rgds  Rodrigo
>>>>>>>>
>>>>>>>> On Sun, Feb 14, 2016 at 4:20 PM, Rodrigo Esquivel <
>>>>>>>> rodrigo.esquivel at gmail.com> wrote:
>>>>>>>>
>>>>>>>>> Thanks Simone, I appreciate your patience and time spent with me.
>>>>>>>>> The thumbs are appearing but now I do not have the layer itself in the map(
>>>>>>>>> see attached file), touching here and there also noticed that when I try to
>>>>>>>>> download the layer I have an authentication error. I suspect that they are
>>>>>>>>> both sides of the same problem. What do you recommend to check?
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Best Regards from Panama,
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Rodrigo Esquivel
>>>>>>>>>
>>>>>>>>> On Sun, Feb 14, 2016 at 2:32 AM, Simone Dalmasso <
>>>>>>>>> simone.dalmasso at gmail.com> wrote:
>>>>>>>>>
>>>>>>>>>> the thumbnails are saved in /var /www/geonode. if you restore
>>>>>>>>>> that one you'll get them back.
>>>>>>>>>>
>>>>>>>>>> hope it helps
>>>>>>>>>>
>>>>>>>>>> 2016-02-14 5:48 GMT+01:00 Rodrigo Esquivel <
>>>>>>>>>> rodrigo.esquivel at gmail.com>:
>>>>>>>>>>
>>>>>>>>>>> Good night  .. thanks for the advice it seems that somehow the
>>>>>>>>>>> first dump I generated  was corrupted.  I generated a new one, restored it
>>>>>>>>>>> and I didn't have any problem accessing the application.   However even
>>>>>>>>>>> though I have access to the layers,  the preview is not appearing( see
>>>>>>>>>>> troubleshootingrestore.png)  Looking in older  mails I thought that the
>>>>>>>>>>> problem could be in the web.xml or in the local_settings.py, but both
>>>>>>>>>>> seemed normal to me so I suspect that besides the subdirectories
>>>>>>>>>>> /usr/share/geoserver/data and /var/lib/geoserver  I have to take in account
>>>>>>>>>>> another one.
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Thanks for your Time,
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Rodrigo Esquivel
>>>>>>>>>>>
>>>>>>>>>>> On Sat, Feb 13, 2016 at 2:45 AM, Simone Dalmasso <
>>>>>>>>>>> simone.dalmasso at gmail.com> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Hi,
>>>>>>>>>>>> the error tells that either your db is not configured with
>>>>>>>>>>>> postgis (but if you have restored then it should be) of you have to add
>>>>>>>>>>>> POSTGIS_VERSION=(2,1,0) to your settings.
>>>>>>>>>>>>
>>>>>>>>>>>> 2016-02-13 4:38 GMT+01:00 Rodrigo Esquivel <
>>>>>>>>>>>> rodrigo.esquivel at gmail.com>:
>>>>>>>>>>>>
>>>>>>>>>>>>> Hello All, I  am making some  backup and restore tests.  I
>>>>>>>>>>>>> followed all the information I found in the net:  Backup of the Database
>>>>>>>>>>>>> and the files  in the directories /usr/share/geoserver/data  and
>>>>>>>>>>>>> /var/lib/geoserver/geonode-data.  After I restore the Data Base backup and
>>>>>>>>>>>>> the sub-directories  I have an error 500 when I try to run the application.
>>>>>>>>>>>>>   The Apache's log is telling me that there is some file that do not have
>>>>>>>>>>>>> permission to be accessed( I am attaching the file)  I am using   Geonode R
>>>>>>>>>>>>> 2.09 and Ubuntu 12.04. Does anyone could tell me  if there is any thing
>>>>>>>>>>>>> else I need to do?   Thanks in advance for your time.
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> Rodrigo Esquivel
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>> geonode-devel mailing list
>>>>>>>>>>>>> geonode-devel at lists.osgeo.org
>>>>>>>>>>>>> http://lists.osgeo.org/mailman/listinfo/geonode-devel
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> Simone
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> geonode-devel mailing list
>>>>>>>>>>> geonode-devel at lists.osgeo.org
>>>>>>>>>>> http://lists.osgeo.org/mailman/listinfo/geonode-devel
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Simone
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Simone
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Simone
>>>>
>>>> _______________________________________________
>>>> geonode-devel mailing list
>>>> geonode-devel at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/geonode-devel
>>>>
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20160219/7523e9e9/attachment-0001.html>

More information about the geonode-devel mailing list