Servoy 5.2 "WARNING: No administrator..."

Classic Servoy
1

On Servoy 5.2 Server Administration I have manually created an user for the group “Administrators” because the import of the users of my solution doesn’t worked (Sybase db > PostgreSQL). But the User Information “WARNING: No administrator user…” on Servoy Server Home is still displayed!?

2

are you sure that the user is in “administrators”?
Then when accessing /servoy-admin/ again you should be prompted to login.

3

Hi Johan,

yes I know! The user is definitely in “Administrators” but I get no login dialog after restart the server.

4

weird then we check with this query:

select user_uid from servoy_users su, servoy_user_groups sug, servoy_groups sg where sg.group_name = ? and sg.group_id = sug.group_id and sug.user_id = su.user_id

where ? == Administrators

and if that returns rows then you have to be authenticated. So i guess somehow that query is still not returning anything.

5

Ok and what could I do to fix that?

6

can you query those tables in a sql tool?
(like SQL Explorer in servoy developer)

to see if there are really users in those groups?

My guess is that it is somehow still not configured right.

7

First a little more explanation:
I have installed PostgreSQL as stand alone and than Servoy 5.2 without database. On pgAdmin I have created the databases I need incl. the servoy_repository. Than I added the databases in servoy-admin.

I took a look into the servoy_repository tables:

servoy_user_groups has no data
servoy_groups has data group_name “Administrators” + “users”
servoy_users has my created users as data

8

Did you add the Admin user through the server pages or your servoy developer? If you added it via servoy developer maybe you need to commit your changes to the repo? if not, suggestion, maybe try a brand new repo db, open up dev let it configure it, go back in to server pages, add a new admin user and try again to see if it asks for a password.

9

tgs:
servoy_user_groups has no data
servoy_groups has data group_name “Administrators” + “users”
servoy_users has my created users as data

then the users are in no groups. for hat servoy_users_groups must have data. (see the query above)
So you really dont have the users in groups, you just have users and groups but they are not linked.

10

I could fix it!

I have deleted and recreated the servoy_repository db and started the servoy_server with the argument -upgradeRepository.
On servoy-admin I have than created a user and added it to the administrators group. I quess perhaps I forgot this last important step before :oops: . If so I would say sorry.

Thank you
Thomas