Projet

Général

Profil

Support #58910

Install publik-devinst sur Sid : problème de certificat ?

Ajouté par Pierre Cros il y a plus de 2 ans. Mis à jour il y a plus de 2 ans.

Statut:
Fermé
Priorité:
Normal
Assigné à:
-
Version cible:
-
Début:
23 novembre 2021
Echéance:
% réalisé:

0%

Temps estimé:
Patch proposed:
Non
Planning:
Non

Description

Sur ma machine, purgée de toute install nginx, je vais jusqu'à

 ansible-playbook -i inventory.yml deploy-tenants.yml

Et j'obtiens :

TASK [deploy-tenants : Run command hobo-manage to initiate the development subdomains and a super-user] ***********************************************************************************
fatal: [localhost]: FAILED! => {"changed": true, "cmd": ["/home/pcros/envs/publik-env-py3/bin/hobo-manage", "cook", "/tmp/cook-recipe.json", "--timeout=600"], "delta": "0:00:00.639037", "end": "2021-11-23 15:39:33.774622", "msg": "non-zero return code", "rc": 1, "start": "2021-11-23 15:39:33.135585", "stderr": "<string>:199: UserWarning: journald will not be used directly, please install python-systemd\nStarting new HTTPS connection (1): hobo.dev.publik.love:443\nCommandError: ['Erreur\\xa0: pas de certificat valide pour https://hobo.dev.publik.love/']", "stderr_lines": ["<string>:199: UserWarning: journald will not be used directly, please install python-systemd", "Starting new HTTPS connection (1): hobo.dev.publik.love:443", "CommandError: ['Erreur\\xa0: pas de certificat valide pour https://hobo.dev.publik.love/']"], "stdout": "", "stdout_lines": []}

PLAY RECAP ********************************************************************************************************************************************************************************
localhost                  : ok=9    changed=1    unreachable=0    failed=1    skipped=1    rescued=0    ignored=0

cat /var/log/hobo-agent/stderr.log

[2021-11-23 06:01:06,287: WARNING/MainProcess] Please run `celery upgrade settings path/to/settings.py` to avoid these warnings and to allow a smoother upgrade to Celery 6.0.
[2021-11-23 06:01:06,387: INFO/MainProcess] Connected to amqp://guest:**@127.0.0.1:5672//
[2021-11-23 06:01:06,429: INFO/MainProcess] mingle: searching for neighbors
[2021-11-23 06:01:06,436: WARNING/MainProcess] No hostname was supplied. Reverting to default 'localhost'
[2021-11-23 06:01:07,499: INFO/MainProcess] mingle: all alone
[2021-11-23 06:01:07,540: INFO/MainProcess] celery@hobo.agent.carbon-x1 ready.

ping authentic.dev.publik.love

pcros@carbon-x1:~/dev/publik-devinst$ ping authentic.dev.publik.love
PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.051 ms
64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.036 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.092 ms
^C

Demandes liées

Lié à Publik Installation Développeur - Development #58934: Assurer une compat avec psycopg2 > 2.8.6Fermé24 novembre 2021

Actions

Historique

#1

Mis à jour par Emmanuel Cazenave il y a plus de 2 ans

Tu peux tenter un sudo systemctl reload nginx puis repartir sur ansible-playbook -i inventory.yml deploy-tenants.yml.

#2

Mis à jour par Pierre Cros il y a plus de 2 ans

J'ai tout refait pour être sûr.

Le message d'erreur est différent :

