×
The 2025 Client Survey is now open! Responses will be accepted up until 10/31. Please feel free to share this link within your organization and we thank you in advance for your participation!

Configuration Error Detected at LabKey Server Startup

Installation Forum (Inactive)
Configuration Error Detected at LabKey Server Startup MP  2018-05-17 15:02
Status: Closed
 

Hi,

I am trying to manually install Labkey Server 18.1 on my computer (running a non-english version of Windows 7, 64-bit) on Chrome. I'm using tomcat (8.5.31) and postgres (9.5.13).

When I'm trying to run localhost:8080/labkey I get a following error:
Configuration Error Detected at LabKey Server Startup
DataSources are not properly configured in labkey.xml

Attached are labkey.xml and tomcat log.

Thank you for your support

Matt

 
 
Jon (LabKey DevOps) responded:  2018-05-18 15:26
Hi Matt,

According to your log file, it states that it can't connect to the PostgreSQL server address:

Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:247)
    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
    at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
    at org.postgresql.Driver.makeConnection(Driver.java:452)
    at org.postgresql.Driver.connect(Driver.java:254)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:247)
    at org.labkey.api.data.DbScope.ensureDataBase(DbScope.java:1134)
    ... 20 more

Please make sure that your firewall allows connections to port 5432 and also make sure your hb_pga.conf file is configured to accept connections, then restart the PostgreSQL service. This is a pretty handy guide that goes over how to configure PostgreSQL to allow remote connections that should help as well:

https://community.jaspersoft.com/blog/configure-postgresql-remote-connections

Regards,

Jon