Locked Out of Administration Console

Classic Servoy
1

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

2

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!

3

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.

4

Where are they in the repository database ?

5

Take a look at the tables servoy_users, servoy_user_groups and servoy_groups.

6

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.

7

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

8

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 …

9

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.

10

Hey no problem I just thought there was something else involved that I had missed. :wink: