Aggregate on VPS

Hi all.

I am trying to set up ODK Aggregate 1.0 RC3 on a VPS running CentOS 6
x86_64.

I have installed mysql-server 5.1 and tomcat 6.0.24 from the yum
repositories.
The mysql-connector is copied to /usr/share/tomcat6/lib/
I have run the script to create the mysql database and users.

I create the WAR file using the Windows RC3 installer on my laptop.

I deploy the WAR to the server using the Tomcat Web Application
Manager

http://11.12.13.14:8080/manager/html/

The file uploads and extracts but fails to start. Manager gives the
following error:
FAIL - Application at context path /ODKAggregate could not be started

catalina.log shows the following:

http://11.12.13.14:8080/ODKAggregate/

Gives:
HTTP Status 404 -
type Status report
message
description The requested resource () is not available.

I haven't tried the manager-based deployment on Fedora/CentOS.
However, it does work on Windows /Tomcat 6.

Did you type in the filename (./ODKAggregate.war) in the upper portion ("Deploy
directory or WAR file located on server") of the Manager deployment screen
or did you use the lower half ("WAR file to deploy") and the Browse button
to specify it?

It looks like you were hand-typing in the upper half. You should be able to
just select the war file and deploy from the bottom half of that section.
The "./" is suspicious. The proper form for a "file:" URL is:

file://fully-qualified-hostname/rooted-directory-path

e.g., for windows, it is something ugly like:

file://fred.opendatakit.org/c:\Users\user\Documents\ODKAggregate.war

If that is not the issue...

Are you using a Sun/Oracle JVM or OpenJDK?

Try the Sun/Oracle JDK and let me know if that resolves the issue.

Mitch

··· On Fri, Oct 21, 2011 at 10:47 AM, Peter Crees wrote:

Hi all.

I am trying to set up ODK Aggregate 1.0 RC3 on a VPS running CentOS 6
x86_64.

I have installed mysql-server 5.1 and tomcat 6.0.24 from the yum
repositories.
The mysql-connector is copied to /usr/share/tomcat6/lib/
I have run the script to create the mysql database and users.

I create the WAR file using the Windows RC3 installer on my laptop.

I deploy the WAR to the server using the Tomcat Web Application
Manager

http://11.12.13.14:8080/manager/html/

The file uploads and extracts but fails to start. Manager gives the
following error:
FAIL - Application at context path /ODKAggregate could not be started

catalina.log shows the following:
http://pastebin.com/rCHvJ3zP

http://11.12.13.14:8080/ODKAggregate/

Gives:
HTTP Status 404 -
type Status report
message
description The requested resource () is not available.

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer

University of Washington
mitchellsundt@gmail.com

Mitch,

Thanks for the quick reply.

I used the lower section ("WAR file to upload") the Browse button to
specify it then 'Deploy'.

I have also tried Sun Java 1.6.0_03-b05, same problem

Peter

··· On Oct 22, 2:11 am, Mitch Sundt wrote: > I haven't tried the manager-based deployment on Fedora/CentOS. > However, it does work on Windows /Tomcat 6. > > Did you type in the filename (./ODKAggregate.war) in the upper portion ("Deploy > directory or WAR file located on server") of the Manager deployment screen > or did you use the lower half ("WAR file to deploy") and the Browse button > to specify it? > > It looks like you were hand-typing in the upper half. You should be able to > just select the war file and deploy from the bottom half of that section. > The "./" is suspicious. The proper form for a "file:" URL is: > > file://fully-qualified-hostname/rooted-directory-path > > e.g., for windows, it is something ugly like: > > file://fred.opendatakit.org/c:\\Users\\user\\Documents\\ODKAggregate.war > > If that is not the issue... > > Are you using a Sun/Oracle JVM or OpenJDK? > > Try the Sun/Oracle JDK and let me know if that resolves the issue. > > Mitch > > > > > > > > > > On Fri, Oct 21, 2011 at 10:47 AM, Peter Crees wrote: > > Hi all. > > > I am trying to set up ODK Aggregate 1.0 RC3 on a VPS running CentOS 6 > > x86_64. > > > I have installed mysql-server 5.1 and tomcat 6.0.24 from the yum > > repositories. > > The mysql-connector is copied to /usr/share/tomcat6/lib/ > > I have run the script to create the mysql database and users. > > > I create the WAR file using the Windows RC3 installer on my laptop. > > > I deploy the WAR to the server using the Tomcat Web Application > > Manager > > >http://11.12.13.14:8080/manager/html/ > > > The file uploads and extracts but fails to start. Manager gives the > > following error: > > FAIL - Application at context path /ODKAggregate could not be started > > > catalina.log shows the following: > >http://pastebin.com/rCHvJ3zP > > >http://11.12.13.14:8080/ODKAggregate/ > > > Gives: > > HTTP Status 404 - > > type Status report > > message > > description The requested resource () is not available. > > > -- > > Post: opendatakit@googlegroups.com > > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > > Options:http://groups.google.com/group/opendatakit?hl=en > > -- > Mitch Sundt > Software Engineerhttp://www.OpenDataKit.org > University of Washington > mitchellsu...@gmail.com

OK the logs from Sun Java were more descriptive then the OpenJDK ones.

Error was with the login to the mysql database. My server does not
have a working FQDN, only an IP address.

Changing the .sql script to 'odk_user'@'localhost' seems to have fixed
it.

Best,
Peter

··· On Oct 22, 5:57 am, Peter Crees wrote: > Mitch, > > Thanks for the quick reply. > > I used the lower section ("WAR file to upload") the Browse button to > specify it then 'Deploy'. > > I have also tried Sun Java 1.6.0_03-b05, same problem > > Peter > > On Oct 22, 2:11 am, Mitch Sundt wrote: > > > > > > > > > I haven't tried the manager-based deployment on Fedora/CentOS. > > However, it does work on Windows /Tomcat 6. > > > Did you type in the filename (./ODKAggregate.war) in the upper portion ("Deploy > > directory or WAR file located on server") of the Manager deployment screen > > or did you use the lower half ("WAR file to deploy") and the Browse button > > to specify it? > > > It looks like you were hand-typing in the upper half. You should be able to > > just select the war file and deploy from the bottom half of that section. > > The "./" is suspicious. The proper form for a "file:" URL is: > > > file://fully-qualified-hostname/rooted-directory-path > > > e.g., for windows, it is something ugly like: > > > file://fred.opendatakit.org/c:\\Users\\user\\Documents\\ODKAggregate.war > > > If that is not the issue... > > > Are you using a Sun/Oracle JVM or OpenJDK? > > > Try the Sun/Oracle JDK and let me know if that resolves the issue. > > > Mitch > > > On Fri, Oct 21, 2011 at 10:47 AM, Peter Crees wrote: > > > Hi all. > > > > I am trying to set up ODK Aggregate 1.0 RC3 on a VPS running CentOS 6 > > > x86_64. > > > > I have installed mysql-server 5.1 and tomcat 6.0.24 from the yum > > > repositories. > > > The mysql-connector is copied to /usr/share/tomcat6/lib/ > > > I have run the script to create the mysql database and users. > > > > I create the WAR file using the Windows RC3 installer on my laptop. > > > > I deploy the WAR to the server using the Tomcat Web Application > > > Manager > > > >http://11.12.13.14:8080/manager/html/ > > > > The file uploads and extracts but fails to start. Manager gives the > > > following error: > > > FAIL - Application at context path /ODKAggregate could not be started > > > > catalina.log shows the following: > > >http://pastebin.com/rCHvJ3zP > > > >http://11.12.13.14:8080/ODKAggregate/ > > > > Gives: > > > HTTP Status 404 - > > > type Status report > > > message > > > description The requested resource () is not available. > > > > -- > > > Post: opendatakit@googlegroups.com > > > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > > > Options:http://groups.google.com/group/opendatakit?hl=en > > > -- > > Mitch Sundt > > Software Engineerhttp://www.OpenDataKit.org > > University of Washington > > mitchellsu...@gmail.com

Wow. I'm glad switching to the Sun JVM gave a better indication of the
cause.
I would never have tied the OpenJDK's errors back to a DB access problem!

Mitch

··· On Fri, Oct 21, 2011 at 3:10 PM, Peter Crees wrote:

OK the logs from Sun Java were more descriptive then the OpenJDK ones.

Error was with the login to the mysql database. My server does not
have a working FQDN, only an IP address.

Changing the .sql script to 'odk_user'@'localhost' seems to have fixed
it.

Best,
Peter

On Oct 22, 5:57 am, Peter Crees pe...@rmrkz.com wrote:

Mitch,

Thanks for the quick reply.

I used the lower section ("WAR file to upload") the Browse button to
specify it then 'Deploy'.

I have also tried Sun Java 1.6.0_03-b05, same problem

Peter

On Oct 22, 2:11 am, Mitch Sundt msu...@cs.washington.edu wrote:

I haven't tried the manager-based deployment on Fedora/CentOS.
However, it does work on Windows /Tomcat 6.

Did you type in the filename (./ODKAggregate.war) in the upper portion
("Deploy
directory or WAR file located on server") of the Manager deployment
screen
or did you use the lower half ("WAR file to deploy") and the Browse
button
to specify it?

It looks like you were hand-typing in the upper half. You should be
able to
just select the war file and deploy from the bottom half of that
section.
The "./" is suspicious. The proper form for a "file:" URL is:

file://fully-qualified-hostname/rooted-directory-path

e.g., for windows, it is something ugly like:

file://fred.opendatakit.org/c
:\Users\user\Documents\ODKAggregate.war

If that is not the issue...

Are you using a Sun/Oracle JVM or OpenJDK?

Try the Sun/Oracle JDK and let me know if that resolves the issue.

Mitch

On Fri, Oct 21, 2011 at 10:47 AM, Peter Crees pe...@rmrkz.com wrote:

Hi all.

I am trying to set up ODK Aggregate 1.0 RC3 on a VPS running CentOS 6
x86_64.

I have installed mysql-server 5.1 and tomcat 6.0.24 from the yum
repositories.
The mysql-connector is copied to /usr/share/tomcat6/lib/
I have run the script to create the mysql database and users.

I create the WAR file using the Windows RC3 installer on my laptop.

I deploy the WAR to the server using the Tomcat Web Application
Manager

http://11.12.13.14:8080/manager/html/

The file uploads and extracts but fails to start. Manager gives the
following error:
FAIL - Application at context path /ODKAggregate could not be started

catalina.log shows the following:
http://pastebin.com/rCHvJ3zP

http://11.12.13.14:8080/ODKAggregate/

Gives:
HTTP Status 404 -
type Status report
message
description The requested resource () is not available.

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options:http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineerhttp://www.OpenDataKit.org
University of Washington
mitchellsu...@gmail.com

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com