search

twentyhq / twenty

Building a modern alternative to Salesforce, powered by the community.
https://twenty.com
Other
23.8k stars 2.46k forks source link

Incorrect Database Connection String in .env File #8741

Open Lucifer4255 opened 6 days ago

Lucifer4255 commented 6 days ago

The default database connection string provided in the .env file for the twenty repository appears to be incorrect. Specifically, the connection string causes authentication failures when attempting to connect to PostgreSQL.

Steps to Reproduce: Clone the repository and set up the environment using the provided .env file. Run the application or attempt a database connection. Observe authentication failure due to an incorrect connection string format or credentials. Image Image

Expected Behavior: The application should connect successfully to the PostgreSQL database using the provided .env configuration.

Suggested Fix: Verify and update the default connection string in the .env file to ensure it follows the correct format: postgres://<username>:<password>@<host>:<port>/<database>

if possible i can work in this issue

FelixMalfait commented 5 days ago

Good point, it's because docker's default is postgres:twenty (we use the Postgres super user), but the local setup (brew, wsl, etc.) defaults to using postgres:postgres ; we should probably just use postgres:postgres everywhere remove drop the instrusctions in the doc to create a twenty user (since it's a local setup anyway)

Lucifer4255 commented 5 days ago

Well can i edit the documentation then?

BOHEUS commented 4 days ago

@Lucifer4255 go ahead, I'll review it