<@ULVA73B9P> i updated my database password and ch...
# ask-community
i
@Marvin i updated my database password and change the setttings
prefect config set PREFECT_API_DATABASE_CONNECTION_URL=...
. However, i am still seeing the flow runs running into password authentication error
m
It seems like you're experiencing a password authentication error with your Prefect database connection after updating your settings. Here are a few things to consider: 1. Correct Environment Variable: Make sure you are setting the correct environment variable. Prefect uses
PREFECT_API_DATABASE_CONNECTION_URL
for database connections, which should be correctly formatted with an async driver. For example, for PostgreSQL, it should look something like
<postgresql+asyncpg://username:password@hostname:port/database>
. 2. Check for Async Driver: Ensure that your connection URL uses an async driver. For PostgreSQL, it should be
postgresql+asyncpg
. Refer to the Prefect settings documentation for more details. 3. Restart Services: After updating the environment variable, make sure to restart any services or processes that depend on these settings to ensure they pick up the new configuration. 4. Logs for Debugging: Check the logs for any additional error messages that might give more insight into the authentication issue. 5. Version Compatibility: Ensure you are running a compatible version of Prefect. Sometimes, issues arise from version mismatches, so updating to the latest version might help. If these steps do not resolve the issue, consider checking the Prefect GitHub issues for any related problems or reaching out to their support. Here are a couple of related GitHub issues that might provide additional context or solutions: - Prefect UI not working with Server API Auth - Add Token Auth to Prefect Server If you need further assistance, feel free to ask!