[GeoNode-devel] Geonode Unable to Sign in (Julierme Pinheiro)

Toni Schönbuchner toni.schoenbuchner at csgis.de
Thu May 10 10:57:33 PDT 2018


Hey ho Julierme,

this is the interesting part:
> 140163086272256] OperationalError: attempt to write a readonly database

yes this is most likely caused by missing permissions of the user who runs the process. 
can you please check your sqlite database file it shoud name something like db.sqlite3 
$ ls -l db.sqlite3


if you do not know where to find it something have a look in your settings.py or local.settings
or do $ find / -name '*sqlite3‘ -type f 2>/dev/null


Cheers,

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 10.05.2018 um 19:33 schrieb geonode-devel-request at lists.osgeo.org:
> 
>   1. Re: [GeoNode-users]  Geonode Unable to Sign in (Julierme Pinheiro)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Thu, 10 May 2018 14:33:06 -0300
> From: Julierme Pinheiro <juliermeopensourcedeveloper at gmail.com <mailto:juliermeopensourcedeveloper at gmail.com>>
> To: Alessio Fabiani <alessio.fabiani at geo-solutions.it <mailto:alessio.fabiani at geo-solutions.it>>
> Cc: ANDRIAMIADANTSOA Fanevanjanahary <fanevanjanahary at gmail.com <mailto:fanevanjanahary at gmail.com>>,
> 	geonode-users <geonode-users at lists.osgeo.org <mailto:geonode-users at lists.osgeo.org>>,  geonode-devel
> 	<geonode-devel at lists.osgeo.org <mailto:geonode-devel at lists.osgeo.org>>
> Subject: Re: [GeoNode-devel] [GeoNode-users]  Geonode Unable to Sign
> 	in
> Message-ID:
> 	<CAKTKyJLa14UN6ggximM4dVJ4T9OhwhUQbL7ivsrZMHV8FFC5kQ at mail.gmail.com <mailto:CAKTKyJLa14UN6ggximM4dVJ4T9OhwhUQbL7ivsrZMHV8FFC5kQ at mail.gmail.com>>
> Content-Type: text/plain; charset="utf-8"
> 
> Find bellow the error.log response when I try to sign in and refresh
> geonode site. Do you think the problem could be related to user geo
> permissions?
> 
> [Thu May 10 14:20:59.195452 2018] [wsgi:error] [pid 4130:tid
> 140163086272256] Internal Server Error: /account/login/
> [Thu May 10 14:20:59.200485 2018] [wsgi:error] [pid 4130:tid
> 140163086272256] Traceback (most recent call last):
> [Thu May 10 14:20:59.200510 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/core/handlers/base.py",
> line 132, in get_response
> [Thu May 10 14:20:59.200518 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     response = wrapped_callback(request, *callback_args,
> **callback_kwargs)
> [Thu May 10 14:20:59.200524 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/views/generic/base.py",
> line 71, in view
> [Thu May 10 14:20:59.200531 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return self.dispatch(request, *args, **kwargs)
> [Thu May 10 14:20:59.200538 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/utils/decorators.py",
> line 34, in _wrapper
> [Thu May 10 14:20:59.200544 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return bound_func(*args, **kwargs)
> [Thu May 10 14:20:59.200551 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/views/decorators/debug.py",
> line 76, in sensitive_post_parameters_wrapper
> [Thu May 10 14:20:59.200558 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return view(request, *args, **kwargs)
> [Thu May 10 14:20:59.200564 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/utils/decorators.py",
> line 30, in bound_func
> [Thu May 10 14:20:59.200571 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return func.__get__(self, type(self))(*args2,
> **kwargs2)
> [Thu May 10 14:20:59.200577 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/allauth/account/views.py",
> line 133, in dispatch
> [Thu May 10 14:20:59.200584 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return super(LoginView, self).dispatch(request, *args,
> **kwargs)
> [Thu May 10 14:20:59.200590 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/allauth/account/views.py",
> line 79, in dispatch
> [Thu May 10 14:20:59.200597 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     **kwargs)
> [Thu May 10 14:20:59.200603 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/views/generic/base.py",
> line 89, in dispatch
> [Thu May 10 14:20:59.200610 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return handler(request, *args, **kwargs)
> [Thu May 10 14:20:59.200616 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/allauth/account/views.py",
> line 101, in post
> [Thu May 10 14:20:59.200623 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     if form.is_valid():
> [Thu May 10 14:20:59.200629 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/forms/forms.py",
> line 184, in is_valid
> [Thu May 10 14:20:59.200635 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return self.is_bound and not self.errors
> [Thu May 10 14:20:59.200641 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/forms/forms.py",
> line 176, in errors
> [Thu May 10 14:20:59.200648 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     self.full_clean()
> [Thu May 10 14:20:59.200670 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/forms/forms.py",
> line 393, in full_clean
> [Thu May 10 14:20:59.200677 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     self._clean_form()
> [Thu May 10 14:20:59.200683 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/forms/forms.py",
> line 417, in _clean_form
> [Thu May 10 14:20:59.200689 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     cleaned_data = self.clean()
> [Thu May 10 14:20:59.200695 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/allauth/account/forms.py",
> line 159, in clean
> [Thu May 10 14:20:59.200701 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     **credentials)
> [Thu May 10 14:20:59.200707 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/allauth/account/adapter.py",
> line 483, in authenticate
> [Thu May 10 14:20:59.200713 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     user = authenticate(request=request, **credentials)
> [Thu May 10 14:20:59.200719 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/allauth/compat.py",
> line 54, in authenticate
> [Thu May 10 14:20:59.200725 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return authenticate(**credentials)
> [Thu May 10 14:20:59.200731 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/contrib/auth/__init__.py",
> line 74, in authenticate
> [Thu May 10 14:20:59.200756 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     user = backend.authenticate(**credentials)
> [Thu May 10 14:20:59.200764 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/contrib/auth/backends.py",
> line 18, in authenticate
> [Thu May 10 14:20:59.200770 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     if user.check_password(password):
> [Thu May 10 14:20:59.200776 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/contrib/auth/models.py",
> line 241, in check_password
> [Thu May 10 14:20:59.200782 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return check_password(raw_password, self.password,
> setter)
> [Thu May 10 14:20:59.200788 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/contrib/auth/hashers.py",
> line 62, in check_password
> [Thu May 10 14:20:59.200794 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     setter(password)
> [Thu May 10 14:20:59.200800 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/contrib/auth/models.py",
> line 240, in setter
> [Thu May 10 14:20:59.200807 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     self.save(update_fields=["password"])
> [Thu May 10 14:20:59.200813 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/geonode/people/models.py",
> line 169, in save
> [Thu May 10 14:20:59.200819 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     super(Profile, self).save(*args, **kwargs)
> [Thu May 10 14:20:59.200825 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/db/models/base.py",
> line 734, in save
> [Thu May 10 14:20:59.200831 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     force_update=force_update, update_fields=update_fields)
> [Thu May 10 14:20:59.200837 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/db/models/base.py",
> line 762, in save_base
> [Thu May 10 14:20:59.200843 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     updated = self._save_table(raw, cls, force_insert,
> force_update, using, update_fields)
> [Thu May 10 14:20:59.200855 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/db/models/base.py",
> line 827, in _save_table
> [Thu May 10 14:20:59.200861 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     forced_update)
> [Thu May 10 14:20:59.200867 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/db/models/base.py",
> line 877, in _do_update
> [Thu May 10 14:20:59.200874 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return filtered._update(values) > 0
> [Thu May 10 14:20:59.200880 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/db/models/query.py",
> line 580, in _update
> [Thu May 10 14:20:59.200886 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return query.get_compiler(self.db).execute_sql(CURSOR)
> [Thu May 10 14:20:59.200892 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
> line 1062, in execute_sql
> [Thu May 10 14:20:59.200898 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     cursor = super(SQLUpdateCompiler,
> self).execute_sql(result_type)
> [Thu May 10 14:20:59.200904 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
> line 840, in execute_sql
> [Thu May 10 14:20:59.200910 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     cursor.execute(sql, params)
> [Thu May 10 14:20:59.200916 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/db/backends/utils.py",
> line 79, in execute
> [Thu May 10 14:20:59.200923 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return super(CursorDebugWrapper, self).execute(sql,
> params)
> [Thu May 10 14:20:59.200928 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/db/backends/utils.py",
> line 64, in execute
> [Thu May 10 14:20:59.200935 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return self.cursor.execute(sql, params)
> [Thu May 10 14:20:59.200941 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/db/utils.py",
> line 98, in __exit__
> [Thu May 10 14:20:59.200947 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     six.reraise(dj_exc_type, dj_exc_value, traceback)
> [Thu May 10 14:20:59.200953 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/db/backends/utils.py",
> line 64, in execute
> [Thu May 10 14:20:59.200959 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return self.cursor.execute(sql, params)
> [Thu May 10 14:20:59.200965 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]   File
> "/home/geo/Envs/geonode/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py",
> line 318, in execute
> [Thu May 10 14:20:59.200971 2018] [wsgi:error] [pid 4130:tid
> 140163086272256]     return Database.Cursor.execute(self, query, params)
> [Thu May 10 14:20:59.200977 2018] [wsgi:error] [pid 4130:tid
> 140163086272256] OperationalError: attempt to write a readonly database
> 
> 
> Kind regards
> 
> Julierme

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20180510/ff413ad1/attachment-0001.html>


More information about the geonode-devel mailing list