[GeoNode-users] Failed to save to Geoserver catalog: 500, Store already exists in workspace 'geonode'.
Alessio Fabiani
alessio.fabiani at geo-solutions.it
Thu Aug 29 04:09:34 PDT 2019
Hi,
uhm that's very strange. Could you please run the following command and
tell me the output?
pip freeze | grep -i config
Il giorno mar 27 ago 2019 alle ore 01:39 Israel López <asralf at gmail.com> ha
scritto:
> Hi guys, I'm testing de 2.10.0-release branch on a Ubuntu installation dev
> mode (no docker), when the local_settings.py.geoserver.sample is edited and
> assign postgres databases, I got
> this error when I'm trying to upload a second shape. The first time
> everything is ok,
> but in the second time I get this error always, I've tried to with clean
> databases again
> and always is the same.
>
> Does I'm doing something wrong??
>
> The error says:
>
> Traceback (most recent call last):
> File "/home/israel/Proyectos/geonode/geonode/upload/views.py", line 650,
> in view
> resp = _steps[step](req, upload_session)
> File "/home/israel/Proyectos/geonode/geonode/upload/views.py", line 425,
> in check_step_view
> return next_step_response(request, upload_session)
> File "/home/israel/Proyectos/geonode/geonode/upload/utils.py", line 382,
> in next_step_response
> return run_response(req, upload_session)
> File "/home/israel/Proyectos/geonode/geonode/upload/utils.py", line 618,
> in run_response
> run_import(upload_session)
> File "/home/israel/Proyectos/geonode/geonode/upload/utils.py", line 584,
> in run_import
> store_name=ogc_server_settings.datastore_db['NAME']
> File "/home/israel/Proyectos/geonode/geonode/geoserver/helpers.py", line
> 1293, in create_geoserver_db_featurestore
> cat.save(ds)
> File
> "/home/israel/.virtualenvs/forkGeonode/local/lib/python2.7/site-packages/geoserver/catalog.py",
> line 290, in save
> raise FailedRequestError('Failed to save to Geoserver catalog: {},
> {}'.format(resp.status_code, resp.text))
> FailedRequestError: Failed to save to Geoserver catalog: 500, Store
> 'base1_data' already exists in workspace 'geonode'
>
> I've found that the next line can't get the datastore and tries to create
> it again,
> so then raises the error.
>
> helpers.py line 1248
>
> if dsname:
> ds = cat.get_store(dsname)
>
> My local_settings.py
>
> import ast
> import os
> from urlparse import urlparse, urlunparse
> from geonode.settings import *
>
> PROJECT_ROOT = os.path.abspath(os.path.dirname(__file__))
>
> MEDIA_ROOT = os.getenv('MEDIA_ROOT', os.path.join(PROJECT_ROOT, "uploaded"))
>
> STATIC_ROOT = os.getenv('STATIC_ROOT',
> os.path.join(PROJECT_ROOT, "static_root")
> )
>
> TIME_ZONE = 'UTC'
>
> # Backend
> DATABASES = {
> 'default': {
> 'ENGINE': 'django.db.backends.postgresql_psycopg2',
> 'NAME': 'base1',
> 'USER': 'idegeo',
> 'PASSWORD': 'idegeo',
> 'HOST': 'localhost',
> 'PORT': '5432',
> 'CONN_TOUT': 900,
> },
> # vector datastore for uploads
> 'datastore': {
> 'ENGINE': 'django.contrib.gis.db.backends.postgis',
> # 'ENGINE': '', # Empty ENGINE name disables
> 'NAME': 'base1_data',
> 'USER': 'idegeo',
> 'PASSWORD': 'idegeo',
> 'HOST': 'localhost',
> 'PORT': '5432',
> 'CONN_TOUT': 900,
> }
> }
>
> GEOSERVER_LOCATION = os.getenv(
> 'GEOSERVER_LOCATION', 'http://localhost:8080/geoserver/'
> )
>
> GEOSERVER_PUBLIC_HOST = os.getenv(
> 'GEOSERVER_PUBLIC_HOST', SITE_HOST_NAME
> )
>
> GEOSERVER_PUBLIC_PORT = os.getenv(
> 'GEOSERVER_PUBLIC_PORT', 8080
> )
>
> _default_public_location = 'http://{}:{}/geoserver/'.format(GEOSERVER_PUBLIC_HOST, GEOSERVER_PUBLIC_PORT) if GEOSERVER_PUBLIC_PORT else 'http://{}/geoserver/'.format(GEOSERVER_PUBLIC_HOST)
>
> GEOSERVER_WEB_UI_LOCATION = os.getenv(
> 'GEOSERVER_WEB_UI_LOCATION', GEOSERVER_LOCATION
> )
>
> GEOSERVER_PUBLIC_LOCATION = os.getenv(
> 'GEOSERVER_PUBLIC_LOCATION', _default_public_location
> )
>
> OGC_SERVER_DEFAULT_USER = os.getenv(
> 'GEOSERVER_ADMIN_USER', 'admin'
> )
>
> OGC_SERVER_DEFAULT_PASSWORD = os.getenv(
> 'GEOSERVER_ADMIN_PASSWORD', 'geoserver'
> )
>
> # OGC (WMS/WFS/WCS) Server Settings
> OGC_SERVER = {
> 'default': {
> 'BACKEND': 'geonode.geoserver',
> 'LOCATION': GEOSERVER_LOCATION,
> 'WEB_UI_LOCATION': GEOSERVER_WEB_UI_LOCATION,
> 'LOGIN_ENDPOINT': 'j_spring_oauth2_geonode_login',
> 'LOGOUT_ENDPOINT': 'j_spring_oauth2_geonode_logout',
> # PUBLIC_LOCATION needs to be kept like this because in dev mode
> # the proxy won't work and the integration tests will fail
> # the entire block has to be overridden in the local_settings
> 'PUBLIC_LOCATION': GEOSERVER_PUBLIC_LOCATION,
> 'USER': OGC_SERVER_DEFAULT_USER,
> 'PASSWORD': OGC_SERVER_DEFAULT_PASSWORD,
> 'MAPFISH_PRINT_ENABLED': True,
> 'PRINT_NG_ENABLED': True,
> 'GEONODE_SECURITY_ENABLED': True,
> 'GEOFENCE_SECURITY_ENABLED': True,
> 'WMST_ENABLED': False,
> 'BACKEND_WRITE_ENABLED': True,
> 'WPS_ENABLED': False,
> 'LOG_FILE': '%s/geoserver/data/logs/geoserver.log' % os.path.abspath(os.path.join(PROJECT_ROOT, os.pardir)),
> # Set to dictionary identifier of database containing spatial data in DATABASES dictionary to enable
> 'DATASTORE': 'datastore',
> 'TIMEOUT': int(os.getenv('OGC_REQUEST_TIMEOUT', '5')),
> 'MAX_RETRIES': int(os.getenv('OGC_REQUEST_MAX_RETRIES', '5')),
> 'BACKOFF_FACTOR': float(os.getenv('OGC_REQUEST_BACKOFF_FACTOR', '0.3')),
> 'POOL_MAXSIZE': int(os.getenv('OGC_REQUEST_POOL_MAXSIZE', '10')),
> 'POOL_CONNECTIONS': int(os.getenv('OGC_REQUEST_POOL_CONNECTIONS', '10')),
> }
> }
>
> # WARNING: Map Editing is affected by this. GeoExt Configuration is cached for 5 minutes
> # CACHES = {
> # 'default': {
> # 'BACKEND': 'django.core.cache.backends.filebased.FileBasedCache',
> # 'LOCATION': '/var/tmp/django_cache',
> # }
> # }
>
> # If you want to enable Mosaics use the following configuration
> UPLOADER = {
> # 'BACKEND': 'geonode.rest',
> 'BACKEND': 'geonode.importer',
> 'OPTIONS': {
> 'TIME_ENABLED': True,
> 'MOSAIC_ENABLED': False,
> },
> 'SUPPORTED_CRS': [
> 'EPSG:4326',
> 'EPSG:3785',
> 'EPSG:3857',
> 'EPSG:32647',
> 'EPSG:32736'
> ],
> 'SUPPORTED_EXT': [
> '.shp',
> '.csv',
> '.kml',
> '.kmz',
> '.json',
> '.geojson',
> '.tif',
> '.tiff',
> '.geotiff',
> '.gml',
> '.xml'
> ]
> }
>
> # CSW settings
> CATALOGUE = {
> 'default': {
> # The underlying CSW implementation
> # default is pycsw in local mode (tied directly to GeoNode Django DB)
> 'ENGINE': 'geonode.catalogue.backends.pycsw_local',
> # pycsw in non-local mode
> # 'ENGINE': 'geonode.catalogue.backends.pycsw_http',
> # GeoNetwork opensource
> # 'ENGINE': 'geonode.catalogue.backends.geonetwork',
> # deegree and others
> # 'ENGINE': 'geonode.catalogue.backends.generic',
>
> # The FULLY QUALIFIED base url to the CSW instance for this GeoNode
> 'URL': urljoin(SITEURL, '/catalogue/csw'),
> # 'URL': 'http://localhost:8080/geonetwork/srv/en/csw',
> # 'URL': 'http://localhost:8080/deegree-csw-demo-3.0.4/services',
>
> # login credentials (for GeoNetwork)
> # 'USER': 'admin',
> # 'PASSWORD': 'admin',
>
> # 'ALTERNATES_ONLY': True,
> }
> }
>
> # pycsw settings
> PYCSW = {
> # pycsw configuration
> 'CONFIGURATION': {
> # uncomment / adjust to override server config system defaults
> # 'server': {
> # 'maxrecords': '10',
> # 'pretty_print': 'true',
> # 'federatedcatalogues': 'http://catalog.data.gov/csw'
> # },
> 'server': {
> 'home': '.',
> 'url': CATALOGUE['default']['URL'],
> 'encoding': 'UTF-8',
> 'language': LANGUAGE_CODE,
> 'maxrecords': '20',
> 'pretty_print': 'true',
> # 'domainquerytype': 'range',
> 'domaincounts': 'true',
> 'profiles': 'apiso,ebrim',
> },
> 'manager': {
> # authentication/authorization is handled by Django
> 'transactions': 'false',
> 'allowed_ips': '*',
> # 'csw_harvest_pagesize': '10',
> },
> 'metadata:main': {
> 'identification_title': 'GeoNode Catalogue',
> 'identification_abstract': 'GeoNode is an open source platform' \
> ' that facilitates the creation, sharing, and collaborative use' \
> ' of geospatial data',
> 'identification_keywords': 'sdi, catalogue, discovery, metadata,' \
> ' GeoNode',
> 'identification_keywords_type': 'theme',
> 'identification_fees': 'None',
> 'identification_accessconstraints': 'None',
> 'provider_name': 'Organization Name',
> 'provider_url': SITEURL,
> 'contact_name': 'Lastname, Firstname',
> 'contact_position': 'Position Title',
> 'contact_address': 'Mailing Address',
> 'contact_city': 'City',
> 'contact_stateorprovince': 'Administrative Area',
> 'contact_postalcode': 'Zip or Postal Code',
> 'contact_country': 'Country',
> 'contact_phone': '+xx-xxx-xxx-xxxx',
> 'contact_fax': '+xx-xxx-xxx-xxxx',
> 'contact_email': 'Email Address',
> 'contact_url': 'Contact URL',
> 'contact_hours': 'Hours of Service',
> 'contact_instructions': 'During hours of service. Off on ' \
> 'weekends.',
> 'contact_role': 'pointOfContact',
> },
> 'metadata:inspire': {
> 'enabled': 'true',
> 'languages_supported': 'eng,gre',
> 'default_language': 'eng',
> 'date': 'YYYY-MM-DD',
> 'gemet_keywords': 'Utility and governmental services',
> 'conformity_service': 'notEvaluated',
> 'contact_name': 'Organization Name',
> 'contact_email': 'Email Address',
> 'temp_extent': 'YYYY-MM-DD/YYYY-MM-DD',
> }
> }
> }
>
> LOGGING = {
> 'version': 1,
> 'disable_existing_loggers': True,
> 'formatters': {
> 'verbose': {
> 'format': '%(levelname)s %(asctime)s %(module)s %(process)d '
> '%(thread)d %(message)s'
> },
> 'simple': {
> 'format': '%(message)s',
> },
> },
> 'filters': {
> 'require_debug_false': {
> '()': 'django.utils.log.RequireDebugFalse'
> }
> },
> 'handlers': {
> 'console': {
> 'level': 'DEBUG',
> 'class': 'logging.StreamHandler',
> 'formatter': 'simple'
> },
> 'mail_admins': {
> 'level': 'ERROR',
> 'filters': ['require_debug_false'],
> 'class': 'django.utils.log.AdminEmailHandler',
> }
> },
> "loggers": {
> "django": {
> "handlers": ["console"], "level": "ERROR", },
> "geonode": {
> "handlers": ["console"], "level": "INFO", },
> "geonode.qgis_server": {
> "handlers": ["console"], "level": "ERROR", },
> "gsconfig.catalog": {
> "handlers": ["console"], "level": "ERROR", },
> "owslib": {
> "handlers": ["console"], "level": "ERROR", },
> "pycsw": {
> "handlers": ["console"], "level": "INFO", },
> "celery": {
> 'handlers': ["console"], 'level': 'ERROR', },
> },
> }
>
> # Additional settings
> X_FRAME_OPTIONS = 'ALLOW-FROM %s' % SITEURL
> CORS_ORIGIN_ALLOW_ALL = True
>
> GEOIP_PATH = "/usr/local/share/GeoIP"
>
> ACCOUNT_OPEN_SIGNUP = True
> ACCOUNT_APPROVAL_REQUIRED = True
>
> Could you help me, thanks in advance.
>
>
> _______________________________________________
> geonode-users mailing list
> geonode-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/geonode-users
>
--
==
GeoServer Professional Services from the experts! Visit http://goo.gl/it488V
for more information.
==
Ing. Alessio Fabiani
@alfa7691
Founder/Technical Lead
GeoSolutions S.A.S.
Via di Montramito 3/A - 55054 Massarosa (LU) - Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 331 6233686
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE
2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si
precisa che ogni circostanza inerente alla presente email (il suo
contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è
riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il
messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra
operazione è illecita. Le sarei comunque grato se potesse darmene notizia.
This email is intended only for the person or entity to which it is
addressed and may contain information that is privileged, confidential or
otherwise protected from disclosure. We remind that - as provided by
European Regulation 2016/679 “GDPR” - copying, dissemination or use of this
e-mail or the information herein by anyone other than the intended
recipient is prohibited. If you have received this email by mistake, please
notify us immediately by telephone or e-mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20190829/03fdd92f/attachment-0001.html>
More information about the geonode-users
mailing list