Dear all,
I setted up an instance of Aggregate on an Synology NAS Server, runs
fine... If someone likes to have a description of the steps, feel free to
contact me.
Then I made a data export of the whole database of Aggregate from the
collecting server and imported all data to the new NAS-machine, setted up
whith the same parameters like the first, esp. database name, but with
different FQDN. For the export an import the MySQL Workbench was my friend.
Now I can't access the Aggregate platform, login via Google fails with
"OpenID auth request contains an unregistered domain". Sign in with
Aggregate password with one of the given users fails too. I can see the
_registerd_users table's contents (see pic taken from phpMyAdmin, but....)
No login...
The database has about 17,5 G in ~1.200 submissions, so that the way via
Briefcase would take a very long time.
Any God of Databases out there, who may give me a hint?
Thanks to all.
Gunter
I assume you are using MySQL.
Note that the username for the database account is tied to the IP address
of the requester.
I.e., in order to log in with username 'foo', you need to log in from the
IP address specified in the create_db_and_user.sql script.
That contains something like:
create database odk_prod;
create user 'odk_prod'@'localhost' identified by 'odk_prod';
grant all on odk_prod.* to 'odk_prod'@'localhost' identified by
'odk_prod';
flush privileges;
As you can see, this ties the username 'odk_prod' to ONLY work when logging
in from the same host as the one running the database (localhost).
You can edit this script file and supply the IP address or FQDN of the
webserver, and run it, and it should magically begin working.
···
On Thu, Mar 26, 2015 at 7:26 AM, Gunter Lorek < gunterlorek.gemament@gmail.com> wrote:
Dear all,
I setted up an instance of Aggregate on an Synology NAS Server, runs
fine... If someone likes to have a description of the steps, feel free to
contact me.
Then I made a data export of the whole database of Aggregate from the
collecting server and imported all data to the new NAS-machine, setted up
whith the same parameters like the first, esp. database name, but with
different FQDN. For the export an import the MySQL Workbench was my friend.
Now I can't access the Aggregate platform, login via Google fails with
"OpenID auth request contains an unregistered domain". Sign in with
Aggregate password with one of the given users fails too. I can see the
_registerd_users table's contents (see pic taken from phpMyAdmin, but....)
No login...
The database has about 17,5 G in ~1.200 submissions, so that the way via
Briefcase would take a very long time.
Any God of Databases out there, who may give me a hint?
Thanks to all.
Gunter
--
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
Hello,
I'am interested to have a description to install ODK Aggregate on Synology NAS.
Thanks
I would also be interested in learning the steps to set up odk on a synology nas. Thanks for offering to share.
Dear Mich,
thank you for your reply.
As you assumed, I'm using MySQL (the MariaDB fork). Database and Tomcat are
running on the physically same machine, database's IP is localhost.
I ran the sql script file after creating the war file with the Aggregate
installer. The user given in the inastaller hast granted rights to the
database.
After deploying the .war file Aggregate and login with the name given for
admin in the installer works fine...
I backed up the whole database on the old machine and imported all in the
new machine's odk_prod database (from above). There's no access to
Aggregate, after showing the redirect page therse's a (german) "this page
can not be shown" page.
Are there system tables (these starting with an underscore) which must not
have been copied / imported?
Or there's a better way using Briefcase to export all data at the old
machine and pushing them to the new machine?
Greetings from spring in germany,
Gunter
···
Am Freitag, 27. März 2015 21:56:14 UTC+1 schrieb Mitch Sundt:
>
> I assume you are using MySQL.
>
> Note that the username for the database account is tied to the IP address
> of the requester.
>
> I.e., in order to log in with username 'foo', you need to log in from the
> IP address specified in the create_db_and_user.sql script.
>
> That contains something like:
>
> create database `odk_prod`;
> create user 'odk_prod'@'localhost' identified by 'odk_prod';
> grant all on `odk_prod`.* to 'odk_prod'@'localhost' identified by
> 'odk_prod';
> flush privileges;
>
>
> As you can see, this ties the username 'odk_prod' to ONLY work when
> logging in from the same host as the one running the database (localhost).
>
> You can edit this script file and supply the IP address or FQDN of the
> webserver, and run it, and it should magically begin working.
>
>
>
>
>
> On Thu, Mar 26, 2015 at 7:26 AM, Gunter Lorek <gunterlore...@gmail.com > wrote:
>
>> Dear all,
>>
>> I setted up an instance of Aggregate on an Synology NAS Server, runs
>> fine... If someone likes to have a description of the steps, feel free to
>> contact me.
>>
>> Then I made a data export of the whole database of Aggregate from the
>> collecting server and imported all data to the new NAS-machine, setted up
>> whith the same parameters like the first, esp. database name, but with
>> different FQDN. For the export an import the MySQL Workbench was my friend.
>>
>> Now I can't access the Aggregate platform, login via Google fails with
>> "OpenID auth request contains an unregistered domain". Sign in with
>> Aggregate password with one of the given users fails too. I can see the
>> _registerd_users table's contents (see pic taken from phpMyAdmin, but....)
>> No login...
>>
>> The database has about 17,5 G in ~1.200 submissions, so that the way via
>> Briefcase would take a very long time.
>>
>> Any God of Databases out there, who may give me a hint?
>>
>> Thanks to all.
>>
>> Gunter
>>
>> --
>> --
>> Post: opend...@googlegroups.com
>> Unsubscribe: opendatakit...@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...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Mitch Sundt
> Software Engineer
> University of Washington
> mitche...@gmail.com
>
ODK Aggregate is a webserver.
NAS is network-attached-storage. That's like a disk drive up in the cloud
(like Google Drive).
They are two different things.
See http://opendatakit.org/use/aggregate/ for information on to set up ODK
Aggregate.
···
On Wed, Jul 15, 2015 at 2:26 AM, wrote:
Hello,
I'am interested to have a description to install ODK Aggregate on Synology
NAS.
Thanks
--
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
Hi there,
I think your best bet is to finding some online tutorials on
installing Tomcat and MySQL on a Synology and go from there...
Yaw
···
--
Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.
On Thu, Nov 5, 2015 at 7:04 PM, mmann1123@gmail.com wrote:
I would also be interested in learning the steps to set up odk on a synology nas. Thanks for offering to share.
--
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.
The database access settings used by ODK Aggregate were constructed for a
database that is on the same machine as the ODK Aggregate webserver.
To resolve this, you must:
(1) re-run the ODK Aggregate installer and supply the new database server
IP address (or DNS name). Note that you should ensure that the IP address
for BOTH the ODK Aggregate webserver AND the database server are static
IP addresses if you are using IP addresses instead of DNS names.
(2) delete the first line in the generated create SQL script *and run it *on
your database. This creates a user that can access the your database from
the IP address / DNS name of your webserver. If your webserver IP address
is reassigned, this will break, which is why you need to make your
webserver IP address a static IP address, unless you are using a DNS name.
(3) deploy the WAR. That contains a configuration file that identifies the
IP address / DNS name of your database. If your database IP address is ever
reassigned, this will break, which is why you need to make your database IP
address a static IP address, unless you are using a DNS name.
···
On Wed, Apr 8, 2015 at 6:12 AM, Gunter Lorek <gunterlorek.gemament@gmail.com wrote:
Dear Mich,
thank you for your reply.
As you assumed, I'm using MySQL (the MariaDB fork). Database and Tomcat
are running on the physically same machine, database's IP is localhost.
I ran the sql script file after creating the war file with the Aggregate
installer. The user given in the inastaller hast granted rights to the
database.
After deploying the .war file Aggregate and login with the name given for
admin in the installer works fine...
I backed up the whole database on the old machine and imported all in the
new machine's odk_prod database (from above). There's no access to
Aggregate, after showing the redirect page therse's a (german) "this page
can not be shown" page.
Are there system tables (these starting with an underscore) which must not
have been copied / imported?
Or there's a better way using Briefcase to export all data at the old
machine and pushing them to the new machine?
Greetings from spring in germany,
Gunter
Am Freitag, 27. März 2015 21:56:14 UTC+1 schrieb Mitch Sundt:
I assume you are using MySQL.
Note that the username for the database account is tied to the IP address
of the requester.
I.e., in order to log in with username 'foo', you need to log in from the
IP address specified in the create_db_and_user.sql script.
That contains something like:
create database odk_prod;
create user 'odk_prod'@'localhost' identified by 'odk_prod';
grant all on odk_prod.* to 'odk_prod'@'localhost' identified by
'odk_prod';
flush privileges;
As you can see, this ties the username 'odk_prod' to ONLY work when
logging in from the same host as the one running the database (localhost).
You can edit this script file and supply the IP address or FQDN of the
webserver, and run it, and it should magically begin working.
On Thu, Mar 26, 2015 at 7:26 AM, Gunter Lorek gunterlore...@gmail.com wrote:
Dear all,
I setted up an instance of Aggregate on an Synology NAS Server, runs
fine... If someone likes to have a description of the steps, feel free to
contact me.
Then I made a data export of the whole database of Aggregate from the
collecting server and imported all data to the new NAS-machine, setted up
whith the same parameters like the first, esp. database name, but with
different FQDN. For the export an import the MySQL Workbench was my friend.
Now I can't access the Aggregate platform, login via Google fails with
"OpenID auth request contains an unregistered domain". Sign in with
Aggregate password with one of the given users fails too. I can see the
_registerd_users table's contents (see pic taken from phpMyAdmin, but....)
No login...
The database has about 17,5 G in ~1.200 submissions, so that the way via
Briefcase would take a very long time.
Any God of Databases out there, who may give me a hint?
Thanks to all.
Gunter
--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitche...@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/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
The split isn't that clear these days because Synology has "NAS" devices
that allow for software installs (e.g., Tomcat). Brave new world.
Yaw
···
--
Need ODK services? http://nafundi.com provides form design, server setup,
professional support, and software development for ODK.
On Wed, Jul 15, 2015 at 11:53 AM, Mitch Sundt mitchellsundt@gmail.com wrote:
ODK Aggregate is a webserver.
NAS is network-attached-storage. That's like a disk drive up in the cloud
(like Google Drive).
They are two different things.
See http://opendatakit.org/use/aggregate/ for information on to set up
ODK Aggregate.
On Wed, Jul 15, 2015 at 2:26 AM, hmoriot@gmail.com wrote:
Hello,
I'am interested to have a description to install ODK Aggregate on
Synology NAS.
Thanks
--
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 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.
I wrote one find it here, and comment and share:
https://blog.offline365.info/blog/2016/05/29/installing-odk-on-synology-dsm-with-tomcat-6/
···
On Friday, 6 November 2015 02:51:28 UTC+1, Yaw Anokwa wrote:
> Hi there,
>
> I think your best bet is to finding some online tutorials on
> installing Tomcat and MySQL on a Synology and go from there...
>
Dear Mitch,
thank you very much. I made all as requested, but I suppose, there's a
small guy in my machine, who wanted to optain an early weekend....
I pulled the data with Briefcase and pushed it to the new machine with a
fresh installed Aggregate. This had a positive secondary effect. We're
planning to give access to some technicians to a part of the database, but
we are also using ODK to submit data of our repairmen, so I setted up a
second instance with a separate database. With Briefcase, this was a very
comfortable way to divide the data.
···
Am Mittwoch, 8. April 2015 19:24:28 UTC+2 schrieb Mitch Sundt:
>
> The database access settings used by ODK Aggregate were constructed for a
> database that is on the same machine as the ODK Aggregate webserver.
>
> To resolve this, you must:
>
> (1) re-run the ODK Aggregate installer and supply the new database server
> IP address (or DNS name). Note that you should ensure that the IP address
> for *BOTH* the ODK Aggregate webserver *AND* the database server are
> static IP addresses if you are using IP addresses instead of DNS names.
>
> (2) *delete* the first line in the generated create SQL script *and run
> it *on your database. This creates a user that can access the your
> database from the IP address / DNS name of your webserver. If your
> webserver IP address is reassigned, this will break, which is why you need
> to make your webserver IP address a static IP address, unless you are using
> a DNS name.
>
> (3) deploy the WAR. That contains a configuration file that identifies the
> IP address / DNS name of your database. If your database IP address is ever
> reassigned, this will break, which is why you need to make your database IP
> address a static IP address, unless you are using a DNS name.
>
>