rag-api wont work

[Hackerdude374]

What happened?

the rag-api wont work, cant attach files

Steps to Reproduce

What browsers are you seeing the problem on?

No response

Relevant log output

/base.py", line 3303, in raw_connection
2024-09-25 22:04:20 rag_api           |     return self.pool.connect()
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 449, in connect
2024-09-25 22:04:20 rag_api           |     return _ConnectionFairy._checkout(self)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1263, in _checkout
2024-09-25 22:04:20 rag_api           |     fairy = _ConnectionRecord.checkout(pool)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 712, in checkout
2024-09-25 22:04:20 rag_api           |     rec = pool._do_get()
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 179, in _do_get
2024-09-25 22:04:20 rag_api           |     with util.safe_reraise():
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
2024-09-25 22:04:20 rag_api           |     raise exc_value.with_traceback(exc_tb)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get
2024-09-25 22:04:20 rag_api           |     return self._create_connection()
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection
2024-09-25 22:04:20 rag_api           |     return _ConnectionRecord(self)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 674, in __init__
2024-09-25 22:04:20 rag_api           |     self.__connect()
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 900, in __connect
2024-09-25 22:04:20 rag_api           |     with util.safe_reraise():
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
2024-09-25 22:04:20 rag_api           |     raise exc_value.with_traceback(exc_tb)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 896, in __connect
2024-09-25 22:04:20 rag_api           |     self.dbapi_connection = connection = pool._invoke_creator(self)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 643, in connect
2024-09-25 22:04:20 rag_api           |     return dialect.connect(*cargs, **cparams)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 616, in connect
2024-09-25 22:04:20 rag_api           |     return self.loaded_dbapi.connect(*cargs, **cparams)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/psycopg2/__init__.py", line 122, in connect
2024-09-25 22:04:20 rag_api           |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
2024-09-25 22:04:20 rag_api           | psycopg2.OperationalError: connection to server at "vectordb" (172.18.0.5), port 5432 failed: FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "myuser", database "mydatabase", no encryption
2024-09-25 22:04:20 rag_api           | 
2024-09-25 22:04:20 rag_api           | 
2024-09-25 22:04:20 rag_api           | The above exception was the direct cause of the following exception:
2024-09-25 22:04:20 rag_api           | 
2024-09-25 22:04:20 rag_api           | Traceback (most recent call last):
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/langchain_community/vectorstores/pgvector.py", line 383, in create_vector_extension
2024-09-25 22:04:20 rag_api           |     session.execute(statement)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2306, in execute
2024-09-25 22:04:20 rag_api           |     return self._execute_internal(
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2181, in _execute_internal
2024-09-25 22:04:20 rag_api           |     conn = self._connection_for_bind(bind)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2050, in _connection_for_bind
2024-09-25 22:04:20 rag_api           |     return trans._connection_for_bind(engine, execution_options)
2024-09-25 22:04:20 rag_api           |   File "<string>", line 2, in _connection_for_bind
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go
2024-09-25 22:04:20 rag_api           |     ret_value = fn(self, *arg, **kw)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1144, in _connection_for_bind
2024-09-25 22:04:20 rag_api           |     conn = bind.connect()
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3279, in connect
2024-09-25 22:04:20 rag_api           |     return self._connection_cls(self)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 147, in __init__
2024-09-25 22:04:20 rag_api           |     Connection._handle_dbapi_exception_noconnection(
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2443, in _handle_dbapi_exception_noconnection
2024-09-25 22:04:20 rag_api           |     raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
2024-09-25 22:04:20 rag_api           |     self._dbapi_connection = engine.raw_connection()
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3303, in raw_connection
2024-09-25 22:04:20 rag_api           |     return self.pool.connect()
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 449, in connect
2024-09-25 22:04:20 rag_api           |     return _ConnectionFairy._checkout(self)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1263, in _checkout
2024-09-25 22:04:20 rag_api           |     fairy = _ConnectionRecord.checkout(pool)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 712, in checkout
2024-09-25 22:04:20 rag_api           |     rec = pool._do_get()
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 179, in _do_get
2024-09-25 22:04:20 rag_api           |     with util.safe_reraise():
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
2024-09-25 22:04:20 rag_api           |     raise exc_value.with_traceback(exc_tb)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get
2024-09-25 22:04:20 rag_api           |     return self._create_connection()
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection
2024-09-25 22:04:20 rag_api           |     return _ConnectionRecord(self)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 674, in __init__
2024-09-25 22:04:20 rag_api           |     self.__connect()
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 900, in __connect
2024-09-25 22:04:20 rag_api           |     with util.safe_reraise():
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
2024-09-25 22:04:20 rag_api           |     raise exc_value.with_traceback(exc_tb)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 896, in __connect
2024-09-25 22:04:20 rag_api           |     self.dbapi_connection = connection = pool._invoke_creator(self)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 643, in connect
2024-09-25 22:04:20 rag_api           |     return dialect.connect(*cargs, **cparams)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 616, in connect
2024-09-25 22:04:20 rag_api           |     return self.loaded_dbapi.connect(*cargs, **cparams)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/psycopg2/__init__.py", line 122, in connect
2024-09-25 22:04:20 rag_api           |     conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
2024-09-25 22:04:20 rag_api           | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "vectordb" (172.18.0.5), port 5432 failed: FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "myuser", database "mydatabase", no encryption
2024-09-25 22:04:20 rag_api           | 
2024-09-25 22:04:20 rag_api           | (Background on this error at: https://sqlalche.me/e/20/e3q8)
2024-09-25 22:04:20 rag_api           | 
2024-09-25 22:04:20 rag_api           | The above exception was the direct cause of the following exception:
2024-09-25 22:04:20 rag_api           | 
2024-09-25 22:04:20 rag_api           | Traceback (most recent call last):
2024-09-25 22:04:20 rag_api           |   File "/app/main.py", line 46, in <module>
2024-09-25 22:04:20 rag_api           |     from psql import PSQLDatabase, ensure_custom_id_index_on_embedding, pg_health_check
2024-09-25 22:04:20 rag_api           |   File "/app/psql.py", line 3, in <module>
2024-09-25 22:04:20 rag_api           |     from config import DSN, logger
2024-09-25 22:04:20 rag_api           |   File "/app/config.py", line 232, in <module>
2024-09-25 22:04:20 rag_api           |     vector_store = get_vector_store(
2024-09-25 22:04:20 rag_api           |   File "/app/store_factory.py", line 20, in get_vector_store
2024-09-25 22:04:20 rag_api           |     return AsyncPgVector(
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/langchain_core/_api/deprecation.py", line 183, in warn_if_direct_instance
2024-09-25 22:04:20 rag_api           |     return wrapped(self, *args, **kwargs)
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/langchain_community/vectorstores/pgvector.py", line 341, in __init__
2024-09-25 22:04:20 rag_api           |     self.__post_init__()
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/langchain_community/vectorstores/pgvector.py", line 348, in __post_init__
2024-09-25 22:04:20 rag_api           |     self.create_vector_extension()
2024-09-25 22:04:20 rag_api           |   File "/usr/local/lib/python3.10/site-packages/langchain_community/vectorstores/pgvector.py", line 386, in create_vector_extension
2024-09-25 22:04:20 rag_api           |     raise Exception(f"Failed to create vector extension: {e}") from e
2024-09-25 22:04:20 rag_api           | Exception: Failed to create vector extension: (psycopg2.OperationalError) connection to server at "vectordb" (172.18.0.5), port 5432 failed: FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "myuser", database "mydatabase", no encryption
2024-09-25 22:04:20 rag_api           | 
2024-09-25 22:04:20 rag_api           | (Background on this error at: https://sqlalche.me/e/20/e3q8)
2033-01-01 00:00:00 
rag_api exited with code 1

Screenshots

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

[danny-avila]

Check the ports and configuration.

More on this specific error:
https://stackoverflow.com/questions/10693978/psycopg2-reporting-pg-hba-conf-error

Configuration guide:
https://www.librechat.ai/docs/configuration/rag_api

[madrover]

Following docker-library/postgres#482, I fixed this issue by removing the librechat_pgdata2 volume.
I didn't care about it because it was a brand new installation.

@danny-avila , what's the impact of removing the Docker volume where the vectordb data is stored? How come this is a local volume as opposed to a bind mount as the other volumes?

Thanks!