error install openwisp on raspberry for testing (debian 11) ....what is the mistake?
67 views
Skip to first unread message
Michele Salerno
Feb 9, 2022, 10:14:18 AM2/9/22
to OpenWISP
TASK [openwisp.openwisp2-dev : migrate] *******************************************************************************************************************************************************************************************************
Wednesday 09 February 2022 15:59:13 +0100 (0:00:03.024) 0:06:38.982 ****
fatal: [openwisp.nnxx.ninux.org]: FAILED! => changed=false
cmd: ./manage.py migrate --noinput
msg: |2-
:stderr: Traceback (most recent call last):
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 230, in ensure_connection
self.connect()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 211, in connect
self.connection = self.get_new_connection(conn_params)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/postgresql/base.py", line 199, in get_new_connection
connection = Database.connect(**conn_params)
File "/opt/openwisp2/env/lib/python3.9/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATALE: autenticazione Peer fallita per l'utente "openwisp2"
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/openwisp2/./manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/__init__.py", line 425, in execute_from_command_line
utility.execute()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/__init__.py", line 419, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 373, in run_from_argv
self.execute(*args, **cmd_options)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 417, in execute
output = self.handle(*args, **options)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 90, in wrapped
res = handle_func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 75, in handle
self.check(databases=[database])
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 438, in check
all_issues = checks.run_checks(
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/checks/registry.py", line 77, in run_checks
new_errors = check(app_configs=app_configs, databases=databases)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/checks/model_checks.py", line 34, in check_all_models
errors.extend(model.check(**kwargs))
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/models/base.py", line 1307, in check
*cls._check_indexes(databases),
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/models/base.py", line 1699, in _check_indexes
connection.features.supports_covering_indexes or
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/functional.py", line 48, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/postgresql/features.py", line 84, in is_postgresql_11
return self.connection.pg_version >= 110000
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/functional.py", line 48, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/postgresql/base.py", line 339, in pg_version
with self.temporary_connection():
File "/usr/lib/python3.9/contextlib.py", line 117, in __enter__
return next(self.gen)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 614, in temporary_connection
with self.cursor() as cursor:
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 270, in cursor
return self._cursor()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 246, in _cursor
self.ensure_connection()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 230, in ensure_connection
self.connect()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 230, in ensure_connection
self.connect()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 211, in connect
self.connection = self.get_new_connection(conn_params)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/postgresql/base.py", line 199, in get_new_connection
connection = Database.connect(**conn_params)
File "/opt/openwisp2/env/lib/python3.9/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATALE: autenticazione Peer fallita per l'utente "openwisp2"
path: /opt/openwisp2/env/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
syspath:
- /tmp/ansible_django_manage_payload_2y13uc6k/ansible_django_manage_payload.zip
- /usr/lib/python39.zip
- /usr/lib/python3.9
- /usr/lib/python3.9/lib-dynload
- /usr/local/lib/python3.9/dist-packages
- /usr/lib/python3/dist-packages
- /usr/lib/python3.9/dist-packages
PLAY RECAP ************************************************************************************************************************************************************************************************************************************
openwisp.nnxx.ninux.org : ok=98 changed=8 unreachable=0 failed=1 skipped=57 rescued=0 ignored=0
Wednesday 09 February 2022 15:59:28 +0100 (0:00:14.447) 0:06:53.430 ****
===============================================================================
openwisp.openwisp2-dev : Install openwisp2 controller and its dependencies ------------------------------------------------------------------------------------------------------------------------------------------------------------ 31.49s
openwisp.openwisp2-dev : Install openwisp monitoring and its dependencies ------------------------------------------------------------------------------------------------------------------------------------------------------------- 20.32s
openwisp.openwisp2-dev : Install openwisp2_radius and its dependencies ---------------------------------------------------------------------------------------------------------------------------------------------------------------- 20.29s
openwisp.openwisp2-dev : Install openwisp firmware upgrader and its dependencies ------------------------------------------------------------------------------------------------------------------------------------------------------ 20.03s
openwisp.openwisp2-dev : Install openwisp2 network topology and its dependencies ------------------------------------------------------------------------------------------------------------------------------------------------------ 17.58s
openwisp.openwisp2-dev : Update pip & related tools ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 17.21s
openwisp.openwisp2-dev : Pin channels_redis to 2.4 for redis 4 compatibility ---------------------------------------------------------------------------------------------------------------------------------------------------------- 16.12s
openwisp.openwisp2-dev : migrate ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 14.45s
openwisp.openwisp2-dev : Install static minification dependencies --------------------------------------------------------------------------------------------------------------------------------------------------------------------- 13.41s
openwisp.openwisp2-dev : Install extra python packages -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 12.20s
openwisp.openwisp2-dev : Install uwsgi ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 11.99s
openwisp.openwisp2-dev : Install psycopg2 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 11.93s
ow-influxdb : Install logrotate ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 10.16s
ow-influxdb : Install gpg-agent (update apt cache first) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 9.92s
openwisp.openwisp2-dev : Install django-redis ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 9.82s
ow-influxdb : Install system dependencies ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 9.79s
ow-influxdb : Install gpg (update apt cache first) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 7.68s
Stouts.postfix : Install requirements (Debian) ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 6.81s
Update APT package cache --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 6.58s
openwisp.openwisp2-dev : Update APT package cache -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 5.97s
Playbook run took 0 days, 0 hours, 6 minutes, 53 seconds
Wednesday 09 February 2022 15:59:13 +0100 (0:00:03.024) 0:06:38.982 ****
fatal: [openwisp.nnxx.ninux.org]: FAILED! => changed=false
cmd: ./manage.py migrate --noinput
msg: |2-
:stderr: Traceback (most recent call last):
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 230, in ensure_connection
self.connect()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 211, in connect
self.connection = self.get_new_connection(conn_params)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/postgresql/base.py", line 199, in get_new_connection
connection = Database.connect(**conn_params)
File "/opt/openwisp2/env/lib/python3.9/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATALE: autenticazione Peer fallita per l'utente "openwisp2"
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/openwisp2/./manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/__init__.py", line 425, in execute_from_command_line
utility.execute()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/__init__.py", line 419, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 373, in run_from_argv
self.execute(*args, **cmd_options)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 417, in execute
output = self.handle(*args, **options)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 90, in wrapped
res = handle_func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 75, in handle
self.check(databases=[database])
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 438, in check
all_issues = checks.run_checks(
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/checks/registry.py", line 77, in run_checks
new_errors = check(app_configs=app_configs, databases=databases)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/checks/model_checks.py", line 34, in check_all_models
errors.extend(model.check(**kwargs))
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/models/base.py", line 1307, in check
*cls._check_indexes(databases),
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/models/base.py", line 1699, in _check_indexes
connection.features.supports_covering_indexes or
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/functional.py", line 48, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/postgresql/features.py", line 84, in is_postgresql_11
return self.connection.pg_version >= 110000
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/functional.py", line 48, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/postgresql/base.py", line 339, in pg_version
with self.temporary_connection():
File "/usr/lib/python3.9/contextlib.py", line 117, in __enter__
return next(self.gen)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 614, in temporary_connection
with self.cursor() as cursor:
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 270, in cursor
return self._cursor()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 246, in _cursor
self.ensure_connection()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 230, in ensure_connection
self.connect()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 230, in ensure_connection
self.connect()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/base.py", line 211, in connect
self.connection = self.get_new_connection(conn_params)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/postgresql/base.py", line 199, in get_new_connection
connection = Database.connect(**conn_params)
File "/opt/openwisp2/env/lib/python3.9/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATALE: autenticazione Peer fallita per l'utente "openwisp2"
path: /opt/openwisp2/env/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
syspath:
- /tmp/ansible_django_manage_payload_2y13uc6k/ansible_django_manage_payload.zip
- /usr/lib/python39.zip
- /usr/lib/python3.9
- /usr/lib/python3.9/lib-dynload
- /usr/local/lib/python3.9/dist-packages
- /usr/lib/python3/dist-packages
- /usr/lib/python3.9/dist-packages
PLAY RECAP ************************************************************************************************************************************************************************************************************************************
openwisp.nnxx.ninux.org : ok=98 changed=8 unreachable=0 failed=1 skipped=57 rescued=0 ignored=0
Wednesday 09 February 2022 15:59:28 +0100 (0:00:14.447) 0:06:53.430 ****
===============================================================================
openwisp.openwisp2-dev : Install openwisp2 controller and its dependencies ------------------------------------------------------------------------------------------------------------------------------------------------------------ 31.49s
openwisp.openwisp2-dev : Install openwisp monitoring and its dependencies ------------------------------------------------------------------------------------------------------------------------------------------------------------- 20.32s
openwisp.openwisp2-dev : Install openwisp2_radius and its dependencies ---------------------------------------------------------------------------------------------------------------------------------------------------------------- 20.29s
openwisp.openwisp2-dev : Install openwisp firmware upgrader and its dependencies ------------------------------------------------------------------------------------------------------------------------------------------------------ 20.03s
openwisp.openwisp2-dev : Install openwisp2 network topology and its dependencies ------------------------------------------------------------------------------------------------------------------------------------------------------ 17.58s
openwisp.openwisp2-dev : Update pip & related tools ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 17.21s
openwisp.openwisp2-dev : Pin channels_redis to 2.4 for redis 4 compatibility ---------------------------------------------------------------------------------------------------------------------------------------------------------- 16.12s
openwisp.openwisp2-dev : migrate ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 14.45s
openwisp.openwisp2-dev : Install static minification dependencies --------------------------------------------------------------------------------------------------------------------------------------------------------------------- 13.41s
openwisp.openwisp2-dev : Install extra python packages -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 12.20s
openwisp.openwisp2-dev : Install uwsgi ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 11.99s
openwisp.openwisp2-dev : Install psycopg2 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 11.93s
ow-influxdb : Install logrotate ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 10.16s
ow-influxdb : Install gpg-agent (update apt cache first) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 9.92s
openwisp.openwisp2-dev : Install django-redis ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 9.82s
ow-influxdb : Install system dependencies ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 9.79s
ow-influxdb : Install gpg (update apt cache first) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 7.68s
Stouts.postfix : Install requirements (Debian) ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 6.81s
Update APT package cache --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 6.58s
openwisp.openwisp2-dev : Update APT package cache -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 5.97s
Playbook run took 0 days, 0 hours, 6 minutes, 53 seconds
My playbook is:
Michele Salerno
Feb 9, 2022, 11:19:39 AM2/9/22
to OpenWISP
I try add "localhost" on setting db and now the error is:
TASK [openwisp.openwisp2-dev : migrate] *******************************************************************************************************************************************************************************************************
Wednesday 09 February 2022 17:16:23 +0100 (0:00:02.984) 0:06:29.118 ****
fatal: [openwisp.basilicata.nnxx]: FAILED! => changed=false
cmd: ./manage.py migrate --noinput
msg: |-
stdout: Operations to perform:
Apply all migrations: account, admin, auth, authtoken, check, config, connection, contenttypes, device_monitoring, firmware_upgrader, geo, monitoring, openwisp_ipam, openwisp_notifications, openwisp_radius, openwisp_users, pki, reversion, sessions, sites, socialaccount, topology
Running migrations:
Applying geo.0001_initial...
:stderr: Traceback (most recent call last):
post_migrate_state = executor.migrate(
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/migrations/executor.py", line 126, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/migrations/executor.py", line 156, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/migrations/executor.py", line 236, in apply_migration
state = migration.apply(state, schema_editor)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/migrations/migration.py", line 125, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/migrations/operations/models.py", line 92, in database_forwards
schema_editor.create_model(model)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 355, in create_model
sql, params = self.table_sql(model)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 170, in table_sql
definition, extra_params = self.column_sql(model, field)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 269, in column_sql
db_params = field.db_parameters(connection=self.connection)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/models/fields/__init__.py", line 737, in db_parameters
type_string = self.db_type(connection)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/contrib/gis/db/models/fields.py", line 105, in db_type
return connection.ops.geo_db_type(self)
AttributeError: 'DatabaseOperations' object has no attribute 'geo_db_type'
path: /opt/openwisp2/env/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
syspath:
- /tmp/ansible_django_manage_payload_4mfm0cks/ansible_django_manage_payload.zip
- /usr/lib/python39.zip
- /usr/lib/python3.9
- /usr/lib/python3.9/lib-dynload
- /usr/local/lib/python3.9/dist-packages
- /usr/lib/python3/dist-packages
- /usr/lib/python3.9/dist-packages
TASK [openwisp.openwisp2-dev : migrate] *******************************************************************************************************************************************************************************************************
Wednesday 09 February 2022 17:16:23 +0100 (0:00:02.984) 0:06:29.118 ****
fatal: [openwisp.basilicata.nnxx]: FAILED! => changed=false
cmd: ./manage.py migrate --noinput
msg: |-
stdout: Operations to perform:
Apply all migrations: account, admin, auth, authtoken, check, config, connection, contenttypes, device_monitoring, firmware_upgrader, geo, monitoring, openwisp_ipam, openwisp_notifications, openwisp_radius, openwisp_users, pki, reversion, sessions, sites, socialaccount, topology
Running migrations:
Applying geo.0001_initial...
:stderr: Traceback (most recent call last):
File "/opt/openwisp2/./manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/__init__.py", line 425, in execute_from_command_line
utility.execute()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/__init__.py", line 419, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 373, in run_from_argv
self.execute(*args, **cmd_options)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 417, in execute
output = self.handle(*args, **options)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 90, in wrapped
res = handle_func(*args, **kwargs)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 253, in handleexecute_from_command_line(sys.argv)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/__init__.py", line 425, in execute_from_command_line
utility.execute()
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/__init__.py", line 419, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 373, in run_from_argv
self.execute(*args, **cmd_options)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 417, in execute
output = self.handle(*args, **options)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/core/management/base.py", line 90, in wrapped
res = handle_func(*args, **kwargs)
post_migrate_state = executor.migrate(
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/migrations/executor.py", line 126, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/migrations/executor.py", line 156, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/migrations/executor.py", line 236, in apply_migration
state = migration.apply(state, schema_editor)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/migrations/migration.py", line 125, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/migrations/operations/models.py", line 92, in database_forwards
schema_editor.create_model(model)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 355, in create_model
sql, params = self.table_sql(model)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 170, in table_sql
definition, extra_params = self.column_sql(model, field)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 269, in column_sql
db_params = field.db_parameters(connection=self.connection)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/db/models/fields/__init__.py", line 737, in db_parameters
type_string = self.db_type(connection)
File "/opt/openwisp2/env/lib/python3.9/site-packages/django/contrib/gis/db/models/fields.py", line 105, in db_type
return connection.ops.geo_db_type(self)
AttributeError: 'DatabaseOperations' object has no attribute 'geo_db_type'
path: /opt/openwisp2/env/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
syspath:
- /usr/lib/python39.zip
- /usr/lib/python3.9
- /usr/lib/python3.9/lib-dynload
- /usr/local/lib/python3.9/dist-packages
- /usr/lib/python3/dist-packages
- /usr/lib/python3.9/dist-packages
Ajay Tripathi
Feb 9, 2022, 11:39:25 AM2/9/22
to OpenWISP
Hi,
It seems that your database doesn't support gis.
Can you please ensure postgis is installed and working properly on your postgres instance?
Best,
Ajay T.
--
You received this message because you are subscribed to the Google Groups "OpenWISP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openwisp+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/openwisp/5534f1b2-ff7b-4138-b1db-bc49b2181e96n%40googlegroups.com.
Michele Salerno
Feb 9, 2022, 11:54:57 AM2/9/22
to OpenWISP
root@ninux:~ # apt-get install postgis postgresql-13-postgis-3
Lettura elenco dei pacchetti... Fatto
Generazione albero delle dipendenze... Fatto
Lettura informazioni sullo stato... Fatto
postgis � gi� alla versione pi� recente (3.1.1+dfsg-1).
postgresql-13-postgis-3 � gi� alla versione pi� recente (3.1.1+dfsg-1).
0 aggiornati, 0 installati, 0 da rimuovere e 0 non aggiornati.
Lettura elenco dei pacchetti... Fatto
Generazione albero delle dipendenze... Fatto
Lettura informazioni sullo stato... Fatto
postgis � gi� alla versione pi� recente (3.1.1+dfsg-1).
postgresql-13-postgis-3 � gi� alla versione pi� recente (3.1.1+dfsg-1).
0 aggiornati, 0 installati, 0 da rimuovere e 0 non aggiornati.
Federico Capoano
Feb 9, 2022, 12:54:31 PM2/9/22
to open...@googlegroups.com
No it's not because GIS in my opinion, it's the pg_hba conf which needs to be configured to allow peer access:
Best regards
Federico CapoanoTo view this discussion on the web, visit https://groups.google.com/d/msgid/openwisp/CAPxBCYbdceGCNa1wyOkqXcxAVpeHPyP4XY__wwV3HRGtq0WyCw%40mail.gmail.com.
Michele Salerno
Feb 9, 2022, 1:45:57 PM2/9/22
to OpenWISP
#
# Ansible managed: modified on 26-11-2021
#
# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# See: https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html
local all postgres peer
local all all peer
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
# Ansible managed: modified on 26-11-2021
#
# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# See: https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html
local all postgres peer
local all all peer
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
Michele Salerno
Feb 12, 2022, 9:43:09 AM2/12/22
to OpenWISP
[Solved]
The basic of my playbook is example on readme.
On example is:
openwisp2_database:
The basic of my playbook is example on readme.
On example is:
openwisp2_database:
engine: django.db.backends.postgresql
name: openwisp2
user: postgres
password: ""
host: ""
port: ""
options: {}
I try change this with
openwisp2_database:
engine: django.contrib.gis.db.backends.postgis
name: openwisp2
user: openwisp2
password: "XXXXXXX"
host: "localhost"
port: "5432"
options: {}
openwisp2_database:
engine: django.contrib.gis.db.backends.postgis
name: openwisp2
user: openwisp2
password: "XXXXXXX"
host: "localhost"
port: "5432"
options: {}
Now is ok, bat error in nginx, i add on /etc/nginx/nginx.conf and is ok.
http {
server_names_hash_bucket_size 64;
##
# Basic Settings
##
server_names_hash_bucket_size 64;
##
# Basic Settings
##
Reply all
Reply to author
Forward
0 new messages