ODK aggregate installation!

Anybody can guide me on the following issue:

On server machine Microsoft IIS already configured as primary Internet
Server. We have installed the Tomcat, MySQL and ODK aggregate as per the
instruction mentioned at
http://opendatakit.org/use/aggregate/tomcat-install/
http://opendatakit.org/use/aggregate/tomcat-install/ but we are unable to
run ODK aggregate. We feel some different port settings for the
configuration of ODK aggregate as IIS already running on the server.

Please provide us step by step configuration of ODK aggregate when IIS
already installed on the server (Windows 2003).

Thanks

Irum Jamshed | Manager - Data Management
International Rescue Committee
mailto:Irum.Jamshed@pakistan.the Irum.Jamshed@pakistan.theirc.org | +92
91 5703310 (Ext-105) | rescue.org

12345

image

Before proceeding to deploying ODK Aggregate, you should first get the
default Tomcat 6 server page to display. If you don't know what that
should look like, install Tomcat on a computer without IIS running, and
open a browser to the port the Tomcat server is running on.

Until you can get that Tomcat 6 server page to show on your IIS server, you
are still working through the generic problem of configuring IIS and Tomcat
to coexist on the same server. A Microsoft certified systems engineer
should be able to help with this, or anyone familiar with Tomcat
configuration.

Once you do get the Tomcat 6 server page to show, you should then be able
to deploy ODK Aggregate and it should just work. i.e., this is unlikely to
be a problem specific to ODK Aggregate.

Mitch

image

··· On Fri, Jul 13, 2012 at 1:02 AM, irum.jamshed < irum.jamshed@pakistan.theirc.org> wrote:

Anybody can guide me on the following issue:****


On server machine Microsoft IIS already configured as primary Internet
Server. We have installed the Tomcat, MySQL and ODK aggregate as per the
instruction mentioned at http://opendatakit.org/use/aggregate/tomcat
-install/ but we are unable to run ODK aggregate. We feel some different
port settings for the configuration of ODK aggregate as IIS already running
on the server. ****


Please provide us step by step configuration of ODK aggregate when IIS
already installed on the server (Windows 2003).****


Thanks****


Irum Jamshed | Manager - Data Management
International Rescue Committee
Irum.Jamshed@pakistan.the
irc.org
| +92 91 5703310 (Ext-105) | rescue.org


[image: 12345]****


--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Did you run the database configuration script that the installer generated?
That should have created the username and password that ODK Aggregate uses.

For MySQL, a common problem is to forget to install the MySQL Connector/J
into the Tomcat lib directory.

The server configuration is described here:
http://code.google.com/p/opendatakit/wiki/AggregateDeploymentConfiguration
The jdbc connection settings are in jdbc.properties

Mitch

··· On Fri, Mar 8, 2013 at 1:41 AM, wrote:

Hi,

I am having a similar problem. I have set up Tomcat on the server machine
and the default Tomcat 6 page shows up, no problem there. When I tried to
deploy ODK aggregate and start up Tomcat I can still get the default page,
but when starting up Tomcat throws the following exception:

Exception: ------
java.sql.SQLException: Access denied for user 'lbwsatserver'@'localhost'
(using
password: YES)

Is it possible to check the password that ODK is providing, and/or
manually change it? As a consequence localhost/ODKAggregate returns a 404
error, or just says it cannot connect.

Cheers,

Matt Rose

UCL/MIRA Kathmandu

On Friday, 13 July 2012 22:15:05 UTC+5:45, Mitch wrote:

Before proceeding to deploying ODK Aggregate, you should first get the
default Tomcat 6 server page to display. If you don't know what that
should look like, install Tomcat on a computer without IIS running, and
open a browser to the port the Tomcat server is running on.

Until you can get that Tomcat 6 server page to show on your IIS server,
you are still working through the generic problem of configuring IIS and
Tomcat to coexist on the same server. A Microsoft certified systems
engineer should be able to help with this, or anyone familiar with Tomcat
configuration.

