Madsonic - Mashup Mod (old Support Thread)

[GJ51]

But you haven't tested your phones on a known working server, or had someone else test your server availability from outside your network? Is the computer you're using to connect inside or outside your network?

You're letting us know you're having trouble, but you're not providing enough information to help pinpoint what the problem is.

My modded site is up and running and I can connect to it with my Android phone without issues. My other users are also not experiencing any issues.

If you want help, you have to be willing to do some simple tests that identify the problem.

It would also be helpful to know what OS and installation version you are running.

[MadEvil]

I have verified my phone has full connectivity in both Wifi & 4G, the interesting part is it was working with just plain old Subsonic however since I deleted and rebuilt using the Madsonic Mod I haven't been able to stream.

I am able to access through my web browser on my computer, just not from my mobile devices.

Hi,

Well this can have several causes:

• transcoding
• Client App caching
• wrong method with the wrong technique

TYI: Madsonic Mashup Mod works only with self hosted domain, the redirecting service from *.subsonic.org isn't working! (Work as Design)

I test my Mod with the standard Subsonic Android Client and it works well.

Did you replace the ffmpeg version or did you try an other version?
Did you try to wipe your Subsonic App Caches/Data on Mobile Clients?

can you give me some more details? (Server, Installation, Environment, ...)

Best regards

[N17r0us]

For my versions I am running 3112 on w Windows7 machine, my machine is accessible outside my internal home network, I am using a (no-ip.com) host redirect which has my correct and current IP for my home internet establised. I can access the web interface for the subsonic server remotely from my work or from friends houses so I know all ports are being forwarded correctly, additionally I can access the web interface from my mobile phone web browser.

I am using iSub Music Streamer for my iPhone, I have removed and re installed the program as well as reconfigured all settings.

What seems to happen is the app will connect to my subsonic server and act as if its playing however doesn't, it will however fully cache the song and I can then play the file from it being locally cached.

@GJ51 I will shoot you a PM shortly to get test credentials.

[N17r0us]

Thank you Gary (GJ51) for all your help, I will find a better solution for my phone.

[MadEvil]

Madsonic Client Design Draft 2



Show Design Gallery

Best regards

[GJ51]

I have verified my phone has full connectivity in both Wifi & 4G, the interesting part is it was working with just plain old Subsonic however since I deleted and rebuilt using the Madsonic Mod I haven't been able to stream.

I am able to access through my web browser on my computer, just not from my mobile devices.

Hi,

Well this can have several causes:

• transcoding
• Client App caching
• wrong method with the wrong technique

TYI: Madsonic Mashup Mod works only with self hosted domain, the redirecting service from *.subsonic.org isn't working! (Work as Design)

I test my Mod with the standard Subsonic Android Client and it works well.

Did you replace the ffmpeg version or did you try an other version?
Did you try to wipe your Subsonic App Caches/Data on Mobile Clients?

can you give me some more details? (Server, Installation, Environment, ...)

Best regards

Actually, the redirect service will work if you do a few extra steps. I switched to the WAR version a while back once Bushman4 convinced me I wasn't too old to learn new tricks.

If you install Subsonic using the standard release and register the server.subsonic.org address, then change over to your modded setup and use the same port it'll work. I did that a few months ago when I started using the Mashup mod and never noticed that it was an issue.

[gurutech]

Can someone post the link to this? The only ones I have found from the first post are gallery (pictures), or the sourceforge repository. I can't seem to find the actual mod in the first post.

[GJ51]

http://ul.to/f/ejk2sl

[gurutech]

Installed, and got this error:

