Change Password odk aggregate in mysql db

Speaks good guys later!

I need your help , in the company I work for has a ODK Aggregate system that stopped working a few days , possibly a fired former developer changed the password .

How do I reset the password for the mysql database and can access the system again ?
I can not install a new version because I'm using 0.xe with many important data.

I ask your help , thank you.

The ODK Aggregate configuration is in the
WEB-INF\lib\ODKAggregate-settings.jar under the Tomcat\webapps...
directory.

Copy this up to your desktop, change the extension to '.zip' and extract
all.

Then open up the jdbc.properties file (e.g., in notepad++) to see what the
username and password are that ODK Aggregate expects.

Then, you can search the web for instructions on how to reset or change a
password for that username in your database.

This will restore the database to the password that works with ODK
Aggregate.

··· -------------- That may or may not be a good idea if it is possible that someone knows that password and can access your server.

Alternatively, you can change the password on your database, then re-run
the ODK Aggregate installer and supply the new password.

Then you would update the WAR file in your Tomcat server with the
newly-generated version.

See https://github.com/opendatakit/opendatakit/wiki/Aggregate-Release-Notes
for how to determine what version of software you have, and if you update
your version, what you need to do.

On Wed, Jan 13, 2016 at 12:13 PM, cerbctic@gmail.com wrote:

Speaks good guys later!

I need your help , in the company I work for has a ODK Aggregate system
that stopped working a few days , possibly a fired former developer changed
the password .

How do I reset the password for the mysql database and can access the
system again ?
I can not install a new version because I'm using 0.xe with many important
data.

I ask your help , thank you.

--

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

quarta-feira, 13 de Janeiro de 2016 às 19:59:33 UTC-3, Mitch Sundt escreveu:

The ODK Aggregate configuration is in the WEB-INF\lib\ODKAggregate-settings.jar under the Tomcat\webapps...\ directory.

Copy this up to your desktop, change the extension to '.zip' and extract all.

Then open up the jdbc.properties file (e.g., in notepad++) to see what the username and password are that ODK Aggregate expects.

Then, you can search the web for instructions on how to reset or change a password for that username in your database.

This will restore the database to the password that works with ODK Aggregate.

That may or may not be a good idea if it is possible that someone knows that password and can access your server.

Alternatively, you can change the password on your database, then re-run the ODK Aggregate installer and supply the new password.

Then you would update the WAR file in your Tomcat server with the newly-generated version.

See https://github.com/opendatakit/opendatakit/wiki/Aggregate-Release-Notes for how to determine what version of software you have, and if you update your version, what you need to do.

Speaks good guys later!

I need your help , in the company I work for has a ODK Aggregate system that stopped working a few days , possibly a fired former developer changed the password .

How do I reset the password for the mysql database and can access the system again ?

I can not install a new version because I'm using 0.xe with many important data.

I ask your help , thank you.

--

--

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

Speaking friend, I need to change the password of the admin user in mysql table ( _registered_users ).

··· > On Wed, Jan 13, 2016 at 12:13 PM, wrote:

Using Google Search for instructions

··· On Thu, Jan 14, 2016 at 3:51 AM, wrote:

quarta-feira, 13 de Janeiro de 2016 às 19:59:33 UTC-3, Mitch Sundt
escreveu:

The ODK Aggregate configuration is in the
WEB-INF\lib\ODKAggregate-settings.jar under the Tomcat\webapps...
directory.

Copy this up to your desktop, change the extension to '.zip' and extract
all.

Then open up the jdbc.properties file (e.g., in notepad++) to see what
the username and password are that ODK Aggregate expects.

Then, you can search the web for instructions on how to reset or change
a password for that username in your database.

This will restore the database to the password that works with ODK
Aggregate.

That may or may not be a good idea if it is possible that someone knows
that password and can access your server.

Alternatively, you can change the password on your database, then re-run
the ODK Aggregate installer and supply the new password.

Then you would update the WAR file in your Tomcat server with the
newly-generated version.

See
https://github.com/opendatakit/opendatakit/wiki/Aggregate-Release-Notes
for how to determine what version of software you have, and if you update
your version, what you need to do.

On Wed, Jan 13, 2016 at 12:13 PM, cerb...@gmail.com wrote:

Speaks good guys later!

I need your help , in the company I work for has a ODK Aggregate system
that stopped working a few days , possibly a fired former developer changed
the password .

How do I reset the password for the mysql database and can access the
system again ?

I can not install a new version because I'm using 0.xe with many
important data.

I ask your help , thank you.

--

--

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

Speaking friend, I need to change the password of the admin user in mysql
table ( _registered_users ).

--

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

quinta-feira, 14 de Janeiro de 2016 às 17:48:42 UTC-3, Mitch Sundt escreveu:

Using Google Search for instructions