TASK [deploy-tenants : Run command hobo-manage to initiate the development subdomains and a super-user] ***********************************************************************************
fatal: [localhost]: FAILED! => {"changed": true, "cmd": ["/home/pcros/envs/publik-env-py3/bin/hobo-manage", "cook", "/tmp/cook-recipe.json", "--timeout=600"], "delta": "0:00:01.289691", "end": "2021-11-23 18:09:03.671227", "msg": "non-zero return code", "rc": 1, "start": "2021-11-23 18:09:02.381536", "stderr": "<string>:199: UserWarning: journald will not be used directly, please install python-systemd\nStarting new HTTPS connection (1): hobo.dev.publik.love:443\nhttps://hobo.dev.publik.love:443 \"GET / HTTP/1.1\" 302 0\nStarting new HTTPS connection (1): authentic.dev.publik.love:443\nhttps://authentic.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None\nStarting new HTTPS connection (1): combo.dev.publik.love:443\nhttps://combo.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None\nStarting new HTTPS connection (1): agent-combo.dev.publik.love:443\nhttps://agent-combo.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None\nStarting new HTTPS connection (1): wcs.dev.publik.love:443\nhttps://wcs.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None\nStarting new HTTPS connection (1): passerelle.dev.publik.love:443\nhttps://passerelle.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None\nStarting new HTTPS connection (1): fargo.dev.publik.love:443\nhttps://fargo.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None\nStarting new HTTPS connection (1): chrono.dev.publik.love:443\nhttps://chrono.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None\nStarting new HTTPS connection (1): bijoe.dev.publik.love:443\nhttps://bijoe.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None\nTraceback (most recent call last):\n  File \"/home/pcros/src/hobo/manage.py\", line 10, in <module>\n    execute_from_command_line(sys.argv)\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/core/management/__init__.py\", line 381, in execute_from_command_line\n    utility.execute()\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/core/management/__init__.py\", line 375, in execute\n    self.fetch_command(subcommand).run_from_argv(self.argv)\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/core/management/base.py\", line 323, in run_from_argv\n    self.execute(*args, **cmd_options)\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/core/management/base.py\", line 364, in execute\n    output = self.handle(*args, **options)\n  File \"/home/pcros/src/hobo/hobo/environment/management/commands/cook.py\", line 87, in handle\n    self.run_cook(recipe)\n  File \"/home/pcros/src/hobo/hobo/environment/management/commands/cook.py\", line 111, in run_cook\n    getattr(self, action.replace('-', '_'))(**action_args)\n  File \"/home/pcros/src/hobo/hobo/environment/management/commands/cook.py\", line 194, in create_superuser\n    user, created = User.objects.get_or_create(username=username, email=email, is_superuser=True)\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/manager.py\", line 82, in manager_method\n    return getattr(self.get_queryset(), name)(*args, **kwargs)\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/query.py\", line 538, in get_or_create\n    return self.get(**kwargs), False\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/query.py\", line 402, in get\n    num = len(clone)\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/query.py\", line 256, in __len__\n    self._fetch_all()\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/query.py\", line 1242, in _fetch_all\n    self._result_cache = list(self._iterable_class(self))\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/query.py\", line 55, in __iter__\n    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/sql/compiler.py\", line 1175, in execute_sql\n    return list(result)\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/sql/compiler.py\", line 1554, in cursor_iter\n    for rows in iter((lambda: cursor.fetchmany(itersize)), sentinel):\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/sql/compiler.py\", line 1554, in <lambda>\n    for rows in iter((lambda: cursor.fetchmany(itersize)), sentinel):\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/utils.py\", line 96, in inner\n    return func(*args, **kwargs)\n  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/backends/postgresql/utils.py\", line 6, in utc_tzinfo_factory\n    raise AssertionError(\"database connection isn't set to UTC\")\nAssertionError: database connection isn't set to UTC", "stderr_lines": ["<string>:199: UserWarning: journald will not be used directly, please install python-systemd", "Starting new HTTPS connection (1): hobo.dev.publik.love:443", "https://hobo.dev.publik.love:443 \"GET / HTTP/1.1\" 302 0", "Starting new HTTPS connection (1): authentic.dev.publik.love:443", "https://authentic.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None", "Starting new HTTPS connection (1): combo.dev.publik.love:443", "https://combo.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None", "Starting new HTTPS connection (1): agent-combo.dev.publik.love:443", "https://agent-combo.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None", "Starting new HTTPS connection (1): wcs.dev.publik.love:443", "https://wcs.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None", "Starting new HTTPS connection (1): passerelle.dev.publik.love:443", "https://passerelle.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None", "Starting new HTTPS connection (1): fargo.dev.publik.love:443", "https://fargo.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None", "Starting new HTTPS connection (1): chrono.dev.publik.love:443", "https://chrono.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None", "Starting new HTTPS connection (1): bijoe.dev.publik.love:443", "https://bijoe.dev.publik.love:443 \"GET / HTTP/1.1\" 404 None", "Traceback (most recent call last):", "  File \"/home/pcros/src/hobo/manage.py\", line 10, in <module>", "    execute_from_command_line(sys.argv)", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/core/management/__init__.py\", line 381, in execute_from_command_line", "    utility.execute()", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/core/management/__init__.py\", line 375, in execute", "    self.fetch_command(subcommand).run_from_argv(self.argv)", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/core/management/base.py\", line 323, in run_from_argv", "    self.execute(*args, **cmd_options)", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/core/management/base.py\", line 364, in execute", "    output = self.handle(*args, **options)", "  File \"/home/pcros/src/hobo/hobo/environment/management/commands/cook.py\", line 87, in handle", "    self.run_cook(recipe)", "  File \"/home/pcros/src/hobo/hobo/environment/management/commands/cook.py\", line 111, in run_cook", "    getattr(self, action.replace('-', '_'))(**action_args)", "  File \"/home/pcros/src/hobo/hobo/environment/management/commands/cook.py\", line 194, in create_superuser", "    user, created = User.objects.get_or_create(username=username, email=email, is_superuser=True)", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/manager.py\", line 82, in manager_method", "    return getattr(self.get_queryset(), name)(*args, **kwargs)", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/query.py\", line 538, in get_or_create", "    return self.get(**kwargs), False", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/query.py\", line 402, in get", "    num = len(clone)", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/query.py\", line 256, in __len__", "    self._fetch_all()", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/query.py\", line 1242, in _fetch_all", "    self._result_cache = list(self._iterable_class(self))", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/query.py\", line 55, in __iter__", "    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/sql/compiler.py\", line 1175, in execute_sql", "    return list(result)", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/sql/compiler.py\", line 1554, in cursor_iter", "    for rows in iter((lambda: cursor.fetchmany(itersize)), sentinel):", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/models/sql/compiler.py\", line 1554, in <lambda>", "    for rows in iter((lambda: cursor.fetchmany(itersize)), sentinel):", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/utils.py\", line 96, in inner", "    return func(*args, **kwargs)", "  File \"/home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/django/db/backends/postgresql/utils.py\", line 6, in utc_tzinfo_factory", "    raise AssertionError(\"database connection isn't set to UTC\")", "AssertionError: database connection isn't set to UTC"], "stdout": "", "stdout_lines": []}

