PnX-SI / GeoNature

Application de saisie et de synthèse des observations faune et flore
GNU General Public License v3.0
100 stars 102 forks source link

GeoNature 2.14.2 : module GeoNature ne fonctionne pas / UsersHub et TaxHub OK #3185

Closed SimonGuilbaud closed 1 week ago

SimonGuilbaud commented 1 week ago

Bonjour à tous,

Je me lance à mon tour dans l'aventure de GeoNature. Et comme cadeau de bienvenu le module Geonature ne fonctionne pas.

Version J'ai fais l'installation de GeoNature 2.14.2 sur un Debian 12 installé sur une VM. J'ai suivi le manuel d'installation à la lettre pour l'installation globale. Voici mon fichier install_all.ini. J'ai juste modifier le nom d'utilisateur postgres et son mot de passe (voir pièce-jointe avec pass masqué) install_all.ini.txt

Description du bug Une fois l'installation indiquée comme terminée, quand je veux me lancer le module GéoNature cela n'aboutit pas : PAS OK ->http://192.168.96.201/geonature image

En revanche cela fonctionne pour TaxHub et UsersHub : OK -> http://192.168.96.201/taxhub/#!/taxref OK -> http://192.168.96.201/usershub/users/list

Lors de l'installation hormis quelques : "could not change directory to "/home/gnadmin/geonature": Permission non accordée" Je n'ai rien remarqué de particulier.

En parallèle, j'ai essayé de me connecter

Tests effectués J'ai essayé à plusieurs reprises la réinstallation complète après avec supprimé les dossier geonature, taxhub et usershub et en indiquant drop=true dans le fichier install_all.ini mais le problème est toujours le même.

Si quelqu'un pouvait m'aider ca serait bien aimable.

Merci d'avance.

Simon

Voici l'intégrale du descriptif de l'installation (avec quelques oublis (pour allèger le code) indiqués par le symbole [....]) :


gnadmin@Geonature:~$ nano install_all.ini
gnadmin@Geonature:~$ touch install_all.log
chmod +x install_all.sh
./install_all.sh 2>&1 | tee install_all.log
############### Installation des paquets systèmes ###############
Installation de l'environnement logiciel...
Lecture des listes de paquets…
Construction de l'arbre des dépendances…
Lecture des informations d'état…
unzip est déjà la version la plus récente (6.0-28).
git est déjà la version la plus récente (1:2.39.2-1.1).
postgresql-postgis est déjà la version la plus récente (3.3.2+dfsg-1+b1).
postgis est déjà la version la plus récente (3.3.2+dfsg-1+b1).
python3-pip est déjà la version la plus récente (23.0.1+dfsg-1).
python3-venv est déjà la version la plus récente (3.11.2-1+b1).
python3-dev est déjà la version la plus récente (3.11.2-1+b1).
libpq-dev est déjà la version la plus récente (15.8-0+deb12u1).
libgdal-dev est déjà la version la plus récente (3.6.2+dfsg-1+b2).
libffi-dev est déjà la version la plus récente (3.4.4-1).
libpangocairo-1.0-0 est déjà la version la plus récente (1.50.12+ds-1).
apache2 est déjà la version la plus récente (2.4.62-1~deb12u1).
redis est déjà la version la plus récente (5:7.0.15-1~deb12u1).
gettext-base est déjà la version la plus récente (0.21-12).
0 mis à jour, 0 nouvellement installés, 0 à enlever et 0 non mis à jour.
Module rewrite already enabled
Module proxy already enabled
Considering dependency proxy for proxy_http:
Module proxy already enabled
Module proxy_http already enabled
Installation de la base de données et configuration de l'application GeoNature ...
Installation de nvm
Installation de nvm
=> nvm is already installed in /home/gnadmin/.nvm, trying to update using git
=> => Compressing and cleaning up git repository

=> nvm source string already in /home/gnadmin/.bashrc
=> bash_completion source string already in /home/gnadmin/.bashrc
=> Close and reopen your terminal to start using nvm or run the following to use it now:

export NVM_DIR="$HOME/.nvm"
[ -s "$NVM_DIR/nvm.sh" ] && \. "$NVM_DIR/nvm.sh"  # This loads nvm
[ -s "$NVM_DIR/bash_completion" ] && \. "$NVM_DIR/bash_completion"  # This loads nvm bash_completion
v20.17.0 is already installed.
Now using node v20.17.0 (npm v10.8.2)
Installation du backend GeoNature
Utilisation du fichier de configuration GeoNature exisant
Activation du virtual env...
Installation des dépendances Python...
Requirement already satisfied: pip>=19.3 in ./venv/lib/python3.11/site-packages (24.2)
Requirement already satisfied: wheel in ./venv/lib/python3.11/site-packages (0.44.0)
Obtaining file:///home/gnadmin/geonature
  Installing build dependencies: started
  Installing build dependencies: finished with status 'done'
  Checking if build backend supports build_editable: started
  Checking if build backend supports build_editable: finished with status 'done'
  Getting requirements to build editable: started
  Getting requirements to build editable: finished with status 'done'
  Preparing editable metadata (pyproject.toml): started
  Preparing editable metadata (pyproject.toml): finished with status 'done'
Ignoring importlib-metadata: markers 'python_version < "3.10"' don't match your environment
[...]
Building wheels for collected packages: geonature
  Building editable for geonature (pyproject.toml): started
  Building editable for geonature (pyproject.toml): finished with status 'done'
  Created wheel for geonature: filename=geonature-2.14.2-0.editable-py3-none-any.whl size=16564 sha256=b8ebb5a5df99fab94a030663f268594d9bf361290718f397e92e684ce547b2d1
  Stored in directory: /tmp/pip-ephem-wheel-cache-y3m0umoq/wheels/54/53/31/4842d9b47b7500b96f763fb4b91d74e0d96a74e2098c54661d
Successfully built geonature
Installing collected packages: geonature
  Attempting uninstall: geonature
    Found existing installation: geonature 2.14.2
    Uninstalling geonature-2.14.2:
      Successfully uninstalled geonature-2.14.2
Successfully installed geonature-2.14.2
Génération du fichier d’autocomplétion de la commande Geonature…
Modification du script 'activate' du virtual env pour sourcer le fichier d'autocomplétion de la commande GeoNature...
Installation des paquets npm
Found '/home/gnadmin/geonature/frontend/.nvmrc' with version <lts/iron>
Now using node v20.17.0 (npm v10.8.2)
npm warn old lockfile
npm warn old lockfile The package-lock.json file was created with an old version of npm,
npm warn old lockfile so supplemental metadata must be fetched from the registry.
npm warn old lockfile
npm warn old lockfile This is a one-time fix-up, please be patient...
npm warn old lockfile
npm warn deprecated popper.js@1.16.1: You can find the new Popper v2 at @popperjs/core, this package is dedicated to the legacy v1

added 4 packages, and audited 5 packages in 638ms

2 packages are looking for funding
  run `npm fund` for details

1 moderate severity vulnerability

To address all issues (including breaking changes), run:
  npm audit fix --force

Run `npm audit` for details.
Installation des scripts systemd
Installation de la configuration systemd-tmpfiles…
d /run/geonature 0750 gnadmin gnadmin -
d /var/log/geonature 0750 gnadmin gnadmin -
d /var/lib/geonature 0750 gnadmin gnadmin -
Installation des fichiers de service systemd…
[Unit]
Description=GeoNature
After=postgresql.service
After=network.target

