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