more newbie help: cannot access subsonic with admin as user

Need help? Post your questions here.

Moderator: moderators

more newbie help: cannot access subsonic with admin as user

Postby hatmandude » Wed Apr 29, 2009 4:20 pm

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???
hatmandude
 
Posts: 26
Joined: Tue Apr 28, 2009 10:15 pm

Postby jigsaw » Wed Apr 29, 2009 6:05 pm

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
Currently without Subsonic due to hardware failure :(
User avatar
jigsaw
 
Posts: 242
Joined: Sat Oct 13, 2007 12:01 pm
Location: Stavanger, Norway

Postby hatmandude » Wed Apr 29, 2009 9:39 pm

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
hatmandude
 
Posts: 26
Joined: Tue Apr 28, 2009 10:15 pm

Postby jonathanroz » Wed Apr 29, 2009 9:43 pm

On Windows the default directory for this is C:\subsonic\db
jonathanroz
 
Posts: 172
Joined: Thu Dec 18, 2008 8:54 pm
Location: Frisco, TX USA

Postby hatmandude » Wed Apr 29, 2009 9:51 pm

got it- thanks. Now to see if I can resolve other issue you have replied to-stay tuned
hatmandude
 
Posts: 26
Joined: Tue Apr 28, 2009 10:15 pm


Return to Help

Who is online

Users browsing this forum: No registered users and 14 guests