[Service]
Type=simple
User=gnadmin
Group=gnadmin
WorkingDirectory=/home/gnadmin/geonature/
Environment=GUNICORN_PROC_NAME=geonature
Environment=GUNICORN_NUM_WORKERS=4
Environment=GUNICORN_HOST=127.0.0.1
Environment=GUNICORN_PORT=8000
Environment=GUNICORN_TIMEOUT=30
Environment=GUNICORN_LOG_FILE=/var/log/geonature/%N%I.log
EnvironmentFile=-/home/gnadmin/geonature/environ
ExecStart=/home/gnadmin/geonature/backend/venv/bin/gunicorn geonature:create_app() \
                --name "${GUNICORN_PROC_NAME}" --workers "${GUNICORN_NUM_WORKERS}" \
                --bind "${GUNICORN_HOST}:${GUNICORN_PORT}" --timeout="${GUNICORN_TIMEOUT}" \
                --log-file "${GUNICORN_LOG_FILE}"
ExecReload=/bin/kill -s HUP $MAINPID
KillMode=mixed
TimeoutStartSec=10
TimeoutStopSec=5
PrivateTmp=true

[Install]
WantedBy=multi-user.target
[Unit]
Description=GeoNature Celery Worker Service
After=redis-server.service
After=postgresql.service
ReloadPropagatedFrom=geonature.service

[Service]
Type=simple
User=gnadmin
Group=gnadmin
WorkingDirectory=/home/gnadmin/geonature/
Environment=CELERY_APP="geonature.celery_app:app"
Environment=CELERYD_LOG_FILE="/var/log/geonature/%N%I.log"
Environment=CELERYD_LOG_LEVEL="INFO"
Environment=CELERYD_SCHEDULE_FILENAME="/var/lib/geonature/celerybeat-schedule.db"
EnvironmentFile=-/home/gnadmin/geonature/environ
ExecStart=/home/gnadmin/geonature/backend/venv/bin/celery -A ${CELERY_APP} worker \
                        --beat --schedule-filename=${CELERYD_SCHEDULE_FILENAME} \
                        --logfile=${CELERYD_LOG_FILE} \
                        --loglevel=${CELERYD_LOG_LEVEL} \
                        $CELERYD_OPTS
ExecReload=/bin/kill -s HUP $MAINPID

[Install]
WantedBy=multi-user.target
[Unit]
Description=Reload GeoNature

[Service]
Type=oneshot
ExecStart=/usr/bin/systemctl reload geonature
[Unit]
StopWhenUnneeded=true

[Path]
PathModified=/home/gnadmin/geonature/config/%i_config.toml
Unit=geonature-reload.service

[Install]
WantedBy=multi-user.target
#!/bin/sh

service="/etc/systemd/system/geonature-reload@.path"
wantdir="$1/geonature.service.wants"

mkdir -p "$wantdir"