PLAY RECAP ********************************************************************************************************************************************************************************
localhost                  : ok=9    changed=1    unreachable=0    failed=1    skipped=1    rescued=0    ignored=0

Et surtout j'ai dans /var/log/hobo-agent/stderr.log

[2021-11-22 19:35:16,504: WARNING/MainProcess] No hostname was supplied. Reverting to default 'localhost'
[2021-11-22 19:35:16,525: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_RESULT_SERIALIZER' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the result_serializer instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-22 19:35:16,525: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_TASK_SERIALIZER' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the task_serializer instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-22 19:35:16,525: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_ACCEPT_CONTENT' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the accept_content instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-22 19:35:16,525: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_QUEUES' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the task_queues instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-22 19:35:16,525: WARNING/MainProcess] Please run `celery upgrade settings path/to/settings.py` to avoid these warnings and to allow a smoother upgrade to Celery 6.0.
[2021-11-22 19:35:16,628: INFO/MainProcess] Connected to amqp://guest:**@127.0.0.1:5672//
[2021-11-22 19:35:16,669: INFO/MainProcess] mingle: searching for neighbors
[2021-11-22 19:35:16,677: WARNING/MainProcess] No hostname was supplied. Reverting to default 'localhost'
[2021-11-22 19:35:17,745: INFO/MainProcess] mingle: all alone
[2021-11-22 19:35:17,770: INFO/MainProcess] celery@hobo.agent.carbon-x1 ready.

worker: Warm shutdown (MainProcess)
[2021-11-22 20:48:10,488: WARNING/MainProcess] No hostname was supplied. Reverting to default 'localhost'
[2021-11-22 20:48:10,506: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_ACCEPT_CONTENT' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the accept_content instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-22 20:48:10,506: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_TASK_SERIALIZER' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the task_serializer instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-22 20:48:10,506: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_QUEUES' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the task_queues instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-22 20:48:10,506: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_RESULT_SERIALIZER' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the result_serializer instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-22 20:48:10,507: WARNING/MainProcess] Please run `celery upgrade settings path/to/settings.py` to avoid these warnings and to allow a smoother upgrade to Celery 6.0.
[2021-11-22 20:48:10,605: INFO/MainProcess] Connected to amqp://guest:**@127.0.0.1:5672//
[2021-11-22 20:48:10,646: INFO/MainProcess] mingle: searching for neighbors
[2021-11-22 20:48:10,654: WARNING/MainProcess] No hostname was supplied. Reverting to default 'localhost'
[2021-11-22 20:48:11,721: INFO/MainProcess] mingle: all alone
[2021-11-22 20:48:11,736: INFO/MainProcess] celery@hobo.agent.carbon-x1 ready.

