[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