Hi Jaiganesh,

If I'm reading your screenshot correctly, it looks like you're viewing the labkey.xml file within the unzipped directory ./LabKey19.1.1-63156.2-community-bin

However, within the XML file, you have a docBase of /usr/local/labkey/labkey/labkeywebapp

This leads me to believe that your actual LabKey installation is under /usr/local/labkey/labkey, which is ideal.

However, because you're running that vim command under LabKey19.1.1-63156.2-community-bin, that leads me to believe that you either didn't place that labkey.xml file in the appropriate Tomcat directory or you're just accessing the wrong one.

If you can access the location where you've stored Tomcat, you should see the following folder structure under it:

CATALINA_HOME/conf/Catalina/localhost

So for example, if you installed Tomcat under /usr/local/tomcat, then the path you're seeking would be:

/usr/local/tomcat/conf/Catalina/localhost

(See https://www.labkey.org/Documentation/wiki-page.view?name=installComponents#tom for more details on the Tomcat installation)

Inside of this localhost directory is where that labkey.xml file should be residing.

If you don't have a labkey.xml file in there, move the copy you showed us in your screenshot over into that location. If you do have one there, make sure that the permissions are set appropriate for the same user account that is running the Tomcat process and that it is configured properly within it, looking like your screenshot.

(See https://www.labkey.org/Documentation/wiki-page.view?name=configTomcat#4 for more details on the labkey.xml file and the location).

Regards,

Jon

Hi Jon ,

  Thanks for the advice !! We have placed the labkey.xml in the path tomcat path and look as attached . But still I am unable to view labkey page

We are installed tomcat using and root is the owner of labkey.xml file

Regards
Jaiganesh M

Hi Jaiganesh,

I noticed your screenshot looks different than the other one for the PostgreSQL address URL.

In your first screenshot, you have:

url="jdbc:postgresql://localhost:5432/labkey"

But in your other one, you have:

url="jdbc:postgresql://localhost/labkey"

Did you change it and remove the port number? If so, what was the reason?

Would it be possible for you to put that port number back?

Regards,

Jon

Hello Jon,

Let me start with some clarity on installation details required.
1. should we start tomcat service under root user? doesnt a security issue.
2. how do we test tomcat with postgres ?

Coming to your feedback, we adapt labkey.xml as below. and tomcat service is restarted many times. as always tomcat doest not connect with postgres DB / labkey application doesnt work.

"url="jdbc:postgresql://localhost:5432/labkey"

Let me share postgres port details.
[postgres@GDCLBKYAP801 ~]$ netstat -tapn | grep -i listen
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp 0 0 0.0.0.0:8080 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:1270 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 1259/postmaster
tcp 0 0 0.0.0.0:8443 0.0.0.0:* LISTEN -
tcp 0 0 127.0.0.1:8005 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:8009 0.0.0.0:* LISTEN -
tcp6 0 0 :::5432 :::* LISTEN 1259/postmaster
[postgres@GDCLBKYAP801 ~]$
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[root@GDCLBKYAP801 ~]# ls -l /usr/local/labkey/apps/apache-tomcat-9.0.22/conf/Catalina/localhost/labkey.xml
-rwxr-xr-x. 1 root root 2120 Aug 21 14:28 /usr/local/labkey/apps/apache-tomcat-9.0.22/conf/Catalina/localhost/labkey.xml
[root@GDCLBKYAP801 ~]#
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Regs
Monie

Hi Monie,

You typically should try to use a non-root user to run the Tomcat service. The Tomcat user should have permissions to the directory where the LabKey binaries are installed, the directory where Tomcat is installed, and the directory you've designated to be the File Repository for LabKey.

I'm not sure what you mean by "How do we test Tomcat with Postgres"? You should have a separate database user that will be listed in your labkey.xml file. This database user doesn't have to be the same user as the user that is running the Tomcat service.

When you had installed your PostgreSQL server, did you setup any additional database admin users or did you just get the default postgres user?

Regards,

Jon