# Locked Out of Administration Console

**URL:** <https://forum.servoy.com/t/locked-out-of-administration-console/14623>\
**Category:** Classic Servoy\
**Created:** [September 9, 2011, 9:31pm UTC](https://forum.servoy.com/t/locked-out-of-administration-console/14623 "2011-09-09T21:31:07Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![wgrayson](https://avatars.discourse-cdn.com/v4/letter/w/e47774/32.png) [@wgrayson](https://forum.servoy.com/u/wgrayson)\
**Post date:** [September 9, 2011, 9:31pm UTC](https://forum.servoy.com/t/locked-out-of-administration-console/14623/1 "2011-09-09T21:31:07Z")

</div>

Somehow I’ve gotten locked out of the Server Administration Console. I can manage accounts within developer, but I can’t get in to the console to import a new solution or make any changes.

So far I’ve uninstalled and reinstalled sevoy on my server, and restarted the Servoy and Database service. Still same result. Using 5.2.9 on Windows

Is there any way to recover that password or wipe it out completely? thanks!  
Wes

---

<div class="post-metadata">

**Author:** ![AlanBourke](https://avatars.discourse-cdn.com/v4/letter/a/b5a626/32.png) [@AlanBourke](https://forum.servoy.com/u/AlanBourke)\
**Post date:** [September 28, 2011, 10:52am UTC](https://forum.servoy.com/t/locked-out-of-administration-console/14623/2 "2011-09-28T10:52:22Z")

</div>

If I remember from another post on this forum, the passwords are MD5 hashed and then Base64 encoded. So if you can generate a new string using those rules and a plaintext password, you can put this into the relevant field on the ‘admin’ user record in the servoy\_users table in your repository\_server database.

You will then also need to edit the server properties file and for the server\_repository database entry, edit the password there. It will probably be of the form:

server.1.password=encrypted:XZFg9JKIdj0=

but you can also just put plaintext in:

server.1.password=mypassword

That should get you in. Then change the password for ‘admin’ so that it gets written back in encrypted form!

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [September 28, 2011, 1:28pm UTC](https://forum.servoy.com/t/locked-out-of-administration-console/14623/3 "2011-09-28T13:28:09Z")

</div>

Those are server connection passwords which has nothing to do with his problem of getting into the servoy-admin pages.  
Those passwords are stored inside the repository database.

---

<div class="post-metadata">

**Author:** ![AlanBourke](https://avatars.discourse-cdn.com/v4/letter/a/b5a626/32.png) [@AlanBourke](https://forum.servoy.com/u/AlanBourke)\
**Post date:** [September 29, 2011, 2:56pm UTC](https://forum.servoy.com/t/locked-out-of-administration-console/14623/4 "2011-09-29T14:56:24Z")

</div>

Where are they in the repository database ?

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [September 29, 2011, 3:09pm UTC](https://forum.servoy.com/t/locked-out-of-administration-console/14623/5 "2011-09-29T15:09:38Z")

</div>

Take a look at the tables _servoy\_users_, _servoy\_user\_groups_ and _servoy\_groups_.

---

<div class="post-metadata">

**Author:** ![ngervasi](https://avatars.discourse-cdn.com/v4/letter/n/f9ae1b/32.png) [@ngervasi](https://forum.servoy.com/u/ngervasi)\
**Post date:** [September 29, 2011, 10:49pm UTC](https://forum.servoy.com/t/locked-out-of-administration-console/14623/6 "2011-09-29T22:49:20Z")

</div>

An easy way is to completely delete all the Repository tables, let servoy recreate them, reimport the solutions and reset the admininstrator password. Maybe an overkill but quick and effective.

---

<div class="post-metadata">

**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\
**Post date:** [September 30, 2011, 8:37am UTC](https://forum.servoy.com/t/locked-out-of-administration-console/14623/7 "2011-09-30T08:37:35Z")

</div>

just deleting the users out of the users table would also work.

---

<div class="post-metadata">

**Author:** ![AlanBourke](https://avatars.discourse-cdn.com/v4/letter/a/b5a626/32.png) [@AlanBourke](https://forum.servoy.com/u/AlanBourke)\
**Post date:** [September 30, 2011, 4:03pm UTC](https://forum.servoy.com/t/locked-out-of-administration-console/14623/8 "2011-09-30T16:03:28Z")

</div>

> ROCLASI:  
> Take a look at the tables _servoy\_users_, _servoy\_user\_groups_ and _servoy\_groups_.

I mentioned in my reply to the OP that the password would have to be changed in servoy\_users …

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [September 30, 2011, 7:18pm UTC](https://forum.servoy.com/t/locked-out-of-administration-console/14623/9 "2011-09-30T19:18:35Z")

</div>

Hi Alan,

> AlanBourke:
> 
> > ROCLASI:  
> > Take a look at the tables _servoy\_users_, _servoy\_user\_groups_ and _servoy\_groups_.
> 
> I mentioned in my reply to the OP that the password would have to be changed in servoy\_users …

I responded to your question:

> AlanBourke:  
> Where are they in the repository database ?

Seems you already knew the answer.  
Sorry to confuse you.

---

<div class="post-metadata">

**Author:** ![AlanBourke](https://avatars.discourse-cdn.com/v4/letter/a/b5a626/32.png) [@AlanBourke](https://forum.servoy.com/u/AlanBourke)\
**Post date:** [October 3, 2011, 9:03am UTC](https://forum.servoy.com/t/locked-out-of-administration-console/14623/10 "2011-10-03T09:03:16Z")

</div>

Hey no problem I just thought there was something else involved that I had missed. ![:wink:]( "Wink")
