I have been racking my brain on these forums for the past day and I am a little stuck.
I have installed Discourse from the main install instructions on Digital Ocean. I have Discourse installed via Docker. I installed NGINX and Wordpress and PHP and MySQL all on a single VPS.
I have been able to get everything running so far, Wordpress and Discourse. I am now attempting to connect phppgadmin to the local PostgreSQL database to view and administer databases. I have gotten so far as to get phppgadmin installed, but I am lost when it comes to getting it connected. Currently it lets me see the Database, but it prompts for a username and password and none of the ones I am using work.
I have attempted to connect to the psql instance via command line, but I have not be able to successfully connect to great a password for the postgres user. I get this error message:
root@server:/var/discourse# psql -h 127.0.0.1 -U postgres -d discourse
Password for user postgres:
psql: FATAL: password authentication failed for user "postgres"
FATAL: password authentication failed for user “postgres”
I have passed the 5432 port through the app.yml.
I have also granted the following access in the pg_hba.conf file:
# TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust host all all 127.0.0.1/32 trust host all all 172.17.42.1/32 trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust # Allow replication connections from localhost, by a user with the # replication privilege. #local replication postgres trust #host replication postgres 127.0.0.1/32 trust #host replication postgres ::1/128 trust
I cant seem to login and I have no idea where any file would be that I need to modify to allow me to login to the psql instance. Any help to allow a username\password to authenticate against the database would be greatly appreciated.