Subsonic 3.7 released

[sindre_mehus]

Hi all,

Please notice that 3.7 has been released. There's a whole bunch of new stuff, but most importantly:

o New jukebox mode.
o New themes and languages.
o Improved search.
o Performance improvements.
o Bugfixes

Complete change log: http://subsonic.sourceforge.net/changelog.php
Download: http://subsonic.sourceforge.net/download.php

Please remember to vote for Subsonic in the SourceForge Community Awards (see signature below)!

Thanks for your attention,
Sindre

[ok]

First off, I will definitely vote for subsonic later today.

I just wanted to mention a bug listed in a non v3.7 specific topic that relates specifically to v3.7.

When updating to v3.7, the "admin" user seems to lose admin rights. I had already designated another user to be an admin, so I'm good to go. However, those people with only one admin user, may no longer have the ability to, for instance, change "settings".

Just an FYI,

Cheers
ok

[SpritHansi]

I didn't have that problem when I upgraded from v3.6 to v3.7.

[zeekay]

Great release sindre! Thanks for your hard work

[ok]

Hi again,

This is still a problem for me.

I installed v3.6 back again and saw settings for the admin user. Then I reinstalled v3.7 and settings was not available for the admin user.

I'm running Windows XP Pro.

Any ideas?

Thanks
Scott

[ok]

Also, here's the other post describing this admin user issue

http://forum.subsonic.org/forum/viewtop ... admin+user

[ok]

P.S. I voted for Subsonic on SF.net

[ok]

I hunted blindly through the subsonic files and found a file called subsonic.script

I guessed that these were the available user roles:

INSERT INTO ROLE VALUES(1,'admin')
INSERT INTO ROLE VALUES(2,'download')
INSERT INTO ROLE VALUES(3,'upload')
INSERT INTO ROLE VALUES(4,'playlist')
INSERT INTO ROLE VALUES(5,'coverart')
INSERT INTO ROLE VALUES(6,'comment')
INSERT INTO ROLE VALUES(7,'podcast')
INSERT INTO ROLE VALUES(8,'stream')
INSERT INTO ROLE VALUES(9,'settings')
INSERT INTO ROLE VALUES(10,'jukebox')

But the admin user only had these eight roles

INSERT INTO USER_ROLE VALUES('admin',1)
INSERT INTO USER_ROLE VALUES('admin',2)
INSERT INTO USER_ROLE VALUES('admin',3)
INSERT INTO USER_ROLE VALUES('admin',4)
INSERT INTO USER_ROLE VALUES('admin',5)
INSERT INTO USER_ROLE VALUES('admin',6)
INSERT INTO USER_ROLE VALUES('admin',7)
INSERT INTO USER_ROLE VALUES('admin',8)

The fix I used

Caveat: this worked for me but you may want to get a second opinion from a Subsonic expert first before proceeding unless you're a daredevil like me.

1) Login to Subsonic as the admin user
2) Change the section of the URL listed as "index.view" to "db.view" (i.e. http://localhost/db.view)
3) Enter select * from user_role where username = 'admin' in the box and click the <OK> button.
4) If it shows only eight roles, Houston we have a problem for v3.7 as there now seem to be 10 roles
5) Enter INSERT INTO USER_ROLE VALUES('admin',9) in the box and click the <OK> button.
6) Note: not sure if this is necessary, but I also entered INSERT INTO USER_ROLE VALUES('admin',10) in the box and click the <OK> button.
7) Reenter select * from user_role where username = 'admin' in the box and click the <OK> button.

The admin user should now have 10 roles, or nine roles if you don't run step 6.

