Modify Default admin User

[wuhaa]

Hi,

I have installed subsonic on my ubuntu server. I want to change the default user "admin" to a different login name (username) while retaining its admin privilege.

I think subsonic uses hsqldb to store this info. Its worth mentioning that I have very little knowledge of Java in general. So I googled for a manager interface fro the db. I found that hsqldb has this sort of built in and it can be invoked with

java -cp hsqldb.jar org.hsqldb.util.DatabaseManager

So the jar file sits in the subsonic/WEB-INF/lib/hsqldb-1.8.0.7.jar and the data file sits in subsonic/db/subsonic.data in case anyone is not aware as I was.

Anyhow I am unable to change this user "admin" as the Management utility does not show any data in that subsonic.data file. I am also unsure what the table names are as "Show Tables;" does not execute.

If anyone has managed to do this, please shed some light as to how to achieve this (preferably from the cli).

Thanks

[wuhaa]

Is this not possible or no one has tried to do this...?

Maybe subsonic developers can comment....

[oxide[NL]]

create a new user with full admin rights ^^

[wuhaa]

I know that answer was coming... How do I delete the admin user after I have created the new user with admin rights?

[oxide[NL]]

good question, didnt figure that one out yet also
sorry mate

[jigsaw]

I know that answer was coming... How do I delete the admin user after I have created the new user with admin rights?

go to http://<YOUR_HOST>/db.view after you've logged in as the new admin user and run this SQL:

Code: Select all

delete from user where username = 'admin'


Keep in mind that many a application has some things which only applies for the user with the name admin. Deleting it could cause some issues for you, so you do it at your own risk

[wuhaa]

Beautiful, that is what I was looking for. This interface can allow for a lot more modifications. Thank you for sharing that.

I do have a followup question to that. Is their a way to execute a command line query in hsqldb (something like java db.view "select *from user")...

By the way, Im running subsonic through tomcat 6

Thanks,

[indecline]

4delete

Code: Select all

delete from user where username = 'admin'

4rename

Code: Select all

UPDATE user SET username='mom' WHERE username='admin'

dosent works

Code: Select all

Integrity constraint violation SYS_FK_51 table: USER_ROLE

thanks !