Page 1 of 1

Tables and so on

PostPosted: Wed Sep 08, 2010 8:24 pm
by rodskin
Hi where can I find where users and passwords are kept? Is it a MySql table or what?

Thanks,

Rodskin

PostPosted: Thu Sep 09, 2010 6:13 am
by delcypher
Subsonic uses HSQL. However everytime Subsonic stops running it puts some information /path/to/subsonic/install/db/subsonic.script

When Subsonic is started again that file is used to recreate some of the database.

If search that file you'll find a line similar to this

Code: Select all
INSERT INTO USER VALUES('admin','enc:61646d696e4',0,0,0,FALSE)


Passwords are hex encoded ('enc:' indicates this which is not part of the password).

Hope that helps