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. On Wed, Feb 9, 2022, 9:49 PM Michele Salerno <[email protected]> wrote: > 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 > > Il giorno mercoledì 9 febbraio 2022 alle 16:14:18 UTC+1 Michele Salerno ha > scritto: > >> 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 >> > -- > 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 [email protected]. > To view this discussion on the web, visit > https://groups.google.com/d/msgid/openwisp/5534f1b2-ff7b-4138-b1db-bc49b2181e96n%40googlegroups.com > <https://groups.google.com/d/msgid/openwisp/5534f1b2-ff7b-4138-b1db-bc49b2181e96n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web, visit https://groups.google.com/d/msgid/openwisp/CAPxBCYbdceGCNa1wyOkqXcxAVpeHPyP4XY__wwV3HRGtq0WyCw%40mail.gmail.com.
