ODK aggregate local server

··· ---

Yao

I have been trying to set up a local server for the odk by installing the ODK Aggregate v1.3.0 windows-installer.

I have tomcat v6 and mysql already installed in my comp.

I have been following these steps http://code.google.com/p/crossriver-openhds/wiki/OpenDataKitInstallation

unfortunately, when i get to the last step and try to implement the steps below, I get two errors in the command window which I suspect are making me not be able to run the odk aggregate server

Error 1007 ; can't create a database 'odk-prod'; database already exists

Error 1397 ; Operation CREATE USER failed for 'odk_user' @ 'local host'

I expect to have the above statement to be as highlighted in yellow below

what could be the problem?

I would wish to know whether there is an alternative for converting the xml forms with data into csv format on my personal comp.

my comp is running on windows 7

Regards

Karuru

To complete the installation, you need to:

  1. Execute the mysql (mysql.exe) commandline client using the root account and password (the password you chose during the installation of the database), and supply the create_db_and_user.sql to it.

To open the mysql commandline client, open a cmd window (Windows), terminal window (MacOS) or
term window (Linux) and 'cd' to the directory containing the mysql client (mysql.exe on Windows).
Then, please type:

  mysql --user root --password

And enter the MySQL server root password. You will then be within the mysql commandline client. You should see a 'mysql>' prompt. Type:

  source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK Aggregate/create_db_and_user.sql
  exit