for conf in "/home/gnadmin/geonature"/config/*_config.toml; do
        confname=$(basename ${conf%"_config.toml"})
        ln -s "$service" "$wantdir/geonature-reload@$confname.path"
done
Installation de la configuration logrotate…
/var/log/geonature/geonature.log {
    su gnadmin gnadmin
    daily
    rotate 8
    size 100M
    create
    compress
    postrotate
    systemctl reload geonature || true
    endscript
}
/var/log/geonature/geonature-worker.log {
    su gnadmin gnadmin
    daily
    rotate 8
    size 100M
    create
    compress
    postrotate
    systemctl reload geonature-worker || true
    endscript
}
Activation de geonature au démarrage…
Vous pouvez maintenant démarrer GeoNature avec la commande : sudo systemctl start geonature
Vous pouvez maintenant démarrer le worker GeoNature avec la commande : sudo systemctl start geonature-worker
Installation de la base de données
could not change directory to "/home/gnadmin/geonature": Permission non accordée
Close all Postgresql conections on GeoNature DB
could not change directory to "/home/gnadmin/geonature": Permission non accordée
 pg_terminate_backend
----------------------
(0 rows)

Drop database...
could not change directory to "/home/gnadmin/geonature": Permission non accordée
Check GeoNature database user 'pgnadmin' exists…
could not change directory to "/home/gnadmin/geonature": Permission non accordée
Creating GeoNature database...
could not change directory to "/home/gnadmin/geonature": Permission non accordée
Adding PostgreSQL extensions
could not change directory to "/home/gnadmin/geonature": Permission non accordée
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
DO
GRANT access to GeoNature user to necessary tables...
could not change directory to "/home/gnadmin/geonature": Permission non accordée
GRANT
could not change directory to "/home/gnadmin/geonature": Permission non accordée
GRANT
could not change directory to "/home/gnadmin/geonature": Permission non accordée
GRANT
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 3842a6d800a0, Add public shared functions
INFO  [alembic.runtime.migration] Running upgrade  -> 6afe74833ed0, ref_geo schema
INFO  [alembic.runtime.migration] Running upgrade  -> fa35dfe5ff27, utilisateurs schema 1.4.7 (usershub 2.1.3)
INFO  [alembic.runtime.migration] Running upgrade  -> 9c2c0254aadc, create taxonomie schema version 1.8.1
INFO  [alembic.runtime.migration] Running upgrade 6afe74833ed0 -> e0ac4c9f5c0a, add indexes on FK referencing l_areas.id_area
INFO  [alembic.runtime.migration] Running upgrade  -> 6015397d686a, create ref_nomenclature schema 1.3.9
INFO  [alembic.runtime.migration] Running upgrade  -> 72f227e37bdf, utilisateurs sample data
INFO  [alembic.runtime.migration] Running upgrade fa35dfe5ff27 -> 830cc8f4daef, add additional_data field to bib_organismes
INFO  [alembic.runtime.migration] Running upgrade 830cc8f4daef -> 5b334b77f5f5, fix v_roleslist_forall_applications
INFO  [alembic.runtime.migration] Running upgrade 5b334b77f5f5 -> 951b8270a1cf, add unique constraint on bib_organismes.uuid_organisme
INFO  [alembic.runtime.migration] Running upgrade  -> 96a713739fdd, insert inpn data in ref_nomenclatures
INFO  [alembic.runtime.migration] Running upgrade  -> f5436084bf17, add support for taxonomy into ref_nomenclatures
INFO  [alembic.runtime.migration] Running upgrade 9c2c0254aadc -> 7540702c6407, cd_ref utility functions
INFO  [alembic.runtime.migration] Running upgrade 7540702c6407 -> 98035939bc0d, find_all_taxons_parents
INFO  [alembic.runtime.migration] Running upgrade 98035939bc0d -> c93cbb35cfe4, set default value for id_liste
INFO  [alembic.runtime.migration] Running upgrade c93cbb35cfe4 -> 4fb7e197d241, create taxonomie.v_bdc_status view
INFO  [alembic.runtime.migration] Running upgrade  -> 62e63cd6135d, create ref_habitats schema
INFO  [alembic.runtime.migration] Running upgrade  -> 46e91e738845, insert inpn data in ref_habitats schema
INFO  [alembic.runtime.migration] Created temporary directory '/tmp/tmpxf3j9k9i'
INFO  [alembic.runtime.migration] Downloading 'HABREF_50.zip'…
INFO  [alembic.runtime.migration] Insert INPN data in bib_habref_typo_rel…
INFO  [alembic.runtime.migration] Insert INPN data in bib_habref_statuts…
INFO  [alembic.runtime.migration] Insert INPN data in habref_sources…
INFO  [alembic.runtime.migration] Insert INPN data in typoref…
INFO  [alembic.runtime.migration] Insert INPN data in habref…
INFO  [alembic.runtime.migration] Insert INPN data in habref_corresp_hab…
INFO  [alembic.runtime.migration] Insert INPN data in habref_corresp_taxon…
INFO  [alembic.runtime.migration] Insert INPN data in cor_habref_terr_statut…
INFO  [alembic.runtime.migration] Insert INPN data in typoref_fields…
INFO  [alembic.runtime.migration] Insert INPN data in cor_habref_description…
INFO  [alembic.runtime.migration] Insert INPN data in cor_hab_source…
INFO  [alembic.runtime.migration] Populate table autocomplete_habitat…
INFO  [alembic.runtime.migration] Running upgrade  -> f06cc80cc8ba, geonature schemas 2.7.5
INFO  [alembic.runtime.migration] Running upgrade f06cc80cc8ba -> c0fdf2ee7f4f, auto update cor_area_synthese
INFO  [alembic.runtime.migration] Running upgrade c0fdf2ee7f4f -> 7077aa76da3d, bump dependencies
INFO  [alembic.runtime.migration] Running upgrade 7077aa76da3d -> 2a2e5c519fd1, fix gn_synthese.get_default_nomenclature_value
INFO  [alembic.runtime.migration] Running upgrade 2a2e5c519fd1 -> 5f4c4b644844, delete cascade on  cor_dataset_territory and cor_dataset_protocol
INFO  [alembic.runtime.migration] Running upgrade 5f4c4b644844 -> 2aa558b1be3a, add schema gn_profiles
INFO  [alembic.runtime.migration] Running upgrade 2aa558b1be3a -> 1eb624249f2b, add default value in additionalFields bib
INFO  [alembic.runtime.migration] Running upgrade 1eb624249f2b -> 7471f51011c8, change index_vm_valid_profiles_cd_ref to unique index
INFO  [alembic.runtime.migration] Running upgrade 7471f51011c8 -> 6f7d5549d49e, delete view v_synthese_validation_forwebapp
INFO  [alembic.runtime.migration] Running upgrade 6f7d5549d49e -> dde31e76ce45, remove old profile function
INFO  [alembic.runtime.migration] Running upgrade dde31e76ce45 -> 61e46813d621, Update synthese sensitivity
INFO  [alembic.runtime.migration] Running upgrade 61e46813d621 -> dfec5f64ac73, Fix sensitivity algorithm
INFO  [alembic.runtime.migration] Recompute sensitivity…
INFO  [alembic.runtime.migration] Sensitivity updated for 0 rows
INFO  [alembic.runtime.migration] Running upgrade dfec5f64ac73 -> ac08dcf3f27b, Do not auto-compute diffusion_level
INFO  [alembic.runtime.migration] Clearing diffusion level…
INFO  [alembic.runtime.migration] Cleared diffusion level on 0 rows.
INFO  [alembic.runtime.migration] Running upgrade dde31e76ce45 -> 30edd97ae582, Remove gn_export.t_config_exports
INFO  [alembic.runtime.migration] Running upgrade 30edd97ae582, ac08dcf3f27b -> 1dbc45309d6e, Merge sensitivity
INFO  [alembic.runtime.migration] Running upgrade 1dbc45309d6e -> ca052245c6ec, remove local srid
INFO  [alembic.runtime.migration] Running upgrade ca052245c6ec -> 095da7bc6667, add table gn_synthese.bib_reports_types
INFO  [alembic.runtime.migration] Create bib_reports_types table...
INFO  [alembic.runtime.migration] Running upgrade 095da7bc6667 -> 829a376daa52, add table gn_synthese.t_reports
INFO  [alembic.runtime.migration] Create t_reports table...
INFO  [alembic.runtime.migration] Running upgrade 829a376daa52 -> ca0fe5d21ea2, remove v_synthese_decode_nomenclatures
INFO  [alembic.runtime.migration] Running upgrade ca0fe5d21ea2 -> 74908bad752e, add_altitude_calculation_in_t_base_site
INFO  [alembic.runtime.migration] Running upgrade 74908bad752e -> 77a3bc6628d2, additional fields: add datalist widget
INFO  [alembic.runtime.migration] Running upgrade 77a3bc6628d2 -> d80835fb13c8, Remove gn_sensitivity.cor_sensitivity_synthese
INFO  [alembic.runtime.migration] Running upgrade d80835fb13c8 -> 6070edb31013, Set constraint check_cor_af_territory NOT VALID
INFO  [alembic.runtime.migration] Running upgrade 6070edb31013 -> f4ffdc68072c, add id_module in t_sources
INFO  [alembic.runtime.migration] Running upgrade f4ffdc68072c -> 8d90ab5e686d, Add profiles default parameters
INFO  [alembic.runtime.migration] Running upgrade 8d90ab5e686d -> 07f10bbb4f3b, add mobile app settings url
INFO  [alembic.runtime.migration] Running upgrade 07f10bbb4f3b -> 42040535a20e, add ng_module column in t_modules
INFO  [alembic.runtime.migration] Running upgrade 42040535a20e -> 4b5478df71cb, Update synthese sensitivity, including previously NULL rows
INFO  [alembic.runtime.migration] Running upgrade 4b5478df71cb -> 2d7edda45dd4, set cascade on FK referencing sensitivity rules
INFO  [alembic.runtime.migration] Running upgrade 2d7edda45dd4 -> 36d0bd313a47, add notification schema, tables and data
INFO  [alembic.runtime.migration] Create schema gn_notifications
INFO  [alembic.runtime.migration] Create table gn_notifications.bib_notifications_methods
INFO  [alembic.runtime.migration] Create table gn_notifications.bib_notifications_categories
INFO  [alembic.runtime.migration] Create table gn_notifications.bib_notifications_templates
INFO  [alembic.runtime.migration] Create table gn_notifications.t_notifications
INFO  [alembic.runtime.migration] Create table gn_notifications.t_notifications_rules
INFO  [alembic.runtime.migration] Insertion des données méthodes
INFO  [alembic.runtime.migration] Insertion des données catégories
INFO  [alembic.runtime.migration] Insertion des données template
INFO  [alembic.runtime.migration] Running upgrade 36d0bd313a47 -> 4cf3fd5d06f5, set not-null on synthese.id_source
INFO  [alembic.runtime.migration] Running upgrade 4cf3fd5d06f5 -> 09a637f06b96, Default notification rules
INFO  [alembic.runtime.migration] Running upgrade 4fb7e197d241 -> d768a5da908c, add bdc_status indexes
INFO  [alembic.runtime.migration] Running upgrade d768a5da908c -> 4a549132d156, Add unique constraints
INFO  [alembic.runtime.migration] Running upgrade 4a549132d156 -> c4415009f164, Taxref v15 db structure
INFO  [alembic.runtime.migration] Running upgrade 09a637f06b96 -> 8888e5cce63b, add index on id_area for table cor_area_synthese
INFO  [alembic.runtime.migration] Running upgrade 8888e5cce63b -> 497f52d996dd, TAdditionalFields : remove useless columns and values
INFO  [alembic.runtime.migration] Running upgrade 497f52d996dd -> 0cae32a010ea, lstrip static/medias/ from t_medias.media_path
INFO  [alembic.runtime.migration] Running upgrade 0cae32a010ea -> 5d65f9c93a32, fix permissions view
INFO  [alembic.runtime.migration] Running upgrade 5d65f9c93a32 -> 8279ce74006b, set modules default type
INFO  [alembic.runtime.migration] Running upgrade 8279ce74006b -> 05a91edb6796, Improve the view gn_synthese.v_export_for_synthese
INFO  [alembic.runtime.migration] Running upgrade 05a91edb6796 -> cec41a6d3a15, revome v_roles_permissions
INFO  [alembic.runtime.migration] Running upgrade cec41a6d3a15 -> 9e9218653d6c, add synthese log history
INFO  [alembic.runtime.migration] Running upgrade 9e9218653d6c -> cf1c1fdbde77, correction-sql-on-delete-module
INFO  [alembic.runtime.migration] Running upgrade cf1c1fdbde77 -> e2a94808cf76, add notifications object
INFO  [alembic.runtime.migration] Running upgrade e2a94808cf76 -> 95acee9f0452, add comment notification
INFO  [alembic.runtime.migration] Running upgrade 95acee9f0452 -> df5a5099e084, add additional fields object
INFO  [alembic.runtime.migration] Running upgrade df5a5099e084 -> 0630b93bcfe0, add permissions inherited modules objects
INFO  [alembic.runtime.migration] Running upgrade 0630b93bcfe0 -> 7fe46b0e4729, multiple filters per permission
INFO  [alembic.runtime.migration] Running upgrade 7fe46b0e4729 -> f051b88a57fd, permissions available
INFO  [alembic.runtime.migration] Running upgrade f051b88a57fd -> f1dd984bff97, add sensitivity filter
INFO  [alembic.runtime.migration] Running upgrade f1dd984bff97 -> 446e902a14e7, add id_module to v_synthese_for_web_app
INFO  [alembic.runtime.migration] Running upgrade 446e902a14e7 -> d99a7c22cc3c, add_column_group_inpn_to_v_synthese_for_web_app
INFO  [alembic.runtime.migration] Running upgrade d99a7c22cc3c -> 5a2c9c65129f, add sensitivity filter export synthese
INFO  [alembic.runtime.migration] Running upgrade 5a2c9c65129f -> 9f4db1786c22, add group3 inpn to synthese views
Context impl PostgresqlImpl.
Will assume transactional DDL.
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 6015397d686a -> 11e7741319fd, fix ref_nomenclatures.get_default_nomenclature_value
INFO  [alembic.runtime.migration] Running upgrade 11e7741319fd -> f8c2c8482419, fix ref_nomenclatures.get_default_nomenclature_value
INFO  [alembic.runtime.migration] Running upgrade f8c2c8482419 -> b820c66d8daa, fix ref_nomenclatures.get_nomenclature_label
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 46e91e738845 -> 805442837a68, correction on habref data
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade c4415009f164 -> 1b1a3f5cd107, Add table to link bdc_status and ref_geo
INFO  [alembic.runtime.migration] Running upgrade 1b1a3f5cd107 -> f2c36312b3de, fix vm_taxref_for_autocomplete
INFO  [alembic.runtime.migration] Running upgrade f2c36312b3de -> 27fd7e2b4b79, Add vm_taxref_list_forautocomplete index
INFO  [alembic.runtime.migration] Running upgrade 27fd7e2b4b79 -> 188bc535258a, Drop old status table
INFO  [alembic.runtime.migration] Running upgrade 188bc535258a -> 23c25552d707, Create bdc_status_table if not exists
INFO  [alembic.runtime.migration] Running upgrade 23c25552d707 -> 6607b25b2d66, Taxref : set null to empty string
INFO  [alembic.runtime.migration] Running upgrade 6607b25b2d66 -> 3bd542b72955, optimize_vm_taxref_for_autocomplete
INFO  [alembic.runtime.migration] Running upgrade 3bd542b72955 -> 32c5ed42bdbd, Add table: t_meta_taxref
INFO  [alembic.runtime.migration] Running upgrade 32c5ed42bdbd -> 33e20a7682b4, check_group3_inpn_vm_and_function
INFO  [alembic.runtime.migration] Running upgrade f5436084bf17 -> 803524258bd3, add group3_inpn cor_taxref_nomenclature
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 33e20a7682b4 -> 8f3256f60915, group3_inpn_autocomplete
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 951b8270a1cf -> 10e87bc144cd, get_id_role_by_name()
INFO  [alembic.runtime.migration] Running upgrade 10e87bc144cd -> 112ccf1024ce, add unique constraint on t_roles UUID
INFO  [alembic.runtime.migration] Running upgrade 112ccf1024ce -> f4bf21ac6238, fix temp user organism size
INFO  [alembic.runtime.migration] Running upgrade f4bf21ac6238 -> f9d3b95946cd, set code_profil in integer
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade e0ac4c9f5c0a -> 4882d6141a41, add regions in area types
INFO  [alembic.runtime.migration] Running upgrade 4882d6141a41 -> 681306b27407, fix altitude trigger
INFO  [alembic.runtime.migration] Running upgrade 681306b27407 -> cb038e76d59c, fix functions local srid
INFO  [alembic.runtime.migration] Running upgrade cb038e76d59c -> f7374cd6e38d, add linears
INFO  [alembic.runtime.migration] Running upgrade f7374cd6e38d -> dea1645de8c0, Référentiel point, cor (area, linear, point)
INFO  [alembic.runtime.migration] Running upgrade dea1645de8c0 -> 795f6ea8ec45, cor_areas & cor_linear_areas
INFO  [alembic.runtime.migration] Running upgrade 795f6ea8ec45 -> bc2fcc772b46, Add column LAreas.geom_4326
INFO  [alembic.runtime.migration] Running upgrade bc2fcc772b46 -> f22d70b8fcfa, add areas types size hierarchy
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 96a713739fdd -> 618542880d1f, fix typo in nomenclature type definition
INFO  [alembic.runtime.migration] Running upgrade 618542880d1f -> ee1146f6c0f4, Add UICN Red List
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 3842a6d800a0 -> ba207b468e31, create fr_numeric collation
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 3fdaa1805575, Insert French departments in ref_geo
INFO  [alembic.runtime.migration] Create temporary departments table…
INFO  [alembic.runtime.migration] Created temporary directory '/tmp/tmpuu6zh82_'
INFO  [alembic.runtime.migration] Downloading 'departements_fr_2020-02.csv.xz'…
INFO  [alembic.runtime.migration] Inserting departments data in temporary table…
INFO  [alembic.runtime.migration] Copy departments data in l_areas…
INFO  [alembic.runtime.migration] Re-indexing…
INFO  [alembic.runtime.migration] Dropping temporary departments table…
Created temporary directory '/tmp/tmp5_b02uxq'
Downloading 'TAXREF_v17_2024.zip'…
Insert TAXREF v17 habitats…
Insert TAXREF v17 rangs…
Insert TAXREF v17 statuts…
Insert TAXREF v17 referentiel…
Created temporary directory '/tmp/tmpvgfel6xa'
Downloading 'BDC-Statuts-v17.zip'…
Insert BDC statuts types…
Insert BDC statuts…
Populate BDC statuts…
Populate Link BDC statuts with Areas…
Refresh materialized views…
Committing…
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> a763fb554ff2, insert taxonomic filtering data in ref_nomenclatures.cor_taxref_nomenclatures
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 3d0bf4ee67d1, geonature samples
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 0dfdbfbccd63, Insert French municipalities in ref_geo
INFO  [alembic.runtime.migration] Create temporary municipalities table…
INFO  [alembic.runtime.migration] Created temporary directory '/tmp/tmprj1yb6ak'
INFO  [alembic.runtime.migration] Downloading 'communes_fr_2020-02.csv.xz'…
INFO  [alembic.runtime.migration] Inserting municipalities data in temporary table…
INFO  [alembic.runtime.migration] Copy municipalities in l_areas…
INFO  [alembic.runtime.migration] Copy municipalities in li_municipalities…
INFO  [alembic.runtime.migration] Re-indexing…
INFO  [alembic.runtime.migration] Dropping temporary municipalities table…
INFO  [alembic.runtime.migration] Running upgrade 0dfdbfbccd63 -> fda887e7b578, empty message
INFO  [alembic.runtime.migration] Correct area_name for communes (for characters Œ and œ)
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> d02f4563bebe, Insert French regions in ref_geo
INFO  [alembic.runtime.migration] Create temporary regions table…
INFO  [alembic.runtime.migration] Created temporary directory '/tmp/tmporxi2vd0'
INFO  [alembic.runtime.migration] Downloading 'regions_fr_2021-11.csv.xz'…
INFO  [alembic.runtime.migration] Inserting regions data in temporary table…
INFO  [alembic.runtime.migration] Copy regions in l_areas…
INFO  [alembic.runtime.migration] Re-indexing…
INFO  [alembic.runtime.migration] Dropping temporary regions table…
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 586613e2faeb, Insert INPN 1×1 grids in ref_geo
INFO  [alembic.runtime.migration] Create temporary grids table…
INFO  [alembic.runtime.migration] Created temporary directory '/tmp/tmps152c1d4'
INFO  [alembic.runtime.migration] Downloading 'inpn_grids_1.csv.xz'…
INFO  [alembic.runtime.migration] Inserting grids data in temporary table…
INFO  [alembic.runtime.migration] Copy grids in l_areas…
INFO  [alembic.runtime.migration] Copy grids in li_grids…
INFO  [alembic.runtime.migration] Re-indexing…
INFO  [alembic.runtime.migration] Dropping temporary grids table…
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 7d6e98441e4c, Insert INPN 5×5 grids in ref_geo
INFO  [alembic.runtime.migration] Create temporary grids table…
INFO  [alembic.runtime.migration] Created temporary directory '/tmp/tmp42cn3jpu'
INFO  [alembic.runtime.migration] Downloading 'inpn_grids_5.csv.xz'…
INFO  [alembic.runtime.migration] Inserting grids data in temporary table…
INFO  [alembic.runtime.migration] Copy grids in l_areas…
INFO  [alembic.runtime.migration] Copy grids in li_grids…
INFO  [alembic.runtime.migration] Re-indexing…
INFO  [alembic.runtime.migration] Dropping temporary grids table…
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> ede150d9afd9, Insert INPN 10×10 grids in ref_geo
INFO  [alembic.runtime.migration] Create temporary grids table…
INFO  [alembic.runtime.migration] Created temporary directory '/tmp/tmp5qknd9rp'
INFO  [alembic.runtime.migration] Downloading 'inpn_grids_10.csv.xz'…
INFO  [alembic.runtime.migration] Inserting grids data in temporary table…
INFO  [alembic.runtime.migration] Copy grids in l_areas…
INFO  [alembic.runtime.migration] Copy grids in li_grids…
INFO  [alembic.runtime.migration] Re-indexing…
INFO  [alembic.runtime.migration] Dropping temporary grids table…
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
Created temporary directory '/tmp/tmpcwkjdd0z'
Downloading 'RefSensibiliteV17_20240325.zip'…
Ajout de règles de sensibilité 'Référentiel sensibilité TAXREF v17 20240325'
24304 règles ajoutées
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 1715cf31a75d, Insert default French DEM (IGN 250m BD alti)
INFO  [alembic.runtime.migration] Created temporary directory '/tmp/tmp3wmglfk2'
INFO  [alembic.runtime.migration] Downloading 'BDALTIV2_2-0_250M_ASC_LAMB93-IGN69_FRANCE_2017-06-21.zip'…
Processing 1/1: /tmp/tmpv5xblc0u/BDALTIV2_250M_FXX_0098_7150_MNT_LAMB93_IGN69.asc
NOTICE:  Adding SRID constraint
NOTICE:  Adding scale-X constraint
NOTICE:  Adding scale-Y constraint
NOTICE:  Adding blocksize-X constraint
NOTICE:  Adding blocksize-Y constraint
NOTICE:  Adding alignment constraint
NOTICE:  Adding number of bands constraint
NOTICE:  Adding pixel type constraint
NOTICE:  Adding nodata value constraint
NOTICE:  Adding out-of-database constraint
NOTICE:  Adding maximum extent constraint
INFO  [alembic.runtime.migration] Refresh DEM spatial index…
Context impl PostgresqlImpl.
Will assume transactional DDL.
Installation des modules GeoNature
Activation du virtual env
Installation du backend…
Obtaining file:///home/gnadmin/geonature/contrib/occtax
  Preparing metadata (setup.py): started
  Preparing metadata (setup.py): finished with status 'done'
Installing collected packages: occtax
  Attempting uninstall: occtax
    Found existing installation: occtax 1.1.0
    Uninstalling occtax-1.1.0:
      Successfully uninstalled occtax-1.1.0
  DEPRECATION: Legacy editable install of occtax==1.1.0 from file:///home/gnadmin/geonature/contrib/occtax (setup.py develop) is deprecated. pip 25.0 will enforce this behaviour change. A possible replacement is to add a pyproject.toml or enable --use-pep517, and use setuptools >= 64. If the resulting installation is not behaving as expected, try using --config-settings editable_mode=compat. Please consult the setuptools documentation for more information. Discussion can be found at https://github.com/pypa/pip/issues/11457
  Running setup.py develop for occtax
Successfully installed occtax-1.1.0
Correction du lien symbolique /home/gnadmin/geonature/frontend/external_modules/occtax → /home/gnadmin/geonature/contrib/occtax/frontend
Création de la configuration frontend…
Installation / mise à jour de la base de données…
/home/gnadmin/geonature/backend/geonature/utils/module.py:130: SAWarning: Flushing object <TModules at 0x7f6e57b12fd0> with incompatible polymorphic identity None; the object may not refresh and/or load correctly (this warning may be suppressed after 10 occurrences)
  db.session.commit()
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 29c199e07eaa, create occtax schema
INFO  [alembic.runtime.migration] Running upgrade 29c199e07eaa -> addb71d8efad, create occtax export view
INFO  [alembic.runtime.migration] Running upgrade addb71d8efad -> f57107d2d0ad, fix get_default_nomenclature_value
INFO  [alembic.runtime.migration] Running upgrade f57107d2d0ad -> 494cb2245a43, trigger comportement
INFO  [alembic.runtime.migration] Running upgrade 494cb2245a43 -> 944072911ff7, update synthese data (bug occtax trigger)
INFO  [alembic.runtime.migration] Running upgrade 944072911ff7 -> 22c2851bc387, add database default value
INFO  [alembic.runtime.migration] Running upgrade 22c2851bc387 -> 023b0be41829, add id_module in pr_occtax.t_releves
INFO  [alembic.runtime.migration] Running upgrade 023b0be41829 -> c26c770b00ae, fix occtax trigger additionnal data + trigger occ
INFO  [alembic.runtime.migration] Running upgrade c26c770b00ae -> 9624348fea40, restore occtax missing counting
INFO  [alembic.runtime.migration] Running upgrade 9624348fea40 -> 576cbd26b012, default value for id_nomenclature_observations_status
INFO  [alembic.runtime.migration] Running upgrade 576cbd26b012 -> 61802a0f83b8, Fix OccTax triggers to synthese
INFO  [alembic.runtime.migration] Running upgrade 61802a0f83b8 -> df088920b2f3, set not null on t_releves_occtax.id_module
INFO  [alembic.runtime.migration] Running upgrade df088920b2f3 -> 4c97453a2d1a, add missing id module in t_sources
INFO  [alembic.runtime.migration] Running upgrade 4c97453a2d1a -> 9668b861bdb6, remove v_releve_occtax
INFO  [alembic.runtime.migration] Running upgrade 9668b861bdb6 -> 0ff94776a962, t_releves triggers optimization
INFO  [alembic.runtime.migration] Running upgrade 0ff94776a962 -> 1b4f44762020, update cd_hab in fct_tri_synthese_update_releve
INFO  [alembic.runtime.migration] Running upgrade 1b4f44762020 -> e170d1902137, declare permissions
INFO  [alembic.runtime.migration] Running upgrade e170d1902137 -> 43ecf0836b4a, invert count default
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> cce08a64eb4f, insert occtax sample data (noop)
INFO  [alembic.runtime.migration] Running upgrade cce08a64eb4f -> 87705981de5e, insert occtax sample data
Installation du backend…
Obtaining file:///home/gnadmin/geonature/contrib/gn_module_occhab
  Preparing metadata (setup.py): started
  Preparing metadata (setup.py): finished with status 'done'
Installing collected packages: gn-module-occhab
  DEPRECATION: Legacy editable install of gn-module-occhab==1.1.0 from file:///home/gnadmin/geonature/contrib/gn_module_occhab (setup.py develop) is deprecated. pip 25.0 will enforce this behaviour change. A possible replacement is to add a pyproject.toml or enable --use-pep517, and use setuptools >= 64. If the resulting installation is not behaving as expected, try using --config-settings editable_mode=compat. Please consult the setuptools documentation for more information. Discussion can be found at https://github.com/pypa/pip/issues/11457
  Running setup.py develop for gn-module-occhab
Successfully installed gn-module-occhab-1.1.0
Création du lien symbolique /home/gnadmin/geonature/frontend/external_modules/occhab → /home/gnadmin/geonature/contrib/gn_module_occhab/frontend
Installation des dépendances frontend…
Running node v20.17.0 (npm v10.8.2)

added 1 package, and audited 2 packages in 429ms

found 0 vulnerabilities
Création de la configuration frontend…
Installation / mise à jour de la base de données…
/home/gnadmin/geonature/backend/geonature/utils/module.py:130: SAWarning: Flushing object <TModules at 0x7f334fa23610> with incompatible polymorphic identity None; the object may not refresh and/or load correctly (this warning may be suppressed after 10 occurrences)
  db.session.commit()
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 2984569d5df6, create occhab schema
INFO  [alembic.runtime.migration] Running upgrade 2984569d5df6 -> 85efc9bb5a47, declare permissions
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 21f661247023, insert occhab sample data
Installation du backend…
Obtaining file:///home/gnadmin/geonature/contrib/gn_module_validation
  Preparing metadata (setup.py): started
  Preparing metadata (setup.py): finished with status 'done'
Installing collected packages: gn-module-validation
  DEPRECATION: Legacy editable install of gn-module-validation==1.1.0 from file:///home/gnadmin/geonature/contrib/gn_module_validation (setup.py develop) is deprecated. pip 25.0 will enforce this behaviour change. A possible replacement is to add a pyproject.toml or enable --use-pep517, and use setuptools >= 64. If the resulting installation is not behaving as expected, try using --config-settings editable_mode=compat. Please consult the setuptools documentation for more information. Discussion can be found at https://github.com/pypa/pip/issues/11457
  Running setup.py develop for gn-module-validation
Successfully installed gn-module-validation-1.1.0
Création du lien symbolique /home/gnadmin/geonature/frontend/external_modules/validation → /home/gnadmin/geonature/contrib/gn_module_validation/frontend
Création de la configuration frontend…
Installation / mise à jour de la base de données…
/home/gnadmin/geonature/backend/geonature/utils/module.py:130: SAWarning: Flushing object <TModules at 0x7fb2ebd56310> with incompatible polymorphic identity None; the object may not refresh and/or load correctly (this warning may be suppressed after 10 occurrences)
  db.session.commit()
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> df93a68242ee, declare permissions
INFO  [alembic.runtime.migration] Running upgrade df93a68242ee -> 9a4b4b6f8fe6, add_fct_auto_validation
Nouvelle permission : module 'OCCHAB', objet 'ALL', action 'E'
Nouvelle permission : module 'OCCHAB', objet 'ALL', action 'C'
Nouvelle permission : module 'OCCTAX', objet 'ALL', action 'R'
Nouvelle permission : module 'OCCTAX', objet 'ALL', action 'D'
Nouvelle permission : module 'OCCHAB', objet 'ALL', action 'U'
Nouvelle permission : module 'OCCTAX', objet 'ALL', action 'C'
Nouvelle permission : module 'OCCTAX', objet 'ALL', action 'E'
Nouvelle permission : module 'OCCHAB', objet 'ALL', action 'R'
Nouvelle permission : module 'OCCHAB', objet 'ALL', action 'D'
Nouvelle permission : module 'OCCTAX', objet 'ALL', action 'U'
Nouvelle permission : module 'VALIDATION', objet 'ALL', action 'C'
Désactivation du virtual env
Installation du frontend GeoNature
Préparation du frontend...
Activation du venv...
Set API_ENDPOINT to //192.168.96.201/geonature/api in frontend configuration file...
Generated configuration files :
{"API_ENDPOINT":"//192.168.96.201/geonature/api"}
Désactivation du venv...
Installation des paquets Npm
Found '/home/gnadmin/geonature/frontend/.nvmrc' with version <lts/iron>
Now using node v20.17.0 (npm v10.8.2)
npm warn deprecated abab@2.0.6: Use your platform's native atob() and btoa() methods instead
npm warn deprecated @npmcli/move-file@2.0.1: This functionality has been moved to @npmcli/fs
npm warn deprecated @babel/plugin-proposal-unicode-property-regex@7.18.6: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-unicode-property-regex instead.
npm warn deprecated @babel/plugin-proposal-optional-chaining@7.21.0: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-optional-chaining instead.
npm warn deprecated @babel/plugin-proposal-private-methods@7.18.6: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-private-methods instead.
npm warn deprecated @babel/plugin-proposal-json-strings@7.18.6: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-json-strings instead.
npm warn deprecated @babel/plugin-proposal-nullish-coalescing-operator@7.18.6: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-nullish-coalescing-operator instead.
npm warn deprecated @babel/plugin-proposal-export-namespace-from@7.18.9: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-export-namespace-from instead.
npm warn deprecated @babel/plugin-proposal-optional-catch-binding@7.18.6: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-optional-catch-binding instead.
npm warn deprecated @babel/plugin-proposal-class-static-block@7.21.0: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-class-static-block instead.
npm warn deprecated @babel/plugin-proposal-dynamic-import@7.18.6: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-dynamic-import instead.
npm warn deprecated @babel/plugin-proposal-numeric-separator@7.18.6: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-numeric-separator instead.
npm warn deprecated @babel/plugin-proposal-private-property-in-object@7.21.11: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-private-property-in-object instead.
npm warn deprecated @babel/plugin-proposal-object-rest-spread@7.20.7: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-object-rest-spread instead.
npm warn deprecated @babel/plugin-proposal-class-properties@7.18.6: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-class-properties instead.
npm warn deprecated @babel/plugin-proposal-logical-assignment-operators@7.20.7: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-logical-assignment-operators instead.
npm warn deprecated @babel/plugin-proposal-async-generator-functions@7.20.7: This proposal has been merged to the ECMAScript standard and thus this plugin is no longer maintained. Please use @babel/plugin-transform-async-generator-functions instead.
npm warn deprecated popper.js@1.16.1: You can find the new Popper v2 at @popperjs/core, this package is dedicated to the legacy v1

added 1043 packages, and audited 1044 packages in 13s

113 packages are looking for funding
  run `npm fund` for details

13 vulnerabilities (6 moderate, 7 high)

To address issues that do not require attention, run:
  npm audit fix

To address all issues (including breaking changes), run:
  npm audit fix --force

Run `npm audit` for details.
Build du frontend...

> geonature@0.0.0 build
> ng build

- Generating browser application bundles (phase: setup)...
- @ngx-translate/core [es2015/esm2015] (git+https://github.com/ngx-translate/core.git)
- @ngx-translate/http-loader [es2015/esm2015] (git+https://github.com/ngx-translate/http-loader.git)
- @circlon/angular-tree-component [es2015/esm2015] (https://github.com/CirclonGroup/angular-tree-component.git)
✔ Browser application bundle generation complete.
✔ Browser application bundle generation complete.
- Copying assets...
✔ Copying assets complete.
- Generating index html...
- Generating index html...
1 rules skipped due to selector errors:
  .custom-file-input:lang(en)~.custom-file-label -> unmatched pseudo-class :lang
✔ Index html generation complete.

Initial Chunk Files           | Names         |  Raw Size | Estimated Transfer Size
main.1894230530750b20.js      | main          |   2.64 MB |               560.15 kB
styles.83669658bb9fbb5e.css   | styles        | 330.79 kB |                40.90 kB
scripts.389cfc411fcb8b0c.js   | scripts       | 248.96 kB |                55.97 kB
polyfills.562b41e73d769e65.js | polyfills     |  67.42 kB |                20.81 kB
runtime.705c3b3942580339.js   | runtime       |   3.10 kB |                 1.50 kB

| Initial Total |   3.28 MB |               679.33 kB

Lazy Chunk Files              | Names         |  Raw Size | Estimated Transfer Size
301.d4e0913d7618cec2.js       | -             | 440.15 kB |                74.26 kB
621.8d5608f6f5faaedc.js       | -             | 215.05 kB |                34.51 kB
metadata.882052998da5c570.js  | metadata      | 132.20 kB |                27.16 kB
649.44205b1ce69de76d.js       | -             | 102.58 kB |                21.79 kB
synthese.19d7f44b8eeb23cb.js  | synthese      |  51.68 kB |                14.11 kB
242.eb0b149ea2a51f6f.js       | -             |  48.42 kB |                10.54 kB
676.597a93e7d23a5f33.js       | -             |  31.51 kB |                 7.95 kB
472.1e52c4187ecb3de4.js       | -             |  11.31 kB |                 3.41 kB
user.2c42e1013f963716.js      | user          |   9.23 kB |                 2.43 kB
common.9f8774f84382ea8c.js    | common        |   3.02 kB |                 1.19 kB
admin.071fa7cfb92f43ac.js     | admin         |   1.59 kB |               790 bytes

Build at: 2024-09-12T14:59:35.710Z - Hash: ac0c531088606752 - Time: 82246ms

Warning: /home/gnadmin/geonature/frontend/external_modules/occhab/app/components/occhab-map-list/occhab-map-list.component.ts depends on 'moment'. CommonJS or AMD dependencies can cause optimization bailouts.
For more info see: https://angular.io/guide/build#configuring-commonjs-dependencies

Warning: /home/gnadmin/geonature/frontend/external_modules/occhab/app/module.config.ts is part of the TypeScript compilation but it's unused.
Add only entry points to the 'files' or 'include' properties in your tsconfig.

Warning: /home/gnadmin/geonature/frontend/external_modules/occtax/app/module.config.ts is part of the TypeScript compilation but it's unused.
Add only entry points to the 'files' or 'include' properties in your tsconfig.

Warning: /home/gnadmin/geonature/frontend/external_modules/validation/app/module.config.ts is part of the TypeScript compilation but it's unused.
Add only entry points to the 'files' or 'include' properties in your tsconfig.

Warning: /home/gnadmin/geonature/frontend/src/app/GN2CommonModule/form/autocomplete/autocomplete.component.ts depends on 'rxjs/observable/of'. CommonJS or AMD dependencies can cause optimization bailouts.
For more info see: https://angular.io/guide/build#configuring-commonjs-dependencies

Warning: /home/gnadmin/geonature/frontend/src/app/GN2CommonModule/form/dynamic-form-generator/dynamic-form-generator.component.ts depends on 'fast-deep-equal/es6'. CommonJS or AMD dependencies can cause optimization bailouts.
For more info see: https://angular.io/guide/build#configuring-commonjs-dependencies

Warning: /home/gnadmin/geonature/frontend/src/app/GN2CommonModule/map/map.service.ts depends on 'leaflet.markercluster'. CommonJS or AMD dependencies can cause optimization bailouts.
For more info see: https://angular.io/guide/build#configuring-commonjs-dependencies

Warning: /home/gnadmin/geonature/frontend/src/app/GN2CommonModule/map/map.service.ts depends on 'lodash'. CommonJS or AMD dependencies can cause optimization bailouts.
For more info see: https://angular.io/guide/build#configuring-commonjs-dependencies

Warning: /home/gnadmin/geonature/frontend/src/app/app.module.ts depends on 'ng2-cookies'. CommonJS or AMD dependencies can cause optimization bailouts.
For more info see: https://angular.io/guide/build#configuring-commonjs-dependencies

Warning: /home/gnadmin/geonature/frontend/src/app/components/home-content/home-content.component.ts depends on 'leaflet'. CommonJS or AMD dependencies can cause optimization bailouts.
For more info see: https://angular.io/guide/build#configuring-commonjs-dependencies

Warning: /home/gnadmin/geonature/frontend/src/app/metadataModule/services/metadata-search-form.service.ts is part of the TypeScript compilation but it's unused.
Add only entry points to the 'files' or 'include' properties in your tsconfig.

Warning: /home/gnadmin/geonature/frontend/src/app/syntheseModule/services/form.service.ts is part of the TypeScript compilation but it's unused.
Add only entry points to the 'files' or 'include' properties in your tsconfig.

Warning: /home/gnadmin/geonature/frontend/src/app/syntheseModule/synthese-results/synthese-list/synthese-info-obs/modal-info-obs.component.ts is part of the TypeScript compilation but it's unused.
Add only entry points to the 'files' or 'include' properties in your tsconfig.

Warning: /home/gnadmin/geonature/frontend/src/app/syntheseModule/synthese.component.ts depends on 'lodash/cloneDeep'. CommonJS or AMD dependencies can cause optimization bailouts.
For more info see: https://angular.io/guide/build#configuring-commonjs-dependencies

Installation de la config Apache pour GeoNature
Configuration Apache
[sudo] Mot de passe de gnadmin :
# Alias: first have precedence, so static & media aliases must be defined before /geonature alias

Alias "/geonature/api/media" "/home/gnadmin/geonature/backend/media"
<Directory "/home/gnadmin/geonature/backend/media">
    Require all granted
    AllowOverride None
    Options -Indexes
</Directory>

Alias "/geonature/api/static" "/home/gnadmin/geonature/backend/static"
<Directory "/home/gnadmin/geonature/backend/static">
    Require all granted
    AllowOverride None
    Options -Indexes
</Directory>

# CUSTOM STATIC FILE
RewriteEngine On
# Define STATIC_FILE environment variable
RewriteRule "^/geonature/api/static/(.*)$" - [env=STATIC_FILE:$1,chain]
# Test if custom static file exists (not tested for non static file thanks to previous chain flag)
RewriteCond "/home/gnadmin/geonature/custom/%{ENV:STATIC_FILE}" -f
# If so, redirect to custom static file instead of default static file
RewriteRule "^/geonature/api/static/(.*)$" "/home/gnadmin/geonature/custom/$1" [L]
<Directory "/home/gnadmin/geonature/custom">
    Require all granted
    AllowOverride None
    Options -Indexes
</Directory>

AliasMatch "^/geonature(.*)$" "/home/gnadmin/geonature/frontend/dist$1"
<Directory "/home/gnadmin/geonature/frontend/dist">
    Require all granted
</Directory>

<Location "/geonature/api">
    ProxyPass http://127.0.0.1:8000/geonature/api
    ProxyPassReverse http://127.0.0.1:8000/geonature/api
    <IfModule mod_deflate.c>
        AddOutputFilterByType DEFLATE application/json
        AddOutputFilterByType DEFLATE application/geo+json
    </IfModule>
</Location>

# Location: last have precedence so next blocks must be located after /geonature/api location block
<Location "/geonature/api/media">
    ProxyPass !
</Location>
<Location "/geonature/api/static">
    ProxyPass !
</Location>
Module rewrite already enabled
Module proxy already enabled
Considering dependency proxy for proxy_http:
Module proxy already enabled
Module proxy_http already enabled
Considering dependency filter for deflate:
Module filter already enabled
Module deflate already enabled

Téléchargement et installation de TaxHub ...

Installation de l'application Usershub

L'installation est terminée!
camillemonchicourt commented 1 week ago

Sans trop de certitude, je pencherai pour un soucis de permissions sur les dossiers du serveur, comme mentionné sur https://github.com/PnX-SI/GeoNature/issues/2852

A vérifier, creuser, préciser, corriger.

jacquesfize commented 1 week ago

Est-il possible d'avoir les logs ? Le fichier se trouve dans /var/log/geonature.

SimonGuilbaud commented 1 week ago

@camillemonchicourt merci pour la piste vers le post que je n'ai pas trouvé dans mes recherches. En en faisant un chmod +x /home/gnadmin Le tour est joué et j'accède bien au module Géonature. Merci beaucoup.

Pour @jacquesfize voici le contenu du log :

[2024-09-13 08:45:24 +0200] [76132] [INFO] Starting gunicorn 22.0.0
[2024-09-13 08:45:24 +0200] [76132] [INFO] Listening at: http://127.0.0.1:8000 (76132)
[2024-09-13 08:45:24 +0200] [76132] [INFO] Using worker: sync
[2024-09-13 08:45:24 +0200] [76142] [INFO] Booting worker with pid: 76142
[2024-09-13 08:45:24 +0200] [76143] [INFO] Booting worker with pid: 76143
[2024-09-13 08:45:24 +0200] [76161] [INFO] Booting worker with pid: 76161
[2024-09-13 08:45:24 +0200] [76163] [INFO] Booting worker with pid: 76163
[2024-09-13 08:46:10 +0200] [76132] [INFO] Handling signal: hup
[2024-09-13 08:46:10 +0200] [76132] [INFO] Hang up: Master
[2024-09-13 08:46:10 +0200] [76142] [INFO] Worker exiting (pid: 76142)
[2024-09-13 08:46:10 +0200] [77942] [INFO] Booting worker with pid: 77942
[2024-09-13 08:46:10 +0200] [77943] [INFO] Booting worker with pid: 77943
[2024-09-13 08:46:10 +0200] [77944] [INFO] Booting worker with pid: 77944
[2024-09-13 08:46:10 +0200] [77945] [INFO] Booting worker with pid: 77945
[2024-09-13 08:46:10 +0200] [76143] [INFO] Worker exiting (pid: 76143)
[2024-09-13 08:46:10 +0200] [76161] [INFO] Worker exiting (pid: 76161)
[2024-09-13 08:46:10 +0200] [76163] [INFO] Worker exiting (pid: 76163)
[2024-09-13 08:46:10 +0200] [76132] [ERROR] Worker (pid:76163) was sent SIGTERM!
[2024-09-13 08:46:10 +0200] [76132] [ERROR] Worker (pid:76161) was sent SIGTERM!
[2024-09-13 08:46:10 +0200] [76132] [ERROR] Worker (pid:76143) was sent SIGTERM!
[2024-09-13 08:46:10 +0200] [76132] [ERROR] Worker (pid:76142) was sent SIGTERM!

J'ai tout de même une dernière question innocente : Je cherche à me connecter à la bd postgresql de Geonature nouvellement créé depuis PGAdmin mais je n'y arrive pas. Voici les paramètres que je renseigne juste :

Est-ce qu'il est possible de me connecter via PGAdmin et ai-je commis des erreurs de paramétrages ? Merci d'avance pour ce dernier coup de pouce.

jacquesfize commented 1 week ago

Si la base de données est sur la machine sur laquelle est exécuté pgadmin, alors l'adresse doit être 127.0.0.1 (ou "localhost")

camillemonchicourt commented 1 week ago

OK donc pour les permissions des dossiers sur le serveur, faudrait vraiment éclaircir ça car on n'avait pas ça avant. C'est peut-être un changement de sécurité au niveau de debian ou autre, mais ça serait bien de la clarifier pour que d'autres n'aient pas le même soucis.

Pour l'accès à la BDD si tu veux y accéder depuis une autre IP, ce n'est pas un sujet lié à GeoNature mais un sujet normal de PostgreSQL qui ne donne pas accès par défaut depuis l'extérieur, donc depuis une autre adresse IP, pour des raisons de sécurité. J'avais fait une petite doc sur le sujet, à voir si c'est toujours à jour : https://github.com/PnX-SI/Ressources-techniques/blob/master/PostgreSQL/acces-bdd.rst