8) Go back to the index view (i.e. http://localhost/index.view)

At this point, I just refreshed my browser and I had access to settings for the admin user.

Cheers
ok

[sindre_mehus]

Hi,

I can confirm that the fix suggested above will work, well done!

I don't understand, however, how the database comes in this state in the first place. The 'settings' role is new in 3.7, but it's supposed to be assigned to all users during initialization.

For the technically minded, here's the code that's run during init:

Code: Select all

        if (template.queryForInt("select count(*) from role where id = 9") == 0) {
            LOG.info("Role 'settings' not found in database. Creating it.");
            template.execute("insert into role values (9, 'settings')");
            template.execute("insert into user_role select distinct u.username, 9 from user u");
            LOG.info("Role 'settings' was created successfully.");
        }


Can't figure out why this doesn't work in some cases.

[jigsaw]

Can't figure out why this doesn't work in some cases.

Maybe it's an OS thing?
I can confirm that this worked fine after upgrading to 3.7 on linux standalone. No manual fix needed.

[ok]

From v3.6, I upgraded to v3.7b1 a couple of months ago, then downgraded back to v3.6 because of issues I observed with the web player not starting as it previously had, then I upgraded to v3.7.

Is it possible that downgrading from v3.7b1 back to v3.6 put the database in this state?

Also, in my case, the 'settings' role was assigned to all users except for the admin user. Since your code snippet seems targeted at all users, I'm not sure why it didn't work for the admin user in my case.

Cheers
ok

[sindre_mehus]

Is it possible that downgrading from v3.7b1 back to v3.6 put the database in this state?

Ah, yes that's very likely the reason. Do you remember if you modified the admin user (e.g., changed password) after rolling back to 3.6?

[deriksen]

Don't know if this has been mentioned or if it's even just a 3.7 bug, or if it was there in previous versions as well.

Giving a user admin rights (in my case at least) results in mini Now Playing graphics showing the admin user as playing the tracks and not the logged in user (with admin rights).

The log shows the correct user beeing parsed in the StreamController, but if I'm not mistaken, the user statistics gets messed up as well.

[ok]

Is it possible that downgrading from v3.7b1 back to v3.6 put the database in this state?

Ah, yes that's very likely the reason. Do you remember if you modified the admin user (e.g., changed password) after rolling back to 3.6?

No Sindre. I didn't change anything else (I'm 99% sure) after reverting to v3.6

[flacflac]

Great new release Sindre, I went ahead and became registered!

There is a bug in your Jukebox mode regarding the setting "Repeat is off" - it's not off!

I am reading "Repeat is off" above the player controls yet it loops a single track I started playing via Jukebox. Log reads as follows:

