Announcing the ODK Aggregate VM!

As you might already know, ODK Aggregate allows users to download
blank forms and upload completed forms. Aggregate also enables users
to visualize, export and publish form data.

Aggregate can be installed on a local server or in the cloud, but many
users find local servers hard to configure or find the cloud insecure.
At Nafundi, we think we have found a better way through the ODK
Aggregate VM (http://gum.co/odk-aggregate-vm).

The ODK Aggregate VM (virtual machine) solves many of the challenges
of deployment because it is a fully-configured install of Aggregate
that you can run on any computer (desktop, laptop, server). The VM
requires very little setup, works well without Internet connectivity,
and gives you complete control over your data collection campaign.

If you are new to ODK, the VM is a great way to get started with
Aggregate v1.3. In a few clicks, you can have the entire server
running locally on your computer.

If you are an implementer, the VM is the easiest way to get the power
and flexibility of Aggregate without Internet access. You can even
connect your reporting tools to the underlying MySQL database.

If you are a developer, the VM is a perfect test environment. Take
snapshots before you try something totally new. If something goes
wrong, revert easily.

Regardless of who you are, we think the ODK Aggregate VM is a great
way to run Aggregate v1.3. Try it today at
http://gum.co/odk-aggregate-vm!

Yaw

Hi Yaw,

That's very cool! Thanks for making this available. Could you perhaps
explain a little about how this VM is deployed locally? Is it using
VirtualBox?

Cheers,
Martijn

··· On Monday, February 4, 2013 1:16:33 PM UTC-7, Yaw Anokwa wrote: > > As you might already know, ODK Aggregate allows users to download > blank forms and upload completed forms. Aggregate also enables users > to visualize, export and publish form data. > > Aggregate can be installed on a local server or in the cloud, but many > users find local servers hard to configure or find the cloud insecure. > At Nafundi, we think we have found a better way through the ODK > Aggregate VM (http://gum.co/odk-aggregate-vm). > > The ODK Aggregate VM (virtual machine) solves many of the challenges > of deployment because it is a fully-configured install of Aggregate > that you can run on any computer (desktop, laptop, server). The VM > requires very little setup, works well without Internet connectivity, > and gives you complete control over your data collection campaign. > > If you are new to ODK, the VM is a great way to get started with > Aggregate v1.3. In a few clicks, you can have the entire server > running locally on your computer. > > If you are an implementer, the VM is the easiest way to get the power > and flexibility of Aggregate without Internet access. You can even > connect your reporting tools to the underlying MySQL database. > > If you are a developer, the VM is a perfect test environment. Take > snapshots before you try something totally new. If something goes > wrong, revert easily. > > Regardless of who you are, we think the ODK Aggregate VM is a great > way to run Aggregate v1.3. Try it today at > http://gum.co/odk-aggregate-vm! > > Yaw >

Congratulations Yaw! I tested it and it perfectly works. Is it possible if
we could set https rather than http and set the public ip address as well?
And how can we do the data backup? Thanks.

··· On Tuesday, February 5, 2013 3:16:33 AM UTC+7, Yaw Anokwa wrote: > > As you might already know, ODK Aggregate allows users to download > blank forms and upload completed forms. Aggregate also enables users > to visualize, export and publish form data. > > Aggregate can be installed on a local server or in the cloud, but many > users find local servers hard to configure or find the cloud insecure. > At Nafundi, we think we have found a better way through the ODK > Aggregate VM (http://gum.co/odk-aggregate-vm). > > The ODK Aggregate VM (virtual machine) solves many of the challenges > of deployment because it is a fully-configured install of Aggregate > that you can run on any computer (desktop, laptop, server). The VM > requires very little setup, works well without Internet connectivity, > and gives you complete control over your data collection campaign. > > If you are new to ODK, the VM is a great way to get started with > Aggregate v1.3. In a few clicks, you can have the entire server > running locally on your computer. > > If you are an implementer, the VM is the easiest way to get the power > and flexibility of Aggregate without Internet access. You can even > connect your reporting tools to the underlying MySQL database. > > If you are a developer, the VM is a perfect test environment. Take > snapshots before you try something totally new. If something goes > wrong, revert easily. > > Regardless of who you are, we think the ODK Aggregate VM is a great > way to run Aggregate v1.3. Try it today at > http://gum.co/odk-aggregate-vm! > > Yaw >

Nice! Can't wait to try it

··· On Monday, 4 February 2013 23:16:33 UTC+3, Yaw Anokwa wrote: > > As you might already know, ODK Aggregate allows users to download > blank forms and upload completed forms. Aggregate also enables users > to visualize, export and publish form data. > > Aggregate can be installed on a local server or in the cloud, but many > users find local servers hard to configure or find the cloud insecure. > At Nafundi, we think we have found a better way through the ODK > Aggregate VM (http://gum.co/odk-aggregate-vm). > > The ODK Aggregate VM (virtual machine) solves many of the challenges > of deployment because it is a fully-configured install of Aggregate > that you can run on any computer (desktop, laptop, server). The VM > requires very little setup, works well without Internet connectivity, > and gives you complete control over your data collection campaign. > > If you are new to ODK, the VM is a great way to get started with > Aggregate v1.3. In a few clicks, you can have the entire server > running locally on your computer. > > If you are an implementer, the VM is the easiest way to get the power > and flexibility of Aggregate without Internet access. You can even > connect your reporting tools to the underlying MySQL database. > > If you are a developer, the VM is a perfect test environment. Take > snapshots before you try something totally new. If something goes > wrong, revert easily. > > Regardless of who you are, we think the ODK Aggregate VM is a great > way to run Aggregate v1.3. Try it today at > http://gum.co/odk-aggregate-vm! > > Yaw >

When using AggVM in an environment with no internet access, what is the
best way to sync your collected data from Collect to Aggregate?

In my set up, I am running Agg Vm on my laptop, therefore it it available
over my local network through my router at a class C address like
192.168.1.142/aggregate

This does not require Internet access, but it does require a router and a
local network. What about running without the router and synchronizing
directly between phone and laptop?

☞§※☼:airplane::open_umbrella::slight_smile:
~Neil

··· On Mon, Feb 4, 2013 at 3:16 PM, Yaw Anokwa wrote:

As you might already know, ODK Aggregate allows users to download
blank forms and upload completed forms. Aggregate also enables users
to visualize, export and publish form data.

Aggregate can be installed on a local server or in the cloud, but many
users find local servers hard to configure or find the cloud insecure.
At N...

Thanks so much for putting this together.
I've installed the VM and am running it.
I wanted to use Mirth along with ODK so I installed Mirth (and Java6) in
the VM also.
I can get both ODK Aggregate and Mirth to run but I'm having problems
setting up a channel in Mirth.
I am following the instructions here:
http://code.google.com/p/crossriver-openhds/wiki/CreateMirthChannel
But, I can't connect to the database...
I have used both jdbc:mysql://localhost/odk_prod
and jdbc:mysql://192.168.0.43/odk_prod as the URL for the database,
assuming that the port is the standard 3306 for ODK MySQL... is this
correct?
Once (if) I get this working, I'll send you the new VM.

That's so easy to install !

Great.... But one thing, i don't understand is this sentence: " works well
without Internet connectivity"as Yaw said.
How can i use it without any internet connectivity? At least mine's not
worked.. So i need your little help to understand it n to solve it...

Palak

Martijn,

You can deploy it using VirtualBox which is free and available on all
platforms. It is also compatible with VMWare Player (free) and VMWare
Fusion (not free). Depending on the feedback we receive, we may also
build one for EC2 as well.

If you have more technical questions, glad to answer those on the
opendatakit-developers@googlegroups.com list.

Yaw

··· On Mon, Feb 4, 2013 at 4:49 PM, Martijn van de Rijdt wrote: > Hi Yaw, > > That's very cool! Thanks for making this available. Could you perhaps > explain a little about how this VM is deployed locally? Is it using > VirtualBox? > > Cheers, > Martijn > > > On Monday, February 4, 2013 1:16:33 PM UTC-7, Yaw Anokwa wrote: >> >> As you might already know, ODK Aggregate allows users to download >> blank forms and upload completed forms. Aggregate also enables users >> to visualize, export and publish form data. >> >> Aggregate can be installed on a local server or in the cloud, but many >> users find local servers hard to configure or find the cloud insecure. >> At Nafundi, we think we have found a better way through the ODK >> Aggregate VM (http://gum.co/odk-aggregate-vm). >> >> The ODK Aggregate VM (virtual machine) solves many of the challenges >> of deployment because it is a fully-configured install of Aggregate >> that you can run on any computer (desktop, laptop, server). The VM >> requires very little setup, works well without Internet connectivity, >> and gives you complete control over your data collection campaign. >> >> If you are new to ODK, the VM is a great way to get started with >> Aggregate v1.3. In a few clicks, you can have the entire server >> running locally on your computer. >> >> If you are an implementer, the VM is the easiest way to get the power >> and flexibility of Aggregate without Internet access. You can even >> connect your reporting tools to the underlying MySQL database. >> >> If you are a developer, the VM is a perfect test environment. Take >> snapshots before you try something totally new. If something goes >> wrong, revert easily. >> >> Regardless of who you are, we think the ODK Aggregate VM is a great >> way to run Aggregate v1.3. Try it today at >> http://gum.co/odk-aggregate-vm! >> >> Yaw > > -- > -- > 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. > >

Hi Martijn,

It uses VirtualBox and it is easy to deploy this VM locally by extracting
the file to the server. It is copy and paste actually.

Cheers,
Chan Choth

··· On Tuesday, February 5, 2013 7:49:30 AM UTC+7, Martijn van de Rijdt wrote: > > Hi Yaw, > > That's very cool! Thanks for making this available. Could you perhaps > explain a little about how this VM is deployed locally? Is it using > VirtualBox? > > Cheers, > Martijn > > > On Monday, February 4, 2013 1:16:33 PM UTC-7, Yaw Anokwa wrote: >> >> As you might already know, ODK Aggregate allows users to download >> blank forms and upload completed forms. Aggregate also enables users >> to visualize, export and publish form data. >> >> Aggregate can be installed on a local server or in the cloud, but many >> users find local servers hard to configure or find the cloud insecure. >> At Nafundi, we think we have found a better way through the ODK >> Aggregate VM (http://gum.co/odk-aggregate-vm). >> >> The ODK Aggregate VM (virtual machine) solves many of the challenges >> of deployment because it is a fully-configured install of Aggregate >> that you can run on any computer (desktop, laptop, server). The VM >> requires very little setup, works well without Internet connectivity, >> and gives you complete control over your data collection campaign. >> >> If you are new to ODK, the VM is a great way to get started with >> Aggregate v1.3. In a few clicks, you can have the entire server >> running locally on your computer. >> >> If you are an implementer, the VM is the easiest way to get the power >> and flexibility of Aggregate without Internet access. You can even >> connect your reporting tools to the underlying MySQL database. >> >> If you are a developer, the VM is a perfect test environment. Take >> snapshots before you try something totally new. If something goes >> wrong, revert easily. >> >> Regardless of who you are, we think the ODK Aggregate VM is a great >> way to run Aggregate v1.3. Try it today at >> http://gum.co/odk-aggregate-vm! >> >> Yaw >> >

Chan,

Glad it's working for you! Easy ways to enable HTTPS and the ability
to configure the public IP are features we are considering for the
next release. I have filed them in our issue tracker so I don't
forget.

Until that release happens, you can treat the VM like any other
server. So, use the credentials provided in the readme to log into the
command line UI of the VM and configure it as you wish.
http://opendatakit.org/use/aggregate/tomcat-install/ will be of help.

Thanks,

Yaw

··· On Mon, Feb 4, 2013 at 7:00 PM, Chan Choth wrote: > Congratulations Yaw! I tested it and it perfectly works. Is it possible if > we could set https rather than http and set the public ip address as well? > And how can we do the data backup? Thanks.

Good question.

On most computers you can setup an adhoc network and connect your
devices to your computer that way.


You can also use Briefcase on your computer, pull the data that way
via USB, and push it to your VM (on the same computer).

Yaw

··· On Thu, Feb 7, 2013 at 9:56 AM, Neil Hendrick wrote: > When using AggVM in an environment with no internet access, what is the best > way to sync your collected data from Collect to Aggregate? > > In my set up, I am running Agg Vm on my laptop, therefore it it available > over my local network through my router at a class C address like > 192.168.1.142/aggregate > > This does not require Internet access, but it does require a router and a > local network. What about running without the router and synchronizing > directly between phone and laptop? > > ☞§※☼✈☂☻ > ~Neil > > > On Mon, Feb 4, 2013 at 3:16 PM, Yaw Anokwa wrote: >> >> As you might already know, ODK Aggregate allows users to download >> blank forms and upload completed forms. Aggregate also enables users >> to visualize, export and publish form data. >> >> Aggregate can be installed on a local server or in the cloud, but many >> users find local servers hard to configure or find the cloud insecure. >> At N... > > -- > 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. > >

The thing with the Ad Hoc network is that it is for file transfer, and not
for web hosting.
You need your Aggregate VM to be assigned an IP address, so you need your
laptop to act as a router with DHCP.
I'm going to look into this with more detail as I think this is something
that should work, if anyone has any thoughts, let's see if we can come up
with a good solution.
~Neil

[image: Inline image 1]

☞§※☼:airplane::open_umbrella::slight_smile:
~Neil

image

··· On Thu, Feb 7, 2013 at 1:08 PM, Yaw Anokwa wrote:

Good question.

On most computers you can setup an adhoc network and connect your
devices to your computer that way.
http://lifehacker.com/280002/turn-your-laptop-into-a-wireless-hot-spot
http://lifehacker.com/283088/share-your-macs-internet-connection-wirelessly

You can also use Briefcase on your computer, pull the data that way
via USB, and push it to your VM (on the same computer).

Yaw

On Thu, Feb 7, 2013 at 9:56 AM, Neil Hendrick mojotexas@gmail.com wrote:

When using AggVM in an environment with no internet access, what is the
best
way to sync your collected data from Collect to Aggregate?

In my set up, I am running Agg Vm on my laptop, therefore it it available
over my local network through my router at a class C address like
192.168.1.142/aggregate

This does not require Internet access, but it does require a router and a
local network. What about running without the router and synchronizing
directly between phone and laptop?

☞§※☼:airplane::open_umbrella::slight_smile:
~Neil

On Mon, Feb 4, 2013 at 3:16 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

As you might already know, ODK Aggregate allows users to download
blank forms and upload completed forms. Aggregate also enables users
to visualize, export and publish form data.

Aggregate can be installed on a local server or in the cloud, but many
users find local servers hard to configure or find the cloud insecure.
At N...

--
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.

--

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.

Mark,

The database is called 'aggregate'. To confirm this, log into the VM's
command line with the credentials in the readme. Then login using
'mysql -u root -p' and run 'show databases' to get a list of
databases.

I'm also pretty sure MySQL doesn't allow connections outside of
localhost so you might have to configure your mysql user to allow
those connections (less secure) or connect over SSH (more secure).

Yaw

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

On Wed, Feb 13, 2013 at 2:04 PM, Mark Spohr mhspohr@gmail.com wrote:

Thanks so much for putting this together.
I've installed the VM and am running it.
I wanted to use Mirth along with ODK so I installed Mirth (and Java6) in the
VM also.
I can get both ODK Aggregate and Mirth to run but I'm having problems
setting up a channel in Mirth.
I am following the instructions here:
http://code.google.com/p/crossriver-openhds/wiki/CreateMirthChannel
But, I can't connect to the database...
I have used both jdbc:mysql://localhost/odk_prod and
jdbc:mysql://192.168.0.43/odk_prod as the URL for the database, assuming
that the port is the standard 3306 for ODK MySQL... is this correct?
Once (if) I get this working, I'll send you the new VM.

--

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.

Palak,

Please don't post to both lists.

The VM works without Internet connectivity, but you need IP
connectivity (usually WiFi) to connect ODK Collect to ODK Aggregate
running in VM.

Thanks,

Yaw

··· -- Need ODK services? Go to http://nafundi.com for form design, data cleaning, custom reporting, and software development for ODK.

On Thu, Aug 1, 2013 at 2:05 PM, Palak Darji palaksdarji@gmail.com wrote:

That's so easy to install !

Great.... But one thing, i don't understand is this sentence: " works well
without Internet connectivity"as Yaw said.
How can i use it without any internet connectivity? At least mine's not
worked.. So i need your little help to understand it n to solve it...

Palak

--

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.

Does it play well with ODK Survey?

☞§※☼:airplane::open_umbrella::slight_smile:
~Neil

Hello Yaw,

I have downloaded and installed ODK Aggregate Virtual machine(VM) in my
machine and everything is working fine. I have submitted two forms to the
VM through ODK Briefcase and form data is submitted successfully. I need to
verify the form data in Database in VM. How can i check the submitted form
data in VM? Please help me.

Thanks
Avadhani Ramakrishna.

··· On Tuesday, 5 February 2013 14:12:59 UTC+5:30, Chan Choth Puth wrote: > > Hi Martijn, > > It uses VirtualBox and it is easy to deploy this VM locally by extracting > the file to the server. It is copy and paste actually. > > Cheers, > Chan Choth > > On Tuesday, February 5, 2013 7:49:30 AM UTC+7, Martijn van de Rijdt wrote: >> >> Hi Yaw, >> >> That's very cool! Thanks for making this available. Could you perhaps >> explain a little about how this VM is deployed locally? Is it using >> VirtualBox? >> >> Cheers, >> Martijn >> >> >> On Monday, February 4, 2013 1:16:33 PM UTC-7, Yaw Anokwa wrote: >>> >>> As you might already know, ODK Aggregate allows users to download >>> blank forms and upload completed forms. Aggregate also enables users >>> to visualize, export and publish form data. >>> >>> Aggregate can be installed on a local server or in the cloud, but many >>> users find local servers hard to configure or find the cloud insecure. >>> At Nafundi, we think we have found a better way through the ODK >>> Aggregate VM (http://gum.co/odk-aggregate-vm). >>> >>> The ODK Aggregate VM (virtual machine) solves many of the challenges >>> of deployment because it is a fully-configured install of Aggregate >>> that you can run on any computer (desktop, laptop, server). The VM >>> requires very little setup, works well without Internet connectivity, >>> and gives you complete control over your data collection campaign. >>> >>> If you are new to ODK, the VM is a great way to get started with >>> Aggregate v1.3. In a few clicks, you can have the entire server >>> running locally on your computer. >>> >>> If you are an implementer, the VM is the easiest way to get the power >>> and flexibility of Aggregate without Internet access. You can even >>> connect your reporting tools to the underlying MySQL database. >>> >>> If you are a developer, the VM is a perfect test environment. Take >>> snapshots before you try something totally new. If something goes >>> wrong, revert easily. >>> >>> Regardless of who you are, we think the ODK Aggregate VM is a great >>> way to run Aggregate v1.3. Try it today at >>> http://gum.co/odk-aggregate-vm! >>> >>> Yaw >>> >>

On Windows, if you have the virtual network router configure the AggVM at a
fixed IP address off its router subnet, then you should be able to define
the routing to it via the configuration files in
C:\Windows\System32\drivers\etc\ (i.e., hosts, networks). These are good
old Unix network routing files.

I haven't set this up myself. It may require the AggVM be given a DNS name
and static IP in order to put the route into the hosts file. Not sure
whether this will all 'just work' with the AggVM or if it requires some
fiddling.

As long as the ad-hoc network relies on your laptop for the DNS gateway
functionality, it will first apply the ...\etc files then attempt to
resolve locations via its registered DNS gateway.

Mitch

image

··· On Thu, Feb 7, 2013 at 2:18 PM, Neil Hendrick wrote:

The thing with the Ad Hoc network is that it is for file transfer, and not
for web hosting.
You need your Aggregate VM to be assigned an IP address, so you need your
laptop to act as a router with DHCP.
I'm going to look into this with more detail as I think this is something
that should work, if anyone has any thoughts, let's see if we can come up
with a good solution.
~Neil

[image: Inline image 1]

☞§※☼:airplane::open_umbrella::slight_smile:
~Neil

On Thu, Feb 7, 2013 at 1:08 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Good question.

On most computers you can setup an adhoc network and connect your
devices to your computer that way.
http://lifehacker.com/280002/turn-your-laptop-into-a-wireless-hot-spot

http://lifehacker.com/283088/share-your-macs-internet-connection-wirelessly

You can also use Briefcase on your computer, pull the data that way
via USB, and push it to your VM (on the same computer).

Yaw

On Thu, Feb 7, 2013 at 9:56 AM, Neil Hendrick mojotexas@gmail.com wrote:

When using AggVM in an environment with no internet access, what is the
best
way to sync your collected data from Collect to Aggregate?

In my set up, I am running Agg Vm on my laptop, therefore it it
available
over my local network through my router at a class C address like
192.168.1.142/aggregate

This does not require Internet access, but it does require a router and
a
local network. What about running without the router and synchronizing
directly between phone and laptop?

☞§※☼:airplane::open_umbrella::slight_smile:
~Neil

On Mon, Feb 4, 2013 at 3:16 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

As you might already know, ODK Aggregate allows users to download
blank forms and upload completed forms. Aggregate also enables users
to visualize, export and publish form data.

Aggregate can be installed on a local server or in the cloud, but many
users find local servers hard to configure or find the cloud insecure.
At N...

--
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.

--

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.

--

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

Neil,

Another option on Windows is to turn on ad-hoc mode on your machine. Assign
it a static IP and assign static IPs to your phones. Now your phones should
be able to ping your machine over this IP network.

Next, go into VirtualBox's networking settings and switch the VM from
bridged to NAT. That'll get you an IP without needing DHCP or a router.
Then, use port forwarding to route port 80 traffic from your machine to the
VM.

Again this is more of an advanced use-case, but it should work.

Yaw

image

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

On Thu, Feb 7, 2013 at 2:51 PM, Mitch S mitchellsundt@gmail.com wrote:

On Windows, if you have the virtual network router configure the AggVM at
a fixed IP address off its router subnet, then you should be able to define
the routing to it via the configuration files in
C:\Windows\System32\drivers\etc\ (i.e., hosts, networks). These are good
old Unix network routing files.

I haven't set this up myself. It may require the AggVM be given a DNS name
and static IP in order to put the route into the hosts file. Not sure
whether this will all 'just work' with the AggVM or if it requires some
fiddling.

As long as the ad-hoc network relies on your laptop for the DNS gateway
functionality, it will first apply the ...\etc files then attempt to
resolve locations via its registered DNS gateway.

Mitch

On Thu, Feb 7, 2013 at 2:18 PM, Neil Hendrick mojotexas@gmail.com wrote:

The thing with the Ad Hoc network is that it is for file transfer, and
not for web hosting.
You need your Aggregate VM to be assigned an IP address, so you need your
laptop to act as a router with DHCP.
I'm going to look into this with more detail as I think this is something
that should work, if anyone has any thoughts, let's see if we can come up
with a good solution.
~Neil

[image: Inline image 1]

☞§※☼:airplane::open_umbrella::slight_smile:
~Neil

On Thu, Feb 7, 2013 at 1:08 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Good question.

On most computers you can setup an adhoc network and connect your
devices to your computer that way.
http://lifehacker.com/280002/turn-your-laptop-into-a-wireless-hot-spot

http://lifehacker.com/283088/share-your-macs-internet-connection-wirelessly

You can also use Briefcase on your computer, pull the data that way
via USB, and push it to your VM (on the same computer).

Yaw

On Thu, Feb 7, 2013 at 9:56 AM, Neil Hendrick mojotexas@gmail.com wrote:

When using AggVM in an environment with no internet access, what is
the best
way to sync your collected data from Collect to Aggregate?

In my set up, I am running Agg Vm on my laptop, therefore it it
available
over my local network through my router at a class C address like
192.168.1.142/aggregate

This does not require Internet access, but it does require a router
and a
local network. What about running without the router and synchronizing
directly between phone and laptop?

☞§※☼:airplane::open_umbrella::slight_smile:
~Neil

On Mon, Feb 4, 2013 at 3:16 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

As you might already know, ODK Aggregate allows users to download
blank forms and upload completed forms. Aggregate also enables users
to visualize, export and publish form data.

Aggregate can be installed on a local server or in the cloud, but many
users find local servers hard to configure or find the cloud insecure.
At N...

--
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.

--

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.

--

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

--

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.

Neil,

What I did on Windows7 is:

Laptop is not connected to any WiFi router or Ethernet cable.
For testing completely offline I used VirtualRouter, and let it use the
Virtualbox adapter.
Change settings in Virtualbox to use Microsoft Virtual WiFi Miniport Adapter
(Bridged Mode).

I've been able to upload forms, download to phone and upload instances back to aggregate.

Nelson

Generally, you want to use localhost in the jdbc setup, as the IP address
192.168.0.43 is dynamically allocated and is therefore brittle.
Note that users other than root must be granted access to databases. You
are perhaps missing that grant?

Mitch

··· On Wed, Feb 13, 2013 at 5:51 PM, Yaw Anokwa wrote:

Mark,

The database is called 'aggregate'. To confirm this, log into the VM's
command line with the credentials in the readme. Then login using
'mysql -u root -p' and run 'show databases' to get a list of
databases.

I'm also pretty sure MySQL doesn't allow connections outside of
localhost so you might have to configure your mysql user to allow
those connections (less secure) or connect over SSH (more secure).

Yaw

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

On Wed, Feb 13, 2013 at 2:04 PM, Mark Spohr mhspohr@gmail.com wrote:

Thanks so much for putting this together.
I've installed the VM and am running it.
I wanted to use Mirth along with ODK so I installed Mirth (and Java6) in
the
VM also.
I can get both ODK Aggregate and Mirth to run but I'm having problems
setting up a channel in Mirth.
I am following the instructions here:
http://code.google.com/p/crossriver-openhds/wiki/CreateMirthChannel
But, I can't connect to the database...
I have used both jdbc:mysql://localhost/odk_prod and
jdbc:mysql://192.168.0.43/odk_prod as the URL for the database, assuming
that the port is the standard 3306 for ODK MySQL... is this correct?
Once (if) I get this working, I'll send you the new VM.

--

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.

--

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