How to Connect PG by SQL Chain?[solved]

[dxforceiwei]

I've designed an SQL chain to connect to Postgres, and I'm certain that it can establish a connection. However, when Chat responds with 'Error: getaddrinfo ENOTFOUND base,' it seems like it hasn't even connected to PG.
How should I troubleshoot this? Any guidance?

[dxforceiwei]

Is it because the .env file hasn't been set up?

PORT=3000
# DATABASE_PATH=/your_database_path/.flowise
# APIKEY_PATH=/your_api_key_path/.flowise
# SECRETKEY_PATH=/your_api_key_path/.flowise
# LOG_PATH=/your_log_path/.flowise/logs

# NUMBER_OF_PROXIES= 1

DATABASE_TYPE=postgres
DATABASE_PORT="5432"
DATABASE_HOST="172.22.1.71"
DATABASE_NAME="XXXX"
DATABASE_USER="XXXXX"
DATABASE_PASSWORD="XXXXX"

# FLOWISE_USERNAME=user
# FLOWISE_PASSWORD=1234
# FLOWISE_SECRETKEY_OVERWRITE=myencryptionkey
# DEBUG=true
# LOG_LEVEL=debug (error | warn | info | verbose | debug)
# TOOL_FUNCTION_BUILTIN_DEP=crypto,fs
# TOOL_FUNCTION_EXTERNAL_DEP=moment,lodash

# LANGCHAIN_TRACING_V2=true
# LANGCHAIN_ENDPOINT=https://api.smith.langchain.com
# LANGCHAIN_API_KEY=your_api_key
# LANGCHAIN_PROJECT=your_project

If that's the case, where should the schema be configured?