Reset DB Password

aeu1 · June 22, 2020, 7:48am

Hi,

I installed Rasa X on my VM, and it was working fine, but then I made a mistake I managed somehow to lose my .env file, and all the passwords in it changed. Now when I try sudo docker-compose up I get the error here :

rasa-x_1           | Traceback (most recent call last):
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2345, in _wrap_pool_connect
rasa-x_1           |     return fn()
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
rasa-x_1           |     return _ConnectionFairy._checkout(self)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
rasa-x_1           |     fairy = _ConnectionRecord.checkout(pool)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rasa-x_1           |     rec = pool._do_get()
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
rasa-x_1           |     self._dec_overflow()
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 69, in __exit__
rasa-x_1           |     exc_value, with_traceback=exc_tb,
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
rasa-x_1           |     raise exception
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
rasa-x_1           |     return self._create_connection()
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
rasa-x_1           |     return _ConnectionRecord(self)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
rasa-x_1           |     self.__connect(first_connect_check=True)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
rasa-x_1           |     pool.logger.debug("Error on connect(): %s", e)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 69, in __exit__
rasa-x_1           |     exc_value, with_traceback=exc_tb,
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
rasa-x_1           |     raise exception
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
rasa-x_1           |     connection = pool._invoke_creator(self)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
rasa-x_1           |     return dialect.connect(*cargs, **cparams)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 490, in connect
rasa-x_1           |     return self.dbapi.connect(*cargs, **cparams)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/psycopg2/__init__.py", line 127, in connect
rasa-x_1           |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
rasa-x_1           | psycopg2.OperationalError: FATAL:  password authentication failed for user "admin"
rasa-x_1           |
rasa-x_1           |
rasa-x_1           | The above exception was the direct cause of the following exception:
rasa-x_1           |
rasa-x_1           | Traceback (most recent call last):
rasa-x_1           |   File "/usr/local/lib/python3.7/runpy.py", line 193, in _run_module_as_main
rasa-x_1           |     "__main__", mod_spec)
rasa-x_1           |   File "/usr/local/lib/python3.7/runpy.py", line 85, in _run_code
rasa-x_1           |     exec(code, run_globals)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/rasax/community/__main__.py", line 19, in <module>
rasa-x_1           |     main()
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/rasax/community/server.py", line 29, in main
rasa-x_1           |     sql_migrations.run_migrations(session)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/rasax/community/sql_migrations.py", line 25, in run_migrations
rasa-x_1           |     _run_schema_migrations(session)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/rasax/community/sql_migrations.py", line 41, in _run_schema_migrations
rasa-x_1           |     _run_alembic_migration(alembic_config)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/rasax/community/sql_migrations.py", line 65, in _run_alembic_migration
rasa-x_1           |     command.upgrade(alembic_config, target_revision)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/alembic/command.py", line 298, in upgrade
rasa-x_1           |     script.run_env()
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/alembic/script/base.py", line 489, in run_env
rasa-x_1           |     util.load_python_file(self.dir, "env.py")
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 98, in load_python_file
rasa-x_1           |     module = load_module_py(module_id, path)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/alembic/util/compat.py", line 184, in load_module_py
rasa-x_1           |     spec.loader.exec_module(module)
rasa-x_1           |   File "<frozen importlib._bootstrap_external>", line 728, in exec_module
rasa-x_1           |   File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/rasax/community/database/schema_migrations/alembic/env.py", line 96, in <module>
rasa-x_1           |     run_migrations_online()
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/rasax/community/database/schema_migrations/alembic/env.py", line 68, in run_migrations_online
rasa-x_1           |     with connectable.connect() as connection:
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2272, in connect
rasa-x_1           |     return self._connection_cls(self, **kwargs)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 104, in __init__
rasa-x_1           |     else engine.raw_connection()
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2379, in raw_connection
rasa-x_1           |     self.pool.unique_connection, _connection
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2349, in _wrap_pool_connect
rasa-x_1           |     e, dialect, self
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1591, in _handle_dbapi_exception_noconnection
rasa-x_1           |     sqlalchemy_exception, with_traceback=exc_info[2], from_=e
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
rasa-x_1           |     raise exception
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2345, in _wrap_pool_connect
rasa-x_1           |     return fn()
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
rasa-x_1           |     return _ConnectionFairy._checkout(self)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
rasa-x_1           |     fairy = _ConnectionRecord.checkout(pool)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rasa-x_1           |     rec = pool._do_get()
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
rasa-x_1           |     self._dec_overflow()
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 69, in __exit__
rasa-x_1           |     exc_value, with_traceback=exc_tb,
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
rasa-x_1           |     raise exception
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
rasa-x_1           |     return self._create_connection()
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
rasa-x_1           |     return _ConnectionRecord(self)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
rasa-x_1           |     self.__connect(first_connect_check=True)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
rasa-x_1           |     pool.logger.debug("Error on connect(): %s", e)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 69, in __exit__
rasa-x_1           |     exc_value, with_traceback=exc_tb,
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
rasa-x_1           |     raise exception
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
rasa-x_1           |     connection = pool._invoke_creator(self)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
rasa-x_1           |     return dialect.connect(*cargs, **cparams)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 490, in connect
rasa-x_1           |     return self.dbapi.connect(*cargs, **cparams)
rasa-x_1           |   File "/usr/local/lib/python3.7/site-packages/psycopg2/__init__.py", line 127, in connect
rasa-x_1           |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
rasa-x_1           | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL:  password authentication failed for user "admin"

I tried to reinstall Rasa X by removing the docker images and recreating them, but the DB password is still the old one. How can I fix this issue ? Is there a way to reset the password ?

Thanks for your help.

aeu1 · June 22, 2020, 10:07am

For now I managed to get Rasa X running by changing the volume of db in the docker-compose.yml like this :

db:
restart: always
image: "bitnami/postgresql:11.7.0"
expose:
  - "5432"
environment:
  POSTGRESQL_USERNAME: "${DB_USER:-admin}"
  POSTGRESQL_PASSWORD: "${DB_PASSWORD}"
  POSTGRESQL_DATABASE: "${DB_DATABASE:-rasa}"
volumes:
  - ./db:/bitnami/postgresql2

This is not the optimal solution but it is working for now. If you have a better solution for me, I’d be happy to hear about it !

akelad · June 23, 2020, 11:01am

Hi @aeu1 I would suggest removing the installation folder completely, and running the docker-compose install script again. That would be the cleanest way

aeu1 · June 23, 2020, 2:07pm

Yes that, for sure, is a solution

Thanks for your reply !

Topic		Replies	Views
My .env file is throwing error in docker compose [Deprecated] Rasa X Community Edition	13	837	February 2, 2022
Docker-compose db connection error <password authentication failed for user "admin"> [Deprecated] Rasa X Community Edition	0	1678	May 8, 2022
Intallation Errors [Deprecated] Rasa X Community Edition	2	748	June 21, 2019
Error response from daemon: Container [Deprecated] Rasa X Community Edition	1	1689	July 23, 2019
I cant login to rasa x [Deprecated] Rasa X Community Edition	13	1823	August 4, 2020

Reset DB Password

Related Topics