Security bug!?

Classic Servoy
1

I think there is a rather serious/annoying security bug.

I was running RC3 (on win xp with a win 2000 SP4 server running MS SQL server 2000 SP3).

For some strange reason, I was unable to add any more users from Developer (using the menus not a method). Rather when I did add them, they only ‘appeared’ to be added. On re-entering Security and also when restarting Servoy, any users I added were no longer there.

In desperation, I upgraded my Dev PC and the Server both to RC7 build 266.

The problem is still there - I cannot add any users to my solution?

Any chance of an URGENT repsonse?

Thanks
Chris

2

I can’t confirm this. I have been playing with this only yesterday without issues… BTW mac os…

3

Also unable to reproduce, after creating a user is there any error in your .log.txt file in your Servoy install dir?

4

This is some sort of error with a duplicate key?

See attached .log file from the server.

I have looked in the SQL table and there are 33 valid users in the servoy_users table. I am trying to add a new user?

Any ideas?

5

first of all, it seems that you at one time had 2 developers open at once. (but this has nothing to do with the sequences)

second youre key sequence is not in sync with the database.
Can you try to just create 30+ users…
(in a script, just loop )

and then you should see that the key sequence is insync again (after X users)

We will add a button in the server/admin page where we can sync all the servoy_sequences with the database.

6

I did have 2 developers open at once from seperate machines - in error - is this likely to have caused any problems?

I tried the method and it created a whole bunch of users which I have now deleted and it seems to be OK.

7

no, and it is possible to work on same repository with 2 developers (only when starting 2 developers on one machine one developer will fail to start the webserver as johan mentioned