[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: {}
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
##
Il giorno mercoledì 9 febbraio 2022 alle 19:45:57 UTC+1 Michele Salerno ha
scritto:
> #
> # 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/6738e7ec-b248-4d3a-80e3-375e38cc14c8n%40googlegroups.com.