worker: Warm shutdown (MainProcess)
[2021-11-22 20:58:32,996: WARNING/MainProcess] No hostname was supplied. Reverting to default 'localhost'
[2021-11-22 20:58:33,003: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_RESULT_SERIALIZER' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the result_serializer instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-22 20:58:33,003: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_QUEUES' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the task_queues instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-22 20:58:33,003: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_TASK_SERIALIZER' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the task_serializer instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-22 20:58:33,003: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_ACCEPT_CONTENT' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the accept_content instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-22 20:58:33,003: WARNING/MainProcess] Please run `celery upgrade settings path/to/settings.py` to avoid these warnings and to allow a smoother upgrade to Celery 6.0.
[2021-11-22 20:58:33,075: INFO/MainProcess] Connected to amqp://guest:**@127.0.0.1:5672//
[2021-11-22 20:58:33,120: INFO/MainProcess] mingle: searching for neighbors
[2021-11-22 20:58:33,128: WARNING/MainProcess] No hostname was supplied. Reverting to default 'localhost'
[2021-11-22 20:58:34,190: INFO/MainProcess] mingle: all alone
[2021-11-22 20:58:34,209: INFO/MainProcess] celery@hobo.agent.carbon-x1 ready.

worker: Warm shutdown (MainProcess)
[2021-11-23 06:01:06,252: WARNING/MainProcess] No hostname was supplied. Reverting to default 'localhost'
[2021-11-23 06:01:06,287: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_RESULT_SERIALIZER' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the result_serializer instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-23 06:01:06,287: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_QUEUES' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the task_queues instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-23 06:01:06,287: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_TASK_SERIALIZER' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the task_serializer instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-23 06:01:06,287: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_ACCEPT_CONTENT' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the accept_content instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-23 06:01:06,287: WARNING/MainProcess] Please run `celery upgrade settings path/to/settings.py` to avoid these warnings and to allow a smoother upgrade to Celery 6.0.
[2021-11-23 06:01:06,387: INFO/MainProcess] Connected to amqp://guest:**@127.0.0.1:5672//
[2021-11-23 06:01:06,429: INFO/MainProcess] mingle: searching for neighbors
[2021-11-23 06:01:06,436: WARNING/MainProcess] No hostname was supplied. Reverting to default 'localhost'
[2021-11-23 06:01:07,499: INFO/MainProcess] mingle: all alone
[2021-11-23 06:01:07,540: INFO/MainProcess] celery@hobo.agent.carbon-x1 ready.

worker: Warm shutdown (MainProcess)
[2021-11-23 18:03:50,576: WARNING/MainProcess] No hostname was supplied. Reverting to default 'localhost'
[2021-11-23 18:03:50,601: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_QUEUES' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the task_queues instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-23 18:03:50,601: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_ACCEPT_CONTENT' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the accept_content instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-23 18:03:50,601: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_TASK_SERIALIZER' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the task_serializer instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-23 18:03:50,601: WARNING/MainProcess] /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages/celery/app/utils.py:204: CDeprecationWarning: 
    The 'CELERY_RESULT_SERIALIZER' setting is deprecated and scheduled for removal in
    version 6.0.0. Use the result_serializer instead

  deprecated.warn(description=f'The {setting!r} setting',

[2021-11-23 18:03:50,602: WARNING/MainProcess] Please run `celery upgrade settings path/to/settings.py` to avoid these warnings and to allow a smoother upgrade to Celery 6.0.
[2021-11-23 18:03:50,687: INFO/MainProcess] Connected to amqp://guest:**@127.0.0.1:5672//
[2021-11-23 18:03:50,725: INFO/MainProcess] mingle: searching for neighbors
[2021-11-23 18:03:50,733: WARNING/MainProcess] No hostname was supplied. Reverting to default 'localhost'
[2021-11-23 18:03:51,779: INFO/MainProcess] mingle: all alone
[2021-11-23 18:03:51,813: INFO/MainProcess] celery@hobo.agent.carbon-x1 ready.

#3

Mis à jour par Frédéric Péters il y a plus de 2 ans

"AssertionError: database connection isn't set to UTC"],

c'est ça la la vraie erreur; ça a déjà été traité et visiblement donc pas assez. (c'est une version de psycopg2 trop élevée par rapport à django).

#4

Mis à jour par Emmanuel Cazenave il y a plus de 2 ans

Ah ça progresse.

T'es bien sur la dernière version de publik-devisnt ? Tu tombes dans un bug qui a été corrigé en principe #55980.

