[GeoNode-devel] Geonode Unable to Sign in (Julierme Pinheiro)
Julierme Pinheiro
juliermeopensourcedeveloper at gmail.com
Thu May 10 13:36:00 PDT 2018
Hi Toni Schonbuchner,
Thank you for your reply. Discussing here with my IT colleague, we realized
that DB could be the one in:
/usr/local/lib/python2.7/dist-packages/geonode/development.db
We changed the development.db permission by
chmod a+w /usr/local/lib/python2.7/dist-packages/geonode/development.db
I got very excited about python manage.py createsuperuser because I was
asked for the:
username:
Email address:
Password:
Password (again):
But at the end, look the finally response:
geo at geo:/home/geonode/my_geonode$ python manage.py createsuperuser
Username: juliermeadmin
Email address: julierme.pinheiro at sipam.gov.br
Password:
Password (again):
Traceback (most recent call last):
File "manage.py", line 31, in <module>
execute_from_command_line(sys.argv)
File
"/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py",
line 354, in execute_from_command_line
utility.execute()
File
"/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py",
line 346, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File
"/usr/local/lib/python2.7/dist-packages/django/core/management/base.py",
line 394, in run_from_argv
self.execute(*args, **cmd_options)
File
"/usr/local/lib/python2.7/dist-packages/django/contrib/auth/management/commands/createsuperuser.py",
line 50, in execute
return super(Command, self).execute(*args, **options)
File
"/usr/local/lib/python2.7/dist-packages/django/core/management/base.py",
line 445, in execute
output = self.handle(*args, **options)
File
"/usr/local/lib/python2.7/dist-packages/django/contrib/auth/management/commands/createsuperuser.py",
line 149, in handle
self.UserModel._default_manager.db_manager(database).create_superuser(**user_data)
File
"/usr/local/lib/python2.7/dist-packages/django/contrib/auth/models.py",
line 191, in create_superuser
**extra_fields)
File
"/usr/local/lib/python2.7/dist-packages/django/contrib/auth/models.py",
line 182, in _create_user
user.save(using=self._db)
File "/usr/local/lib/python2.7/dist-packages/geonode/people/models.py",
line 169, in save
super(Profile, self).save(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py",
line 734, in save
force_update=force_update, update_fields=update_fields)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py",
line 762, in save_base
updated = self._save_table(raw, cls, force_insert, force_update, using,
update_fields)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py",
line 846, in _save_table
result = self._do_insert(cls._base_manager, using, fields, update_pk,
raw)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py",
line 885, in _do_insert
using=using, raw=raw)
File
"/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py", line
127, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py",
line 920, in _insert
return query.get_compiler(using=using).execute_sql(return_id)
File
"/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py",
line 974, in execute_sql
cursor.execute(sql, params)
File
"/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line
79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File
"/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line
64, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line
98, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File
"/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line
64, in execute
return self.cursor.execute(sql, params)
File
"/usr/local/lib/python2.7/dist-packages/django/db/backends/sqlite3/base.py",
line 318, in execute
return Database.Cursor.execute(self, query, params)
django.db.utils.OperationalError: unable to open database file
Also, looking at /usr/local/lib/python2.7/dist-packages/django/db/backends
I found the following directories: sqlite3 mysql oracle
postgresql_psycopg2 base dummy
and the following files:__init__.py __init__.pyc signals.py
signals.pyc util.py util.pyc utils.py utils.pyc
Tweaking through sqlite3 directory, I got the following:
-rw-r--r-- 1 root staff 17462 Mai 8 13:39 base.py
-rw-r--r-- 1 root staff 17022 Mai 8 13:39 base.pyc
-rw-r--r-- 1 root staff 305 Mai 8 13:39 client.py
-rw-r--r-- 1 root staff 814 Mai 8 13:39 client.pyc
-rw-r--r-- 1 root staff 3297 Mai 8 13:39 creation.py
-rw-r--r-- 1 root staff 3603 Mai 8 13:39 creation.pyc
-rw-r--r-- 1 root staff 2631 Mai 8 13:39 features.py
-rw-r--r-- 1 root staff 3432 Mai 8 13:39 features.pyc
-rw-r--r-- 1 root staff 0 Mai 8 13:39 __init__.py
-rw-r--r-- 1 root staff 156 Mai 8 13:39 __init__.pyc
-rw-r--r-- 1 root staff 11019 Mai 8 13:39 introspection.py
-rw-r--r-- 1 root staff 9354 Mai 8 13:39 introspection.pyc
-rw-r--r-- 1 root staff 8655 Mai 8 13:39 operations.py
-rw-r--r-- 1 root staff 10228 Mai 8 13:39 operations.pyc
-rw-r--r-- 1 root staff 11377 Mai 8 13:39 schema.py
-rw-r--r-- 1 root staff 8944 Mai 8 13:39 schema.pyc
-rw-r--r-- 1 root staff 389 Mai 8 13:39 utils.py
-rw-r--r-- 1 root staff 710 Mai 8 13:39 utils.pyc
Note: At the beginning of geonode installation I set Source
/usr/local/bin/virtualenvwrapper.sh
and the tutorial sets
source $HOME/.local/bin/virtualenvwrapper.sh
I wonder if this could cause any issue.
I appreciated your time.
Kind regards
Julierme
2018-05-10 14:57 GMT-03:00 Toni Schönbuchner <toni.schoenbuchner at csgis.de>:
> 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
> <https://maps.google.com/?q=Kolonnadenstra%C3%9Fe+1+04109+Leipzig&entry=gmail&source=g>
> 04109 Leipzig
> <https://maps.google.com/?q=Kolonnadenstra%C3%9Fe+1+04109+Leipzig&entry=gmail&source=g>
> -----------------------------------------------
> 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>
> To: Alessio Fabiani <alessio.fabiani at geo-solutions.it>
> Cc: ANDRIAMIADANTSOA Fanevanjanahary <fanevanjanahary at gmail.com>,
> geonode-users <geonode-users at lists.osgeo.org>, geonode-devel
> <geonode-devel at lists.osgeo.org>
> Subject: Re: [GeoNode-devel] [GeoNode-users] Geonode Unable to Sign
> in
> Message-ID:
> <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/a520c7e5/attachment-0001.html>
More information about the geonode-devel
mailing list