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.

Answer 2

In 2017, the hashed string is

INSERT INTO USER VALUES(1,2,'$2a$13$7SoSK1AUMK.Nf9NVlfSyr.OfRrYP8lyH/rOBThvBm68r5wO/A/d22',TRUE,'admin','[email protected]','admin user','Super Administrator')

and that is admin/admin

Answer 3

CollabNet Edge uses Apache httpd for serving the Subversion repository. I don't have it installed, so I'm not 100% sure where things are stored, but the standard Apache Httpd documentation can help you out. Also refer to the online Subversion manual, and most importantly take a good look at the Apache httpd Server Configuration in Chapter 6. These can help clarify how Apache httpd and Subversion are setup and pared together. Everything is basically a front end to Apache httpd and your repository. I'd start with Chapter 6 of the Subversion online manual in the section of configuring Apache.

Cutting to the chase: See if you have a command called htpasswd on your system. This command allows you to generate the passwords for Apache. You can use this command to replace the encrypted passwords with different passwords that you do know. Make a backup copy of that svn_auth_file and see if you can use htpasswd to change your passwords to something you know.

Remember to back up every file before you mess with it, and read up about how Apache is configured in the Subversion online manual. Take a look at your Apache httpd configuration files and get an idea of how everything is put together. Then, try using htpasswd to reset your admin password.