(tu peux laisser tomber les copié/coller de /var/log/hobo-agent/stderr.log pour l'instant).

#5

Mis à jour par Emmanuel Cazenave il y a plus de 2 ans

En fait je veux bien le résultat de ces deux commandes :

apt-cache policy python3-psycopg2
/home/pcros/envs/publik-env-py3/bin/pip show psycopg2

#6

Mis à jour par Pierre Cros il y a plus de 2 ans

apt-cache policy python3-psycopg2

python3-psycopg2:
  Installé : 2.9.1-1+b1
  Candidat : 2.9.1-1+b1
 Table de version :
 *** 2.9.1-1+b1 500
        500 http://deb.debian.org/debian sid/main amd64 Packages
        100 /var/lib/dpkg/status

/home/pcros/envs/publik-env-py3/bin/pip show psycopg2

Name: psycopg2
Version: 2.9.1
Summary: psycopg2 - Python-PostgreSQL Database Adapter
Home-page: https://psycopg.org/
Author: Federico Di Gregorio
Author-email: fog@initd.org
License: LGPL with exceptions
Location: /home/pcros/envs/publik-env-py3/lib/python3.9/site-packages
Requires: 
Required-by: django-tenant-schemas, bijoe, wcs-olap
#7

Mis à jour par Pierre Cros il y a plus de 2 ans

et j'ai refait le git clone juste avant pour être sûr que j'avais bien la dernière version.

#8

Mis à jour par Frédéric Péters il y a plus de 2 ans

Ça clasherait parce que ce commit prend la version système en espérant qu'elle soit < 2.9

use python3-psycopg2 in the virtualenv (#55980)

alors que

python3-psycopg2:
  Installé : 2.9.1-1+b1

Par contre c'est la même version dispo dans testing donc ça devrait merder chez tout le monde pareil :/

Perso je me suis gelé sur la version 2.8.6-2 de bullseye, en perspective bourrine je suggérerais l'installation de https://deb.debian.org/debian/pool/main/p/psycopg2/python3-psycopg2_2.8.6-2_amd64.deb mais il y a sans doute à d'abord attendre une meilleure suggestion de Manu (vu que je ne suis pas sur publik-devinst ma situation est différente).

#9

Mis à jour par Emmanuel Cazenave il y a plus de 2 ans

Frédéric Péters a écrit :

par contre c'est la même version dispo dans testing donc ça devrait merder chez tout le monde pareil :/

Je suis en stable où tout se passe bien, jenkins devrait voir ce problème sur testing mais ne voit rien, les autres devs en testing/unstable ont pas du refaire de run de publik-devinst récemment.

Perso je me suis gelé sur la version 2.8.6-2 de bullseye, en perspective bourrine je suggérerais l'installation de https://deb.debian.org/debian/pool/main/p/psycopg2/python3-psycopg2_2.8.6-2_amd64.deb

Pas mieux, ensuite relancer ansible-playbook -K -i inventory.yml install.yml qui devrait rendre dispo cette nouvelle version de psycopg2 dans le virtualenv, puis ansible-playbook -i inventory.yml deploy-tenants.yml.

#10

Mis à jour par Frédéric Péters il y a plus de 2 ans

Je suis en stable où tout se passe bien

Parce qu'encore 2.8.6, ok.

jenkins devrait voir ce problème sur testing mais ne voit rien

En fait jenkins ne va pas jusqu'à l'exécution du cook, j'ai l'impression, ça ne lance pas ansible-playbook -i inventory.yml deploy-tenants.yml. (je viens de créer #58927).

~~

Sur ces histoires psycopg2, j'aurais comme suggestion alternative, plutôt que se battre à essayer d'en chopper la bonne version, qu'il soit intégré un moment de patch de django dans l'installation. (je ne sais évidemment pas à quel point c'est possible/facile avec ansible).

--- a/django/db/backends/postgresql/utils.py
+++ b/django/db/backends/postgresql/utils.py
@@ -2,6 +2,6 @@ from django.utils.timezone import utc

 def utc_tzinfo_factory(offset):
-    if offset != 0:
+    if offset:
         raise AssertionError("database connection isn't set to UTC")
     return utc
#11

Mis à jour par Emmanuel Cazenave il y a plus de 2 ans

#12

Mis à jour par Pierre Cros il y a plus de 2 ans

  • Statut changé de Nouveau à Fermé

En attendant #58934, j'ai fait ce que Manu proposait et ça fonctionne, merci tout le monde.

Formats disponibles : Atom PDF