Servoy Forum

by **Westy** » Mon Jul 19, 2004 12:39 am

I have a customer who entered his administrator name and password within Developer and did not write the information down. He has now forgotten the password. What is the fastest way to fix this situation and get him up and running again?

by **Jan Aleman** » Mon Jul 19, 2004 10:30 am

1.make a backup of the repository database
2. delete the contents of the table servoy_users using a sql tool

by **Karel Broer** » Mon Jul 26, 2004 5:03 pm

jaleman wrote:2. delete the contents of the table servoy_users using a sql tool

How do I do this on OS X 10.3?

by **Jan Aleman** » Mon Jul 26, 2004 5:06 pm

That depends on which database you use. If you use iAnywhere (as of 2.0 the default database Servoy ships with) you can download the developer edition of iAnywhere from www.ianywhere.com and use Sybase Central (information on using sybase central is in our docs as well as in the sybase docs) to connect to the database.

by **Karel Broer** » Mon Jul 26, 2004 5:53 pm

Pfew... I can login in Security again.... I re-installed Servoy Developer and imported the solution again. That did it too :wink:

Thanks iAnyway, Jan!

by **Jan Aleman** » Mon Jul 26, 2004 5:56 pm

iAnytime!

by **Karel Broer** » Tue Jul 27, 2004 11:45 pm

I just had a little look into Sybase Central, it's a really nice tool! I even can rename the tables....

by **Jan Aleman** » Thu Sep 02, 2004 4:02 am

freecolours wrote:I just had a little look into Sybase Central, it's a really nice tool! I even can rename the tables....

Note that if you rename tables you must restart servoy developer before it can see the changes.

by **Karel Broer** » Thu Sep 02, 2004 9:34 am

Thanks! I noticed that... other thing about Sybase central is that I would like to be able to change the column type, but I can't. Is there a possibility to do that somewhere?

by **Jan Aleman** » Wed Sep 08, 2004 1:42 am

delete it and recreate it

by **Karel Broer** » Wed Sep 08, 2004 9:21 am

Yes, but do I erase the data content in the deleted and re-created column?

by **Jan Aleman** » Wed Sep 08, 2004 4:53 pm

yes of course

you can copy the data into a copy table to avoid that.

Servoy Forum

Remedy for a lost administrator password

Remedy for a lost administrator password

Sybase Central

Re: Sybase Central

Who is online