POKE ME for any consultancy

Monday, July 28, 2014

How can I reset my admin password in Collabnet Subversion edge?

Presumably your admin password has been changed to something else and you have forgotten it. The only way to reset this without deleting the database is to edit it directly (it's pretty easy).

Stop the Subversion Edge service on Windows or run the $ bin/csvn stop command on Linux/Solaris
Find your install directory (eg, c:\csvn). This will contain a folder named data which contains a file named "csvn-production-hsqldb.script". 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','admin@example.com',TRUE,
    '78989asdef7898abde4252aedcb4352','Super Administrator','admin')
Replace the long encrypted password field ("789...") with this: 21232f297a57a5a743894a0e4a801fc3
Save, and restart the Subversion Edge service.
admin/admin should work after that.

No comments:

Post a Comment