#django #nginx #gis
Вопрос:
Я прохожу процесс установки, и когда я дойду до шага 6.3, обновите конфигурацию OAuth2, чтобы ввести новое имя хоста.
ПРЕДУПРЕЖДЕНИЯ sudo PYTHON=игнорировать VIRTUAL_ENV=$VIRTUAL_ENV DJANGO_SETTINGS_MODULE=геонод.настройки GEONODE_ETC=/opt/геонод/геонод ГЕОСЕРВЕР_DATA_DIR=/opt/данные/геосервер_data TOMCAT_SERVICE=»служба tomcat» APACHE_SERVICE=»служба nginx» геонод_упдатеип -l локальный хост-p csdc.immap.org
Я получил эти ошибки, связанные с базой данных:
Traceback (most recent call last):
File "/home/geonode/.virtualenvs/geonode/bin/django-admin", line 8, in <module>
sys.exit(execute_from_command_line())
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
utility.execute()
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/core/management/__init__.py", line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/core/management/base.py", line 323, in run_from_argv
self.execute(*args, **cmd_options)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/core/management/base.py", line 364, in execute
output = self.handle(*args, **options)
File "/opt/geonode/geonode/base/management/commands/fixsitename.py", line 39, in handle
site = Site.objects.get_current()
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/contrib/sites/models.py", line 58, in get_current
return self._get_site_by_id(site_id)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/contrib/sites/models.py", line 30, in _get_site_by_id
site = self.get(pk=site_id)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/models/manager.py", line 82, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/models/query.py", line 402, in get
num = len(clone)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/models/query.py", line 256, in __len__
self._fetch_all()
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/models/query.py", line 1242, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/models/query.py", line 55, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/models/sql/compiler.py", line 1142, in execute_sql
cursor.execute(sql, params)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/backends/utils.py", line 99, in execute
return super().execute(sql, params)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/utils.py", line 89, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/home/geonode/.virtualenvs/geonode/lib/python3.8/site-packages/django/db/backends/sqlite3/base.py", line 383, in execute
return Database.Cursor.execute(self, query, params)
django.db.utils.OperationalError: no such table: django_site
Я мог видеть, что это относится к sqlite3, поэтому я пытаюсь выполнить следующие шаги, чтобы продолжать обновлять ip, запущены nginx, uwsgi, процесс tomcat, и URL-адрес geoserver работает идеально, но при доступе к URL-адресу geonode я всегда получал 502 плохих ошибки шлюза.
uwsgi геонод.журнал:
Mon Aug 30 19:47:37 2021 - *** Operational MODE: preforking ***
Mon Aug 30 19:47:37 2021 - *** no app loaded. going in full dynamic mode ***
Mon Aug 30 19:47:37 2021 - *** uWSGI is running in multiple interpreter mode ***
Mon Aug 30 19:47:37 2021 - !!!!!!!!!!!!!! WARNING !!!!!!!!!!!!!!
Mon Aug 30 19:47:37 2021 - no request plugin is loaded, you will not be able to manage requests.
Mon Aug 30 19:47:37 2021 - you may need to install the package for your language of choice, or simply load it with --plugin.
Mon Aug 30 19:47:37 2021 - !!!!!!!!!!! END OF WARNING !!!!!!!!!!
Mon Aug 30 19:47:37 2021 - spawned uWSGI master process (pid: 23009)
Mon Aug 30 19:47:37 2021 - spawned uWSGI worker 1 (pid: 23014, cores: 1)
Mon Aug 30 19:47:37 2021 - spawned uWSGI worker 2 (pid: 23015, cores: 1)
Mon Aug 30 19:51:04 2021 - SIGINT/SIGQUIT received...killing workers...
Mon Aug 30 19:51:05 2021 - worker 1 buried after 1 seconds
Mon Aug 30 19:51:05 2021 - worker 2 buried after 1 seconds
Mon Aug 30 19:51:05 2021 - goodbye to uWSGI.
Mon Aug 30 19:51:05 2021 - *** Starting uWSGI 2.0.18-debian (64bit) on [Mon Aug 30 19:51:05 2021] ***
Mon Aug 30 19:51:05 2021 - compiled with version: 10.0.1 20200405 (experimental) [master revision 0be9efad938:fcb98e4978a:705510a708d3642c9c962beb663c476167e4e8a4] on 11 April 2020 11:15:55
Mon Aug 30 19:51:05 2021 - os: Linux-5.4.0-81-generic #91-Ubuntu SMP Thu Jul 15 19:09:17 UTC 2021
Mon Aug 30 19:51:05 2021 - nodename: immap-geonode
Mon Aug 30 19:51:05 2021 - machine: x86_64
Mon Aug 30 19:51:05 2021 - clock source: unix
Mon Aug 30 19:51:05 2021 - pcre jit disabled
Mon Aug 30 19:51:05 2021 - detected number of CPU cores: 4
Mon Aug 30 19:51:05 2021 - current working directory: /
Mon Aug 30 19:51:05 2021 - writing pidfile to /run/uwsgi/app/geonode/pid
Mon Aug 30 19:51:05 2021 - detected binary path: /usr/bin/uwsgi-core
Mon Aug 30 19:51:05 2021 - your processes number limit is 31710
Mon Aug 30 19:51:05 2021 - your memory page size is 4096 bytes
Mon Aug 30 19:51:05 2021 - detected max file descriptor number: 1024
Mon Aug 30 19:51:05 2021 - lock engine: pthread robust mutexes
Mon Aug 30 19:51:05 2021 - thunder lock: disabled (you can enable it with --thunder-lock)
Mon Aug 30 19:51:05 2021 - uwsgi socket 0 bound to UNIX address /run/uwsgi/app/geonode/socket fd 3
Mon Aug 30 19:51:05 2021 - setgid() to 33
Mon Aug 30 19:51:05 2021 - setuid() to 33
Mon Aug 30 19:51:05 2021 - your server socket listen backlog is limited to 100 connections
Mon Aug 30 19:51:05 2021 - your mercy for graceful operations on workers is 60 seconds
Mon Aug 30 19:51:05 2021 - mapped 218760 bytes (213 KB) for 2 cores
Mon Aug 30 19:51:05 2021 - *** Operational MODE: preforking ***
Mon Aug 30 19:51:05 2021 - *** no app loaded. going in full dynamic mode ***
Mon Aug 30 19:51:05 2021 - *** uWSGI is running in multiple interpreter mode ***
Mon Aug 30 19:51:05 2021 - !!!!!!!!!!!!!! WARNING !!!!!!!!!!!!!!
Mon Aug 30 19:51:05 2021 - no request plugin is loaded, you will not be able to manage requests.
Mon Aug 30 19:51:05 2021 - you may need to install the package for your language of choice, or simply load it with --plugin.
Mon Aug 30 19:51:05 2021 - !!!!!!!!!!! END OF WARNING !!!!!!!!!!
Mon Aug 30 19:51:05 2021 - spawned uWSGI master process (pid: 23449)
Mon Aug 30 19:51:05 2021 - spawned uWSGI worker 1 (pid: 23452, cores: 1)
Mon Aug 30 19:51:05 2021 - spawned uWSGI worker 2 (pid: 23453, cores: 1)
nginx error.log
2021/08/30 19:30:10 [error] 22148#22148: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:30:10 [error] 22148#22148: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:30:57 [error] 22148#22148: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:30:57 [error] 22148#22148: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:32:51 [error] 22149#22149: *8 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:32:51 [error] 22149#22149: *8 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:37:48 [error] 22625#22625: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:37:49 [error] 22625#22625: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:37:50 [error] 22625#22625: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:37:51 [error] 22625#22625: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:37:57 [error] 22625#22625: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:37:57 [error] 22625#22625: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:45:32 [error] 22625#22625: *9 connect() failed (111: Connection refused) while connecting to upstream, client: 136.144.41.187, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "159.65.231.205:80"
2021/08/30 19:47:50 [error] 23038#23038: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:47:50 [error] 23038#23038: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:48:07 [error] 23038#23038: *8 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:48:07 [error] 23038#23038: *8 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:48:08 [error] 23038#23038: *8 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:48:09 [error] 23038#23038: *8 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:50:39 [error] 23154#23154: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 66.249.73.92, server: csdc.immap.org, request: "GET /robots.txt HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:51:09 [error] 23259#23259: *2 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:51:09 [error] 23259#23259: *2 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:51:10 [error] 23259#23259: *2 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:51:10 [error] 23259#23259: *2 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:56:40 [error] 23549#23549: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:56:40 [error] 23549#23549: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:56:42 [error] 23549#23549: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:56:42 [error] 23549#23549: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:56:42 [error] 23549#23549: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:56:43 [error] 23549#23549: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 19:56:44 [error] 23549#23549: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 19:56:44 [error] 23549#23549: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org>
2021/08/30 20:07:40 [error] 23549#23549: *11 connect() failed (111: Connection refused) while connecting to upstream, client: 183.136.225.14, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "159.65.231.205:80"
2021/08/30 20:08:34 [error] 23549#23549: *13 connect() failed (111: Connection refused) while connecting to upstream, client: 183.136.225.14, server: csdc.immap.org, request: "GET /robots.txt HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "159.65.231.205>
2021/08/30 20:08:35 [error] 23549#23549: *15 connect() failed (111: Connection refused) while connecting to upstream, client: 183.136.225.14, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "159.65.231.205:80"
2021/08/30 20:08:36 [error] 23549#23549: *17 connect() failed (111: Connection refused) while connecting to upstream, client: 183.136.225.14, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "159.65.231.20>
2021/08/30 20:09:30 [error] 23549#23549: *20 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 20:09:30 [error] 23549#23549: *20 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.or>
2021/08/30 20:09:32 [error] 23549#23549: *20 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET / HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.org"
2021/08/30 20:09:32 [error] 23549#23549: *20 connect() failed (111: Connection refused) while connecting to upstream, client: 186.30.121.183, server: csdc.immap.org, request: "GET /favicon.ico HTTP/1.1", upstream: "uwsgi://127.0.0.1:8000", host: "csdc.immap.or>
2021/08/30 20:10:03 [alert] 23549#23549: *19 open socket #13 left in connection 3
nginx.conf:
user www-data;
worker_processes auto;
pid /run/nginx.pid;
include /etc/nginx/modules-enabled/*.conf;
events {
worker_connections 768;
# multi_accept on;
}
http {
##
# Basic Settings
##
sendfile on;
tcp_nopush on;
tcp_nodelay on;
keepalive_timeout 65;
types_hash_max_size 2048;
# server_tokens off;
# server_names_hash_bucket_size 64;
# server_name_in_redirect off;
include /etc/nginx/mime.types;
default_type application/octet-stream;
##
# SSL Settings
##
ssl_protocols TLSv1 TLSv1.1 TLSv1.2; # Dropping SSLv3, ref: POODLE
ssl_prefer_server_ciphers on;
##
# Logging Settings
##
access_log /var/log/nginx/access.log;
error_log /var/log/nginx/error.log;
##
# Gzip Settings
##
gzip on;
gzip_vary on;
gzip_proxied any;
gzip_http_version 1.1;
gzip_disable "MSIE [1-6].";
gzip_buffers 16 8k;
gzip_min_length 1100;
geonode.ini:
uwsgi-socket = 0.0.0.0:8000
# http-socket = 0.0.0.0:8000
gid = www-data
plugins = python3
virtualenv = /home/geonode/.virtualenvs/geonode
env = DJANGO_SETTINGS_MODULE=geonode.settings
env = GEONODE_INSTANCE_NAME=geonode
env = GEONODE_LB_HOST_IP=
env = GEONODE_LB_PORT=
# #################
# backend
# #################
env = POSTGRES_USER=postgres
env = POSTGRES_PASSWORD=postgres
env = GEONODE_DATABASE=geonode
env = GEONODE_DATABASE_PASSWORD=geonode
env = GEONODE_GEODATABASE=geonode_data
env = GEONODE_GEODATABASE_PASSWORD=geonode
env = GEONODE_DATABASE_SCHEMA=public
env = GEONODE_GEODATABASE_SCHEMA=public
env = DATABASE_HOST=www.csdc.immap.org
env = DATABASE_PORT=5432
env = DATABASE_URL=postgis://geonode:geonode@csdc.immap.org:5432/geonode
env = GEODATABASE_URL=postgis://geonode:geonode@csdc.immap.org:5432/geonode_data
env = GEONODE_DB_CONN_MAX_AGE=0
env = GEONODE_DB_CONN_TOUT=5
env = DEFAULT_BACKEND_DATASTORE=datastore
env = BROKER_URL=amqp://admin:admin@csdc.immap.org:5672//
env = ASYNC_SIGNALS=False
env = SITEURL=http://csdc.immap.org/
env = ALLOWED_HOSTS="['*']"
# Data Uploader
env = DEFAULT_BACKEND_UPLOADER=geonode.importer
env = TIME_ENABLED=True
env = MOSAIC_ENABLED=False
env = HAYSTACK_SEARCH=False
env = HAYSTACK_ENGINE_URL=http://elasticsearch:9200/
env = HAYSTACK_ENGINE_INDEX_NAME=haystack
env = HAYSTACK_SEARCH_RESULTS_PER_PAGE=200
# #################
# nginx
# HTTPD Server
# #################
env = GEONODE_LB_HOST_IP=csdc.immap.org
env = GEONODE_LB_PORT=80
# IP or domain name and port where the server can be reached on HTTPS (leave HOST empty if you want to use HTTP only)
# port where the server can be reached on HTTPS
env = HTTP_HOST=csdc.immap.org
env = HTTPS_HOST=
env = HTTP_PORT=8000
env = HTTPS_PORT=443
# #################
# geoserver
# #################
env = GEOSERVER_WEB_UI_LOCATION=http://csdc.immap.org/geoserver/
env = GEOSERVER_PUBLIC_LOCATION=http://csdc.immap.org/geoserver/
env = GEOSERVER_LOCATION=http://csdc.immap.org:8080/geoserver/
env = GEOSERVER_ADMIN_USER=admin
env = GEOSERVER_ADMIN_PASSWORD=geoserver
env = OGC_REQUEST_TIMEOUT=5
env = OGC_REQUEST_MAX_RETRIES=1
env = OGC_REQUEST_BACKOFF_FACTOR=0.3
env = OGC_REQUEST_POOL_MAXSIZE=10
env = OGC_REQUEST_POOL_CONNECTIONS=10
# Java Options amp; Memory
env = ENABLE_JSONP=true
env = outFormat=text/javascript
env = GEOSERVER_JAVA_OPTS="-Djava.awt.headless=true -Xms1G -Xmx6G -XX: UnlockDiagnosticVMOptions -XX: LogVMOutput -XX:LogFile=/var/log/jvm.log -XX:PerfDataSamplingInterval=500 -XX:SoftRefLRUPolicyMSPerMB=36000 -XX:-UseGCOverheadLimit -XX: UseConcMarkSweepGC -XX: UseParNewGC -XX:ParallelGCThreads=4 -Dfile.encoding=UTF8 -Djavax.servlet.request.encoding=UTF-8 -Djavax.servlet.response.encoding=UTF-8 -Duser.timezone=America/Bogota -Dorg.geotools.shapefile.datetime=false -DGEOSERVER_CSRF_DISABLED=true -DPRINT_BASE_URL=http://geoserver:8080/geoserver/pdf -DALLOW_ENV_PARAMETRIZATION=true -Xbootclasspath/a:/usr/local/tomcat/webapps/geoserver/WEB-INF/lib/marlin-0.9.3-Unsafe.jar -Dsun.java2d.renderer=org.marlin.pisces.MarlinRenderingEngine"
# #################
# Security
# #################
# Admin Settings
env = ADMIN_USERNAME=admin
env = ADMIN_PASSWORD=admin
env = ADMIN_EMAIL=admin@csdc.immap.org
# EMAIL Notifications
env = EMAIL_ENABLE=False
env = DJANGO_EMAIL_BACKEND=django.core.mail.backends.smtp.EmailBackend
env = DJANGO_EMAIL_HOST=csdc.immap.org
env = DJANGO_EMAIL_PORT=25
env = DJANGO_EMAIL_HOST_USER=
env = DJANGO_EMAIL_HOST_PASSWORD=
env = DJANGO_EMAIL_USE_TLS=False
env = DJANGO_EMAIL_USE_SSL=False
env = DEFAULT_FROM_EMAIL='GeoNode <no-reply@csdc.immap.org>'
# Session/Access Control
env = LOCKDOWN_GEONODE=False
env = CORS_ORIGIN_ALLOW_ALL=True
env = X_FRAME_OPTIONS="SAMEORIGIN"
env = SESSION_EXPIRED_CONTROL_ENABLED=True
env = DEFAULT_ANONYMOUS_VIEW_PERMISSION=True
env = DEFAULT_ANONYMOUS_DOWNLOAD_PERMISSION=True
# Users Registration
env = ACCOUNT_OPEN_SIGNUP=False
env = ACCOUNT_EMAIL_REQUIRED=True
env = ACCOUNT_APPROVAL_REQUIRED=False
env = ACCOUNT_CONFIRM_EMAIL_ON_GET=False
env = ACCOUNT_EMAIL_VERIFICATION=none
env = ACCOUNT_EMAIL_CONFIRMATION_EMAIL=False
env = ACCOUNT_EMAIL_CONFIRMATION_REQUIRED=False
env = ACCOUNT_AUTHENTICATION_METHOD=username_email
env = AUTO_ASSIGN_REGISTERED_MEMBERS_TO_REGISTERED_MEMBERS_GROUP_NAME=True
# OAuth2
env = OAUTH2_API_KEY=
env = OAUTH2_CLIENT_ID=Jrchz2oPY3akmzndmgUTYrs9gczlgoV20YPSvqaV
env = OAUTH2_CLIENT_SECRET=rCnp5txobUo83EpQEblM8fVj3QT5zb5qRfxNsuPzCqZaiRyIoxM4jdgMiZKFfePBHYXCLd7B8NlkfDBY9HKeIQPcy5Cp08KQNpRHQbjpLItDHv12GvkSeXp6OxaUETv3
# GeoNode APIs
env = API_LOCKDOWN=False
env = TASTYPIE_APIKEY=
# #################
# Production and
# Monitoring
# #################
env = DEBUG=False
SECRET_KEY='myv-y4#7j-d*p-__@j#*3z@!y24fz8%^z2v6atuy4bo9vqr1_a'
env = CACHE_BUSTING_STATIC_ENABLED=False
env = CACHE_BUSTING_MEDIA_ENABLED=False
env = MEMCACHED_ENABLED=False
env = MEMCACHED_BACKEND=django.core.cache.backends.memcached.MemcachedCache
env = MEMCACHED_LOCATION=127.0.0.1:11211
env = MEMCACHED_LOCK_EXPIRE=3600
env = MEMCACHED_LOCK_TIMEOUT=10
env = MAX_DOCUMENT_SIZE=2
env = CLIENT_RESULTS_LIMIT=5
env = API_LIMIT_PER_PAGE=1000
# GIS Client
env = GEONODE_CLIENT_LAYER_PREVIEW_LIBRARY=mapstore
env = MAPBOX_ACCESS_TOKEN=
env = BING_API_KEY=
env = GOOGLE_API_KEY=
# Monitoring
env = MONITORING_ENABLED=True
env = MONITORING_DATA_TTL=365
env = USER_ANALYTICS_ENABLED=True
env = USER_ANALYTICS_GZIP=True
env = CENTRALIZED_DASHBOARD_ENABLED=False
env = MONITORING_SERVICE_NAME=local-geonode
env = MONITORING_HOST_NAME=geonode
# Other Options/Contribs
env = MODIFY_TOPICCATEGORY=True
env = AVATAR_GRAVATAR_SSL=True
env = EXIF_ENABLED=True
env = CREATE_LAYER=True
env = FAVORITE_ENABLED=True
logto = /opt/data/logs/geonode.log
pidfile = /tmp/geonode.pid
chdir = /opt/geonode
module = geonode.wsgi:application
strict = false
master = true
enable-threads = true
vacuum = true ; Delete sockets during shutdown
single-interpreter = true
die-on-term = true ; Shutdown when receiving SIGTERM (default is respawn)
need-app = true
# logging
# path to where uwsgi logs will be saved
# logto = /opt/data/geonode_logs/geonode.log
daemonize = /opt/data/logs/geonode.log
touch-reload = /opt/geonode/geonode/wsgi.py
buffer-size = 32768
harakiri = 60 ; forcefully kill workers after 60 seconds
py-callos-afterfork = true ; allow workers to trap signals
max-requests = 1000 ; Restart workers after this many requests
max-worker-lifetime = 3600 ; Restart workers after this many seconds
reload-on-rss = 2048 ; Restart workers after this much resident memory
worker-reload-mercy = 60 ; How long to wait before forcefully killing workers
cheaper-algo = busyness
processes = 128 ; Maximum number of workers allowed
cheaper = 8 ; Minimum number of workers allowed
cheaper-initial = 16 ; Workers created at startup
cheaper-overload = 1 ; Length of a cycle in seconds
cheaper-step = 16 ; How many workers to spawn at a time
cheaper-busyness-multiplier = 30 ; How many cycles to wait before killing workers
cheaper-busyness-min = 20 ; Below this threshold, kill workers (if stable for multiplier cycles)
cheaper-busyness-max = 70 ; Above this threshold, spawn new workers
cheaper-busyness-backlog-alert = 16 ; Spawn emergency workers if more than this many requests are waiting in the queue
cheaper-busyness-backlog-step = 2 ; How many emergency workers to create if there are too many requests in the queue
Я проверяю другие проблемы в репозитории Geonode на Github: #6059, #6152, и я не могу найти решение, я также пытаюсь установить Geonode с помощью docker, и при базовой установке мне это не удалось, При расширенной установке мне просто нужно решить эту проблему с плохим шлюзом, любые подсказки и помощь в этом будут очень признательны.
Комментарии:
1. «такой таблицы нет: django_site», скорее всего, означает, что вы не запускали
python manage.py migrate.2. Я уже проверил базы данных в postgres, и таблицы там есть, геосервер подключается к базе данных и работает, странная вещь, но я думаю, что это связано с sqlite
3. Когда это происходит, обычно происходит потому, что пытается использовать SQLite вместо Postgres. Дважды проверьте, что геонод указывает на Postgres. Посмотрите на эти настройки:
GEODATABASE_URLиDATABASE_URLи убедитесь, что они указывают на правильную базу данных4.Согласно файлам .env, settings.py и geonode.ini
DATABASE_URL=postgis://geonode:geonode@csdc.immap.org:5432/geonodeGEODATABASE_URL=postgis://geonode:geonode@csdc.immap.org:5432/geonode_data5. @AKX я уже запустил
./paver_local.sh sync, эта команда предназначена для запуска миграций, не так ли? когда я бегуpython manage.py migrate, я получаю:django.db.utils.OperationalError: attempt to write a readonly database