Subsonic Forum

I'm going to do a fresh reformat and install of Ubuntu 13.04 sometime soon ..
My subsonic server is working great on 12.10 the problem is I have some user accounts setup , and I can't just recreate them because I don't know my users passwords.
What is the correct way to backup and reinstate this information when doing a fresh install of OS and subsonic? I don't mind so much if the music library etc has to be rebuilded, but I do need to preserve the users - it should be transparent to them apart from an hour or two of downtime.

Take a look at /var/subsonic/db/subsonic.script, specifically the lines that begin with
INSERT INTO USER VALUES
INSERT INTO USER_ROLE VALUES
INSERT INTO USER_SETTINGS VALUES

The command

Code: Select all

grep 'INTO USER' /var/subsonic/db/subsonic.script

should show you all of them.

Edit the file in the new install and drop them in.

NOTE: I have not done this, but it is what I would try myself, and no one else has replied.