MusicCabinet 0.7.22 + Tomcat6.0.35 Issues

[Fractal]

First off, is there a known problem between these versions? (I am running Oracle Java 7) If there is no known issue, details follow:

-I do not have postgresql installed at the moment
-The standard subsonic war file deploys and runs just fine
-This is a clean install of Mint 14 with tomcat6 being the only addition
-OpenJDK has been removed
-The subsonic log reports no errors, only INFO
-The catalina log reports many errors but I cant seem to figure out which is the real cause

Catalina Log: http://pastebin.com/aDyMhGag
Subsonic Log: http://pastebin.com/1z4pRN9v

Any help is much appreciated. I would prefer to run MusicCabinet over tomcat instead of standalone because I feel it will be easier for me to expand upon. My next step is implementing SRE and then possibly my own extensions of the tool.

~Fractal

[hakko]

"Disk store path can't be created: /usr/share/tomcat6/subsonic/ehcache"

Does your server user have write permissions?

[Fractal]

"Disk store path can't be created: /usr/share/tomcat6/subsonic/ehcache"

Does your server user have write permissions?

Ah good catch. Should have noticed that. Thanks!

[jpspyro]

[RESOLVED]
I am having some similar issues.

Running,
Ubuntu 12.10
Postgresql 9.1
Tomcat 6.0.35
Java / Oracle Corporation 1.7.0

I had Subsonic 4.7 installed, configured, and working.

I downloaded the modified MusicCabinet version 0.7.22 and replaced the subsonic.war file while the tomcat server was down. Brought the server back up and now I get 'org.springframework.jdbc.BadSqlGrammarException'.

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_track_number, main_artist, main_album, main_genre, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_caption_cutoff, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat from user_settings where username=?]; nested exception is java.sql.SQLException: Column not found: FINAL_VERSION_NOTIFICATION in statement [select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_track_number, main_artist, main_album, main_genre, main_year, main_bit_rate, main_duration, main_format, main_file_size, playlist_caption_cutoff, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_chat from user_settings where username=?] 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)

/var/log/tomcat6/catalina.out
Mar 01, 2013 6:59:59 PM org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
Mar 01, 2013 6:59:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
SEVERE: The web application [/subsonic] registered the JDBC driver [org.hsqldb.jdbcDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
Mar 01, 2013 6:59:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/subsonic] appears to have started a thread named [HSQLDB Timer @321984a] but has failed to stop it. This is very likely to create a memory leak.
Mar 01, 2013 6:59:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/subsonic] appears to have started a thread named [Timer-0] but has failed to stop it. This is very likely to create a memory leak.
Mar 01, 2013 6:59:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/subsonic] appears to have started a thread named [pool-1-thread-1] but has failed to stop it. This is very likely to create a memory leak.
Mar 01, 2013 6:59:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/subsonic] appears to have started a thread named [pool-1-thread-2] but has failed to stop it. This is very likely to create a memory leak.
Mar 01, 2013 6:59:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/subsonic] appears to have started a thread named [pool-2-thread-1] but has failed to stop it. This is very likely to create a memory leak.
Mar 01, 2013 6:59:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/subsonic] appears to have started a thread named [pool-3-thread-1] but has failed to stop it. This is very likely to create a memory leak.
Mar 01, 2013 7:00:00 PM org.apache.coyote.http11.Http11Protocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
Mar 01, 2013 7:00:01 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat6/server/classes], exists: [false], isDirectory: [false], canRead: [false]
Mar 01, 2013 7:00:01 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat6/server], exists: [false], isDirectory: [false], canRead: [false]
Mar 01, 2013 7:00:01 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat6/shared/classes], exists: [false], isDirectory: [false], canRead: [false]
Mar 01, 2013 7:00:01 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat6/shared], exists: [false], isDirectory: [false], canRead: [false]
Mar 01, 2013 7:00:02 PM org.apache.coyote.http11.Http11Protocol init


I see no errors in the subsonic.log file.


Any help would be much appreciated.

[jpspyro]

After a couple of tries.

I created missing folders under /usr/share/tomcat6 mentioned in my post above and gave read/write permissions.

I undeployed and removed the subsonic folder and data under /var/lib/tomcat6/webapps/subsonic.

I started with a fresh copy of subsonic 4.7, deployed that, set up the admin user and password. I then stopped the tomcat server, removed the old subsonic fodler and data under /var/lib/tomcat6/webapps/subsonic, deployed the MusicCabinet version of subsonic, and it appears to be working now.

It seems that the version of subsonic+musiccabinet requires /usr/share/tomcat6/subsonic/ehcache.