MusicCabinet - artist radio, genre radio & related artists

[hakko]

I totally agree that there's a lot more to do! I have such a long wish list for this project. The only problem with charts is that the Terms of Service for last.fm states that chart data is to be cached for seven days (so it can't be updated daily). see http://www.last.fm/api and http://www.last.fm/api/tos

but if you have concrete ideas of which api methods to use, and how to display the data, feel free to post! (and remember that it's open source, so you can start hacking on it yourself! and I'll incorporate your code into the project if it's well written and follows the general code standard. see https://github.com/hakko/musiccabinet)

[vollbr0t]

i don't know... for me it would not be absolutley necessary to have the VERY newest charts... one week old data is very much okay i think

[precipitous]

Regarding integrating more Last.FM data and functionality - I would LOVE to have the ability to select and play Last.FM (user) group radio in MusicCabinet much like we can now play genre radio. They have some really amazing group radio stations available like Brainwashed, The Real Dark Ambient Group, Cold Meat Industry, etc.

@Hakko - Would such a thing be possible?

[hakko]

I just listened to (and enjoyed) Brainwashed radio station, but I can't figure out how to integrate it? I can't find any way to extract historical playlists of what have been played at such a radio station (then that could be summoned into both "generate playlist of my matching tracks" and "show me a list of the tracks I miss"). How do you imagine it to work?

[precipitous]

I just listened to (and enjoyed) Brainwashed radio station, but I can't figure out how to integrate it? I can't find any way to extract historical playlists of what have been played at such a radio station (then that could be summoned into both "generate playlist of my matching tracks" and "show me a list of the tracks I miss"). How do you imagine it to work?

@hakko: I do not know how Last.FM handles the group radio stations, but I will do some research and get back to you... They have a fairly extensive API, and there is a lot of outside documentation available, so I am sure I will be able to figure out something. I know that there are methods for both groups and radios that return at least part of the data MusicCabinet would need, so hopefully it will not be too difficult to find the rest.

In case you are interested, the official Last.FM API site is: http://forum.subsonic.org/forum/posting.php?mode=quote&f=8&t=9504&p=43505

[hakko]

I guess you mean http://www.last.fm/api ? One could fetch loved tracks for a user + top tracks for the last week or so and generate playlists out of that, but I'm not sure about radio stations? let me know if you find something useful!

[precipitous]

I guess you mean http://www.last.fm/api ? One could fetch loved tracks for a user + top tracks for the last week or so and generate playlists out of that, but I'm not sure about radio stations? let me know if you find something useful!

I guess I should have proof-read my post before submitting it.... I feel like a real idiot! **Note to self: remember to copy before pasting!)**

[hakko]

: ) np

[vollbr0t]

throwing just some more ideas in the forum:
another awesome function would be to generate a random playlist from just the "loved"-tracks a user has marked on last.fm! in addition a button within subsonic to love a track on last.fm would be great too

[Aktarus]

I have a little problem with my database update since a couple of weeks !!!
When I update manually or automaticaly the database, everything seems to be ok (no errors) but some new albums are missings !!!
If I want to update MusicCabinet manually, I got this SQL error:

Error
Subsonic encountered an internal error. You can report this error in the Subsonic Forum. Please include the information below.

Exception org.springframework.jdbc.BadSqlGrammarException
Message StatementCallback; bad SQL grammar [create table music.duplicate_artists (artist_id integer)]; nested exception is org.postgresql.util.PSQLException: ERREUR: la relation « duplicate_artists » existe déjà
Java version Sun Microsystems Inc. 1.6.0_31
Operating system Windows 7 6.1
Server jetty-6.1.x
Memory Used 211 of 247 MB
Stack trace org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table music.duplicate_artists (artist_id integer)]; nested exception is org.postgresql.util.PSQLException: ERREUR: la relation « duplicate_artists » existe déjà
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:429)
at com.github.hakko.musiccabinet.dao.jdbc.JdbcDatabaseAdministrationDao.loadDatabaseUpdate(JdbcDatabaseAdministrationDao.java:199)
at com.github.hakko.musiccabinet.service.DatabaseAdministrationService.loadNewDatabasUpdates(DatabaseAdministrationService.java:100)
at net.sourceforge.subsonic.controller.MusicCabinetSettingsController.doSubmitAction(MusicCabinetSettingsController.java:88)
at org.springframework.web.servlet.mvc.SimpleFormController.onSubmit(SimpleFormController.java:443)
at org.springframework.web.servlet.mvc.SimpleFormController.onSubmit(SimpleFormController.java:409)
at org.springframework.web.servlet.mvc.SimpleFormController.onSubmit(SimpleFormController.java:381)
at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267)
at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:265)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:166)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:173)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at net.sourceforge.subsonic.filter.RequestEncodingFilter.doFilter(RequestEncodingFilter.java:43)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at net.sourceforge.subsonic.filter.ParameterDecodingFilter.doFilter(ParameterDecodingFilter.java:54)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at net.sourceforge.subsonic.filter.BootstrapVerificationFilter.doFilter(BootstrapVerificationFilter.java:54)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
Caused by: org.postgresql.util.PSQLException: ERREUR: la relation « duplicate_artists » existe déjà
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:422)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
... 62 more

Does someone have an idea of what is wrong with my database ???
My system is up to date with the latest release of mod !!!


MERCI

[jake-]

I have a little problem with my database update since a couple of weeks !!!
When I update manually or automaticaly the database, everything seems to be ok (no errors) but some new albums are missings !!!
If I want to update MusicCabinet manually, I got this SQL error:

Do you have installed the correct Postgres Version (PostgreSQL 9.1)?

[Aktarus]

I have a little problem with my database update since a couple of weeks !!!
When I update manually or automaticaly the database, everything seems to be ok (no errors) but some new albums are missings !!!
If I want to update MusicCabinet manually, I got this SQL error:

Do you have installed the correct Postgres Version (PostgreSQL 9.1)?

Yes, I have the latest release of PostgreSQL

[hakko]

Aktarus: sorry, that sounds like my fault!

How do you feel about starting pgAdmin (the tool that lets you manage Postgresql) and fix the problem?

Start pgAdmin, display Postgresql 9.1 databases, connect to musiccabinet, open a SQL window and execute:

Code: Select all

drop table music.duplicate_artists

then log in to the Subsonic web interface as administrator, go to Settings -> MusicCabinet. There should be a text saying something like "it looks like you recently installed or updated MusicCabinet" and a button saying "update database". Press the "update database" button and wait while the database gets repaired (this could take a little while - say 10-60 seconds). report back if you run into any trouble! here or in a pm.

[Aktarus]

Oh yes ... it seems to work well now !!!

Thank you very much ... for everything

[jacobthe4th]

Hakko,

I had to rebuild my server this weekend and I am running SS v6.2, with the MC v5.50 The log files are here http://tinyurl.com/7w54ln5.

I believe again it is stumbling on an artist or something. Here is what the Settings-> Search dialog says...



Let me know what I have setup wrong... if you see anyhting.

Thanks,

Jacob