Once you do get the Tomcat 6 server page to show, you should then be
able to deploy ODK Aggregate and it should just work. i.e., this is
unlikely to be a problem specific to ODK Aggregate.

Mitch

On Fri, Jul 13, 2012 at 1:02 AM, irum.jamshed < irum.j...@pakistan.theirc.org> wrote:

Anybody
can guide me on the following issue:

On server machine Microsoft IIS
already configured as primary Internet Server. We have installed the
Tomcat,
MySQL and ODK aggregate as per the instruction mentioned at
http://opendatakit.org/use/aggregate/tomcat-install/ but we are unable to
run ODK
aggregate. We feel some different port settings for the configuration of
ODK
aggregate as IIS already running on the server.

Please provide us step by step
configuration of ODK aggregate when IIS already installed on the server
(Windows 2003).

Thanks

Irum Jamshed | Manager - Data Management

International Rescue Committee

Irum.Jamshed@pakistan.theirc.org | +92
91 5703310 (Ext-105) | rescue.org

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Erum which kind of error facing in odk

Hi Mitch,

I ran create_db_and_user.sql, and it seemed to work as set out in the instructions. The database, username and password were created.

I checked the settings in jdbc.properties and also installed Connector/J into the Tomcat lib directory, however I get the access denied exception metioned before, and also a "SEVERE: Error listenerStart" error.

Thanks,

Matt

··· On 8 Mar 2013, at 23:55, Mitch Sundt wrote:

Did you run the database configuration script that the installer generated? That should have created the username and password that ODK Aggregate uses.

For MySQL, a common problem is to forget to install the MySQL Connector/J into the Tomcat lib directory.

The server configuration is described here: http://code.google.com/p/opendatakit/wiki/AggregateDeploymentConfiguration
The jdbc connection settings are in jdbc.properties

Mitch

On Fri, Mar 8, 2013 at 1:41 AM, mbd.rose@gmail.com wrote:
Hi,

I am having a similar problem. I have set up Tomcat on the server machine and the default Tomcat 6 page shows up, no problem there. When I tried to deploy ODK aggregate and start up Tomcat I can still get the default page, but when starting up Tomcat throws the following exception:

Exception: ------
java.sql.SQLException: Access denied for user 'lbwsatserver'@'localhost' (using
password: YES)

Is it possible to check the password that ODK is providing, and/or manually change it? As a consequence localhost/ODKAggregate returns a 404 error, or just says it cannot connect.

Cheers,

Matt Rose

UCL/MIRA Kathmandu

On Friday, 13 July 2012 22:15:05 UTC+5:45, Mitch wrote:

Before proceeding to deploying ODK Aggregate, you should first get the default Tomcat 6 server page to display. If you don't know what that should look like, install Tomcat on a computer without IIS running, and open a browser to the port the Tomcat server is running on.

Until you can get that Tomcat 6 server page to show on your IIS server, you are still working through the generic problem of configuring IIS and Tomcat to coexist on the same server. A Microsoft certified systems engineer should be able to help with this, or anyone familiar with Tomcat configuration.

Once you do get the Tomcat 6 server page to show, you should then be able to deploy ODK Aggregate and it should just work. i.e., this is unlikely to be a problem specific to ODK Aggregate.

Mitch

On Fri, Jul 13, 2012 at 1:02 AM, irum.jamshed irum.j...@pakistan.theirc.org wrote:

Anybody
can guide me on the following issue:

On server machine Microsoft IIS
already configured as primary Internet Server. We have installed the Tomcat,
MySQL and ODK aggregate as per the instruction mentioned at http://opendatakit.org/use/aggregate/tomcat-install/ but we are unable to run ODK
aggregate. We feel some different port settings for the configuration of ODK
aggregate as IIS already running on the server.

Please provide us step by step
configuration of ODK aggregate when IIS already installed on the server
(Windows 2003).

Thanks

