Configuring PGAdmin4 to access the labkey database

LabKey Support Forum
Configuring PGAdmin4 to access the labkey database timcooper  2022-02-15 00:58
Status: Closed
 

I'm attempting to add my local LabKey server to PGAdmin4. The server is running and accessible at:

http://localhost:8080/labkey

I followed the setup detailed here:

https://www.labkey.org/Documentation/wiki-page.view?name=installComponents

However, I am receiving an error:

Unable to connect to server: connection to server at "localhost" (127.0.0.1), port 8080 failed: expected authentication requrest from server, but received H

My PGAdmin settings are as follows:

Host name/address: localhost
Port: 8080
Maintenance database: labkey
Username: labkey (used to setup tomcat - I've also tried the username I initially created when first accessing the labkey server at http://localhost:8080/labkey)
Password: the database password associated with 'labkey'

What am I doing wrong?

Thanks!

 
 
Jon (LabKey DevOps) responded:  2022-02-15 14:15
Hi Tim,

Port 8080 is reserved for Tomcat web server operations to allow your browser to connect to the site. It isn't meant to be used for your database connection.

To connect to your database, you would need to use a different port that is designated for PostgreSQL. By default, PostgreSQL server uses port 5432 (see https://www.enterprisedb.com/postgres-tutorials/connecting-postgresql-using-psql-and-pgadmin for more details).

Just like our XML example here shows how your LabKey server connects to a PostgreSQL database (https://www.labkey.org/Documentation/wiki-page.view?name=cpasxml#db), for your PGAdmin utility (or using the psql command-line tool) to connect to PostgreSQL, you would need to use that same database port as well.

Regards,

Jon