Services setup issues during installation

GabomaGeek · 7 March 2022 15:04

I follow this documentation Quick start - Turn-key research data management repository, and i executed invenio-cli install and all went right. When i run invenio-cli services setup, I have this

Traceback (most recent call last):
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
    return fn()
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 364, in connect
    return _ConnectionFairy._checkout(self)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
    rec = pool._do_get()
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
    self._dec_overflow()
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.raise_(
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
    return self._create_connection()
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
    return _ConnectionRecord(self)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
    self.__connect(first_connect_check=True)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
    pool.logger.debug("Error on connect(): %s", e)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.raise_(
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
    connection = pool._invoke_creator(self)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
    return dialect.connect(*cargs, **cparams)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 508, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:  password authentication failed for user "test"
connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:  password authentication failed for user "test"


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/bin/invenio", line 8, in <module>
    sys.exit(cli())
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/click/core.py", line 829, in __call__
    return self.main(*args, **kwargs)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/flask/cli.py", line 586, in main
    return super(FlaskGroup, self).main(*args, **kwargs)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/click/core.py", line 782, in main
    rv = self.invoke(ctx)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/click/core.py", line 1289, in invoke
    rv.append(sub_ctx.command.invoke(sub_ctx))
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/click/core.py", line 1066, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/click/core.py", line 610, in invoke
    return callback(*args, **kwargs)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/click/decorators.py", line 21, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/flask/cli.py", line 426, in decorator
    return __ctx.invoke(f, *args, **kwargs)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/click/core.py", line 610, in invoke
    return callback(*args, **kwargs)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/invenio_db/cli.py", line 86, in init
    if not database_exists(database_url):
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy_utils/functions/database.py", line 484, in database_exists
    return bool(get_scalar_result(engine, text))
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy_utils/functions/database.py", line 458, in get_scalar_result
    result_proxy = engine.execute(sql)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2234, in execute
    connection = self._contextual_connect(close_with_result=True)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2302, in _contextual_connect
    self._wrap_pool_connect(self.pool.connect, None),
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
    Connection._handle_dbapi_exception_noconnection(
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1583, in _handle_dbapi_exception_noconnection
    util.raise_(
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
    return fn()
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 364, in connect
    return _ConnectionFairy._checkout(self)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
    rec = pool._do_get()
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
    self._dec_overflow()
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.raise_(
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
    return self._create_connection()
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
    return _ConnectionRecord(self)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
    self.__connect(first_connect_check=True)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
    pool.logger.debug("Error on connect(): %s", e)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.raise_(
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
    connection = pool._invoke_creator(self)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
    return dialect.connect(*cargs, **cparams)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 508, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/home/francky/.local/share/virtualenvs/test-FbZuhZEr/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:  password authentication failed for user "test"
connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:  password authentication failed for user "test"

(Background on this error at: http://sqlalche.me/e/13/e3q8)
Failed to setup services.

I don’t know if i have to create a database and/or a user or edit a file to solve this.
I follow this link http://sqlalche.me/e/13/e3q8 but i don’t really understand what to do.

i don’t really speak English so, sorry for this.
Can someone help me?

Thanks

nitarocc · 7 March 2022 15:46

Most probably, you have some other docker services running… Invenio is trying to connect to Postgres, but is actually another database already running. You need to stop everything and try again.

Try to search with any search engine how to see running Docker containers (docker ps) and how to stop all of them (docker kill $(docker ps -q)).

See also: How to Stop All Docker Containers | TypeOfNaN

GabomaGeek · 7 March 2022 16:48

Thanks. Another postgresql instance was running i stopped it and now it’s fine.

alanindicia · 26 October 2024 10:58

I get this precise problem. I have followed the advice from nitarocc to kill all running Docker containers with `docker kill $docker ps -q) but the error persists. I don’t know if you are still around or if there is someone at Invenio can help me with this.

nitarocc · 30 October 2024 08:03

Hello,
the issue is most probably the same. I would search on the Internet how to find if you have multiple instances running in your computer.
Please join the Discord chat for more help: Getting help - Turn-key research data management repository

alanindicia · 4 November 2024 12:37

Thanks for your reply. It’s definitely not another instance, I’ve checked.