quarta-feira, 13 de Janeiro de 2016 às 19:59:33 UTC-3, Mitch Sundt escreveu:

The ODK Aggregate configuration is in the WEB-INF\lib\ODKAggregate-settings.jar under the Tomcat\webapps...\ directory.

Copy this up to your desktop, change the extension to '.zip' and extract all.

Then open up the jdbc.properties file (e.g., in notepad++) to see what the username and password are that ODK Aggregate expects.

Then, you can search the web for instructions on how to reset or change a password for that username in your database.

This will restore the database to the password that works with ODK Aggregate.


That may or may not be a good idea if it is possible that someone knows that password and can access your server.

Alternatively, you can change the password on your database, then re-run the ODK Aggregate installer and supply the new password.

Then you would update the WAR file in your Tomcat server with the newly-generated version.

See https://github.com/opendatakit/opendatakit/wiki/Aggregate-Release-Notes for how to determine what version of software you have, and if you update your version, what you need to do.

Speaks good guys later!

I need your help , in the company I work for has a ODK Aggregate system that stopped working a few days , possibly a fired former developer changed the password .

How do I reset the password for the mysql database and can access the system again ?

I can not install a new version because I'm using 0.xe with many important data.

I ask your help , thank you.

--

--

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

Speaking friend, I need to change the password of the admin user in mysql table ( _registered_users ).

--

--

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

I know how to update the mysql , what I need to know is how to generate a new password, then I 'll update manually in mysql the table ( _registered_users ) .

How do I generate the password ( aggregate) ?

As I cryptographer this password ? I'm using version 1.2.0

··· > On Thu, Jan 14, 2016 at 3:51 AM, wrote: > > On Wed, Jan 13, 2016 at 12:13 PM, wrote:

Why are you directly modifying that table?

The password is a Digest Auth hashed password.

The way to set passwords is through the Site Admin / Permissions page,
choosing "Change Password"

If you have forgotten your password, re-install ODK Aggregate, specifying a
different username for the super-user. This will then be initialized to
have "aggregate" as the password, and you will be able to log in.

··· On Fri, Jan 15, 2016 at 11:32 AM, wrote:

quinta-feira, 14 de Janeiro de 2016 às 17:48:42 UTC-3, Mitch Sundt
escreveu:

Using Google Search for instructions

On Thu, Jan 14, 2016 at 3:51 AM, cerb...@gmail.com wrote:
quarta-feira, 13 de Janeiro de 2016 às 19:59:33 UTC-3, Mitch Sundt
escreveu:

The ODK Aggregate configuration is in the
WEB-INF\lib\ODKAggregate-settings.jar under the Tomcat\webapps...
directory.

Copy this up to your desktop, change the extension to '.zip' and
extract all.

Then open up the jdbc.properties file (e.g., in notepad++) to see what
the username and password are that ODK Aggregate expects.

Then, you can search the web for instructions on how to reset or
change a password for that username in your database.

This will restore the database to the password that works with ODK
Aggregate.


That may or may not be a good idea if it is possible that someone
knows that password and can access your server.

Alternatively, you can change the password on your database, then
re-run the ODK Aggregate installer and supply the new password.

Then you would update the WAR file in your Tomcat server with the
newly-generated version.

See
https://github.com/opendatakit/opendatakit/wiki/Aggregate-Release-Notes
for how to determine what version of software you have, and if you update
your version, what you need to do.

On Wed, Jan 13, 2016 at 12:13 PM, cerb...@gmail.com wrote:

Speaks good guys later!

I need your help , in the company I work for has a ODK Aggregate
system that stopped working a few days , possibly a fired former developer
changed the password .

How do I reset the password for the mysql database and can access the
system again ?

I can not install a new version because I'm using 0.xe with many
important data.

I ask your help , thank you.

--

--

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

Speaking friend, I need to change the password of the admin user in
mysql table ( _registered_users ).

--

--

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

I know how to update the mysql , what I need to know is how to generate a
new password, then I 'll update manually in mysql the table (
_registered_users ) .

How do I generate the password ( aggregate) ?

As I cryptographer this password ? I'm using version 1.2.0

--

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

sexta-feira, 15 de Janeiro de 2016 às 16:38:01 UTC-3, Mitch Sundt escreveu:

Why are you directly modifying that table?

The password is a Digest Auth hashed password.

The way to set passwords is through the Site Admin / Permissions page, choosing "Change Password"

If you have forgotten your password, re-install ODK Aggregate, specifying a different username for the super-user. This will then be initialized to have "aggregate" as the password, and you will be able to log in.

quinta-feira, 14 de Janeiro de 2016 às 17:48:42 UTC-3, Mitch Sundt escreveu:

Using Google Search for instructions

quarta-feira, 13 de Janeiro de 2016 às 19:59:33 UTC-3, Mitch Sundt escreveu:

