Struggling to launch with npx nx database:reset twenty-server
Seems like I'm getting an issue with a password authentication in when I execute this command.
25 Replies
@spleenatsteam I had the same issue before. If you're just testing, you can try changing 'peer' to 'trust' in your PostgreSQL config usually in
/etc/postgresql/16/main/pg_hba.conf . However, keep in mind that this setting allows local connections (from the same machine) without a password, which is generally safe but not ideal for production environments.I can't seem to find that file, where can I find this?
which version of postgres are you using?
@spleenatsteam
Uh, 14 I think? It seemed to install that version
In that case it should be
/etc/postgresql/14/main/pg_hba.conf
Replace the number with your version of postgresWould it be under the twenty directory?
No
It depends on your postgres installation
Try
sudo nano /etc/postgresql/14/main/pg_hba.confoh shit that did something
Yes that's the one
Go to the bottom and do this
You can use your preferred text editor if you're not familiar with nano
This is the first time I've seen nano haha
What do you use then?
I see this right now, there's a few peers
Try changing all of them to trust
Including the scram-sha-256
Save and then restart postgres
Alright let me try to do that again
I seem to still get issues with running this command: npx nx database:reset twenty-server
Did you changed all the method to trust?
And restart pg?
I did change all to trust, I think I restarted PG, not sure though?
I got something new however,
Got it!!
@r
Glad it worked!!
hey guys i am using this via docker so is there a solution for that?
nvm i think it works now, i had done something wrong just had to clear the docker volume