← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Reset to original org unit

 

You need to link in your conf/hibernate.properties file (recently also
named as dhis.conf). See the documentation:
http://dhis2.github.io/dhis2-docs/master/en/implementer/html/ch08s03.html#d5e503

On Tue, Mar 15, 2016 at 12:02 AM, moses mwale <isoftcom.ic@xxxxxxxxx> wrote:

> Right I have postgresql and pgadmin but how to connect is the problem..
> how do I go about it? Please help am in trouble here
> On 15 Mar 2016 01:01, "moses mwale" <isoftcom.ic@xxxxxxxxx> wrote:
>
>> Right I have postgresql and Garmin but how to connect is the problem..
>> how do I go about it? Please help am in trouble here
>> On 15 Mar 2016 00:55, "Knut Staring" <knutst@xxxxxxxxx> wrote:
>>
>>> Are you linking dhis2 live to postgresql? If so, you can use pgadmin
>>>
>>> On Mon, Mar 14, 2016 at 11:53 PM, moses mwale <isoftcom.ic@xxxxxxxxx>
>>> wrote:
>>>
>>>> Where do i perform this query at, am using dhis2 live
>>>> On 15 Mar 2016 00:42, "Knut Staring" <knutst@xxxxxxxxx> wrote:
>>>>
>>>>> Try this:
>>>>>
>>>>> insert into usermembership
>>>>> select ou.organisationunitid,u.userid from organisationunit ou
>>>>>  cross join users u where parentid is null and username='admin'
>>>>>
>>>>> On Mon, Mar 14, 2016 at 10:24 PM, moses mwale <isoftcom.ic@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> I accidentally gave admin admin user, user by organisation specific
>>>>>> districts removed it from parent org. How do i set it back to have parent
>>>>>> org units?
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Knut Staring
>>>>> Dept. of Informatics, University of Oslo
>>>>> Norway: +4791880522
>>>>> Skype: knutstar
>>>>> http://dhis2.org
>>>>>
>>>>
>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> Norway: +4791880522
>>> Skype: knutstar
>>> http://dhis2.org
>>>
>>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org