dhis2-users team mailing list archive

[Ouango william <williamouango@xxxxxxxx>]

Hi all, i have a solution to your problem, you can go to pgadmin, open the database and then go on users table. If you know how to get an user pasword you kwow, just copy it code (it will surely be in a crypted langage)  and go to paste it to the admin code place. Then go to the dhis interface and put the admin new code. This solution can be use only if you have an user code that you know.
Sorry for my english 
William N. D. OUANGO
>Analyste Programmeur
>          DSITS Burkina
>
>
>(00226)     79 33 83 84
>            72 00 31 22
>            66 85 28 18
Le Mardi 13 mai 2014 19h31, Kader Irchad Barry <kaderb777@xxxxxxxxx> a écrit :
 
Yes, I just updated the password (+ the firstname, lastname, and language for the user) through the DHIS2 interface. I was just experiencing some connection outages and might have clicked more than one time on the validation button, if this can explain something. The select query on the "userrolemembers" table returned 0 entry when I checked. I can send you the catalina.out full log if you want to check what went wrong.

Best regards,
Kader



2014-05-13 22:12 GMT+03:00 Jason Pickering <jason.p.pickering@xxxxxxxxx>:

Yeah, that seems really weird. It should not be possible through the user interface to do this. You mean there were no entries at all? The entire table for "userrolemembers" was blank, or maybe you only had a single user in this instance? I can see this happening if you mess directly with the database, but in your case, you simply updated the password through the user interface?
>
>
>Regards,
>Jason
>
>
>
>
>
>On Tue, May 13, 2014 at 8:14 PM, Kader Irchad Barry <kaderb777@xxxxxxxxx> wrote:
>
>Thank you Jason.
>>
>>
>>My table "userrolemembers" had no entry in it. Checking the userid from "users" table and the Superuser id from "userrole" table, I inserted a new entry for my admin user in the "userrolemembers" table and it wordked _after_ rebooting. It was not a problem with the password but with the user's role. I don't understand what caused the disappearance of the role when I changed the default password.
>>
>>
>>Thanks again.
>>
>>
>>Best regards,
>>Kader
>>
>>
>>
>>
>>
>>2014-05-13 20:48 GMT+03:00 Jason Pickering <jason.p.pickering@xxxxxxxxx>:
>>
>>
>>Hi Kader,
>>>Please check the archives here (https://lists.launchpad.net/dhis2-devs/msg25167.html) where I describe a possible solution. This will only work if you still have the admin user, otherwise, you will need to generate an encrypted password through some of the methods described in the archives. 
>>>
>>>
>>>Best regards,
>>>Jason
>>>
>>>
>>>
>>>
>>>
>>>On Tue, May 13, 2014 at 7:34 PM, Kader Irchad Barry <kaderb777@xxxxxxxxx> wrote:
>>>
>>>Dear Adedayo,
>>>>
>>>>
>>>>Thank you for your suggestion. I tried to access through a different browser but the error message is the same.
>>>>
>>>>
>>>>I'm searching through the postgres database where the role is being set to users, but I can't see in the database structure how this association is being made. 
>>>>
>>>>
>>>>Best regards,
>>>>Kader
>>>>
>>>>
>>>>
>>>>2014-05-13 20:00 GMT+03:00 Deemoyes <deemoyes@xxxxxxxxx>:
>>>>
>>>>Dear Kader,
>>>>>
>>>>>
>>>>>You might want to clear the cache of your Chrome browser or simple try another browser first to test the authenticity of the access denied message. You could actually try the Chrome incognito if you don't wanna clear your cache yet.
>>>>>
>>>>>
>>>>>I get that usually when I change permissions of users.
>>>>>
>>>>>
>>>>>I hope this helps.
>>>>>
>>>>>
>>>>>Regards,
>>>>>
>>>>>
>>>>>Adedayo
>>>>>
>>>>>
>>>>>Sent from my BlackBerry 10 smartphone.
>>>>>From: Kader Irchad Barry
>>>>>Sent: Tuesday, 13 May 2014 17:26
>>>>>To: dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>Subject: [Dhis2-users] No more able to access DHIS2 after changing admin	password 
>>>>>
>>>>>
>>>>>Hello,
>>>>>
>>>>>
>>>>>After having installed and configured all data elements and data sets with default admin and password, I changed the default password through the panel. I'm no more able to access to DHIS2 anymore. The error I'm having is this one : "Access denied - You are not allowed to view this page" in a different page from the login page. 
>>>>>
>>>>>
>>>>>I thought the password were mispelled but it is not as if it was this kind of error. When trying to use the former password for example, the error message that appears says: "Wrong username or password" in the _same_ login page. It seems to be something dealing with access rights but I just changed the password and firstname/lastname.
>>>>>
>>>>>
>>>>>I searched through the forum database but it didn't seem that this kind of question has been asked before. Is there a way to reset the default admin password and rights (through the shell for example) without having to reinstall DHIS2 ?
>>>>>
>>>>>
>>>>>Thanks a lot for your help.
>>>>>
>>>>>
>>>>>Best regards
>>>>>Kader
>>>>>
>>>>>_______________________________________________
>>>>>Mailing list: https://launchpad.net/~dhis2-users
>>>>>Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>_______________________________________________
>>>>Mailing list: https://launchpad.net/~dhis2-users
>>>>Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>Unsubscribe : https://launchpad.net/~dhis2-users
>>>>More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>
>


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp