Subsonic Forum

hi all,

I have a fresh Ubuntu 12.04 64bit:

Linux hear 3.2.0-23-generic #36-Ubuntu SMP Tue Apr 10 20:39:51 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux

With a fresh Subsonic 4.8 and MusicCabinet 0.7.24

java version "1.7.0_21"
psql (PostgreSQL) 9.1.9


I can successfully log into postgres manually using:

root@hear:~# psql -U postgres

however I cannot get MusicCabinet to play nicely. The postgres log states:

2013-04-29 16:22:07 UTC FATAL: password authentication failed for user "postgres"

and when I login to Music Cabinet, I am immediately taken to an error page stating the following:

Code: Select all

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   PreparedStatementCallback; bad SQL grammar [select username, locale, theme_id, last_fm_enabled, last_fm_username, transcode_scheme, show_now_playing, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, album_order_ascending, album_order_by_year, default_home_view, default_home_artists, default_home_albums, default_home_songs, artist_grid_width, album_grid_layout, related_artists, recommended_artists, reluctant_artist_loading, only_album_artist_recommendations, various_artists_shortlist, view_stats_for_all_users from user_settings where username=?]; nested exception is java.sql.SQLException: Column not found: ALBUM_ORDER_ASCENDING in statement [select username, locale, theme_id, last_fm_enabled, last_fm_username, transcode_scheme, show_now_playing, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, album_order_ascending, album_order_by_year, default_home_view, default_home_artists, default_home_albums, default_home_songs, artist_grid_width, album_grid_layout, related_artists, recommended_artists, reluctant_artist_loading, only_album_artist_recommendations, various_artists_shortlist, view_stats_for_all_users from user_settings where username=?]
Java version   Oracle Corporation 1.7.0_21
Operating system   Linux 3.2.0-23-generic
Server   jetty/8.y.z-SNAPSHOT
Memory   Used 43 of 120 MB
Stack trace   org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select username, locale, theme_id, last_fm_enabled, last_fm_username, transcode_scheme, show_now_playing, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, album_order_ascending, album_order_by_year, default_home_view, default_home_artists, default_home_albums, default_home_songs, artist_grid_width, album_grid_layout, related_artists, recommended_artists, reluctant_artist_loading, only_album_artist_recommendations, various_artists_shortlist, view_stats_for_all_users from user_settings where username=?]; nested exception is java.sql.SQLException: Column not found: ALBUM_ORDER_ASCENDING in statement [select username, locale, theme_id, last_fm_enabled, last_fm_username, transcode_scheme, show_now_playing, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, album_order_ascending, album_order_by_year, default_home_view, default_home_artists, default_home_albums, default_home_songs, artist_grid_width, album_grid_layout, related_artists, recommended_artists, reluctant_artist_loading, only_album_artist_recommendations, various_artists_shortlist, view_stats_for_all_users from user_settings where username=?]
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
   at net.sourceforge.subsonic.dao.AbstractDao.query(AbstractDao.java:58)
   at net.sourceforge.subsonic.dao.AbstractDao.queryOne(AbstractDao.java:62)
   at net.sourceforge.subsonic.dao.UserDao.getUserSettings(UserDao.java:165)
   at net.sourceforge.subsonic.service.SettingsService.getUserSettings(SettingsService.java:1021)
   at net.sourceforge.subsonic.service.SettingsService.setDefaultMusicCabinetUserSettings(SettingsService.java:1091)
   at net.sourceforge.subsonic.controller.MultiController.index(MultiController.java:93)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:601)
   at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:471)
   at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:408)
   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:900)
   at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
   at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
   at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:648)
   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
   at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
   at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
   at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
   at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
   at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
   at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
   at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
   at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
   at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
   at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
   at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
   at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
   at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
   at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
   at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
   at net.sourceforge.subsonic.filter.RequestEncodingFilter.doFilter(RequestEncodingFilter.java:43)
   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
   at net.sourceforge.subsonic.filter.ParameterDecodingFilter.doFilter(ParameterDecodingFilter.java:54)
   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
   at net.sourceforge.subsonic.filter.BootstrapVerificationFilter.doFilter(BootstrapVerificationFilter.java:54)
   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:559)
   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1072)
   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
   at org.eclipse.jetty.server.Server.handle(Server.java:365)
   at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
   at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:926)
   at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:988)
   at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:635)
   at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
   at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
   at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:627)
   at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:51)
   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
   at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
   at java.lang.Thread.run(Thread.java:722)
