mvergez
commented
1 year ago Bonjour,
J'ai l'impression que ça vient de SQLALCHEMY_DATABASE_URI qui est le paramètre de l'url de la base de données. Il faut le configurer dans /home/geonatureadmin/geonature/config/geonature_config.toml et doit avoir cette forme :
SQLALCHEMY_DATABASE_URI = "postgresql://user_pg:pass_pg@localhost:5432/geonature2db"Il faut remplacer user_pg, pass_pg, localhost:5432 par respectivement l'utilisateur en base de données (geonatadmin par défaut), le mot de passe de cet utilisateur et l'adresse vers la base de donnée et le port.
Peut-être avez vous entré une IP V6 pour l'adresse IP de la base de données ?
camillemonchicourt
rastaferraille
SamyM71
Version 2.12.3
Description du bug Le script se termine par : ValueError: Invalid IPv6 URL
Version OS
Debian 11.7 fraîchement installée.
Voici le log plus détaillé :
NFO [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] Downloading 'BDALTIV2_2-0_250M_ASC_LAMB93-IGN69_FRANCE_2017-06-21.zip'… Traceback (most recent call last): File "/home/geonatureadmin/geonature/backend/venv/bin/geonature", line 8, in
sys.exit(main())
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/click/core.py", line 1130, in call
return self.main(args, kwargs)
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/click/core.py", line 1055, in main
rv = self.invoke(ctx)
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/click/core.py", line 1657, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/click/core.py", line 1657, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/click/core.py", line 1404, in invoke
return ctx.invoke(self.callback, ctx.params)
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/click/core.py", line 760, in invoke
return __callback(args, kwargs)
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/click/decorators.py", line 26, in new_func
return f(get_current_context(), *args, *kwargs)
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/flask/cli.py", line 357, in decorator
return __ctx.invoke(f, args, kwargs)
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/click/core.py", line 760, in invoke
return callback(*args, **kwargs)
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/flask_migrate/cli.py", line 149, in upgrade
_upgrade(directory, revision, sql, tag, x_arg)
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/flask_migrate/init__.py", line 98, in wrapped
f(*args, kwargs)
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/flask_migrate/init.py", line 185, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/alembic/command.py", line 322, in upgrade
script.run_env()
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/alembic/script/base.py", line 569, in run_env
util.load_python_file(self.dir, "env.py")
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
module = load_module_py(module_id, path)
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
spec.loader.exec_module(module) # type: ignore
File "", line 790, in exec_module
File "", line 228, in _call_with_frames_removed
File "/home/geonatureadmin/geonature/backend/geonature/migrations/env.py", line 88, in
run_migrations_online()
File "/home/geonatureadmin/geonature/backend/geonature/migrations/env.py", line 82, in run_migrations_online
context.run_migrations()
File "", line 8, in run_migrations
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/alembic/runtime/environment.py", line 853, in run_migrations
self.get_context().run_migrations( kw)
File "/home/geonatureadmin/geonature/backend/venv/lib/python3.9/site-packages/alembic/runtime/migration.py", line 623, in run_migrations
step.migration_fn(**kw)
File "/home/geonatureadmin/geonature/backend/geonature/migrations/versions/1715cf31a75d_insert_ign_250m_bd_alti_in_dem.py", line 40, in upgrade
db_uri = urlsplit(config["SQLALCHEMY_DATABASE_URI"])
File "/usr/lib/python3.9/urllib/parse.py", line 476, in urlsplit
raise ValueError("Invalid IPv6 URL")
ValueError: Invalid IPv6 URL