Subsonic registration engine

[SparkyRih]

By what I can ell the database used for subsonic is HyperSQL Database Engine (http://hsqldb.org/) and buy the db properties file its version 1.8.0.5. This database is purely written in java and is free.

I have no java experience and have no idea how to edit the existing database, but if there is someone out there that has the know how, we could have a built-in registration page as one with subsonic.

The way I would go is figure out the database structure in subsonic, then build a entirely new database with the same structure, then add the registration table, then build the register.jsp page to include an admin page that will list the user whom registered and then can approve or disapprove the requests.

It's even easier than that, there is no need to change the db structure, you just need to know the structure (which is very easy)... but the hard part for me is that I don't know a lot about java (compared to other languages I know)...

I could give it a try because I'd love to know a bit more about java, but Í don't see myself trying any time soon...

[trickydick]

SO I figured out that you can run the hyperSql Managment tool and connect to the subsonci database using the admin account. Although it is restricted compared to the SA account. Does anyone know the SA password? Is it in the java code/connection string somewhere? I was able to successfully reset the password (which inturn broke subsonic)...goog thing I made a backup of the database.

Heres is how: download Hypersql (http://sourceforge.net/projects/hsqldb/files/

then extract it to where ever on your server. open a command prompt and change directory to the lib folder (..\hsqldb\lib), then type in

Code: Select all

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


This will bring up the GUI for the DB manager. Now you have to connect to it the database. Under Type dropdown select the standalone and then in the URL type the path to your database:

Code: Select all

jdbc:hsqldb:file:c:\subsonic\db\subsonic.data

You'll notice if you hit OK; it will say the SA doens't exist. but you can type int he the admin account you set in subsonic and it will connect but you can;t do anything.

Now if you reset the SA password you can connect, but i still have permission issues, i don't know why.

To reset the SA password (this WILL break subsonic)....be sure to make a backup: go to the subsonic site. login as admin, then in the URl type in db.view. You will get to a DB command window. If you type

Code: Select all

SET PASSWORD "<ur password>"

this will reset the SA password. the site will no longer work, but you can now connect with the SA account in the management tool. Now all you have to do is reset the password back...but what is it?

[trickydick]

oddly enough I found if you stop the subsonci service, you can connect to the database with the SA and a blank password. I guess there is no password for SA. Still can't modify anything though...why? I can't even look at tables

Code: Select all

SELECT * FROM MUSIC_FILE

[SparkyRih]

I thought of an easy way of registering users withtout using mysql or even PHP, but how to solve these questoins:

1. Is it possible to send mails using Java?
2. What is a safe way to reset a users password via mail (since there is no password hash or any other unique data to verify if the reset is legit)...

[trickydick]

the problem with this:

1.) I don't like have two databases for the same system.
2.) Once a user registers, you will have to have it unencrypted to set it in subsonic, this can have some issues, like the plain text password can be hacked, and i have to manually transfer th epassword to the subsonic database. that and I would "know" the users password
3.) Its another code i have to maintain.


Yes you can have an java code setup to send the user a notice when a password get reset, or registered for that matter. you will ahve to have SMTP support or CDOYS or some protocol like that enabled on your server. But again it falls under a different database. why can't we just add more tables (registration table) to the current dbase leaving the current schema intacted for the site to run properly. this won't require any additional code for the subsonic site, except the registration part which should be pretty easy.

another option is to spme how send query strings to the DB.view from another built registration site, that way the manual process is taken care of

[SparkyRih]

I don't think you fully understand me...

In the first place... this system was designed for me and a friend of mine to register users in subsonic BUT ALSO in other mysql driven services on our servers... then some-one else asked me to share it, so I did...

Second, I do like to write a new version for subsonic alone, without any other server or db required... Theoratically I'm able to do that, but I just have no experience in java (YET)...

That said, I don't understand why you would wanna change the subsonic DB? There is no need for that at all...

BTW I think I also found the answer to the second question of my last post...

Give me some time to get familiar with java, or try to make something yourself...

[columbiabbs]

First let me say THANKS for your App. While I don't have it all working yet it does seem like some thing I realy
want to get to work. This is what I have done so far.

1. I have edited the Login.jsp file in the Subsonic folder
2. Have edited the following files
a./lib/config.php
b. mailconf.php
c./lib/mails
3. Now where do I move the files to?.
4. New database?. from where?
5. where do I move the files too?
6. I have three folders in my doc folder that need to be moved somewhere?.

Again thanks for any help you can give me.
William
using ubantu and Debain Subsonic

[dcuellar]

Does this allow me to moderate and accept or decline users' registrations?

I think this mod should be standard. We should also have some sort of invite system where we can send invites through e-mail.

[SparkyRih]

Does this allow me to moderate and accept or decline users' registrations?

I think this mod should be standard. We should also have some sort of invite system where we can send invites through e-mail.

I could add these features in the furute... not a bad idea...

And for those of you not knowing how to get this mod to work, I'm gonna try to create an easy to use package containing everything you need....

[BKKKPewsey]

I like easy
+1

[columbiabbs]

Hi All:
can someone tell me where the files go after then have been edited ?.
Thanks William

[SparkyRih]

Hi All:
can someone tell me where the files go after then have been edited ?.
Thanks William

A lot of people have issues with that, I'm gonna try to make a full package containing everything you need...

I still haven't had time to do this, I'm very sorry for this, I'll try to get it all together this weekend...

[columbiabbs]

Hey has anybody REALY got this work??

I have tryed with not luck,, Can someone please tell where the files go after they have been edited..
I am running linux and 4.5 I realy need some's help... Any help please and thanks.

William.

[guizzzmo]

hello
i dont find where put ehe folder subregengine

thanks;)

[Qbix]

Euuhmm..maybe a really stupid question but....how do I install PHP5 in Subsonic?
I'm not using IIS, Xamp, Wamp or what so ever.