[GeoNode-users] Customizing Geonode (Installed via apt-get) from Geonode-project Dev
Dave Kennewell
davekennewell at gmail.com
Wed Apr 25 21:50:08 PDT 2018
Hi Julierme,
Well, I learned now just how many Django apps use a sqlite database for the
backend... sorry about all the noise from that command. The answer was
actually already there, in the settings.DATABASES variable - "
/etc/julierme_virtualenv/my_geonode/local/lib/python2.7/
site-packages/geonode/development.db"
It seems you're still hitting the geonode development database, your
settings file is not being picked up by django.
This is likely some combination of your virtualenv, your wsgi & apache
setup and your geonode-project template. Honestly this is hard to resolve
over email, sorry.
You can either share your code, get someone local who is experienced with
Django to help, or, if you're on a cloud or virtualised server, rebuild and
check things step-by-step to see where they go wrong.
If you are on a virtualised server, and geonode is the only application
being served from that Operating System, you might want to keep things
simple and skip the usage of a virtual environment.
Let us know how you get on
Dave
On 23 April 2018 at 18:26, Julierme Pinheiro <
juliermeopensourcedeveloper at gmail.com> wrote:
> Hi Dave Kennewell,
>
> greetings from Brazil.
>
> The grep just finished. The response is many settings. py files.
>
> My first attempt, I chose one that is in /etc/julierme_virtualenv/my_
> geonode/lib/python2.7/site-packages/pinax/projects/basic_project/
>
> I commented out the configuration:
>
> #DATABASES = {
> # "default": {
> # "ENGINE": "django.db.backends.sqlite3", # Add
> "postgresql_psycopg2", "postgresql", "mysql", "sqlite3" or "oracle".
> # "NAME": "dev.db", # Or path to database
> file if using sqlite3.
> # "USER": "", # Not used with sqlite3.
> # "PASSWORD": "", # Not used with sqlite3.
> # "HOST": "", # Set to empty string
> for localhost. Not used with sqlite3.
> # "PORT": "", # Set to empty string
> for default. Not used with sqlite3.
> # }
> #}
>
>
> RESPONSE to settings.DATABASES
>
> {'default': {'ENGINE': 'django.db.backends.sqlite3', 'ATOMIC_REQUESTS':
> False, 'CONN_MAX_AGE': 600, 'HOST': '', 'USER': '', 'PASSWORD': '',
> 'OPTIONS': {}, 'AUTOCOMMIT': True, 'NAME': '/etc/julierme_virtualenv/my_
> geonode/local/lib/python2.7/site-packages/geonode/development.db',
> 'TIME_ZONE': 'UTC', 'PORT': '', 'TEST': {'COLLATION': None, 'CHARSET':
> None, 'NAME': None, 'MIRROR': None}}}
>
>
> Second attempt:
>
>
>
> DATABASES = {
> "default": {
> "ENGINE": "django.db.backends.postgresql_psycopg2",
> # Add "postgresql_psycopg2", "postgresql", "mysql", "sqlite3" or "oracle".
> "NAME": "geonode",
> # Or path to database file if using sqlite3.
> "USER": "geonode",
> # Not used with sqlite3.
> "PASSWORD": "DBImAITC",
> # Not used with sqlite3.
> "HOST": "localhost",
> # Set to empty string for localhost. Not used with
> sqlite3.
> "PORT": "5432",
> # Set to empty
> string for default. Not used with sqlite3.
> }
> }
>
> RESPONSE to settings.DATABASES
>
> {'default': {'ENGINE': 'django.db.backends.sqlite3', 'ATOMIC_REQUESTS':
> False, 'CONN_MAX_AGE': 600, 'HOST': '', 'USER': '', 'PASSWORD': '',
> 'OPTIONS': {}, 'AUTOCOMMIT': True, 'NAME': '/etc/julierme_virtualenv/my_
> geonode/local/lib/python2.7/site-packages/geonode/development.db',
> 'TIME_ZONE': 'UTC', 'PORT': '', 'TEST': {'COLLATION': None, 'CHARSET':
> None, 'NAME': None, 'MIRROR': None}}}
>
>
>
> Bellow find the response to the whole < grep -r
> "django.db.backends.sqlite3" "/" > command. Do you suggest a change for any
> of the settings.py listed in the grep?
>
> /etc/... is related to my_geonode (Geonode-Project Dev) and /usr/... is
> related to my Geonode (Apt-get) long-term project.
>
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-packages/dj_database_url.pyc
> matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/oauth2_provider/tests/settings.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/oauth2_provider/tests/settings.py: 'ENGINE':
> 'django.db.backends.sqlite3',
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/rest_framework_nested/runtests/settings.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/rest_framework_nested/runtests/settings.py: 'ENGINE':
> 'django.db.backends.sqlite3', # 'postgresql_psycopg2', 'postgresql',
> 'mysql', 'sqlite3', 'oracle'.
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/__init__.py,sha256=47DEQpj8HBSa-_TImW-
> 5JCeuQeRkm5NMpJWZG3hSuFU,0
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/base.py,sha256=Pe0K8CP7vI_7ZvzdqfIxlYESjVGU-
> TAU5LUhX2rDtk0,17462
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/client.py,sha256=Rg8Bwfj68kI78bjH2bEDQfAL008rCe
> gtk7gIqg3NpFU,305
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/creation.py,sha256=7byYbLiaJKs7yvTLkMa36J2eD7kPlH
> BOVa8mvpBRq7U,3297
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/features.py,sha256=G9NPPhgpknJBUrj0-
> pn8tHgBO5ThgeW6HEJ1KwdXshw,2631
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/backends/sqlite3/
> introspection.py,sha256=ROCqblFqWMBo4AhqHTKNZq5BRFy_2LguFd9AEmSwn20,11019
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/operations.py,sha256=Ov8yrILHFrmWiNU3E3PHmDjny2QgL1
> 6ujUk9OWazEi0,8655
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/schema.py,sha256=uvPssUfC8DxEzhgNkwgOBcMFmsTdw6
> 9hyxap_GvGpJg,11377
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/utils.py,sha256=x1hTKZrG2MkU5f7HUGnVXE3tJWXT4J
> 6C528QzSAB03Q,389
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/base.pyc,,
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/operations.pyc,,
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/backends/sqlite3/
> introspection.pyc,,
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/schema.pyc,,
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/client.pyc,,
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/features.pyc,,
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/__init__.pyc,,
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/utils.pyc,,
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/Django-1.8.19.dist-info/RECORD:django/db/
> backends/sqlite3/creation.pyc,,
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/treebeard/tests/settings.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/treebeard/tests/settings.py: 'ENGINE':
> 'django.db.backends.sqlite3',
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/testproject/settings.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/testproject/settings.py: 'ENGINE':
> 'django.db.backends.sqlite3',
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/geonode/contrib/geosites/README.md: 'ENGINE':
> 'django.db.backends.sqlite3',
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/geonode/contrib/geosites/site_template/local_settings_template.py:
> 'ENGINE': 'django.db.backends.sqlite3',
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/geonode/geoserver/tests.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/geonode/geoserver/tests.py: 'ENGINE':
> 'django.db.backends.sqlite3',
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/geonode/tests/bdd/conftest.py: 'ENGINE':
> 'django.db.backends.sqlite3',
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/geonode/tests/bdd/conftest.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/dj_database_url.py: 'sqlite': 'django.db.backends.sqlite3',
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/dj_pagination/tests/settings.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/dj_pagination/tests/settings.py: 'ENGINE':
> 'django.db.backends.sqlite3',
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pinax/projects/static_project/settings.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pinax/projects/static_project/settings.py: "ENGINE":
> "django.db.backends.sqlite3", # Add "postgresql_psycopg2", "postgresql",
> "mysql", "sqlite3" or "oracle".
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pinax/projects/zero_project/settings.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pinax/projects/zero_project/settings.py: "ENGINE":
> "django.db.backends.sqlite3", # Add "postgresql_psycopg2", "postgresql",
> "mysql", "sqlite3" or "oracle".
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pinax/projects/account_project/settings.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pinax/projects/account_project/settings.py: "ENGINE":
> "django.db.backends.sqlite3", # Add "postgresql_psycopg2", "postgresql",
> "mysql", "sqlite3" or "oracle".
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pinax/projects/basic_project/settings.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pinax/projects/basic_project/settings.py: "ENGINE":
> "django.db.backends.sqlite3", # Add "postgresql_psycopg2", "postgresql",
> "mysql", "sqlite3" or "oracle".
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pytest_django/db_reuse.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pytest_django/live_server_helper.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pytest_django/db_reuse.py: if connection.settings_dict['ENGINE']
> == 'django.db.backends.sqlite3':
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pytest_django/live_server_helper.py: if
> (conn.settings_dict['ENGINE'] == 'django.db.backends.sqlite3' and
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pytest_django/fixtures.py: if db_settings['ENGINE']
> == 'django.db.backends.sqlite3':
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/pytest_django/fixtures.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/actstream/runtests/settings.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/actstream/runtests/manage.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/actstream/runtests/settings.py:ENGINE = os.environ.get('DATABASE_ENGINE',
> 'django.db.backends.sqlite3')
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/actstream/runtests/manage.py:engine = os.environ.get('DATABASE_ENGINE',
> 'django.db.backends.sqlite3')
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/actstream/runtests/manage.py: engine =
> 'django.db.backends.sqlite3'
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/db/backends/sqlite3/__init__.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/db/backends/sqlite3/schema.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/db/backends/sqlite3/base.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/db/backends/sqlite3/features.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/db/backends/sqlite3/client.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/db/backends/sqlite3/introspection.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/db/backends/sqlite3/operations.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/db/backends/sqlite3/utils.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/db/backends/sqlite3/creation.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/features.py:from
> django.db.backends.sqlite3.features import \
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/base.py:from
> django.db.backends.sqlite3.base import (
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/introspection.py:from
> django.db.backends.sqlite3.introspection import (
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/client.py:from
> django.db.backends.sqlite3.client import DatabaseClient
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/operations.py:from
> django.db.backends.sqlite3.operations import DatabaseOperations
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/schema.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/base.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/adapter.py:from
> django.db.backends.sqlite3.base import Database
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/adapter.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/schema.py:from
> django.db.backends.sqlite3.schema import DatabaseSchemaEditor
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/features.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/client.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/introspection.pyc
> matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/operations.pyc matches
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/creation.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/contrib/gis/db/backends/spatialite/creation.py:from
> django.db.backends.sqlite3.creation import DatabaseCreation
> Binary file /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/conf/project_template/project_name/settings.pyc matches
> /etc/julierme_virtualenv/my_geonode/lib/python2.7/site-
> packages/django/conf/project_template/project_name/settings.py:
> 'ENGINE': 'django.db.backends.sqlite3',
> grep: /run/user/1000/gvfs: Permission denied
> Binary file /run/log/journal/18ac8792d324491caeaf131039b9cd97/system.journal
> matches
> /usr/local/lib/python2.7/dist-packages/geonode/contrib/geosites/README.md:
> 'ENGINE': 'django.db.backends.sqlite3',
> /usr/local/lib/python2.7/dist-packages/geonode/contrib/
> geosites/site_template/local_settings_template.py: 'ENGINE':
> 'django.db.backends.sqlite3',
> Binary file /usr/local/lib/python2.7/dist-packages/geonode/geoserver/tests.pyc
> matches
> /usr/local/lib/python2.7/dist-packages/geonode/geoserver/tests.py:
> 'ENGINE': 'django.db.backends.sqlite3',
> /usr/local/lib/python2.7/dist-packages/geonode/tests/bdd/conftest.py:
> 'ENGINE': 'django.db.backends.sqlite3',
> Binary file /usr/local/lib/python2.7/dist-packages/geonode/tests/bdd/conftest.pyc
> matches
> Binary file /usr/lib/python2.7/dist-packages/dj_database_url.pyc matches
> Binary file /usr/lib/python2.7/dist-packages/oauth2_provider/tests/settings.pyc
> matches
> /usr/lib/python2.7/dist-packages/oauth2_provider/tests/settings.py:
> 'ENGINE': 'django.db.backends.sqlite3',
> Binary file /usr/lib/python2.7/dist-packages/rest_framework_nested/runtests/settings.pyc
> matches
> /usr/lib/python2.7/dist-packages/rest_framework_
> nested/runtests/settings.py: 'ENGINE':
> 'django.db.backends.sqlite3', # 'postgresql_psycopg2', 'postgresql',
> 'mysql', 'sqlite3', 'oracle'.
> Binary file /usr/lib/python2.7/dist-packages/treebeard/tests/settings.pyc
> matches
> /usr/lib/python2.7/dist-packages/treebeard/tests/settings.py:
> 'ENGINE': 'django.db.backends.sqlite3',
> Binary file /usr/lib/python2.7/dist-packages/testproject/settings.pyc
> matches
> /usr/lib/python2.7/dist-packages/testproject/settings.py:
> 'ENGINE': 'django.db.backends.sqlite3',
> /usr/lib/python2.7/dist-packages/dj_database_url.py: 'sqlite':
> 'django.db.backends.sqlite3',
> Binary file /usr/lib/python2.7/dist-packages/dj_pagination/tests/settings.pyc
> matches
> /usr/lib/python2.7/dist-packages/dj_pagination/tests/settings.py:
> 'ENGINE': 'django.db.backends.sqlite3',
> Binary file /usr/lib/python2.7/dist-packages/actstream/runtests/settings.pyc
> matches
> Binary file /usr/lib/python2.7/dist-packages/actstream/runtests/manage.pyc
> matches
> /usr/lib/python2.7/dist-packages/actstream/runtests/settings.py:ENGINE =
> os.environ.get('DATABASE_ENGINE', 'django.db.backends.sqlite3')
> /usr/lib/python2.7/dist-packages/actstream/runtests/manage.py:engine =
> os.environ.get('DATABASE_ENGINE', 'django.db.backends.sqlite3')
> /usr/lib/python2.7/dist-packages/actstream/runtests/manage.py: engine
> = 'django.db.backends.sqlite3'
> Binary file /usr/lib/python2.7/dist-packages/django/db/backends/sqlite3/__init__.pyc
> matches
> Binary file /usr/lib/python2.7/dist-packages/django/db/backends/sqlite3/schema.pyc
> matches
> Binary file /usr/lib/python2.7/dist-packages/django/db/backends/sqlite3/base.pyc
> matches
> Binary file /usr/lib/python2.7/dist-packages/django/db/backends/sqlite3/features.pyc
> matches
> Binary file /usr/lib/python2.7/dist-packages/django/db/backends/sqlite3/client.pyc
> matches
> Binary file /usr/lib/python2.7/dist-packages/django/db/backends/sqlite3/introspection.pyc
> matches
> Binary file /usr/lib/python2.7/dist-packages/django/db/backends/sqlite3/operations.pyc
> matches
> Binary file /usr/lib/python2.7/dist-packages/django/db/backends/sqlite3/utils.pyc
> matches
> Binary file /usr/lib/python2.7/dist-packages/django/db/backends/sqlite3/creation.pyc
> matches
> /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/features.py:from django.db.backends.sqlite3.features
> import \
> /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/base.py:from django.db.backends.sqlite3.base
> import (
> /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/introspection.py:from django.db.backends.sqlite3.introspection
> import (
> /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/client.py:from django.db.backends.sqlite3.client
> import DatabaseClient
> /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/operations.py:from django.db.backends.sqlite3.operations
> import DatabaseOperations
> Binary file /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/schema.pyc matches
> Binary file /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/base.pyc matches
> /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/adapter.py:from django.db.backends.sqlite3.base
> import Database
> Binary file /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/adapter.pyc matches
> /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/schema.py:from django.db.backends.sqlite3.schema
> import DatabaseSchemaEditor
> Binary file /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/features.pyc matches
> Binary file /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/client.pyc matches
> Binary file /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/introspection.pyc matches
> Binary file /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/operations.pyc matches
> Binary file /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/creation.pyc matches
> /usr/lib/python2.7/dist-packages/django/contrib/gis/
> db/backends/spatialite/creation.py:from django.db.backends.sqlite3.creation
> import DatabaseCreation
> Binary file /usr/lib/python2.7/dist-packages/django/conf/project_
> template/project_name/settings.pyc matches
> /usr/lib/python2.7/dist-packages/django/conf/project_
> template/project_name/settings.py: 'ENGINE':
> 'django.db.backends.sqlite3',
>
> Thank you for your time and help.
>
> Best regards
>
> Julierme
>
>
>
>
>
>
> 2018-04-19 12:03 GMT-03:00 Dave Kennewell <davekennewell at gmail.com>:
>
>> OK, great Julierme, we're getting there!
>>
>> I'm guessing you want to run Django & geonode from this virtualenv, so
>> let's figure that out.
>>
>> You need to find in which settings file sets the
>> "django.db.backends.sqlite3" in your code, and then comment this section
>> out.
>>
>> If you can't find it, try something like:
>>
>> grep -r "django.db.backends.sqlite3" "/"
>>
>> which will search all files under your root directory "/" for this text.
>> You might need a coffee while you wait, and might need to use sudo to avoid
>> getting a bunch of "permission denied" messages.
>>
>> On 19 April 2018 at 18:42, Julierme Pinheiro <
>> juliermeopensourcedeveloper at gmail.com> wrote:
>>
>>> Looking at the ALLOWED_HOSTS and PROXY_ALLOWED_HOSTS in the settings.py
>>> in my_geonode (Geonode-project DEV)
>>>
>>> ALLOWED_HOSTS = ['localhost', 'django', '172.21.14.45'] if
>>> os.getenv('ALLOWED_HOSTS') is None \
>>> else re.split(r' *[,|:|;] *', os.getenv('ALLOWED_HOSTS'))
>>>
>>> PROXY_ALLOWED_HOSTS += ('nominatim.openstreetmap.org', '172.21.14.45',)
>>>
>>> I am not sure if that configuration is missing something.
>>>
>>> Kind regards
>>>
>>> Julierme
>>>
>>>
>>> 2018-04-19 11:17 GMT-03:00 Julierme Pinheiro <
>>> juliermeopensourcedeveloper at gmail.com>:
>>>
>>>> Dear Toni Schonbuchner and Dave Kennewell,
>>>>
>>>> Thank you very much for your reply.
>>>>
>>>> First if I did not misunderstand Toni suggestion, I tried the following:
>>>>
>>>> *1 - Commenting out <# ENGINE': '', # Empty ENGINE name disables> from
>>>> local_settings.py in my_geonode (Geonode-Project Dev virtualenv)*
>>>>
>>>> Result: the problem remains
>>>>
>>>> *2 - Uncommenting out < ENGINE': '', # Empty ENGINE name disables> from
>>>> local_settings.py in my_geonode (Geonode-Project Dev virtualenv) and
>>>> inserting the line < ENGINE': '', # Empty ENGINE name disables> in
>>>> local_settings.py from Geonode (Geonode apt-get)*.
>>>>
>>>> Result: the problem remains
>>>>
>>>> However, I got a new response to Dave Kennewell suggestion after
>>>> activating my_geonode virtualenv:
>>>>
>>>> *settings.DATABASES*
>>>> {'default': {'ENGINE': 'django.db.backends.sqlite3', 'ATOMIC_REQUESTS':
>>>> False, 'CONN_MAX_AGE': 600, 'HOST': '', 'USER': '', 'PASSWORD': '',
>>>> 'OPTIONS': {}, 'AUTOCOMMIT': True, 'NAME': '/etc/julierme_virtualenv/my_g
>>>> eonode/local/lib/python2.7/site-packages/geonode/development.db',
>>>> 'TIME_ZONE': 'UTC', 'PORT': '', 'TEST': {'COLLATION': None, 'CHARSET':
>>>> None, 'NAME': None, 'MIRROR': None}}}
>>>>
>>>> I think there is no database being used.
>>>>
>>>> I also have to make some few notes:
>>>>
>>>> *1 - ALLOWED_HOSTS, PROXY_ALLOWED_HOSTS and POSTGIS_VERSION are
>>>> commented out in local_settings.py in my_geonode (Geonode-Project Dev)*
>>>>
>>>> *2 - Geoserver Port is 8080 in Geonode(apt-get) and 6060 in
>>>> my_geonode(Geonode-Project Dev), but both are running fine.*
>>>>
>>>>
>>>> Thank you very much for your time and patience.
>>>>
>>>> I appreciated it.
>>>>
>>>> Julierme
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> 2018-04-19 4:29 GMT-03:00 Toni Schönbuchner <
>>>> toni.schoenbuchner at csgis.de>:
>>>>
>>>>> Dear Julierme,
>>>>>
>>>>> I haven´t followed the whole thread but have a look at this comment:
>>>>>
>>>>> 'ENGINE': '', # Empty ENGINE name disables
>>>>>
>>>>> See if things change if you set ENGINE to geonode in your project.
>>>>>
>>>>> Best regards,
>>>>>
>>>>> 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 18.04.2018 um 21:13 schrieb geonode-users-request at lists.osgeo.org:
>>>>>
>>>>> 'ENGINE': '', # Empty ENGINE name disables
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>> _______________________________________________
>> geonode-users mailing list
>> geonode-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/geonode-users
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20180426/db4b07fe/attachment-0001.html>
More information about the geonode-users
mailing list