Code: Select all

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    PreparedStatementCallback; bad SQL grammar [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.override,media_file.format,media_file.title,media_file.album,media_file.album_name,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, playlist_file where media_file.id = playlist_file.media_file_id and playlist_file.playlist_id = ? and media_file.present order by playlist_file.id]; nested exception is java.sql.SQLException: Column not found: MEDIA_FILE.OVERRIDE in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.override,media_file.format,media_file.title,media_file.album,media_file.album_name,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, playlist_file where media_file.id = playlist_file.media_file_id and playlist_file.playlist_id = ? and media_file.present order by playlist_file.id]
Java version    Oracle Corporation 1.7.0_06-icedtea
Operating system    Linux 3.5.3-1.fc17.i686
Server    jetty-6.1.x
Memory    Used 49 of 79 MB
Stack trace    org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.override,media_file.format,media_file.title,media_file.album,media_file.album_name,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, playlist_file where media_file.id = playlist_file.media_file_id and playlist_file.playlist_id = ? and media_file.present order by playlist_file.id]; nested exception is java.sql.SQLException: Column not found: MEDIA_FILE.OVERRIDE in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.override,media_file.format,media_file.title,media_file.album,media_file.album_name,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, playlist_file where media_file.id = playlist_file.media_file_id and playlist_file.playlist_id = ? and media_file.present order by playlist_file.id] at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:220) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710) at net.sourceforge.subsonic.dao.AbstractDao.query(AbstractDao.java:83) at net.sourceforge.subsonic.dao.MediaFileDao.getFilesInPlaylist(MediaFileDao.java:82) at net.sourceforge.subsonic.service.PlaylistService.getFilesInPlaylist(PlaylistService.java:96) at net.sourceforge.subsonic.controller.LoadPlaylistController.loadPlaylistConfirm(LoadPlaylistController.java:72) 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:473) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410) 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.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) 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:124) 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:174) 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.headerComplete(HttpConnection.java:830) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514) 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: java.sql.SQLException: Column not found: MEDIA_FILE.OVERRIDE in statement [select media_file.id,media_file.path,media_file.folder,media_file.type,media_file.override,media_file.format,media_file.title,media_file.album,media_file.album_name,media_file.artist,media_file.album_artist,media_file.disc_number,media_file.track_number,media_file.year,media_file.genre,media_file.bit_rate,media_file.variable_bit_rate,media_file.duration_seconds,media_file.file_size,media_file.width,media_file.height,media_file.cover_art_path,media_file.parent_path,media_file.play_count,media_file.last_played,media_file.comment,media_file.created,media_file.changed,media_file.last_scanned,media_file.children_last_updated,media_file.present,media_file.version from media_file, playlist_file where media_file.id = playlist_file.media_file_id and playlist_file.playlist_id = ? and media_file.present order by playlist_file.id] 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:1322) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:585) ... 67 more


[gurutech]

Found the problem... It's with how my media folders are entered into Subsonic. If I delete both of the folders from the list, the error goes away (but of course, I now have no music!).

As soon as I add a folder (which is in the format of: /media/music), the error comes back. It appears the SQL backend doesn't like that format or something... any ideas how to fix? I'm running Fedora 17, with MySQL, if that helps.

[jdubso]

Fresh install or upgrade? If upgrade make a backup then try a fresh install. Then add media back.

Sent from my Galaxy Nexus using Tapatalk 2

[gurutech]

Did it both ways. Same thing. As soon as a media folder is added, I get the error. If I delete (or even disable) all folders, then it's fine.

One thing I did notice was that I can click on "DB" and click on any of the options listed and click OK, it will show me the correct results.

[gurutech]

ok, seems to be working now... removed it again, then deleted the /var/subsonic folder and reinstalled.

Had to re-do the whole "change admin password" again, but at least it's scanning everything now.

Edit: OK, seems to be working great, except for one thing - the Carousel mod. I click "Hot" and it will show me the "Loading", right, and left arrows, but fails to show any cover art. Any ideas on this? (Had similar problem before installing Mashup with the same mod...)

[MadEvil]

ok, seems to be working now... removed it again, then deleted the /var/subsonic folder and reinstalled.

Had to re-do the whole "change admin password" again, but at least it's scanning everything now.

Edit: OK, seems to be working great, except for one thing - the Carousel mod. I click "Hot" and it will show me the "Loading", right, and left arrows, but fails to show any cover art. Any ideas on this? (Had similar problem before installing Mashup with the same mod...)

hi,
this is changed since Build 3100 viewtopic.php?f=8&t=9187&start=195#p45124

Now you can tag your own favorite albums without linked to Top Rated albums.

Hope this help you.
Best regards

[gurutech]

User error... sheesh... lol

Is this new feature "per user", or is it "overall" (meaning anyone can select an album as a hot item and everyone will see it as a hot item?)