Caused by: java.sql.SQLException: Column not found: ALBUM_ORDER_ASCENDING in statement [select username, locale, theme_id, last_fm_enabled, last_fm_username, transcode_scheme, show_now_playing, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat, album_order_ascending, album_order_by_year, default_home_view, default_home_artists, default_home_albums, default_home_songs, artist_grid_width, album_grid_layout, related_artists, recommended_artists, reluctant_artist_loading, only_album_artist_recommendations, various_artists_shortlist, view_stats_for_all_users from user_settings where username=?]
   at org.hsqldb.jdbc.Util.throwError(Unknown Source)
   at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
   at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
   at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1436)
   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:581)
   ... 82 more


Can someone point me in the right direction? Looking forward to playing with MusicCabinet!

Thanks,

cntrle

That's probably caused by an incorrect password. Try deleting your /var/subsonic/subsonic.properties and give it the postgres password again.

I suspect that MusicCabinet is not compatible when installed on top of subsonic 4.8 yet. I got this same error (BadSqlGrammarException) when I tried to log in after installing MusicCabinet. I had to revert to backups of my C:\subsonic and Program Files\Subsonic folders to get subsonic working again.

I wouldn't normally resurrect a thread like this, but, I am running into the *exact* same issue.
In subsonic.properties, what is the line for supplying the postgres password? I suspect that is all that is needed to fix this issue?

Thanks!

I entered the PostgreSQL password in the initial Subsonic/Music Cabinet set-up screen. I am guessing you already have done this, but I noticed some others have missed this step. If you already have done this.... it sounds like if you remove the file mentioned in the post above, launch Music Cabinet and enter the password in Music Cabinet Setup . I did a clean install and didn't try to update my existing Subsonic 4.6. If this is truly a fresh install you may just want to try again?

Music Cabinet is a great mod and the last.FM integration is a big plus over Subsonic however this forum is not very active, and it appears development has stopped.

Good luck!

o.O wait what setup screen? I never get one?
Setup simply asks a location, and then the first time I login to the server it is my old password and it goes onwards to the error page?

blin100 wrote:o.O wait what setup screen? I never get one?
Setup simply asks a location, and then the first time I login to the server it is my old password and it goes onwards to the error page?

+1 same situation here
no setup screen no nothing

Same Problem here.
There is still no solution?

Or ist there any other tool for browsing by genre?

Does anyhone have a combination of versions from subsonic and musiccabinet, which are working together and can share this to us? Maybe TNRocker?

I am running OS X and did a clean install rather than upgrading my existing Subsonic install. After installing Java, I installed postgres and set up user and password. I then installed and launched Music Cabinet. The initial Music Cabinet screen had prompt and link to add postgres password to Music Cabinet.

If you go to Settings/General, about half way down there is a check box; "Show getting started on start up". Make sure this is selected, log out and log back in. You should see where to add the postgres password. The same screen also allows you to sign up for last.fm. I hope that make sense.

Edit - I think Music Cabinet was a fork of 4.6. I also have users streaming via Dsub (Android) and iSub(iOS). Everything works great, especially the dSub app.

Hi TNRocker,

a standalone installation of MusicCabinet without upgrading an existing Subsonic installation worked for me.
Thank you very much!

Just came across Music Cabinet and installed following instructions, only it refuses to allow me past the login screen. I have entered the default admin/admin username and password, but it simply gives me the same screen again. Any ideas..???

pinkmoon wrote:Just came across Music Cabinet and installed following instructions, only it refuses to allow me past the login screen. I have entered the default admin/admin username and password, but it simply gives me the same screen again. Any ideas..???

Have you checked any of the log files? What OS are you running?

Thanks for the quick reply

Where would I find the log files - and Windows 8..

I'm not sure where they should be in Windows. Look in whatever folder it installed to, probably in your program files folder. There should be both a subsonic.log file and musiccabinet.log file you can check.