Irum Jamshed | Manager - Data Management

International Rescue Committee

Irum.Jamshed@pakistan.theirc.org | +92
91 5703310 (Ext-105) | rescue.org

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--
You received this message because you are subscribed to the Google Groups "ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--
You received this message because you are subscribed to a topic in the Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit-developers/2NH6oprWS_k/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Send me the catalina log of your latest attempt (in the Tomcat logs
directory). I'll see what I can see. It should report what the problem is.

The listener start is probably the SSL-based listener, which will fail to
start because you don't have an SSL certificate installed (that is as
expected).

Are you running on Windows or Linux or OS/X?

Mitch

··· On Sat, Mar 9, 2013 at 12:21 AM, Matthew Rose wrote:

Hi Mitch,

I ran create_db_and_user.sql, and it seemed to work as set out in the
instructions. The database, username and password were created.

I checked the settings in jdbc.properties and also installed Connector/J
into the Tomcat lib directory, however I get the access denied exception
metioned before, and also a "SEVERE: Error listenerStart" error.

Thanks,

Matt

On 8 Mar 2013, at 23:55, Mitch Sundt mitchellsundt@gmail.com wrote:

Did you run the database configuration script that the installer
generated? That should have created the username and password that ODK
Aggregate uses.

For MySQL, a common problem is to forget to install the MySQL
Connector/J into the Tomcat lib directory.

The server configuration is described here:
http://code.google.com/p/opendatakit/wiki/AggregateDeploymentConfiguration
The jdbc connection settings are in jdbc.properties

Mitch

On Fri, Mar 8, 2013 at 1:41 AM, mbd.rose@gmail.com wrote:
Hi,

I am having a similar problem. I have set up Tomcat on the server
machine and the default Tomcat 6 page shows up, no problem there. When I
tried to deploy ODK aggregate and start up Tomcat I can still get the
default page, but when starting up Tomcat throws the following exception:

Exception: ------
java.sql.SQLException: Access denied for user 'lbwsatserver'@'localhost'
(using
password: YES)

Is it possible to check the password that ODK is providing, and/or
manually change it? As a consequence localhost/ODKAggregate returns a 404
error, or just says it cannot connect.

Cheers,

Matt Rose

UCL/MIRA Kathmandu

On Friday, 13 July 2012 22:15:05 UTC+5:45, Mitch wrote:

Before proceeding to deploying ODK Aggregate, you should first get the
default Tomcat 6 server page to display. If you don't know what that
should look like, install Tomcat on a computer without IIS running, and
open a browser to the port the Tomcat server is running on.

Until you can get that Tomcat 6 server page to show on your IIS
server, you are still working through the generic problem of configuring
IIS and Tomcat to coexist on the same server. A Microsoft certified
systems engineer should be able to help with this, or anyone familiar with
Tomcat configuration.

Once you do get the Tomcat 6 server page to show, you should then be
able to deploy ODK Aggregate and it should just work. i.e., this is
unlikely to be a problem specific to ODK Aggregate.

Mitch

On Fri, Jul 13, 2012 at 1:02 AM, irum.jamshed < irum.j...@pakistan.theirc.org> wrote:

Anybody
can guide me on the following issue:

On server machine Microsoft IIS
already configured as primary Internet Server. We have installed the
Tomcat,
MySQL and ODK aggregate as per the instruction mentioned at
http://opendatakit.org/use/aggregate/tomcat-install/ but we are unable to
run ODK
aggregate. We feel some different port settings for the configuration
of ODK
aggregate as IIS already running on the server.

Please provide us step by step
configuration of ODK aggregate when IIS already installed on the server
(Windows 2003).

Thanks

Irum Jamshed | Manager - Data Management

International Rescue Committee

Irum.Jamshed@pakistan.theirc.org | +92
91 5703310 (Ext-105) | rescue.org

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--
You received this message because you are subscribed to the Google
Groups "ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/2NH6oprWS_k/unsubscribe?hl=en
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com