MusicCabinet - artist radio, genre radio & related artists

[hakko]

Is it common to have a machine that can run a Java server but not a Postgres database? It's technically possible to have the two running at different machines, but there's currently no easy configuration for doing that in MusicCabinet.

[PiX64]

I'm sure it is possible, I just haven't seen any documentation anywhere on how to do it. Was hoping maybe you all had some experience with it.

[hakko]

I never heard of unraid before, so maybe I shouldn't even try to give advice. But I'd guess you simply have to build Postgres from the sources. Like this: http://www.thegeekstuff.com/2009/04/lin ... rom-source. But I've no idea how stripped down the unraid is, if it even comes with a compiler...

[PiX64]

Yeah - That is what I was thinking as well. It gets a little tricky with unraid because its a live system that runs off of USB key, and any package install that you needs to be done everytime which of course include modifying .sh scripts and such to get the custom ap running everytime.

Thanks for the help, and hopefully i can get this running.

[PiX64]

How difficult is it to pop open the war and change the location at which musiccabinet looks for the postgresql database?

Is the configutation for the server in its own class, or is it riddled throughout the code?

[hakko]

The subsonic.war is (as you might have noticed) just a zip file. Rename it (or just open it using a good zip file tool) and edit WEB-INF\applicationContext-service.xml.

Look for

Code: Select all

         
<prop key="musiccabinet.jdbc.url">jdbc:postgresql://localhost:5432/musiccabinet</prop>
<prop key="musiccabinet.jdbc.initialurl">jdbc:postgresql://localhost:5432/template1</prop>


and replace "localhost" with your postgres server name. There are no hard-coded references anywhere, it's just that single xml file.

[hakko]

You could also try starting Subsonic with extra parameters (this will depend on your environment). You'd want to do

Code: Select all

java -Dmusiccabinet.jdbc.url=jdbc:postgresql://xx.xx.xx.xx:5432/musiccabinet -Dmusiccabinet.jdbc.initialurl=jdbc:postgresql://xx.xx.xx.xx:5432/template1 <normal Subsonic startup params>

Maybe this is more complicated, but it would mean that whenever I release a new MusicCabinet version, you don't have to alter the subsonic.war file over and over. I never tried this myself but it's technically possible.

[jacobthe4th]

Hakko,

Great Mod! I've been watching this for a while and finally tried it yesterday. Install was cake. I have a question though, my library is nearing 100K tracks and the Music Cabinet indexing seems to have hit a snag. It has been up and running for nearly 18 hours and has made no discernible stats changes for over 10 hours. It still says it is scanning the media folder. Do you write to anything beyond the subsonic.log for errors? It definitely says it is having trouble writing the Tags.

Here is the log file (zipped). http://tinyurl.com/7g9akuz



Could it be it just takes longer time than I anticipated, or is there a problem? A lot of my files are clean, but not all. When cleaned their structure is \\music\{Artist}\{Album}\{Tracks}. The tracks, when scrubbed are ID3 Tagged (2.3) and each contains Artist, Album, Track, Year, Genre, Comment, Album Artist, Disc, and Embedded Album Cover.

Is there any other info that would help?

Thanks,

J

[hakko]

Hi Jacob!

I do get a bit worried when I read your log and it says over and over: "Insufficient system resources exist to complete the requested service". How much memory have you given Subsonic? Your log indicates that you're on Windows. Then you can control it from the system tray icon -> Subsonic control panel. The default allocated value is 100MB, 256MB is more reasonable.

From the About view, which version does it say? Built with MusicCabinet plugin, version 0.5.43? I realized this morning (after a conversation with Ultraviolet who has 500.000 tracks) that there's a small bug lurking somewhere during the import, and I updated subsonic.war to 0.5.44 to get better logging to nail it.

The only log file apart from subsonic.log is called musiccabinet.log and it's written to your temp directory, so you have to search for it. If you're using 0.5.43, I'm afraid it won't be of much help (it's very quiet), but you could always check. It's overwritten when you restart Subsonic so look for it before you do.

Since the import has stalled, I'd just suggest restarting Subsonic (from the system tray -> control panel) and starting off where you left. Everything you've imported so far should be written to the database, so you don't have to start from scratch. Let me know how it turns out! Sorry about the import bug, I hope the extended logging in 0.5.44 will help finding it.

[jacobthe4th]

Hakko,

OK, yeah, my memory is set to 500MB at least, perhaps even 1GB. I am having trouble logging into my server remotely to check (on the road). I had it at 1GB in the past and then noticed it never went past around 300MB ever, so I pared it back, I think. Either way, I can increase it. I will also update to the newer version, it is in fact running 0.5.34.

I will give it another go, once I am local to my server this evening. I will look for the other log file, too. (musiccabinet.log)

I hope the weather in Sweden is nice. I spent two summers in Göteborg ('97 & '98), working at the Volvo Torslanda facility, and loved it. Midsommardagen is a blast.

Thanks for your speedy reply.

Cheers,

- J

[hakko]

Good news! Thanks to Ultraviolet, I realized that under some (unclear, rare) circumstances, last.fm returns artist biographies that don't conform to the official specification. Up to this point, they have caused the import to stall, and fail to insert the recently fetched biographies.

This has now hopefully been addressed in version 0.5.45, which you can download from http://dilerium.se/musiccabinet/subsonic.war. This affects all users, although it seems quite rare. It's a pure bugfix release but I still recommend everyone to start using it.

Jacob: since you also ran into this issue, you could (if you like), connect to your postgres server using the pgAdmin tool, and execute this sql command in the MusicCabinet database:

Code: Select all

delete from library.webservice_history where calltype_id = 5 and artist_id not in (select artist_id from music.artistinfo)

If you do, all missing artist biographies will get fetched the next time you update the search index. If you don't, you'll have to wait for two weeks to have them fetched and updated by the search index. (MusicCabinet will consider them fetched and adhere to the last.fm caching rules, even though inserting them failed.)

and yes, the weather here is great and midsommardagen is just a few weeks away! thank you.

[hakko]

Also: anyone using 0.5.45+ who'd like to help out making this better, please search for musiccabinet.log in your temp directory (the location will vary on different platforms), and if it contains ERROR rows, send it to me in a PM and I'll have a look. Thanks!

[jacobthe4th]

Hakko,

I have to say this is SOOOOOOOO Awesome! I have been waiting for a way to do this for a while now. Love it, thank you!!!

Based on other peoples posts:

1.) Yes, I'd like to see the Wiki link return to the album page. I use it regularly to help fill in the missing TAG info.

2.) Could you make the playlist length configurable, via either the Settings--> Music Cabinet page, or the Settings--> Personal page.

Thanks for your help. I updated the build (from 0.5.43 to 0.5.45) and ran the query and it ran like a top.

Sleep well,

- J

[hakko]

yay! thanks!

1.) ... what Wiki link? I'm confused now

2.) isn't it configurable from Settings -> MusicCabinet? or do I miss something?

[jacobthe4th]

1.) Sorry I was referring to the Wikipedia link that used to show up on the Album page, with the Google, allmusic, and Last.fm on Sindre's base subsonic project.

For Example:



2.) LOL, I'm an idiot. I hadn't looked back at the Music Cabinet tab AFTER the genre and radio tabs were populated. All is clear.

Thanks Again.