Here is what this looks like on Windows, with what you must type in red:

  Microsoft Windows [Version 6.1.7600]
  Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Windows\System32>cd "\Program Files\MySQL\MySQL Server 5.1\bin" C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql.exe --user root --password
  Enter password: *******
  Welcome to the MySQL monitor. Commands end with ; or \g.
  Your MySQL connection id is 13
  Server version: 5.1.47-community MySQL Community Server (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
  This software comes with ABSOLUTELY NO WARRANTY. This is free software,
  and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK Aggregate/create_db_and_user.sql
  Query OK, 1 row affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> exit
  Bye C:\Program Files\MySQL\MySQL Server 5.1\bin>
  1. copy the ODKAggregate.war to the \webapps directory of the Apache
    Tomcat installation.
  2. start Apache (if not already started)
  3. visit http://karuru-pc:8080/ODKAggregate/ and go to the Management / Permissions tab to complete configuring the access rights for ODK Aggregate. NOTE: It may take a few moments for the Apache Tomcat server to detect the ODKAggregate.war; if you get a 404 error, wait a few moments then refresh your browser.
    If you want ODKAggregate to be reached at just http://Karuru-PC:8080/, you can
    rename it to ROOT.war before copying it to the \webapps directory.

Regards;
Stephen Karuru Maina
https://profiles.google.com/TheKarurus

1 Like

You must have a pre-existing MySQL database called odk-prod. Either
delete that database or in the Aggregate installer, use a different
database name.

If you are having trouble installing Aggregate, you can also try the
ODK Aggregate VM at http://gum.co/odk-aggregate-vm. The VM is a
fully-configured version of Aggregate that runs on any computer. It
requires very little setup, works great offline, and gives you
complete control of where your data goes.

For offline XML to CSV conversion, use ODK Briefcase.
http://opendatakit.org/use/briefcase/

Yaw

··· -- Need ODK help? Go to http://nafundi.com for custom development, professional support, form design, implementation advice, and user training for ODK.

On Sat, Feb 16, 2013 at 3:58 AM, Maina karuru stephenkarurum@yahoo.com wrote:


Yao

I have been trying to set up a local server for the odk by installing the
ODK Aggregate v1.3.0 windows-installer.
I have tomcat v6 and mysql already installed in my comp.

I have been following these steps
http://code.google.com/p/crossriver-openhds/wiki/OpenDataKitInstallation

unfortunately, when i get to the last step and try to implement the steps
below, I get two errors in the command window which I suspect are making me
not be able to run the odk aggregate server

Error 1007 ; can't create a database 'odk-prod'; database already
exists
Error 1397 ; Operation CREATE USER failed for 'odk_user' @ 'local
host'

I expect to have the above statement to be as highlighted in yellow below

what could be the problem?

I would wish to know whether there is an alternative for converting the xml
forms with data into csv format on my personal comp.

my comp is running on windows 7

Regards
Karuru

To complete the installation, you need to:

Execute the mysql (mysql.exe) commandline client using the root account and
password (the password you chose during the installation of the database),
and supply the create_db_and_user.sql to it.
To open the mysql commandline client, open a cmd window (Windows), terminal
window (MacOS) or term window (Linux) and 'cd' to the directory containing
the mysql client (mysql.exe on Windows). Then, please type:

mysql --user root --password

And enter the MySQL server root password. You will then be within the mysql
commandline client. You should see a 'mysql>' prompt. Type:

source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK
Aggregate/create_db_and_user.sql
exit

Here is what this looks like on Windows, with what you must type in red:

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Windows\System32>cd "\Program Files\MySQL\MySQL Server 5.1\bin"

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql.exe --user root --password
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.1.47-community MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK
Aggregate/create_db_and_user.sql
Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

C:\Program Files\MySQL\MySQL Server 5.1\bin>

copy the ODKAggregate.war to the \webapps directory of the Apache Tomcat
installation.
start Apache (if not already started)
visit http://karuru-pc:8080/ODKAggregate/ and go to the Management /
Permissions tab to complete configuring the access rights for ODK Aggregate.
NOTE: It may take a few moments for the Apache Tomcat server to detect the
ODKAggregate.war; if you get a 404 error, wait a few moments then refresh
your browser.

If you want ODKAggregate to be reached at just http://Karuru-PC:8080/, you
can rename it to ROOT.war before copying it to the \webapps directory.

Regards;
Stephen Karuru Maina
https://profiles.google.com/TheKarurus

Thank you Yao

Following your instructions I have managed to run the cmd to the final end by changing the name of the database and user names. see the screenprints below.

But on opening the http://Karuru-PC:8080/ODKAggregate/
I see access denied after loging in with my gmail address and allowing the pc to access the information.

Alternatively,
I have tried installing the virtual box then run ODK-Aggregate-VM-1.3.0.0 as shown below

The default settings for the os is Obuntu, but I change this to windows 7 and hit import.

This creates a copy VM_1
But when I click the start button

so I hit ok

so I hit ok again and the VM is set to begin

but unfortunately I cannot log in. there is an error that the VM could not assign an IP adress. I am using a modem to connect to internet.
My worry is, must I be connected to internet for this operation to work? what would happen if I am in an area where there is no network coverage?

Kindly help.

Regards;
Stephen Karuru Maina

··· ________________________________ From: Yaw Anokwa To: "opendatakit@googlegroups.com" Cc: Maina karuru Sent: Saturday, February 16, 2013 7:20 PM Subject: Re: ODK aggregate local server

You must have a pre-existing MySQL database called odk-prod. Either
delete that database or in the Aggregate installer, use a different
database name.

If you are having trouble installing Aggregate, you can also try the
ODK Aggregate VM at http://gum.co/odk-aggregate-vm. The VM is a
fully-configured version of Aggregate that runs on any computer. It
requires very little setup, works great offline, and gives you
complete control of where your data goes.

For offline XML to CSV conversion, use ODK Briefcase.
http://opendatakit.org/use/briefcase/

Yaw

Need ODK help? Go to http://nafundi.com for custom development,
professional support, form design, implementation advice, and user
training for ODK.

On Sat, Feb 16, 2013 at 3:58 AM, Maina karuru stephenkarurum@yahoo.com wrote:


Yao

I have been trying to set up a local server for the odk by installing the
ODK Aggregate v1.3.0 windows-installer.
I have tomcat v6 and mysql already installed in my comp.

I have been following these steps
http://code.google.com/p/crossriver-openhds/wiki/OpenDataKitInstallation

unfortunately, when i get to the last step and try to implement the steps
below, I get two errors in the command window which I suspect are making me
not be able to run the odk aggregate server

Error 1007 ; can't create a database 'odk-prod'; database already
exists
Error 1397 ; Operation CREATE USER failed for 'odk_user' @ 'local
host'

I expect to have the above statement to be as highlighted in yellow below

what could be the problem?

I would wish to know whether there is an alternative for converting the xml
forms with data into csv format on my personal comp.

my comp is running on windows 7

Regards
Karuru

To complete the installation, you need to:

Execute the mysql (mysql.exe) commandline client using the root account and
password (the password you chose during the installation of the database),
and supply the create_db_and_user.sql to it.
To open the mysql commandline client, open a cmd window (Windows), terminal
window (MacOS) or term window (Linux) and 'cd' to the directory containing
the mysql client (mysql.exe on Windows). Then, please type:

mysql --user root --password

And enter the MySQL server root password. You will then be within the mysql
commandline client. You should see a 'mysql>' prompt. Type:

source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK
Aggregate/create_db_and_user.sql
exit

Here is what this looks like on Windows, with what you must type in red:

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Windows\System32>cd "\Program Files\MySQL\MySQL Server 5.1\bin"

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql.exe --user root --password
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.1.47-community MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK
Aggregate/create_db_and_user.sql
Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

C:\Program Files\MySQL\MySQL Server 5.1\bin>

copy the ODKAggregate.war to the \webapps directory of the Apache Tomcat
installation.
start Apache (if not already started)
visit http://karuru-pc:8080/ODKAggregate/ and go to the Management /
Permissions tab to complete configuring the access rights for ODK Aggregate.
NOTE: It may take a few moments for the Apache Tomcat server to detect the
ODKAggregate.war; if you get a 404 error, wait a few moments then refresh
your browser.

If you want ODKAggregate to be reached at just http://Karuru-PC:8080/, you
can rename it to ROOT.war before copying it to the \webapps directory.

Regards;
Stephen Karuru Maina
https://profiles.google.com/TheKarurus

Thank you Yao

following your instructions I have managed to run the cmd to the final end by changing the name of the database and user names. see the screenprint

But on opening the http://Karuru-PC:8080/ODKAggregate/
I see access denied after loging in with my gmail address and allowing the pc to access the information.

Alternatively,
I have tries installing the virtual box then run
ODK-Aggregate-VM-1.3.0.0 as shown below

The default settings
for the os is Obuntu, but I change this to windows 7 and hit import.

This creates a copy VM_1
But when I click the start button

so I hit ok

so I hit ok again and the VM is set to begin

but unfortunately I cannot log in

Regards;
Stephen Karuru Maina

Here I tried the VM.pdf (1020 KB)

··· ________________________________ From: Yaw Anokwa To: "opendatakit@googlegroups.com" Cc: Maina karuru Sent: Saturday, February 16, 2013 7:20 PM Subject: Re: ODK aggregate local server

You must have a pre-existing MySQL database called odk-prod. Either
delete that database or in the Aggregate installer, use a different
database name.

If you are having trouble installing Aggregate, you can also try the
ODK Aggregate VM at http://gum.co/odk-aggregate-vm. The VM is a
fully-configured version of Aggregate that runs on any computer. It
requires very little setup, works great offline, and gives you
complete control of where your data goes.

For offline XML to CSV conversion, use ODK Briefcase.
http://opendatakit.org/use/briefcase/

Yaw

Need ODK help? Go to http://nafundi.com for custom development,
professional support, form design, implementation advice, and user
training for ODK.

On Sat, Feb 16, 2013 at 3:58 AM, Maina karuru stephenkarurum@yahoo.com wrote:


Yao

I have been trying to set up a local server for the odk by installing the
ODK Aggregate v1.3.0 windows-installer.
I have tomcat v6 and mysql already installed in my comp.

I have been following these steps
http://code.google.com/p/crossriver-openhds/wiki/OpenDataKitInstallation

unfortunately, when i get to the last step and try to implement the steps
below, I get two errors in the command window which I suspect are making me
not be able to run the odk aggregate server

Error 1007 ; can't create a database 'odk-prod'; database already
exists
Error 1397 ; Operation CREATE USER failed for 'odk_user' @ 'local
host'

I expect to have the above statement to be as highlighted in yellow below

what could be the
problem?

I would wish to know whether there is an alternative for converting the xml
forms with data into csv format on my personal comp.

my comp is running on windows 7

Regards
Karuru

To complete the installation, you need to:

Execute the mysql (mysql.exe) commandline client using the root account and
password (the password you chose during the installation of the database),
and supply the create_db_and_user.sql to it.
To open the mysql commandline client, open a cmd window (Windows), terminal
window (MacOS) or term window (Linux) and 'cd' to the directory containing
the mysql client (mysql.exe on Windows). Then, please type:

mysql --user root --password

And enter the MySQL server root password. You will then be within the mysql
commandline
client. You should see a 'mysql>' prompt. Type:

source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK
Aggregate/create_db_and_user.sql
exit

Here is what this looks like on Windows, with what you must type in red:

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Windows\System32>cd "\Program Files\MySQL\MySQL Server 5.1\bin"

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql.exe --user root --password
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.1.47-community MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free
software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK
Aggregate/create_db_and_user.sql
Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

C:\Program Files\MySQL\MySQL Server 5.1\bin>

copy the ODKAggregate.war to the \webapps directory of the Apache Tomcat
installation.
start Apache (if not already started)
visit http://karuru-pc:8080/ODKAggregate/ and go to the Management /
Permissions tab to complete configuring the access rights for ODK Aggregate.
NOTE: It may
take a few moments for the Apache Tomcat server to detect the
ODKAggregate.war; if you get a 404 error, wait a few moments then refresh
your browser.

If you want ODKAggregate to be reached at just http://Karuru-PC:8080/, you
can rename it to ROOT.war before copying it to the \webapps directory.

Regards;
Stephen Karuru Maina
https://profiles.google.com/TheKarurus

You must have a pre-existing MySQL database called odk-prod. Either
delete that database or in the Aggregate installer, use a different
database name.

If you are having trouble installing Aggregate, you can also try the
ODK Aggregate VM at http://gum.co/odk-aggregate-vm. The VM is a
fully-configured version of Aggregate that runs on any computer. It
requires very little setup, works great offline, and gives you
complete control of where your data goes.

For offline XML to CSV conversion, use ODK Briefcase.
http://opendatakit.org/use/briefcase/

Yaw

Need ODK help? Go to http://nafundi.com for custom development,
professional support, form design, implementation advice, and user
training for ODK.


Yao

I have been trying to set up a local server for the odk by installing
the
ODK Aggregate v1.3.0 windows-installer.
I have tomcat v6 and mysql already installed in my comp.

I have been following these steps
http://code.google.com/p/crossriver-openhds/wiki/OpenDataKitInstallation

unfortunately, when i get to the last step and try to implement the
steps
below, I get two errors in the command window which I suspect are making
me
not be able to run the odk aggregate server

Error 1007 ; can't create a database 'odk-prod'; database already
exists
Error 1397 ; Operation CREATE USER failed for 'odk_user' @ 'local
host'

I expect to have the above statement to be as highlighted in yellow
below

what could be the problem?

I would wish to know whether there is an alternative for converting the
xml
forms with data into csv format on my personal comp.

my comp is running on windows 7

Regards
Karuru

To complete the installation, you need to:

Execute the mysql (mysql.exe) commandline client using the root account
and
password (the password you chose during the installation of the
database),
and supply the create_db_and_user.sql to it.
To open the mysql commandline client, open a cmd window (Windows),
terminal
window (MacOS) or term window (Linux) and 'cd' to the directory
containing
the mysql client (mysql.exe on Windows). Then, please type:

mysql --user root --password

And enter the MySQL server root password. You will then be within the
mysql
commandline client. You should see a 'mysql>' prompt. Type:

source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK
Aggregate/create_db_and_user.sql
exit

Here is what this looks like on Windows, with what you must type in red:

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Windows\System32>cd "\Program Files\MySQL\MySQL Server 5.1\bin"

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql.exe --user root
--password
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.1.47-community MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights
reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2
license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK
Aggregate/create_db_and_user.sql
Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

C:\Program Files\MySQL\MySQL Server 5.1\bin>

copy the ODKAggregate.war to the \webapps directory of the Apache Tomcat
installation.
start Apache (if not already started)
visit http://karuru-pc:8080/ODKAggregate/ and go to the Management /
Permissions tab to complete configuring the access rights for ODK
Aggregate.
NOTE: It may take a few moments for the Apache Tomcat server to detect
the
ODKAggregate.war; if you get a 404 error, wait a few moments then
refresh
your browser.

If you want ODKAggregate to be reached at just http://Karuru-PC:8080/,
you
can rename it to ROOT.war before copying it to the \webapps directory.

Regards;
Stephen Karuru Maina
https://profiles.google.com/TheKarurus

please Karuru,

i have a local ODK server non connected to the internet, i have mysql 5.5
and odk aggregate 1.4.4 and tomcat 6

everything is working fine, tomcat login page and the server status and the
manager too.
sql is working fine and running, set the d:/source .... in my sql
.war file is also in it's place and the connector also,

the problem that i have is that after running tomcat server and open the
http://192.168.0.100:8080/ODKAggregate/ page,

i enter the username which i set up in the odk aggregate setup (admin)

what would be the pass?
is this the correct username that i'm entering?
what would be the default password?

··· On Saturday, February 16, 2013 6:20:39 PM UTC+2, Yaw Anokwa wrote: > On Sat, Feb 16, 2013 at 3:58 AM, Maina karuru <stephen...@yahoo.com > wrote:

Please don't attach such big files to the email. Many on this list are in
low-bandwidth settings, so we prefer you attach it to an issue at
https://code.google.com/p/opendatakit/issues/list.

Your Google account login will not work because you did not enter a fully
qualified domain name in the Aggregate installer. See
https://code.google.com/p/opendatakit/issues/detail?id=520 for some
suggestions on how to work around this issue.
https://code.google.com/p/opendatakit/wiki/AggregateTroubleshooting is also
a good resource.

As far as the VM, you should not change the OS settings to Windows 7.
Delete both VM and VM_1 and try again. If the VM reports "Network did not
assign this VM an IP" error on startup, it means that the VM is on a
network that did not assign it an IP. Make sure the upstream router assigns
IPs via DHCP. Alternatively, switch the networking in the VM from Bridged
to NAT, but then configure port forwarding on the local computer to enable
external connections to it. Tomcat in the VM listens on port 80.

Yaw

··· -- Need ODK help? Go to http://nafundi.com for custom development, professional support, form design, implementation advice, and user training for ODK.

On Sun, Feb 17, 2013 at 1:44 AM, Maina karuru stephenkarurum@yahoo.comwrote:

Thank you Yao

following your instructions I have managed to run the cmd to the final end
by changing the name of the database and user names. see the screenprint

But on opening the http://Karuru-PC:8080/ODKAggregate/
I see access denied after loging in with my gmail address and allowing the
pc to access the information.

Alternatively,
I have tries installing the virtual box then run ODK-Aggregate-VM-1.3.0.0
as shown below

The default settings for the os is Obuntu, but I change this to windows 7
and hit import.

This creates a copy VM_1
But when I click the start button

so I hit ok

so I hit ok again and the VM is set to begin

but unfortunately I cannot log in

Regards;
Stephen Karuru Maina


From: Yaw Anokwa yanokwa@nafundi.com
To: "opendatakit@googlegroups.com" opendatakit@googlegroups.com
Cc: Maina karuru stephenkarurum@yahoo.com
Sent: Saturday, February 16, 2013 7:20 PM
Subject: Re: ODK aggregate local server

You must have a pre-existing MySQL database called odk-prod. Either
delete that database or in the Aggregate installer, use a different
database name.

If you are having trouble installing Aggregate, you can also try the
ODK Aggregate VM at http://gum.co/odk-aggregate-vm. The VM is a
fully-configured version of Aggregate that runs on any computer. It
requires very little setup, works great offline, and gives you
complete control of where your data goes.

For offline XML to CSV conversion, use ODK Briefcase.
http://opendatakit.org/use/briefcase/

Yaw

Need ODK help? Go to http://nafundi.com for custom development,
professional support, form design, implementation advice, and user
training for ODK.

On Sat, Feb 16, 2013 at 3:58 AM, Maina karuru stephenkarurum@yahoo.com wrote:


Yao

I have been trying to set up a local server for the odk by installing the
ODK Aggregate v1.3.0 windows-installer.
I have tomcat v6 and mysql already installed in my comp.

I have been following these steps
http://code.google.com/p/crossriver-openhds/wiki/OpenDataKitInstallation

unfortunately, when i get to the last step and try to implement the steps
below, I get two errors in the command window which I suspect are making
me
not be able to run the odk aggregate server

Error 1007 ; can't create a database 'odk-prod'; database already
exists
Error 1397 ; Operation CREATE USER failed for 'odk_user' @ 'local
host'

I expect to have the above statement to be as highlighted in yellow below

what could be the problem?

I would wish to know whether there is an alternative for converting the
xml
forms with data into csv format on my personal comp.

my comp is running on windows 7

Regards
Karuru

To complete the installation, you need to:

Execute the mysql (mysql.exe) commandline client using the root account
and
password (the password you chose during the installation of the
database),
and supply the create_db_and_user.sql to it.
To open the mysql commandline client, open a cmd window (Windows),
terminal
window (MacOS) or term window (Linux) and 'cd' to the directory
containing
the mysql client (mysql.exe on Windows). Then, please type:

mysql --user root --password

And enter the MySQL server root password. You will then be within the
mysql
commandline client. You should see a 'mysql>' prompt. Type:

source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK
Aggregate/create_db_and_user.sql
exit

Here is what this looks like on Windows, with what you must type in red:

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Windows\System32>cd "\Program Files\MySQL\MySQL Server 5.1\bin"

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql.exe --user root
--password
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.1.47-community MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights
reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2
license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK
Aggregate/create_db_and_user.sql
Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

C:\Program Files\MySQL\MySQL Server 5.1\bin>

copy the ODKAggregate.war to the \webapps directory of the Apache Tomcat
installation.
start Apache (if not already started)
visit http://karuru-pc:8080/ODKAggregate/ and go to the Management /
Permissions tab to complete configuring the access rights for ODK
Aggregate.
NOTE: It may take a few moments for the Apache Tomcat server to detect
the
ODKAggregate.war; if you get a 404 error, wait a few moments then refresh
your browser.

If you want ODKAggregate to be reached at just http://Karuru-PC:8080/http://karuru-pc:8080/,
you
can rename it to ROOT.war before copying it to the \webapps directory.

Regards;
Stephen Karuru Maina
https://profiles.google.com/TheKarurus

Yao

I have managed to link the VM to my comp via port forwading, What I have not been able to do is to get the odk agreggate log in webpage.
Instead, I have got this error message.

Awaiting Redirect
If you are not redirected, please click here. If the server has not been accessed recently, this may take a few moments.

Here is the link to my web link url.

http://192.168.5.29/openid_login.html?redirect=http%3A%2F%2F192.168.5.29%3A8080%2FAggregate.html

When I click here, I get...

The connection was reset
The connection to the server was reset while the page was loading.
The site could be temporarily unavailable or too busy. Try again in a few
moments.
If you are unable to load any pages, check your computer's network
connection.
If your computer or network is protected by a firewall or proxy, make sure
that Firefox is permitted to access the Web

What is your advice?

Regards;
Stephen Karuru Maina

As noted here: https://opendatakit.org/use/aggregate/

The password is 'aggregate'

··· On Wed, Dec 17, 2014 at 3:43 AM, wrote: > > > > On Saturday, February 16, 2013 6:20:39 PM UTC+2, Yaw Anokwa wrote: >> >> You must have a pre-existing MySQL database called odk-prod. Either >> delete that database or in the Aggregate installer, use a different >> database name. >> >> If you are having trouble installing Aggregate, you can also try the >> ODK Aggregate VM at http://gum.co/odk-aggregate-vm. The VM is a >> fully-configured version of Aggregate that runs on any computer. It >> requires very little setup, works great offline, and gives you >> complete control of where your data goes. >> >> For offline XML to CSV conversion, use ODK Briefcase. >> http://opendatakit.org/use/briefcase/ >> >> Yaw >> -- >> Need ODK help? Go to http://nafundi.com for custom development, >> professional support, form design, implementation advice, and user >> training for ODK. >> >> >> On Sat, Feb 16, 2013 at 3:58 AM, Maina karuru wrote: >> > ________________________________ >> > >> > >> > Yao >> > >> > I have been trying to set up a local server for the odk by installing >> the >> > ODK Aggregate v1.3.0 windows-installer. >> > I have tomcat v6 and mysql already installed in my comp. >> > >> > I have been following these steps >> > http://code.google.com/p/crossriver-openhds/wiki/ >> OpenDataKitInstallation >> > >> > unfortunately, when i get to the last step and try to implement the >> steps >> > below, I get two errors in the command window which I suspect are >> making me >> > not be able to run the odk aggregate server >> > >> > Error 1007 ; can't create a database 'odk-prod'; database >> already >> > exists >> > Error 1397 ; Operation CREATE USER failed for 'odk_user' @ >> 'local >> > host' >> > >> > I expect to have the above statement to be as highlighted in yellow >> below >> > >> > what could be the problem? >> > >> > >> > I would wish to know whether there is an alternative for converting the >> xml >> > forms with data into csv format on my personal comp. >> > >> > my comp is running on windows 7 >> > >> > Regards >> > Karuru >> > >> > >> > >> > >> > >> > To complete the installation, you need to: >> > >> > Execute the mysql (mysql.exe) commandline client using the root account >> and >> > password (the password you chose during the installation of the >> database), >> > and supply the create_db_and_user.sql to it. >> > To open the mysql commandline client, open a cmd window (Windows), >> terminal >> > window (MacOS) or term window (Linux) and 'cd' to the directory >> containing >> > the mysql client (mysql.exe on Windows). Then, please type: >> > >> > mysql --user root --password >> > >> > And enter the MySQL server root password. You will then be within the >> mysql >> > commandline client. You should see a 'mysql>' prompt. Type: >> > >> > source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK >> > Aggregate/create_db_and_user.sql >> > exit >> > >> > Here is what this looks like on Windows, with what you must type in >> red: >> > >> > Microsoft Windows [Version 6.1.7600] >> > Copyright (c) 2009 Microsoft Corporation. All rights reserved. >> > >> > C:\Windows\System32>cd "\Program Files\MySQL\MySQL Server 5.1\bin" >> > >> > C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql.exe --user root >> --password >> > Enter password: ******* >> > Welcome to the MySQL monitor. Commands end with ; or \g. >> > Your MySQL connection id is 13 >> > Server version: 5.1.47-community MySQL Community Server (GPL) >> > >> > Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights >> reserved. >> > This software comes with ABSOLUTELY NO WARRANTY. This is free software, >> > and you are welcome to modify and redistribute it under the GPL v2 >> license >> > >> > Type 'help;' or '\h' for help. Type '\c' to clear the current input >> > statement. >> > >> > mysql> source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK >> > Aggregate/create_db_and_user.sql >> > Query OK, 1 row affected (0.00 sec) >> > >> > Query OK, 0 rows affected (0.00 sec) >> > >> > Query OK, 0 rows affected (0.00 sec) >> > >> > Query OK, 0 rows affected (0.00 sec) >> > >> > mysql> exit >> > Bye >> > >> > C:\Program Files\MySQL\MySQL Server 5.1\bin> >> > >> > copy the ODKAggregate.war to the \webapps directory of the Apache >> Tomcat >> > installation. >> > start Apache (if not already started) >> > visit http://karuru-pc:8080/ODKAggregate/ and go to the Management / >> > Permissions tab to complete configuring the access rights for ODK >> Aggregate. >> > NOTE: It may take a few moments for the Apache Tomcat server to detect >> the >> > ODKAggregate.war; if you get a 404 error, wait a few moments then >> refresh >> > your browser. >> > >> > If you want ODKAggregate to be reached at just http://Karuru-PC:8080/, >> you >> > can rename it to ROOT.war before copying it to the \webapps directory. >> > >> > Regards; >> > Stephen Karuru Maina >> > https://profiles.google.com/TheKarurus >> > >> > >> > > please Karuru, > > i have a local ODK server non connected to the internet, i have mysql 5.5 > and odk aggregate 1.4.4 and tomcat 6 > > everything is working fine, tomcat login page and the server status and > the manager too. > sql is working fine and running, set the d:/source .... in my sql > .war file is also in it's place and the connector also, > > the problem that i have is that after running tomcat server and open the > http://192.168.0.100:8080/ODKAggregate/ page, > > i enter the username which i set up in the odk aggregate setup (admin) > > what would be the pass? > is this the correct username that i'm entering? > what would be the default password? > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. >

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

Also, if you are getting errors during start-up (before the login page is
shown) when running under Tomcat with MySQL, it is likely that you did not
download the MySQL Connector/J and place it in the Tomcat lib directory.

For setting up your network, our installation documentation may be helpful:
http://opendatakit.org/use/aggregate/tomcat-install/

··· On Sun, Feb 17, 2013 at 7:37 AM, Yaw Anokwa wrote:

Please don't attach such big files to the email. Many on this list are in
low-bandwidth settings, so we prefer you attach it to an issue at
https://code.google.com/p/opendatakit/issues/list.

Your Google account login will not work because you did not enter a fully
qualified domain name in the Aggregate installer. See
https://code.google.com/p/opendatakit/issues/detail?id=520 for some
suggestions on how to work around this issue.
https://code.google.com/p/opendatakit/wiki/AggregateTroubleshooting is
also a good resource.

As far as the VM, you should not change the OS settings to Windows 7.
Delete both VM and VM_1 and try again. If the VM reports "Network did not
assign this VM an IP" error on startup, it means that the VM is on a
network that did not assign it an IP. Make sure the upstream router assigns
IPs via DHCP. Alternatively, switch the networking in the VM from Bridged
to NAT, but then configure port forwarding on the local computer to enable
external connections to it. Tomcat in the VM listens on port 80.

Yaw

Need ODK help? Go to http://nafundi.com for custom development,
professional support, form design, implementation advice, and user training
for ODK.

On Sun, Feb 17, 2013 at 1:44 AM, Maina karuru stephenkarurum@yahoo.comwrote:

Thank you Yao

following your instructions I have managed to run the cmd to the final
end by changing the name of the database and user names. see the screenprint

But on opening the http://Karuru-PC:8080/ODKAggregate/
I see access denied after loging in with my gmail address and allowing
the pc to access the information.

Alternatively,
I have tries installing the virtual box then run ODK-Aggregate-VM-1.3.0.0
as shown below

The default settings for the os is Obuntu, but I change this to windows 7
and hit import.

This creates a copy VM_1
But when I click the start button

so I hit ok

so I hit ok again and the VM is set to begin

but unfortunately I cannot log in

Regards;
Stephen Karuru Maina


From: Yaw Anokwa yanokwa@nafundi.com
To: "opendatakit@googlegroups.com" opendatakit@googlegroups.com
Cc: Maina karuru stephenkarurum@yahoo.com
Sent: Saturday, February 16, 2013 7:20 PM
Subject: Re: ODK aggregate local server

You must have a pre-existing MySQL database called odk-prod. Either
delete that database or in the Aggregate installer, use a different
database name.

If you are having trouble installing Aggregate, you can also try the
ODK Aggregate VM at http://gum.co/odk-aggregate-vm. The VM is a
fully-configured version of Aggregate that runs on any computer. It
requires very little setup, works great offline, and gives you
complete control of where your data goes.

For offline XML to CSV conversion, use ODK Briefcase.
http://opendatakit.org/use/briefcase/

Yaw

Need ODK help? Go to http://nafundi.com for custom development,
professional support, form design, implementation advice, and user
training for ODK.

On Sat, Feb 16, 2013 at 3:58 AM, Maina karuru stephenkarurum@yahoo.com wrote:


Yao

I have been trying to set up a local server for the odk by installing
the
ODK Aggregate v1.3.0 windows-installer.
I have tomcat v6 and mysql already installed in my comp.

I have been following these steps

http://code.google.com/p/crossriver-openhds/wiki/OpenDataKitInstallation

unfortunately, when i get to the last step and try to implement the
steps
below, I get two errors in the command window which I suspect are
making me
not be able to run the odk aggregate server

Error 1007 ; can't create a database 'odk-prod'; database already
exists
Error 1397 ; Operation CREATE USER failed for 'odk_user' @ 'local
host'

I expect to have the above statement to be as highlighted in yellow
below

what could be the problem?

I would wish to know whether there is an alternative for converting the
xml
forms with data into csv format on my personal comp.

my comp is running on windows 7

Regards
Karuru

To complete the installation, you need to:

Execute the mysql (mysql.exe) commandline client using the root account
and
password (the password you chose during the installation of the
database),
and supply the create_db_and_user.sql to it.
To open the mysql commandline client, open a cmd window (Windows),
terminal
window (MacOS) or term window (Linux) and 'cd' to the directory
containing
the mysql client (mysql.exe on Windows). Then, please type:

mysql --user root --password

And enter the MySQL server root password. You will then be within the
mysql
commandline client. You should see a 'mysql>' prompt. Type:

source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK
Aggregate/create_db_and_user.sql
exit

Here is what this looks like on Windows, with what you must type in red:

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Windows\System32>cd "\Program Files\MySQL\MySQL Server 5.1\bin"

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql.exe --user root
--password
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.1.47-community MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights
reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2
license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK
Aggregate/create_db_and_user.sql
Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

C:\Program Files\MySQL\MySQL Server 5.1\bin>

copy the ODKAggregate.war to the \webapps directory of the Apache Tomcat
installation.
start Apache (if not already started)
visit http://karuru-pc:8080/ODKAggregate/ and go to the Management /
Permissions tab to complete configuring the access rights for ODK
Aggregate.
NOTE: It may take a few moments for the Apache Tomcat server to detect
the
ODKAggregate.war; if you get a 404 error, wait a few moments then
refresh
your browser.

If you want ODKAggregate to be reached at just http://Karuru-PC:8080/http://karuru-pc:8080/,
you
can rename it to ROOT.war before copying it to the \webapps directory.

Regards;
Stephen Karuru Maina
https://profiles.google.com/TheKarurus

--

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


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

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

Whenever you install ODK Aggregate, you need to specify the hostname and
port to which a browser or ODK Collect device will be connect.

In this case, you have set up port forwarding from port 80 on machine
192.168.5.29 to port 8080 on the same machine, and you want people to
connect to ODK Aggregate via port 80.

So when you run the ODK Aggregate installer to generate the war file, you
should specify

HTTP/1.1 Connector Port: 80
Internet-wide IP address or DNS name: 192.168.5.29

during the configuration.

As you have it now, you specified the port on which ODK Aggregate was
listening (port 8080) rather than the port to which web browsers and ODK
Collect devices will be connecting (port 80).

Mitch

··· On Fri, Feb 22, 2013 at 5:11 AM, Maina karuru wrote:

Yao

I have managed to link the VM to my comp via port forwading, What I have
not been able to do is to get the odk agreggate log in webpage.
Instead, I have got this error message.

Awaiting Redirect
If you are not redirected, please click here. If the server has not been
accessed recently, this may take a few moments.

Here is the link to my web link url.

http://192.168.5.29/openid_login.html?redirect=http%3A%2F%2F192.168.5.29%3A8080%2FAggregate.html

When I click here, I get...

The connection was reset
The connection to the server was reset while the page was loading.
The site could be temporarily unavailable or too busy. Try again in a few
moments.
If you are unable to load any pages, check your computer's network
connection.
If your computer or network is protected by a firewall or proxy, make
sure
that Firefox is permitted to access the Web

What is your advice?

Regards;
Stephen Karuru Maina

--

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


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

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

i managed to enter the page by logging in with google mail password and
then adding the admin user :smiley:

thanks for your reply!

··· On Wed, Dec 17, 2014 at 8:15 PM, Mitch Sundt wrote: > > As noted here: https://opendatakit.org/use/aggregate/ > > The password is 'aggregate' > > > On Wed, Dec 17, 2014 at 3:43 AM, wrote: > >> >> >> On Saturday, February 16, 2013 6:20:39 PM UTC+2, Yaw Anokwa wrote: >>> >>> You must have a pre-existing MySQL database called odk-prod. Either >>> delete that database or in the Aggregate installer, use a different >>> database name. >>> >>> If you are having trouble installing Aggregate, you can also try the >>> ODK Aggregate VM at http://gum.co/odk-aggregate-vm. The VM is a >>> fully-configured version of Aggregate that runs on any computer. It >>> requires very little setup, works great offline, and gives you >>> complete control of where your data goes. >>> >>> For offline XML to CSV conversion, use ODK Briefcase. >>> http://opendatakit.org/use/briefcase/ >>> >>> Yaw >>> -- >>> Need ODK help? Go to http://nafundi.com for custom development, >>> professional support, form design, implementation advice, and user >>> training for ODK. >>> >>> >>> On Sat, Feb 16, 2013 at 3:58 AM, Maina karuru wrote: >>> > ________________________________ >>> > >>> > >>> > Yao >>> > >>> > I have been trying to set up a local server for the odk by installing >>> the >>> > ODK Aggregate v1.3.0 windows-installer. >>> > I have tomcat v6 and mysql already installed in my comp. >>> > >>> > I have been following these steps >>> > http://code.google.com/p/crossriver-openhds/wiki/ >>> OpenDataKitInstallation >>> > >>> > unfortunately, when i get to the last step and try to implement the >>> steps >>> > below, I get two errors in the command window which I suspect are >>> making me >>> > not be able to run the odk aggregate server >>> > >>> > Error 1007 ; can't create a database 'odk-prod'; database >>> already >>> > exists >>> > Error 1397 ; Operation CREATE USER failed for 'odk_user' @ >>> 'local >>> > host' >>> > >>> > I expect to have the above statement to be as highlighted in yellow >>> below >>> > >>> > what could be the problem? >>> > >>> > >>> > I would wish to know whether there is an alternative for converting >>> the xml >>> > forms with data into csv format on my personal comp. >>> > >>> > my comp is running on windows 7 >>> > >>> > Regards >>> > Karuru >>> > >>> > >>> > >>> > >>> > >>> > To complete the installation, you need to: >>> > >>> > Execute the mysql (mysql.exe) commandline client using the root >>> account and >>> > password (the password you chose during the installation of the >>> database), >>> > and supply the create_db_and_user.sql to it. >>> > To open the mysql commandline client, open a cmd window (Windows), >>> terminal >>> > window (MacOS) or term window (Linux) and 'cd' to the directory >>> containing >>> > the mysql client (mysql.exe on Windows). Then, please type: >>> > >>> > mysql --user root --password >>> > >>> > And enter the MySQL server root password. You will then be within the >>> mysql >>> > commandline client. You should see a 'mysql>' prompt. Type: >>> > >>> > source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK >>> > Aggregate/create_db_and_user.sql >>> > exit >>> > >>> > Here is what this looks like on Windows, with what you must type in >>> red: >>> > >>> > Microsoft Windows [Version 6.1.7600] >>> > Copyright (c) 2009 Microsoft Corporation. All rights reserved. >>> > >>> > C:\Windows\System32>cd "\Program Files\MySQL\MySQL Server 5.1\bin" >>> > >>> > C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql.exe --user root >>> --password >>> > Enter password: ******* >>> > Welcome to the MySQL monitor. Commands end with ; or \g. >>> > Your MySQL connection id is 13 >>> > Server version: 5.1.47-community MySQL Community Server (GPL) >>> > >>> > Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights >>> reserved. >>> > This software comes with ABSOLUTELY NO WARRANTY. This is free >>> software, >>> > and you are welcome to modify and redistribute it under the GPL v2 >>> license >>> > >>> > Type 'help;' or '\h' for help. Type '\c' to clear the current input >>> > statement. >>> > >>> > mysql> source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK >>> > Aggregate/create_db_and_user.sql >>> > Query OK, 1 row affected (0.00 sec) >>> > >>> > Query OK, 0 rows affected (0.00 sec) >>> > >>> > Query OK, 0 rows affected (0.00 sec) >>> > >>> > Query OK, 0 rows affected (0.00 sec) >>> > >>> > mysql> exit >>> > Bye >>> > >>> > C:\Program Files\MySQL\MySQL Server 5.1\bin> >>> > >>> > copy the ODKAggregate.war to the \webapps directory of the Apache >>> Tomcat >>> > installation. >>> > start Apache (if not already started) >>> > visit http://karuru-pc:8080/ODKAggregate/ and go to the Management / >>> > Permissions tab to complete configuring the access rights for ODK >>> Aggregate. >>> > NOTE: It may take a few moments for the Apache Tomcat server to detect >>> the >>> > ODKAggregate.war; if you get a 404 error, wait a few moments then >>> refresh >>> > your browser. >>> > >>> > If you want ODKAggregate to be reached at just http://Karuru-PC:8080/, >>> you >>> > can rename it to ROOT.war before copying it to the \webapps directory. >>> > >>> > Regards; >>> > Stephen Karuru Maina >>> > https://profiles.google.com/TheKarurus >>> > >>> > >>> >> >> please Karuru, >> >> i have a local ODK server non connected to the internet, i have mysql 5.5 >> and odk aggregate 1.4.4 and tomcat 6 >> >> everything is working fine, tomcat login page and the server status and >> the manager too. >> sql is working fine and running, set the d:/source .... in my sql >> .war file is also in it's place and the connector also, >> >> the problem that i have is that after running tomcat server and open the >> http://192.168.0.100:8080/ODKAggregate/ page, >> >> i enter the username which i set up in the odk aggregate setup (admin) >> >> what would be the pass? >> is this the correct username that i'm entering? >> what would be the default password? >> >> -- >> -- >> Post: opendatakit@googlegroups.com >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "ODK Community" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to opendatakit+unsubscribe@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitchellsundt@gmail.com > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to a topic in the > Google Groups "ODK Community" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/opendatakit/trBZuMxm2s8/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. >

Please how do i configure my mobile phone (ODK Collect app) to access my ODK Aggregate ON my local PostgreSQL server http://127.0.0.1:8080/ODKAggregate

See https://opendatakit.org/use/aggregate/tomcat-install/

You cannot access it via 127.0.0.1 ; that has special meaning and refers to
"myself" -- i.e., the computer/mobile phone on which you are entering the
value.

The instructions discuss how to configure your network to enable you to
access your computer from your device.

··· On Tue, Feb 17, 2015 at 3:03 AM, wrote:

Please how do i configure my mobile phone (ODK Collect app) to access my
ODK Aggregate ON my local PostgreSQL server
http://127.0.0.1:8080/ODKAggregate

--

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


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

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

Thanks very much, so i f I configure it on an IP of 192.168.1.104 it will
work??

··· On Feb 17, 2015 6:08 PM, "Mitch Sundt" wrote:

See https://opendatakit.org/use/aggregate/tomcat-install/

You cannot access it via 127.0.0.1 ; that has special meaning and refers
to "myself" -- i.e., the computer/mobile phone on which you are entering
the value.

The instructions discuss how to configure your network to enable you to
access your computer from your device.

On Tue, Feb 17, 2015 at 3:03 AM, senyoab@gmail.com wrote:

Please how do i configure my mobile phone (ODK Collect app) to access my
ODK Aggregate ON my local PostgreSQL server
http://127.0.0.1:8080/ODKAggregate

--

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


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

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

--

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


You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/trBZuMxm2s8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

That is a private network address, only visible from within the router /
wifi access point that your computer is connected to.

i.e., your device won't be able to see the computer when connecting via a
cellular network connection or a wifi hotspot elsewhere in the city.

··· On Tue, Feb 17, 2015 at 12:46 PM, senyo aborgah wrote:

Thanks very much, so i f I configure it on an IP of 192.168.1.104 it will
work??
On Feb 17, 2015 6:08 PM, "Mitch Sundt" mitchellsundt@gmail.com wrote:

See https://opendatakit.org/use/aggregate/tomcat-install/

You cannot access it via 127.0.0.1 ; that has special meaning and refers
to "myself" -- i.e., the computer/mobile phone on which you are entering
the value.

The instructions discuss how to configure your network to enable you to
access your computer from your device.

On Tue, Feb 17, 2015 at 3:03 AM, senyoab@gmail.com wrote:

Please how do i configure my mobile phone (ODK Collect app) to access my
ODK Aggregate ON my local PostgreSQL server
http://127.0.0.1:8080/ODKAggregate

--

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


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

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

--

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


You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/trBZuMxm2s8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

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


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

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