Album & Artist Art

Need help? Post your questions here.

Album & Artist Art

Unread postby c0utta » 20 Dec 2013, 04:57

Madsonic has changed the way I listen to music. No longer to I carry an iPod with me, just my BlackBerry with a 64GB microSD card. These holidays I'll purchase the Android app and see if I can get it sideloaded onto the BlackBerry.

I already had a streamlined structure for album and artist art as I run a Squeezebox network at home, so I'm hoping that Madsonic will also fit into this structure.

All my artist and album art is located in one directory and the Squeezebox uses this directory - note that my music folders are designated readonly to Madsonic (and the Squeezebox for that matter).

Being familiar with SQL, am I able to update the cover_art_path to my art folder and have Madsonic use that instead? Which table do I use for artist art and which for album art? Will this stick during a refresh?

Thanks!
c0utta
 
Posts: 12
Joined: 21 Aug 2013, 04:16
Has thanked: 0 time
Been thanked: 10 times

Re: Album & Artist Art

Unread postby c0utta » 23 Jan 2014, 13:16

Time to bump after nearly 5 weeks and 41 views.

Madevil, you're probably the only one who can answer this, but it looks like my nightly rescan overwrites the values that I set for the artist art. I have meticulously organised my art over the last 10 years and sometimes the Last FM artist art is not the ideal.

Also, would you be able to PM to discuss using the Android application sideloaded onto a BlackBerry 10?

Thanks!
c0utta
 
Posts: 12
Joined: 21 Aug 2013, 04:16
Has thanked: 0 time
Been thanked: 10 times

Re: Album & Artist Art

Unread postby c0utta » 17 Mar 2014, 04:05

I've figured out how to manipulate the Cover_Art_Path to suit my needs, but then I needed to run a SQL script every night to update the database values. The db.view page is too small to submit the entire script, and I didn't want to do it interactively.

For future reference, here's how I did it via cron:

Code: Select all
java -jar /var/madsonic/jetty/3830/webapp/WEB-INF/lib/hsqldb-1.8.0.10.jar --inlineRc url=jdbc:hsqldb:file:/var/madsonic/db/subsonic,user=sa,password= /mnt/music/madsonic.sql

Note that /mnt/music/madsonic.sql is where my SQL statements are stored.

Two extra things:
- the madsonic service must be stopped
- you'll need to put a "commit;" at the end of the script
c0utta
 
Posts: 12
Joined: 21 Aug 2013, 04:16
Has thanked: 0 time
Been thanked: 10 times

Re: Album & Artist Art

Unread postby c0utta » 28 Jul 2014, 05:48

Addendum to this.

I had a couple of occasions where my Madsonic instance was being completely trashed so badly that I had to restore from backup. I ended up working out what the problem was - an upgraded Madsonic included a new HSQLDB jar, and I was using the old 1.8.0.10 jar. This was corrupting the database along with the commands above.

After doing some research, I obtained a copy of sqltool.jar and placed it into the lib folder. I could then use:

Code: Select all
java -jar /var/madsonic/jetty/4800/webapp/WEB-INF/lib/sqltool-2.3.2.jar --inlineRc url=jdbc:hsqldb:file:/var/madsonic/db/subsonic,user=sa,password= /mnt/music/madsonic.sql

Two extra things:
- the madsonic service still needs be stopped
- you'll need to put a "commit;" at the end of the script
c0utta
 
Posts: 12
Joined: 21 Aug 2013, 04:16
Has thanked: 0 time
Been thanked: 10 times


Return to Support 5.x

Who is online

Users browsing this forum: No registered users and 1 guest

cron