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 On Wed, Feb 9, 2022 at 1:39 PM Ajay Tripathi <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/openwisp/CAPxBCYbdceGCNa1wyOkqXcxAVpeHPyP4XY__wwV3HRGtq0WyCw%40mail.gmail.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/CAAGgX6Jh%3DQqnXXj7_R6xkVv96TYtKC1qsFu9SoWmucjguS%2Bwww%40mail.gmail.com.
