OHDSI / WebAPI

OHDSI WebAPI contains all OHDSI services that can be called from OHDSI applications
Apache License 2.0
126 stars 156 forks source link

Could not register a new server during PostgreSQL Setup Process. #2307

Open AlexZhengLiu opened 9 months ago

AlexZhengLiu commented 9 months ago

Expected behavior

I tried to follow the PostgreSQL Setup Guide, using PgAdmin4. It should create a new server, because my port is the same as 5432, and other groups are created good.

Actual behavior

It always generate a problem like: "Unable to connect to server: connection failed: ⍰⍰⍰⍰⍰:⍰⍰⍰⍰⍰|ohdsi_admin_user⍰⍰⍰" I tried to restart the service, change my port from 5432 to 5433, use my own IP instead of localhost, none of them works. Could you help provide a better solution for that? Awesome thanks!

Server_Q3 Server_Q4
ww166 commented 9 months ago

You should check something like this:

  1. Is your postgresql server working. is the postgres progress exist and test it with psql or other database tools to connecting.
  2. Is the user or the target database exist.
  3. Is the password correct.
  4. Do you have some firewall or sth block your connection