Re: [Dhis2-users] [Dhis2-devs] URGENT: Data capture and Maintenance org units Access

2018-03-12 Thread Ocaya Stephen 
Hi Georgi, The other workable option where U dont have direct access to
database is use the DHIS2 WebAPI

Georgi, Since the account is a superuser, you could use the WebAPI to
create a new Superuser and allocate to the Main parent orgunit using the
payloads below:-


For this to work properly (currently) you need to generate an ID
(/api/system/id) and then modify the payload like this:

{
  "id": "generated-id",
  "firstName": "John",
  "surname": "Doe",
  "email": "john...@mail.com",
  "userCredentials": {
"userInfo": { "id": "generated-id" },
"username": "johndoe",
"password": "your-password-123",
"userRoles": [ {
  "id": "Euq3XfEIEbx"
} ]
  },
  "organisationUnits": [ {
"id": "ImspTQPwCqd"
  } ],
  "userGroups": [ {
"id": "vAvEltyXGbD"
  } ]
}

generated-id should be generated using /api/system/id (WebAPI)

Then, Use Curl to Create the user. Once done, Login and Update your account
as usual using users App

curl -X POST -u user:pass -d @u.json -H "Content-Type:
application/json" http://server/api/24/users





On Mon, Mar 12, 2018 at 8:47 PM, Knut Staring  wrote:

> Ok...and you cannot just revert to the dump? Or the dump has the same
> problem?
>
> In any case, since you have a dump which you can experiment with (pls note
> that I have not tested this procedure thoroughly, and you might get more
> than one answer if you have more than one root or more than one superuser):
>
> In any case, you should be able to do this in three steps - first finding
> the root OU and then your user:
>
> 1) SELECT organisationunitid, name FROM organisationunit where parentid is
> null; LET'S SAY THE ANSWER IS 18
> 2) SELECT userid from userrole where name='Superuser'; LET'S SAY THE
> ANSWER IS 32
>
> Given those values, you should be able to do this:
>
> 3) UPDATE usermembership SET organisationunitid = 18 WHERE userinfoid = 32;
>
> On Mon, Mar 12, 2018 at 6:21 PM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
>
>> We got a database dump.
>>
>>
>>
>> *From:* Knut Staring [mailto:knu...@gmail.com]
>> *Sent:* Monday, March 12, 2018 7:07 PM
>> *To:* Georgi Chakarov 
>> *Cc:* DHIS 2 developers ; DHIS 2 Users
>> list 
>> *Subject:* Re: [Dhis2-devs] URGENT: Data capture and Maintenance org
>> units Access
>>
>>
>>
>> Do you have direct access to the database?
>>
>>
>>
>> On Mon, Mar 12, 2018, 17:47 Georgi Chakarov 
>> wrote:
>>
>> Hello all,
>>
>>
>>
>> For some testing purpose, I gave my superuser access to ONE org unit at
>> the lowest level. Now, I and (*all other users*) see only this org unit
>> for all data entry and maintenance apps, which is a bit strange.
>>
>> Does anyone know how do I regain access to the entire org unit tree again?
>>
>>
>>
>>
>>
>>
>>
>>
>> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104
>> <(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation, 720
>> Bathurst Street, Toronto Canada M5S 2R4
>> 
>> | *You may unsubscribe from receiving commercial electronic messages
>> from LogicalOutcomes by emailing **i...@logicaloutcomes.net*
>> 
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
>
> Department of Information, Evidence and Research
> World Health Organization, Geneva, Switzerland
> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
> Skype: knutstar
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
--
*Stephen Ocaya*
Tel: +256 393 217 892 | Mob: +256774558980
www.stephocay.com
SkypeID: stephocay
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] URGENT: Data capture and Maintenance org units Access

2018-03-12 Thread Knut Staring 
Ok...and you cannot just revert to the dump? Or the dump has the same
problem?

In any case, since you have a dump which you can experiment with (pls note
that I have not tested this procedure thoroughly, and you might get more
than one answer if you have more than one root or more than one superuser):

In any case, you should be able to do this in three steps - first finding
the root OU and then your user:

1) SELECT organisationunitid, name FROM organisationunit where parentid is
null; LET'S SAY THE ANSWER IS 18
2) SELECT userid from userrole where name='Superuser'; LET'S SAY THE ANSWER
IS 32

Given those values, you should be able to do this:

3) UPDATE usermembership SET organisationunitid = 18 WHERE userinfoid = 32;

On Mon, Mar 12, 2018 at 6:21 PM, Georgi Chakarov  wrote:

> We got a database dump.
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* Monday, March 12, 2018 7:07 PM
> *To:* Georgi Chakarov 
> *Cc:* DHIS 2 developers ; DHIS 2 Users
> list 
> *Subject:* Re: [Dhis2-devs] URGENT: Data capture and Maintenance org
> units Access
>
>
>
> Do you have direct access to the database?
>
>
>
> On Mon, Mar 12, 2018, 17:47 Georgi Chakarov 
> wrote:
>
> Hello all,
>
>
>
> For some testing purpose, I gave my superuser access to ONE org unit at
> the lowest level. Now, I and (*all other users*) see only this org unit
> for all data entry and maintenance apps, which is a bit strange.
>
> Does anyone know how do I regain access to the entire org unit tree again?
>
>
>
>
>
>
>
>
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104
> <(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation, 720
> Bathurst Street, Toronto Canada M5S 2R4
> 
> | *You may unsubscribe from receiving commercial electronic messages from
> LogicalOutcomes by emailing **i...@logicaloutcomes.net*
> 
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
<+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] URGENT: Data capture and Maintenance org units Access

2018-03-12 Thread Georgi Chakarov 
We got a database dump.

From: Knut Staring [mailto:knu...@gmail.com]
Sent: Monday, March 12, 2018 7:07 PM
To: Georgi Chakarov 
Cc: DHIS 2 developers ; DHIS 2 Users list 

Subject: Re: [Dhis2-devs] URGENT: Data capture and Maintenance org units Access

Do you have direct access to the database?

On Mon, Mar 12, 2018, 17:47 Georgi Chakarov 
mailto:geo...@logicaloutcomes.net>> wrote:
Hello all,

For some testing purpose, I gave my superuser access to ONE org unit at the 
lowest level. Now, I and (all other users) see only this org unit for all data 
entry and maintenance apps, which is a bit strange.
Does anyone know how do I regain access to the entire org unit tree again?


[cid:image003.png@01D3BA32.86CFC1D0]


Georgi Chakarov, CIA | 
geo...@logicaloutcomes.net | +1-647-478-5634 
x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, 
Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial 
electronic messages from LogicalOutcomes by emailing 
i...@logicaloutcomes.net

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-d...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] URGENT: Data capture and Maintenance org units Access

2018-03-12 Thread Knut Staring 
Do you have direct access to the database?

On Mon, Mar 12, 2018, 17:47 Georgi Chakarov 
wrote:

> Hello all,
>
>
>
> For some testing purpose, I gave my superuser access to ONE org unit at
> the lowest level. Now, I and (*all other users*) see only this org unit
> for all data entry and maintenance apps, which is a bit strange.
>
> Does anyone know how do I regain access to the entire org unit tree again?
>
>
>
>
>
>
>
>
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x
> 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst
> Street, Toronto Canada M5S 2R4 | *You may unsubscribe from receiving
> commercial electronic messages from LogicalOutcomes by emailing *
> *i...@logicaloutcomes.net* 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp