Re: [SlimDevices: SqueezeCenter] Excluding genre in advanced search
Is there a way to enter some raw SQL instead of the form? I could probably manage that. If not I'll just have to add an additional 'avoid' tag to all special tracks. Oh, if you're willing to dig SQL and code, then yes, there are more options. Your GUI will be your text editor :-). First you could try to edit the virtualLibraries.pref file in your preferences folder (see Settings/Information): - create a library view based on one genre - shut down LMS - take a backup copy of said file - edit the library definition - restart LMS My "kids music" section looks like this: vlid_2da2d7ab: id: advSrch_1421096771 name: Kinder params: - KINDER% - '% KINDER%' - KASPERLI% - '% KASPERLI%' - KINDERMUSIK% - '% KINDERMUSIK%' - 1 sql: INSERT OR IGNORE INTO library_track (library, track) SELECT '%s', id FROM ((SELECT me.id FROM tracks me LEFT JOIN genre_track genreTracks ON genreTracks.track = me.id WHERE ( ( genre IN ( SELECT me.id FROM genres me WHERE ( ( ( me.namesearch LIKE ? OR me.namesearch LIKE ? ) OR ( me.namesearch LIKE ? OR me.namesearch LIKE ? ) OR ( me.namesearch LIKE ? OR me.namesearch LIKE ? ) ) ) ) AND me.audio = ? ) ) GROUP BY me.id)) Edit the SQL to your liking. Just make sure the number of params corresponds in number and position to the question marks in the SQL. And don't break the file's structure... An alternative would be to write your own little plugin with the library definitions. Take a look at the LibraryDemo plugin (https://github.com/Logitech/slimserver/blob/public/7.9/Slim/Plugin/LibraryDemo/Plugin.pm) -- Michael ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Automatically update LMS?
silentcreek wrote: > Well, Debian has unattended upgrade too. tbh you cant compare this :p unattended-upgrades on debian is to keep the computer current with the latest -security- updates automatically. Most of the Users here are real -users- not the usual 24/7 rootboy/girl (s). DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=105804 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Retrieve track name from HTTP stream when added to playlist?
Now the remaining part is to understand if crossfading between two sequential HTTP streams should work. Oh, you're your own plugin developer - and I told you to ask _him_ :-). -- -- Michael ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Retrieve track name from HTTP stream when added to playlist?
Awesome, I've investigated the telnet CLI a bit more based on your mention of "playlist play", and I'm pleased to say that "playlist add" also supports overriding the title! https://github.com/Logitech/slimserver/blob/0856e6e4e0bb9c97175e000c717fa648492f630d/Slim/Control/Request.pm#L550 Hence my little webapp only has to deal with searching from the GMusicProxy, getting a streaming URL and metadata, and passing that URL and title to LMS: b8:27:eb:11:09:95 playlist add http://10.0.0.115:/get_song?id=Thnehqnysgf3uj7xccpp74c5ziq ArtistName%20///%20AlbumName%20///%20TrackName Now the remaining part is to understand if crossfading between two sequential HTTP streams should work. Thanks :) gdhgdh's Profile: http://forums.slimdevices.com/member.php?userid=62957 View this thread: http://forums.slimdevices.com/showthread.php?t=105833 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Excluding genre in advanced search
Same results after disabling all plugins and a complete rescan. Anything else I can try or log? nenu's Profile: http://forums.slimdevices.com/member.php?userid=65867 View this thread: http://forums.slimdevices.com/showthread.php?t=105835 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] SB3 won't play 48 kHz MP3s anymore
bstrulo wrote: > Bump: sorry to nag but does anyone have any ideas? This is starting to > annoy me now; turns out there are more 48khz tracks in my library than I > realised! have you done anything special like added a custom convert.conf file or edited your LMS convert.conf file? What happens if you install 7.8 or 7.7? Any difference? Are you using a DAC or just analog outs of SB3? *Home:* VortexBox 4TB (2.3) > LMS 7.8 > Transporter, Touch, Boom, Radio (all ethernet) *Cottage:* VBA 3TB (2.3) > LMS 7.8 > Touch > Benchmark DAC I, Boom, Radio w/Battery (all ethernet except Radio) *Office:* Win8(64) > LMS 7.9 > Squeezelite *Spares:* Touch(3), Radio(3), Boom, SB3, CONTROLLER *Controllers:* iPhone6 & iPadAir2 (iPeng8 & Squeezepad), CONTROLLER, or SqueezePlay 7.8 on Win7(64) laptop *Files:* ripping: dbpoweramp > FLAC; post-rip: mp3tag, PerfectTunes; Streaming: Spotify garym's Profile: http://forums.slimdevices.com/member.php?userid=17325 View this thread: http://forums.slimdevices.com/showthread.php?t=105741 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] SB3 won't play 48 kHz MP3s anymore
Bump: sorry to nag but does anyone have any ideas? This is starting to annoy me now; turns out there are more 48khz tracks in my library than I realised! bstrulo's Profile: http://forums.slimdevices.com/member.php?userid=15997 View this thread: http://forums.slimdevices.com/showthread.php?t=105741 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Excluding genre in advanced search
I think this is the log you asked for? Code: [16-07-05 17:13:24.5619] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:13:29.4370] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:13:30.5766] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:13:35.4528] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:13:36.5933] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:13:38.8880] Slim::Schema::Debug::query_start (23) SELECT me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me ORDER BY namesort COLLATE en_US : [16-07-05 17:13:41.1733] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:13:42.6245] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:13:46.2184] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:13:48.6557] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:13:50.4295] Slim::Schema::Debug::query_start (23) SELECT COUNT( * ) FROM (SELECT me.id FROM tracks me LEFT JOIN genre_track genreTracks ON genreTracks.track = me.id WHERE ( ( genre NOT IN ( SELECT me.id FROM genres me WHERE ( me.namesearch LIKE ? ) ) AND me.audio = ? ) ) GROUP BY me.id) count_subq: '%KERSTMIS%', '1' [16-07-05 17:13:51.2744] Slim::Schema::Debug::query_start (23) SELECT me.id, me.urlmd5, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.primary_artist, me.tracknum, me.timestamp, me.added_time, me.updated_time, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.cover_cached, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.dlna_profile, me.musicbrainz_id, me.lossless, me.lyrics, me.replay_gain, me.replay_peak, me.extid, me.virtual, me.coverid FROM tracks me LEFT JOIN genre_track genreTracks ON genreTracks.track = me.id WHERE ( ( genre NOT IN ( SELECT me.id FROM genres me WHERE ( me.namesearch LIKE ? ) ) AND me.audio = ? ) ) GROUP BY me.id ORDER BY me.disc, me.titlesort COLLATE en_US LIMIT 50: '%KERSTMIS%', '1' [16-07-05 17:13:56.2434] Slim::Schema::Debug::query_start (23) SELECT me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me ORDER BY namesort COLLATE en_US : [16-07-05 17:13:57.0939] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:13:57.1266] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:14:01.3120] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:14:02.6870] Slim::Control::Queries::_getTagDataForTracks (5562) _getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN (214019) / [] [16-07-05 17:14:06.4214] Slim::Control::Queries::_getT
Re: [SlimDevices: SqueezeCenter] 7.9 - Browse "remote" LMS music libraries
mherger wrote: > > I have also just synced an SB3 and a Touch for testing - they won't > play > > the Remote Music Library stuff either. > > Thanks - easily reproducible. Should be fixed in the next build. Please > > give it a try. > > -- > > Michael Will do. *Vortexbox LMS 7.9 music on QNAP TS419p via NFS* iThingys/iPeng/Tablets *Living Room* - SB3 -> Onkyo TS606 - > Celestion Ditton F20s - Zone 2 -> Sony TA FE 320 -> Sennheiser RS 130 & B&W P7 *Office* - RPi -> Sony TA FE320 -> Celestion F10s / SB3 -> Onkyo CRN 755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - SB Touch -> Topping TP21 -> AKG Headphones *Bedroom (TV)* - Amazon Fire TV (SB Player) -> Topping TP20 -> Wharfedale Modus Cubes d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 View this thread: http://forums.slimdevices.com/showthread.php?t=104818 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] 7.9 - Browse "remote" LMS music libraries
I have also just synced an SB3 and a Touch for testing - they won't play the Remote Music Library stuff either. Thanks - easily reproducible. Should be fixed in the next build. Please give it a try. -- Michael ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] 7.9 - Browse "remote" LMS music libraries
mherger wrote: > > I am not sure if this has been spotted or documented before but it > > appears that a Synchronised Group of players cannot play stuff from a > > remote library whereas as an Unsynchronised player can. > > What kind of resources (LMS or UPnP)? What kind of players? > > -- > > Michael Sorry Michael. The main server is 7.9.0 - 1466761329 running on Vortexbox with music stored on a NAS via NFS The secondary server is 7.9.0 - 1466761329 running on piCorePlayer with music also stored on NAS via SMB I first noticed it with a pair of synced Pi's - when synced they won't play the stuff off the secondary server via the Remote Music Library I have also just synced an SB3 and a Touch for testing - they won't play the Remote Music Library stuff either. In either synced case the playlist gets created Ok - you can select what you want to play but you can't click play in LMS GUI or hit play via iPeng - nothing happens In all cases unsynced players are working fine *Vortexbox LMS 7.9 music on QNAP TS419p via NFS* iThingys/iPeng/Tablets *Living Room* - SB3 -> Onkyo TS606 - > Celestion Ditton F20s - Zone 2 -> Sony TA FE 320 -> Sennheiser RS 130 & B&W P7 *Office* - RPi -> Sony TA FE320 -> Celestion F10s / SB3 -> Onkyo CRN 755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - SB Touch -> Topping TP21 -> AKG Headphones *Bedroom (TV)* - Amazon Fire TV (SB Player) -> Topping TP20 -> Wharfedale Modus Cubes d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 View this thread: http://forums.slimdevices.com/showthread.php?t=104818 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Excluding genre in advanced search
Now I am trying to get 'Library Views' to work, for example to exclude "Kerstmis"/"Christmas" tracks. Selecting these exclusively works, but not excluding them. Please keep in mind that the Advanced Search is a very rough UI to create libraries. The idea behind adding library support was to allow 3rd parties to easily implement multi library modes. The plan was not to provide this feature in LMS. But lack of 3rd party solutions half baked implementations got added in LMS, leaving a lot to desire... "Kerstmis" does not appear as a substring of other Genres. I get similar behaviour for other genres. Seems to be working fine in my case. You can enable debug logging for database.sql to see what queries it's actually running. This might help us to better understand what is going on. Are you using any 3rd party plugin by chance? - if I get this to work, how do I exclude multiple genres? Seperate with comma and space? This currently is not supported. - the Save as 'As Library View' (double As there) only appears after first having searched, then going back to the 'Advanced Search' interface. Is this expected behaviour? Looking through latest Mozilla. Yes, that's expected. -- Michael ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] 7.9 - Browse "remote" LMS music libraries
I am not sure if this has been spotted or documented before but it appears that a Synchronised Group of players cannot play stuff from a remote library whereas as an Unsynchronised player can. What kind of resources (LMS or UPnP)? What kind of players? -- Michael ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] 7.9 - Browse "remote" LMS music libraries
Just resurrecting this post as I have recently upgraded my production server to 7.9.x and started to use Remote Music Libraries. I am not sure if this has been spotted or documented before but it appears that a Synchronised Group of players cannot play stuff from a remote library whereas as an Unsynchronised player can. Not a showstopper but I thought I would mention it as I cannot find any reference to it anywhere. *Vortexbox LMS 7.9 music on QNAP TS419p via NFS* iThingys/iPeng/Tablets *Living Room* - SB3 -> Onkyo TS606 - > Celestion Ditton F20s - Zone 2 -> Sony TA FE 320 -> Sennheiser RS 130 & B&W P7 *Office* - RPi -> Sony TA FE320 -> Celestion F10s / SB3 -> Onkyo CRN 755 -> Wharfedale Modus Cubes *Dining Room* -> SB Boom *Kitchen* -> UE Radio (upgraded to SB Radio) *Bedroom (Bedside)* - SB Touch -> Topping TP21 -> AKG Headphones *Bedroom (TV)* - Amazon Fire TV (SB Player) -> Topping TP20 -> Wharfedale Modus Cubes d6jg's Profile: http://forums.slimdevices.com/member.php?userid=44051 View this thread: http://forums.slimdevices.com/showthread.php?t=104818 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
[SlimDevices: SqueezeCenter] Excluding genre in advanced search
Hi, I just upgraded to 7.9.0 - 1467524616. Now I am trying to get 'Library Views' to work, for example to exclude "Kerstmis"/"Christmas" tracks. Selecting these exclusively works, but not excluding them. In 'All Library (Default)' I have 43560 songs. In the 'Advanced Search': - when I leave everything blank, I get no search results (makes sense). - with Genre "Kerstmis", I get 747 songs. - with Genre "- text search" but a blank entry field, I get 43551 songs. where did the 9 go? Empty Genre tag? - with Genre "- text search" and "Kerstmis", I get 747 songs (as expected). - with Genre "- not in text search" and "Kerstmis", I get 43551 songs. "Kerstmis" does not appear as a substring of other Genres. I get similar behaviour for other genres. Am I doing something wrong? Also: - if I get this to work, how do I exclude multiple genres? Seperate with comma and space? - the Save as 'As Library View' (double As there) only appears after first having searched, then going back to the 'Advanced Search' interface. Is this expected behaviour? Looking through latest Mozilla. Thanks Wouter nenu's Profile: http://forums.slimdevices.com/member.php?userid=65867 View this thread: http://forums.slimdevices.com/showthread.php?t=105835 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Automatically update LMS?
DJanGo wrote: > [...] but i dont think to automate whe whole update procedure is the way > to go. > Pure debian guys always want to have their owwn finger on the trigger > otherwise they would run some other warez from redmond. Well, Debian has 'unattended upgrades' (https://packages.debian.org/jessie/unattended-upgrades), too. And frankly, it works pretty well and reliable. Sure, if you have services that you can't afford to be offline at all, like a fileserver for a large company, you would want to do everything manually. But for my home systems, I don't require such high reliability and availability. Nevertheless, in the past 5 years that I use unattended upgrades on Debian (from Squeeze to Jessie), I have had exactly one case in which an update (for samba) did not apply succesfully. My server sent me notification via email and installed the upgrade manually later (as well as solved the configuration issue that caused the upgrade to fail). For a home server, this is totally acceptable for me and the benefit of not having to take care of updates manually constantly definitly outweighs the minimal downtime I had during that one failed update. Even so, since I'm running the nightly versions of LMS, I apply updates for LMS manually (every 1-2 months). I have thought about a mechanism to automate this, but never pursued it since the frequency of LMS updates I apply is rather low. silentcreek's Profile: http://forums.slimdevices.com/member.php?userid=63007 View this thread: http://forums.slimdevices.com/showthread.php?t=105804 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
