error install openwisp on raspberry for testing (debian 11) ....what is the mistake?

Michele Salerno

unread,

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

My playbook is:

https://pastebin.com/hGiCf7Pk

Michele Salerno

unread,

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):

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 handle
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

Ajay Tripathi

unread,

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

unread,

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.

Federico Capoano

unread,

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:

https://www.postgresql.org/docs/14/auth-pg-hba-conf.html

Best regards

Federico Capoano

To view this discussion on the web, visit https://groups.google.com/d/msgid/openwisp/CAPxBCYbdceGCNa1wyOkqXcxAVpeHPyP4XY__wwV3HRGtq0WyCw%40mail.gmail.com.

Michele Salerno

unread,

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

Michele Salerno

unread,

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:

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: {}