how to recover root password in Collabnet SVN Edge?

Question

I am using CollabNet SVN Edge as my repository server in windows, anyhow I have mess up the user accounts of this SVN including the root one. May I know how can I restore the admin account of this SVN?

Answer 1

If at all you are looking for an option to reset your admin password as you have forgotten it, the only way to reset this without deleting the database is to edit it directly (it's pretty easy).

1. Stop the Subversion Edge service on Windows or run the $ bin/csvn stop command on Linux/Solaris
2. Find your install directory (eg, c:\csvn).This will contain a folder named data which contains a file named "csvn-production-hsqldb.script".

3. Open this file in a text editor. Search for "'admin'" (with the single quotes) -- you should find a row that looks like this:

   INSERT INTO USER VALUES(1,2,'admin user','[email protected]',TRUE,
       '78989asdef7898abde4252aedcb4352','Super Administrator','admin')
   

4. Replace the long encrypted password field ("789...") with this: 21232f297a57a5a743894a0e4a801fc3

5. Save, and restart the Subversion Edge service.

   Username : admin Password : admin

should work after that.