I have been charged with trying to get an ODK Aggregate instance rebuilt
from MySQL dumps. I am highly technical but know diddly about ODK.
(For ref see
https://groups.google.com/forum/#!topic/opendatakit/tA0Nb1QXLng)
I have recovered the DB but can't login with the admin password I have been
supplied with.
I can see the user (odk_user) in _registered_users table with a hashed
passed but I don't know the hashing scheme - is there a way to reset it
directly in the MySQL? I use Linux so have a full suite of tools at my
fingertips.
Now, crawling my grey matter I seem to remember that HTTP DIGEST password
use the Realm as salt for the hashing, but I chose a diff. instance name
"Recovery" for my rebuild, which presents in the login dialog as "Recovery
ODK Aggregate".
Do you think I could I just use the Apache digest generator
$ htdigest -c somefile "Recovery ODK Aggregate" odk_user
and manually update the password via MySQL?
···
On Thursday, 2 July 2015 09:56:32 UTC+1, Fergus Gallagher wrote:
>
>
> I have recovered the DB but can't login with the admin password I have
> been supplied with.
>
> I can see the user (odk_user) in _registered_users table with a hashed
> passed but I don't know the hashing scheme - is there a way to reset it
> directly in the MySQL? I use Linux so have a full suite of tools at my
> fingertips.
>
>
>
I would probably just Change Password for all your users, resetting it to
whatever the password should be (the Site Admins for most deployments
control the user password and don't allow it to be changed).
(the digest hash is stored in the _REGISTERED_USERS table).
···
On Thu, Jul 2, 2015 at 2:25 AM, Fergus Gallagher <fergus.gallagher@gmail.com wrote:
Now, crawling my grey matter I seem to remember that HTTP DIGEST password
use the Realm as salt for the hashing, but I chose a diff. instance name
"Recovery" for my rebuild, which presents in the login dialog as "Recovery
ODK Aggregate".
Do you think I could I just use the Apache digest generator
$ htdigest -c somefile "Recovery ODK Aggregate" odk_user
and manually update the password via MySQL?
On Thursday, 2 July 2015 09:56:32 UTC+1, Fergus Gallagher wrote:
I have recovered the DB but can't login with the admin password I have
been supplied with.
I can see the user (odk_user) in _registered_users table with a hashed
passed but I don't know the hashing scheme - is there a way to reset it
directly in the MySQL? I use Linux so have a full suite of tools at my
fingertips.
--
--
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 - I didn't have a ANY login so I couldn't do a "Change Password" 
But changing the HTTP Digest REALM back to match the original installation
worked - hurrah!
···
On Thursday, 2 July 2015 21:11:35 UTC+1, Mitch Sundt wrote:
>
> I would probably just Change Password for all your users, resetting it to
> whatever the password should be (the Site Admins for most deployments
> control the user password and don't allow it to be changed).
>
> (the digest hash is stored in the _REGISTERED_USERS table).
>
>
> On Thu, Jul 2, 2015 at 2:25 AM, Fergus Gallagher <fergus.g...@gmail.com > wrote:
>
>>
>> Now, crawling my grey matter I seem to remember that HTTP DIGEST password
>> use the Realm as salt for the hashing, but I chose a diff. instance name
>> "Recovery" for my rebuild, which presents in the login dialog as "Recovery
>> ODK Aggregate".
>>
>> Do you think I could I just use the Apache digest generator
>>
>> $ htdigest -c somefile "Recovery ODK Aggregate" odk_user
>>
>> and manually update the password via MySQL?
>>
>> On Thursday, 2 July 2015 09:56:32 UTC+1, Fergus Gallagher wrote:
>>>
>>>
>>> I have recovered the DB but can't login with the admin password I have
>>> been supplied with.
>>>
>>> I can see the user (odk_user) in _registered_users table with a hashed
>>> passed but I don't know the hashing scheme - is there a way to reset it
>>> directly in the MySQL? I use Linux so have a full suite of tools at my
>>> fingertips.
>>>
>>>
>>> --
>> --
>> 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
>