Page 1 of 1

more newbie help: cannot access subsonic with admin as user

PostPosted: Wed Apr 29, 2009 4:20 pm
by hatmandude
I deleted the first user I originally created and so the onyl one remaining was "admin", whose p/w I had previously changed but now when I try to log in it does not let me in even though I am sure of p/w- WTF???

PostPosted: Wed Apr 29, 2009 6:05 pm
by jigsaw
try resetting the password
easy howto:
1. stop subsonic
2. locate the line where the admin user is inserted in SUBSONIC_HOME/db/subsonic.script
Find the line which begins with
Code: Select all
INSERT INTO USER VALUES('admin', .............

replace the second field with 'changeme' ( remember to include the apostrophes )

3. Restart subsonic
4. Now you should be able to log in using username admin and password changeme

PostPosted: Wed Apr 29, 2009 9:39 pm
by hatmandude
Thanks but I cannot locate the file "SUBSONIC_HOME/db/subsonic.script". I looked in the subsonic directory in program files. In the "Log" directory there are 2 files :

1) subsonic-service
2) subsonic-agent

neither of which have a line that begins with "INSERT INTO USER VALUES"

The only other text files are:

build_number, LICENSE, README, version.

Guess I will just unistall and reinstall

PostPosted: Wed Apr 29, 2009 9:43 pm
by jonathanroz
On Windows the default directory for this is C:\subsonic\db

PostPosted: Wed Apr 29, 2009 9:51 pm
by hatmandude
got it- thanks. Now to see if I can resolve other issue you have replied to-stay tuned