[7/4/09 10:43:38 PM CEST] INFO JukeboxService Starting jukebox player on behalf of admin
[7/4/09 10:43:38 PM CEST] DEBUG JukeboxService stateUpdated : OPENING:-1:net.sourceforge.subsonic.io.PlaylistInputStream@39f9d3f0
[7/4/09 10:43:38 PM CEST] INFO PlaylistInputStream Opening new song Album\Trackname.flac
[7/4/09 10:43:38 PM CEST] INFO MusicFileInfoDao Created music file info for X:\music\Soundtracks\Album\
[7/4/09 10:43:38 PM CEST] DEBUG TranscodeInputStream Starting transcoder: [c:\subsonic\transcode\flac] [-c] [-s] [-d] [X:\music\Soundtracks\Album\Trackname.flac]
[7/4/09 10:43:38 PM CEST] DEBUG TranscodeInputStream Starting transcoder: [c:\subsonic\transcode\lame] [-v] [-V] [0] [-] [-]
[7/4/09 10:43:38 PM CEST] DEBUG InputStreamReaderThread (c:\subsonic\transcode\lame) LAME version 3.96.1 (http://lame.sourceforge.net/)
[7/4/09 10:43:38 PM CEST] DEBUG InputStreamReaderThread (c:\subsonic\transcode\lame) CPU features: MMX (ASM used), SSE, SSE2
[7/4/09 10:43:38 PM CEST] DEBUG InputStreamReaderThread (c:\subsonic\transcode\lame) Using polyphase lowpass filter, transition band: 19383 Hz - 19916 Hz
[7/4/09 10:43:38 PM CEST] DEBUG InputStreamReaderThread (c:\subsonic\transcode\lame) Encoding to
[7/4/09 10:43:38 PM CEST] DEBUG InputStreamReaderThread (c:\subsonic\transcode\lame) Encoding as 44.1 kHz VBR(q=0) j-stereo MPEG-1 Layer III (ca. 5.7x) qval=3

[7/4/09 10:43:38 PM CEST] DEBUG JukeboxService opened : {vbr=false, mp3.crc=false, mp3.copyright=false, mp3.padding=false, mp3.channels=2, mp3.version.mpeg=1, audio.framerate.fps=38.28125, audio.channels=2, mp3.framerate.fps=38.28125, mp3.framesize.bytes=727, mp3.version.layer=3, mp3.frequency.hz=44100, mp3.header.pos=0, mp3.bitrate.nominal.bps=224000, mp3.vbr.scale=0, mp3.version.encoding=MPEG1L3, basicplayer.sourcedataline=com.sun.media.sound.MixerSourceLine@44c42ce4, bitrate=224000, audio.type=MP3, mp3.mode=1, mp3.vbr=false, audio.samplerate.hz=44100.0, mp3.original=true}
[7/4/09 10:43:38 PM CEST] DEBUG JukeboxService stateUpdated : OPENED:-1
[7/4/09 10:43:39 PM CEST] DEBUG JukeboxService stateUpdated : PLAYING:-1
[7/4/09 10:43:39 PM CEST] DEBUG JukeboxService stateUpdated : GAIN:0.5099999904632568
[7/4/09 10:43:41 PM CEST] DEBUG JukeboxService stateUpdated : GAIN:0.6100000143051147
[7/4/09 10:43:42 PM CEST] DEBUG JukeboxService stateUpdated : GAIN:0.7099999785423279
[7/4/09 10:43:43 PM CEST] DEBUG JukeboxService stateUpdated : GAIN:0.8100000023841858
[7/4/09 10:43:43 PM CEST] DEBUG JukeboxService stateUpdated : GAIN:0.9100000262260437
[7/4/09 10:43:46 PM CEST] DEBUG JukeboxService stateUpdated : GAIN:0.8399999737739563
[7/4/09 10:47:36 PM CEST] INFO PlaylistInputStream Opening new song Album\Trackname.flac
[7/4/09 10:47:36 PM CEST] DEBUG TranscodeInputStream Starting transcoder: [c:\subsonic\transcode\flac] [-c] [-s] [-d] [X:\music\Soundtracks\Album\Trackname.flac]
[7/4/09 10:47:36 PM CEST] DEBUG TranscodeInputStream Starting transcoder: [c:\subsonic\transcode\lame] [-v] [-V] [0] [-] [-]
[7/4/09 10:47:36 PM CEST] DEBUG InputStreamReaderThread (c:\subsonic\transcode\lame) LAME version 3.96.1 (http://lame.sourceforge.net/)
[7/4/09 10:47:36 PM CEST] DEBUG InputStreamReaderThread (c:\subsonic\transcode\lame) CPU features: MMX (ASM used), SSE, SSE2
[7/4/09 10:47:36 PM CEST] DEBUG InputStreamReaderThread (c:\subsonic\transcode\lame) Using polyphase lowpass filter, transition band: 19383 Hz - 19916 Hz
[7/4/09 10:47:36 PM CEST] DEBUG InputStreamReaderThread (c:\subsonic\transcode\lame) Encoding to
[7/4/09 10:47:36 PM CEST] DEBUG InputStreamReaderThread (c:\subsonic\transcode\lame) Encoding as 44.1 kHz VBR(q=0) j-stereo MPEG-1 Layer III (ca. 5.7x) qval=3


...and it keeps on going. Nothing major, just a little bug. (oh and setting it to "Repeat is ON" does not stop repeating either)

Best wishes,
ff