The ODK Aggregate configuration is in the WEB-INF\lib\ODKAggregate-settings.jar under the Tomcat\webapps...\ directory.

Copy this up to your desktop, change the extension to '.zip' and extract all.

Then open up the jdbc.properties file (e.g., in notepad++) to see what the username and password are that ODK Aggregate expects.

Then, you can search the web for instructions on how to reset or change a password for that username in your database.

This will restore the database to the password that works with ODK Aggregate.


That may or may not be a good idea if it is possible that someone knows that password and can access your server.

Alternatively, you can change the password on your database, then re-run the ODK Aggregate installer and supply the new password.

Then you would update the WAR file in your Tomcat server with the newly-generated version.

See https://github.com/opendatakit/opendatakit/wiki/Aggregate-Release-Notes for how to determine what version of software you have, and if you update your version, what you need to do.

Speaks good guys later!

I need your help , in the company I work for has a ODK Aggregate system that stopped working a few days , possibly a fired former developer changed the password .

How do I reset the password for the mysql database and can access the system again ?

I can not install a new version because I'm using 0.xe with many important data.

I ask your help , thank you.

--

--

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

Speaking friend, I need to change the password of the admin user in mysql table ( _registered_users ).

--

--

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

I know how to update the mysql , what I need to know is how to generate a new password, then I 'll update manually in mysql the table ( _registered_users ) .

How do I generate the password ( aggregate) ?

As I cryptographer this password ? I'm using version 1.2.0

--

--

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 reinstalled as you said , I'm using version 1.2.0 , only found available for download 1.4.7 version .

After you have installed does not work with the same bank , the tables are different.

you have the link to download the version 1.2.0 , i'm not finding .

··· > On Fri, Jan 15, 2016 at 11:32 AM, wrote: > > On Thu, Jan 14, 2016 at 3:51 AM, wrote: > > > On Wed, Jan 13, 2016 at 12:13 PM, wrote:

If updating from an older version, see

On the downloads page, e.g.,

Click on "Previous versions" to access the older versions of the installer.

··· On Fri, Jan 15, 2016 at 11:51 AM, wrote:

sexta-feira, 15 de Janeiro de 2016 às 16:38:01 UTC-3, Mitch Sundt escreveu:

Why are you directly modifying that table?

The password is a Digest Auth hashed password.

The way to set passwords is through the Site Admin / Permissions page,
choosing "Change Password"

If you have forgotten your password, re-install ODK Aggregate,
specifying a different username for the super-user. This will then be
initialized to have "aggregate" as the password, and you will be able to
log in.

On Fri, Jan 15, 2016 at 11:32 AM, cerb...@gmail.com wrote:
quinta-feira, 14 de Janeiro de 2016 às 17:48:42 UTC-3, Mitch Sundt
escreveu:

Using Google Search for instructions

On Thu, Jan 14, 2016 at 3:51 AM, cerb...@gmail.com wrote:

quarta-feira, 13 de Janeiro de 2016 às 19:59:33 UTC-3, Mitch Sundt
escreveu:

The ODK Aggregate configuration is in the
WEB-INF\lib\ODKAggregate-settings.jar under the Tomcat\webapps...
directory.

Copy this up to your desktop, change the extension to '.zip' and
extract all.

Then open up the jdbc.properties file (e.g., in notepad++) to see
what the username and password are that ODK Aggregate expects.

Then, you can search the web for instructions on how to reset or
change a password for that username in your database.

This will restore the database to the password that works with ODK
Aggregate.


That may or may not be a good idea if it is possible that someone
knows that password and can access your server.

Alternatively, you can change the password on your database, then
re-run the ODK Aggregate installer and supply the new password.

Then you would update the WAR file in your Tomcat server with the
newly-generated version.

See
https://github.com/opendatakit/opendatakit/wiki/Aggregate-Release-Notes
for how to determine what version of software you have, and if you update
your version, what you need to do.

On Wed, Jan 13, 2016 at 12:13 PM, cerb...@gmail.com wrote:

Speaks good guys later!

I need your help , in the company I work for has a ODK Aggregate
system that stopped working a few days , possibly a fired former developer
changed the password .

How do I reset the password for the mysql database and can access
the system again ?

I can not install a new version because I'm using 0.xe with many
important data.

I ask your help , thank you.

--

--

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

Speaking friend, I need to change the password of the admin user in
mysql table ( _registered_users ).

--

--

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

I know how to update the mysql , what I need to know is how to generate
a new password, then I 'll update manually in mysql the table (
_registered_users ) .

How do I generate the password ( aggregate) ?

As I cryptographer this password ? I'm using version 1.2.0

--

--

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 reinstalled as you said , I'm using version 1.2.0 , only found
available for download 1.4.7 version .

After you have installed does not work with the same bank , the tables are
different.

you have the link to download the version 1.2.0 , i'm not finding .

--

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