Madsonic - Mashup Mod (old Support Thread)

[N17r0us]

Hi All,

I am running the final version of this mod, I completed a clean install and I am having a problem streaming to mobile devices, both an iPhone and Android will connect to the server, start the buffering process but never play, regardless of how many times I select play. Any ideas?

BTW, great Mod, I really love all the new features.

[GJ51]

Mine works fine using one of the mod apk's for ICS. Have you checked your phones on other known working websites to determin if it's the phone or the server.

You're welcome to test on my server if you like. Just send me a PM and I'll send you the link and creds.

[N17r0us]

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.

[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.