Aggregate: HTTP Status 503 - This application is not currently available

Support
1

Hi all,

I have recently installed a new instance of Aggregate on a server. There have been two previous Aggregate installs on this server (a couple years ago). Those two are running fine.

However, I have had some troubles installing this one. I get through the entire setup process, create the DB etc., move/rename/permission everything as appropriate, but when I open in the browser, I get:

HTTP Status 503 - This application is not currently available

type Status report

message This application is not currently available

description The requested service (This application is not currently available) is not currently available.

I have a vague idea that it might be related to the SSL, but all of the other related posts in this group (eg https://groups.google.com/forum/#!searchin/opendatakit/aggregate$20503/opendatakit/CQm2kr6VkfM/emQD0GOLtv4J and https://groups.google.com/forum/#!searchin/opendatakit/aggregate$20503/opendatakit/qeuYSqzYOw4/hp9ZGj_cTFQJ)
seem to indicate an issue with java. Any suggestions would be appreciated.

SERVER DETAILS
Ubuntu 12.04
mySQL 5.5.47
Tomcat 6
Java 1.7.0_80

INSTALL STEPS FOLLOWED
wget --no-check-certificate https://opendatakit.org/download/4456/

./index.html
'Enter' a bunch of times, agree to license
/var/webapps/ for install directory
2 (mysql)
2 (ssl)
8080
8443
ccpsodk
Default port and server hostname
ccpsodk (for db, instance)
ccpsodk (user for Agg)

root@somvs105:/var/webapps/ODK Aggregate# cat create_db_and_user.sql
create database ccpsodk;
create user 'ccpsodk_user'@'localhost' identified by 'ccpsodk_pw';
grant all on ccpsodk.* to 'ccpsodk_user'@'localhost' identified by 'ccpsodk_pw';
flush privileges;

Pasted the above into mysql

cp ODKAggregate.war ../ccpsodk.war
root@somvs105:/var/webapps# chgrp tomcat6 ccpsodk.war
root@somvs105:/var/webapps# chown tomcat6 ccpsodk.war

service tomcat6 restart

https://odk.ucsf.edu:8443/ccpsodk/ pukes up the 503

RANDOM OTHER THINGS I CHECKED

root@somvs105:/var/webapps# ls -la
total 458656
drwxrwxr-x 7 tomcat6 tomcat6 4096 Feb 8 21:39 .
drwxr-xr-x 6 root root 4096 Apr 30 2012 ..
-rw-r--r-- 1 root root 159954442 May 7 2015 aggrfile.bak
drwxr-xr-x 9 tomcat6 tomcat6 4096 Feb 8 21:39 ccpsodk
-rw-r--r-- 1 tomcat6 tomcat6 73684530 Feb 8 21:39 ccpsodk.war
-rwxrwxrwx 1 tomcat6 tomcat6 159954442 May 7 2015 index.html
drwxr-xr-x 2 root root 4096 Feb 8 21:38 ODK Aggregate
drwxr-xr-x 3 tomcat6 tomcat6 4096 May 1 2012 ROOT
drwxr-xr-x 9 tomcat6 tomcat6 4096 Jun 8 2012 shambamaisha
-rw-r--r-- 1 tomcat6 tomcat6 38011686 Jun 8 2012 shambamaisha.war
drwxr-xr-x 9 tomcat6 tomcat6 4096 Jun 25 2012 shambapeds
-rw-r--r-- 1 tomcat6 tomcat6 38011676 Jun 25 2012 shambapeds.war

mysql> show databases;

··· +-------------------------+ | Database | +-------------------------+ | information_schema | | ccpsodk | | mysql | | odk_shambamaisha.8.8443 | | odk_shambapeds.8.8443 | | performance_schema | | test | +-------------------------+ 7 rows in set (0.00 sec)

mysql> use ccpsodk
Database changed

mysql> show tables;
Empty set (0.00 sec)

root@somvs105:/etc/tomcat6# java -version
java version "1.7.0_80"
Java(TM) SE Runtime Environment (build 1.7.0_80-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode)

root@somvs105:/usr/lib/jvm# update-alternatives --config java
There are 3 choices for the alternative java (providing /usr/bin/java).

Selection Path Priority Status

  • 0 /usr/lib/jvm/java-7-oracle/jre/bin/java 1062 auto mode
    1 /usr/lib/jvm/java-6-openjdk-amd64/jre/bin/java 1061 manual mode
    2 /usr/lib/jvm/java-7-openjdk-amd64/jre/bin/java 1051 manual mode
    3 /usr/lib/jvm/java-7-oracle/jre/bin/java 1062 manual mode

Press enter to keep the current choice[*], or type selection number:

2

Hi all,

I have recently installed a new instance of Aggregate on a server. There have been two previous Aggregate installs on this server (a couple years ago). Those two are running fine.

However, I have had some troubles installing this one. I get through the entire setup process, create the DB etc., move/rename/permission everything as appropriate, but when I open in the browser, I get:

HTTP Status 503 - This application is not currently available

type Status report

message This application is not currently available

description The requested service (This application is not currently available) is not currently available.

I have a vague idea that it might be related to the SSL, but all of the other related posts in this group (eg https://groups.google.com/forum/#!searchin/opendatakit/aggregate$20503/opendatakit/CQm2kr6VkfM/emQD0GOLtv4J and https://groups.google.com/forum/#!searchin/opendatakit/aggregate$20503/opendatakit/qeuYSqzYOw4/hp9ZGj_cTFQJ)
seem to indicate an issue with java. Any suggestions would be appreciated.

SERVER DETAILS
Ubuntu 12.04
mySQL 5.5.47
Tomcat 6
Java 1.7.0_80

INSTALL STEPS FOLLOWED
wget --no-check-certificate https://opendatakit.org/download/4456/

./index.html
'Enter' a bunch of times, agree to license
/var/webapps/ for install directory
2 (mysql)
2 (ssl)
8080
8443
ccpsodk
Default port and server hostname
ccpsodk (for db, instance)
ccpsodk (user for Agg)

root@somvs105:/var/webapps/ODK Aggregate# cat create_db_and_user.sql
create database ccpsodk;
create user 'ccpsodk_user'@'localhost' identified by 'ccpsodk_pw';
grant all on ccpsodk.* to 'ccpsodk_user'@'localhost' identified by 'ccpsodk_pw';
flush privileges;

Pasted the above into mysql

cp ODKAggregate.war ../ccpsodk.war
root@somvs105:/var/webapps# chgrp tomcat6 ccpsodk.war
root@somvs105:/var/webapps# chown tomcat6 ccpsodk.war

service tomcat6 restart

https://odk.ucsf.edu:8443/ccpsodk/ pukes up the 503

RANDOM OTHER THINGS I CHECKED

root@somvs105:/var/webapps# ls -la
total 458656
drwxrwxr-x 7 tomcat6 tomcat6 4096 Feb 8 21:39 .
drwxr-xr-x 6 root root 4096 Apr 30 2012 ..
-rw-r--r-- 1 root root 159954442 May 7 2015 aggrfile.bak
drwxr-xr-x 9 tomcat6 tomcat6 4096 Feb 8 21:39 ccpsodk
-rw-r--r-- 1 tomcat6 tomcat6 73684530 Feb 8 21:39 ccpsodk.war
-rwxrwxrwx 1 tomcat6 tomcat6 159954442 May 7 2015 index.html
drwxr-xr-x 2 root root 4096 Feb 8 21:38 ODK Aggregate
drwxr-xr-x 3 tomcat6 tomcat6 4096 May 1 2012 ROOT
drwxr-xr-x 9 tomcat6 tomcat6 4096 Jun 8 2012 shambamaisha
-rw-r--r-- 1 tomcat6 tomcat6 38011686 Jun 8 2012 shambamaisha.war
drwxr-xr-x 9 tomcat6 tomcat6 4096 Jun 25 2012 shambapeds
-rw-r--r-- 1 tomcat6 tomcat6 38011676 Jun 25 2012 shambapeds.war

mysql> show databases;
+-------------------------+
| Database |
+-------------------------+
| information_schema |
| ccpsodk |
| mysql |
| odk_shambamaisha.8.8443 |
| odk_shambapeds.8.8443 |
| performance_schema |
| test |
+-------------------------+
7 rows in set (0.00 sec)

mysql> use ccpsodk
Database changed

mysql> show tables;
Empty set (0.00 sec)

root@somvs105:/etc/tomcat6# java -version
java version "1.7.0_80"
Java(TM) SE Runtime Environment (build 1.7.0_80-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode)

root@somvs105:/usr/lib/jvm# update-alternatives --config java
There are 3 choices for the alternative java (providing /usr/bin/java).

Selection Path Priority Status

  • 0 /usr/lib/jvm/java-7-oracle/jre/bin/java 1062 auto mode
    1 /usr/lib/jvm/java-6-openjdk-amd64/jre/bin/java 1061 manual mode
    2 /usr/lib/jvm/java-7-openjdk-amd64/jre/bin/java 1051 manual mode
    3 /usr/lib/jvm/java-7-oracle/jre/bin/java 1062 manual mode

Press enter to keep the current choice[*], or type selection number:

Hi all,

I have recently installed a new instance of Aggregate on a server. There have been two previous Aggregate installs on this server (a couple years ago). Those two are running fine.

However, I have had some troubles installing this one. I get through the entire setup process, create the DB etc., move/rename/permission everything as appropriate, but when I open in the browser, I get:

HTTP Status 503 - This application is not currently available

type Status report

message This application is not currently available

description The requested service (This application is not currently available) is not currently available.

I have a vague idea that it might be related to the SSL, but all of the other related posts in this group (eg https://groups.google.com/forum/#!searchin/opendatakit/aggregate$20503/opendatakit/CQm2kr6VkfM/emQD0GOLtv4J and https://groups.google.com/forum/#!searchin/opendatakit/aggregate$20503/opendatakit/qeuYSqzYOw4/hp9ZGj_cTFQJ)
seem to indicate an issue with java. Any suggestions would be appreciated.

SERVER DETAILS
Ubuntu 12.04
mySQL 5.5.47
Tomcat 6
Java 1.7.0_80

INSTALL STEPS FOLLOWED
wget --no-check-certificate https://opendatakit.org/download/4456/

./index.html
'Enter' a bunch of times, agree to license
/var/webapps/ for install directory
2 (mysql)
2 (ssl)
8080
8443
ccpsodk
Default port and server hostname
ccpsodk (for db, instance)
ccpsodk (user for Agg)

root@somvs105:/var/webapps/ODK Aggregate# cat create_db_and_user.sql
create database ccpsodk;
create user 'ccpsodk_user'@'localhost' identified by 'ccpsodk_pw';
grant all on ccpsodk.* to 'ccpsodk_user'@'localhost' identified by 'ccpsodk_pw';
flush privileges;

Pasted the above into mysql

cp ODKAggregate.war ../ccpsodk.war
root@somvs105:/var/webapps# chgrp tomcat6 ccpsodk.war
root@somvs105:/var/webapps# chown tomcat6 ccpsodk.war

service tomcat6 restart

https://odk.ucsf.edu:8443/ccpsodk/ pukes up the 503

RANDOM OTHER THINGS I CHECKED

root@somvs105:/var/webapps# ls -la
total 458656
drwxrwxr-x 7 tomcat6 tomcat6 4096 Feb 8 21:39 .
drwxr-xr-x 6 root root 4096 Apr 30 2012 ..
-rw-r--r-- 1 root root 159954442 May 7 2015 aggrfile.bak
drwxr-xr-x 9 tomcat6 tomcat6 4096 Feb 8 21:39 ccpsodk
-rw-r--r-- 1 tomcat6 tomcat6 73684530 Feb 8 21:39 ccpsodk.war
-rwxrwxrwx 1 tomcat6 tomcat6 159954442 May 7 2015 index.html
drwxr-xr-x 2 root root 4096 Feb 8 21:38 ODK Aggregate
drwxr-xr-x 3 tomcat6 tomcat6 4096 May 1 2012 ROOT
drwxr-xr-x 9 tomcat6 tomcat6 4096 Jun 8 2012 shambamaisha
-rw-r--r-- 1 tomcat6 tomcat6 38011686 Jun 8 2012 shambamaisha.war
drwxr-xr-x 9 tomcat6 tomcat6 4096 Jun 25 2012 shambapeds
-rw-r--r-- 1 tomcat6 tomcat6 38011676 Jun 25 2012 shambapeds.war

mysql> show databases;
+-------------------------+
| Database |
+-------------------------+
| information_schema |
| ccpsodk |
| mysql |
| odk_shambamaisha.8.8443 |
| odk_shambapeds.8.8443 |
| performance_schema |
| test |
+-------------------------+
7 rows in set (0.00 sec)

mysql> use ccpsodk
Database changed

mysql> show tables;
Empty set (0.00 sec)

root@somvs105:/etc/tomcat6# java -version
java version "1.7.0_80"
Java(TM) SE Runtime Environment (build 1.7.0_80-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode)

root@somvs105:/usr/lib/jvm# update-alternatives --config java
There are 3 choices for the alternative java (providing /usr/bin/java).

Selection Path Priority Status

  • 0 /usr/lib/jvm/java-7-oracle/jre/bin/java 1062 auto mode
    1 /usr/lib/jvm/java-6-openjdk-amd64/jre/bin/java 1061 manual mode
    2 /usr/lib/jvm/java-7-openjdk-amd64/jre/bin/java 1051 manual mode
    3 /usr/lib/jvm/java-7-oracle/jre/bin/java 1062 manual mode

Press enter to keep the current choice[*], or type selection number:

Hi all,

I have recently installed a new instance of Aggregate on a server. There have been two previous Aggregate installs on this server (a couple years ago). Those two are running fine.

However, I have had some troubles installing this one. I get through the entire setup process, create the DB etc., move/rename/permission everything as appropriate, but when I open in the browser, I get:

HTTP Status 503 - This application is not currently available

type Status report

message This application is not currently available

description The requested service (This application is not currently available) is not currently available.

I have a vague idea that it might be related to the SSL, but all of the other related posts in this group (eg https://groups.google.com/forum/#!searchin/opendatakit/aggregate$20503/opendatakit/CQm2kr6VkfM/emQD0GOLtv4J and https://groups.google.com/forum/#!searchin/opendatakit/aggregate$20503/opendatakit/qeuYSqzYOw4/hp9ZGj_cTFQJ)
seem to indicate an issue with java. Any suggestions would be appreciated.

SERVER DETAILS
Ubuntu 12.04
mySQL 5.5.47
Tomcat 6
Java 1.7.0_80

INSTALL STEPS FOLLOWED
wget --no-check-certificate https://opendatakit.org/download/4456/

./index.html
'Enter' a bunch of times, agree to license
/var/webapps/ for install directory
2 (mysql)
2 (ssl)
8080
8443
ccpsodk
Default port and server hostname
ccpsodk (for db, instance)
ccpsodk (user for Agg)

root@somvs105:/var/webapps/ODK Aggregate# cat create_db_and_user.sql
create database ccpsodk;
create user 'ccpsodk_user'@'localhost' identified by 'ccpsodk_pw';
grant all on ccpsodk.* to 'ccpsodk_user'@'localhost' identified by 'ccpsodk_pw';
flush privileges;

Pasted the above into mysql

cp ODKAggregate.war ../ccpsodk.war
root@somvs105:/var/webapps# chgrp tomcat6 ccpsodk.war
root@somvs105:/var/webapps# chown tomcat6 ccpsodk.war

service tomcat6 restart

https://odk.ucsf.edu:8443/ccpsodk/ pukes up the 503

RANDOM OTHER THINGS I CHECKED

root@somvs105:/var/webapps# ls -la
total 458656
drwxrwxr-x 7 tomcat6 tomcat6 4096 Feb 8 21:39 .
drwxr-xr-x 6 root root 4096 Apr 30 2012 ..
-rw-r--r-- 1 root root 159954442 May 7 2015 aggrfile.bak
drwxr-xr-x 9 tomcat6 tomcat6 4096 Feb 8 21:39 ccpsodk
-rw-r--r-- 1 tomcat6 tomcat6 73684530 Feb 8 21:39 ccpsodk.war
-rwxrwxrwx 1 tomcat6 tomcat6 159954442 May 7 2015 index.html
drwxr-xr-x 2 root root 4096 Feb 8 21:38 ODK Aggregate
drwxr-xr-x 3 tomcat6 tomcat6 4096 May 1 2012 ROOT
drwxr-xr-x 9 tomcat6 tomcat6 4096 Jun 8 2012 shambamaisha
-rw-r--r-- 1 tomcat6 tomcat6 38011686 Jun 8 2012 shambamaisha.war
drwxr-xr-x 9 tomcat6 tomcat6 4096 Jun 25 2012 shambapeds
-rw-r--r-- 1 tomcat6 tomcat6 38011676 Jun 25 2012 shambapeds.war

mysql> show databases;
+-------------------------+
| Database |
+-------------------------+
| information_schema |
| ccpsodk |
| mysql |
| odk_shambamaisha.8.8443 |
| odk_shambapeds.8.8443 |
| performance_schema |
| test |
+-------------------------+
7 rows in set (0.00 sec)

mysql> use ccpsodk
Database changed

mysql> show tables;
Empty set (0.00 sec)

root@somvs105:/etc/tomcat6# java -version
java version "1.7.0_80"
Java(TM) SE Runtime Environment (build 1.7.0_80-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode)

root@somvs105:/usr/lib/jvm# update-alternatives --config java
There are 3 choices for the alternative java (providing /usr/bin/java).

Selection Path Priority Status

  • 0 /usr/lib/jvm/java-7-oracle/jre/bin/java 1062 auto mode
    1 /usr/lib/jvm/java-6-openjdk-amd64/jre/bin/java 1061 manual mode
    2 /usr/lib/jvm/java-7-openjdk-amd64/jre/bin/java 1051 manual mode
    3 /usr/lib/jvm/java-7-oracle/jre/bin/java 1062 manual mode

Press enter to keep the current choice[*], or type selection number:

For those struggling with similar issues, I have found the solution. In the catalina.out logs I found an exception:

SEVERE: Null component Catalina:type=JspMonitor,name=jsp,WebModule=//localhost/ccpsodk,J2EEApplication=none,J2EEServer=none
Feb 10, 2016 12:25:34 PM org.apache.catalina.startup.HostConfig deployWAR
SEVERE: Error deploying web application archive ccpsodk.war
java.lang.UnsupportedClassVersionError: com/google/apphosting/utils/remoteapi/RemoteApiServlet : Unsupported major.minor version 51.0 (unable to load class com.google.apphosting.utils.remoteapi.RemoteApiServlet)

This pointed me back to the thread I had been reviewing previously (https://groups.google.com/forum/#!searchin/opendatakit/aggregate$20503/opendatakit/qeuYSqzYOw4/hp9ZGj_cTFQJ). I was able to resolve my issue by following Ian's advice in that thread (update-alternatives --config java to switch selection from 0 to 3). Hopefully it sticks after a server reboot :slight_smile:

··· On Monday, February 8, 2016 at 11:51:30 PM UTC-6, colind...@gmail.com wrote: On Monday, February 8, 2016 at 11:51:30 PM UTC-6, colind...@gmail.com wrote: On Monday, February 8, 2016 at 11:51:30 PM UTC-6, colind...@gmail.com wrote: