[GeoNode-users] "layers_uploadsession" does not exist

Christian Willmes christian.willmes at googlemail.com
Fri Jul 10 02:05:56 PDT 2015


Hi,
wow cool, thats an easy fix. I can edit the metadata again. I was 
worried, the whole DB (user rights etc.) would be messed up.

The metadata not stored also in Geoserver, such as the keywords and 
categories are missing. Also the spatial region is not there. But the 
descriptions/abstracts and titles are still there.

regards,
Christian

Am 09.07.2015 um 18:11 schrieb Simone Dalmasso:
> Hi your error is:
> Permission denied: u'/var/www/geonode/uploaded/
> so a:
> $ sudo chmod -R a+w /var/www/geonode/uploaded
> should fix.
>
> For the metadata and categories, they shouldn't be gone at all.
> Not sure what went wrong there.
>
> 2015-07-09 16:56 GMT+02:00 Christian Willmes 
> <christian.willmes at googlemail.com 
> <mailto:christian.willmes at googlemail.com>>:
>
>     Hi,
>
>     first it seemed to work fine, all layers are back and accessible,
>     but I cant edit the metadata of existing layers vie the geonode
>     webapp anymore.
>     The frontend dies and gives an "Internal Server Error".
>
>     The apache error messages look like:
>     [Thu Jul 09 09:50:53.648422 2015] [:error] [pid 2080:tid
>     140415632357120] Internal Server Error:
>     /layers/geonode:sealevels_10_150m/metadata
>     [Thu Jul 09 09:50:53.648484 2015] [:error] [pid 2080:tid
>     140415632357120] Traceback (most recent call last):
>     [...]
>     [Thu Jul 09 09:50:53.648652 2015] [:error] [pid 2080:tid
>     140415632357120] IOError: [Errno 13] Permission denied:
>     u'/var/www/geonode/uploaded/thumbs/layer-d680d189-b46f-468e-8267-e8e5b497988c-thumb.png'
>     [Thu Jul 09 09:50:53.664269 2015] [:error] [pid 2080:tid
>     140415632357120] [remote 134.95.150.136:14361
>     <http://134.95.150.136:14361>] mod_wsgi (pid=2080): Exception
>     occurred processing WSGI script '/var/www/geonode/wsgi/geonode.wsgi'.
>     [...]
>     [Thu Jul 09 09:50:53.665753 2015] [:error] [pid 2080:tid
>     140415632357120] [remote 134.95.150.136:14361
>     <http://134.95.150.136:14361>] File
>     "/usr/lib/python2.7/dist-packages/django/template/context.py",
>     line 56, in __getitem__
>     [Thu Jul 09 09:50:53.665849 2015] [:error] [pid 2080:tid
>     140415632357120] [remote 134.95.150.136:14361
>     <http://134.95.150.136:14361>] raise KeyError(key)
>     [Thu Jul 09 09:50:53.665872 2015] [:error] [pid 2080:tid
>     140415632357120] [remote 134.95.150.136:14361
>     <http://134.95.150.136:14361>] KeyError: 'request'
>
>
>     It is the same account name for the superuser.
>
>     Additionally all the Categories and Keywords are gone... (that's
>     why I wanted to edit the metadata in the first place...)
>
>     Any hint on how I can fix this?
>
>     Thanks and regards,
>     Christian
>
>
>     Am 07.07.2015 um 15:49 schrieb Simone Dalmasso:
>>     Christian, in your case the backup preserver the old schema.
>>     Although since the difference in the new schema is a single
>>     column being added, you can use the "geonode
>>     syncdb --no-initial-data"  before loading back the backup. The
>>     syncdb will create the new schema and the backup should load
>>     leaving the new column blank. The --no-initial-data will make
>>     sure that syncdb only creates the schema without loading any
>>     fixture.
>>
>>     Hope this helps.
>>
>>     2015-07-07 14:48 GMT+02:00 Christian Willmes
>>     <christian.willmes at googlemail.com
>>     <mailto:christian.willmes at googlemail.com>>:
>>
>>         Hi,
>>
>>         following up on this thread:
>>         https://github.com/GeoNode/geonode/issues/2046
>>
>>         I did the sugested steps, but the upload problem persits. No
>>         wonder, because in which step should the
>>         'layers_uploadsession' session be created?
>>
>>         The erreor inthe apache log looks like:
>>         [Tue Jul 07 07:39:11.377817 2015] [:error] [pid 22673:tid
>>         139958275774208] column "context" of relation
>>         "layers_uploadsession" does not exist
>>         [Tue Jul 07 07:39:11.377877 2015] [:error] [pid 22673:tid
>>         139958275774208] LINE 1: ...e", "user_id", "processed",
>>         "error", "traceback", "context")...
>>         [Tue Jul 07 07:39:11.377884 2015] [:error] [pid 22673:tid
>>         139958275774208] ^
>>         [Tue Jul 07 07:39:11.377898 2015] [:error] [pid 22673:tid
>>         139958275774208] Traceback (most recent call last):
>>         [Tue Jul 07 07:39:11.377904 2015] [:error] [pid 22673:tid
>>         139958275774208]   File
>>         "/usr/local/lib/python2.7/dist-packages/geonode/layers/views.py"
>>         [....]
>>
>>
>>         I did exactly the following (from
>>         http://docs.geonode.org/en/master/tutorials/admin/backup/index.html):
>>
>>         sudo -u postgres -i pg_dump -c -Fc geonode > geonodedb.backup
>>
>>
>>         sudo service apache2 stop
>>         sudo /etc/init.d/tomcat7 stop
>>
>>         sudo service postgresql start
>>         sudo -u postgres -i "psql -c 'drop database geonode;'"
>>         sudo -u postgres -i "psql -c 'create database geonode;'"
>>         sudo -u postgres -s "pg_restore -Fc -d geonode
>>         /path/to/geonodedb.backup"
>>
>>         sudo service apache2 start
>>         sudo /etc/init.d/tomcat7 start
>>
>>         ----
>>
>>         How can I solve this problem?
>>
>>         Best regards,
>>         Christian
>>
>>         _______________________________________________
>>         geonode-users mailing list
>>         geonode-users at lists.osgeo.org
>>         <mailto:geonode-users at lists.osgeo.org>
>>         http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users
>>
>>
>>
>>
>>     -- 
>>     Simone
>
>
>
>
> -- 
> Simone

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20150710/9bd50f0e/attachment.html>


More information about the geonode-users mailing list