# # 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 Il giorno mercoledì 9 febbraio 2022 alle 18:54:31 UTC+1 f.capoano ha scritto: > 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/7b9af709-12e2-4d20-bf6a-be038012727bn%40googlegroups.com.
