notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
Port details
logitechmediaserver-sqlplaylist Logitech Media Server plugin to create playlists based on SQL queries
2.5.3859_1 audio on this many watch lists=3 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 2.5.3859_1Version of this port present on the latest quarterly branch.
There is no maintainer for this port.
Any concerns regarding this port should be directed to the FreeBSD Ports mailing list via ports@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2016-10-05 22:50:40
Last Update: 2023-04-25 15:17:15
Commit Hash: feb1fa3
People watching this port, also watch:: openbox, etl, mDNSResponder, InsightToolkit, logitechmediaserver
License: GPLv2+
WWW:
https://wiki.slimdevices.com/index.php/SQL_Playlist_plugin
Description:
This plugin for Logitech Media Server makes it possible to create smart playlists. Although the standard Logitech Media Server doesn't support smart playlists by itself, together with iTunes and the standard Logitech Media Server iTunes integration, it is possible to use smart playlists defined in iTunes. The problem though is that the integrated iTunes smart playlists will not be recalculated until the next time you perform a rescan in Logitech Media Server. The SQL Playlist plugin takes care of this problem and implements native smart playlist in Logitech Media Server without any need to use iTunes. The smart playlists implemented in SQL Playlist will also be automatically re-calculated after each track played so they will be based on the latest statistic information. A smart playlist in SQL Playlist are continous and will run forever in the same way as the standard Random Mix plugin, you can optionally also choose that a smart playlist shouldn't repeat already played tracks and in that case the music will stop when all songs matching the playlist has been played.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (112 items)
Collapse this list.
  1. /usr/local/share/licenses/logitechmediaserver-sqlplaylist-2.5.3859_1/catalog.mk
  2. /usr/local/share/licenses/logitechmediaserver-sqlplaylist-2.5.3859_1/LICENSE
  3. /usr/local/share/licenses/logitechmediaserver-sqlplaylist-2.5.3859_1/GPLv2+
  4. share/logitechmediaserver/Plugins/SQLPlayList/BaseSettings.pm
  5. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/BaseParser.pm
  6. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/ContentParser.pm
  7. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/DirectoryLoader.pm
  8. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/Main.pm
  9. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/ParameterHandler.pm
  10. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/PlaylistWebAdminMethods.pm
  11. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/PluginLoader.pm
  12. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/TemplateContentParser.pm
  13. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/TemplateParser.pm
  14. share/logitechmediaserver/Plugins/SQLPlayList/ConfigManager/WebAdminMethods.pm
  15. share/logitechmediaserver/Plugins/SQLPlayList/HTML/Classic/html/images/sqlplaylist_mix.gif
  16. share/logitechmediaserver/Plugins/SQLPlayList/HTML/Default/html/images/sqlplaylist_mix.gif
  17. share/logitechmediaserver/Plugins/SQLPlayList/HTML/Default/plugins/SQLPlayList/dynamicplaylistlink.html
  18. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/catchtab.js
  19. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/dynamicplaylistlink.html
  20. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/mixerlink.html
  21. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/settings/basic.html
  22. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/settings/subpage_chooser.html
  23. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/sqlplaylist_list.html
  24. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/sqlplaylist_redirect.html
  25. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/sqlplaylist_reload.html
  26. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_edititem.html
  27. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_editsimpleitem.html
  28. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_login.html
  29. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_newitem.html
  30. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_newitemparameters.html
  31. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_newitemtypes.html
  32. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_newsimpleitem.html
  33. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_publishitemparameters.html
  34. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_register.html
  35. share/logitechmediaserver/Plugins/SQLPlayList/HTML/EN/plugins/SQLPlayList/webadminmethods_savedownloadeditem.html
  36. share/logitechmediaserver/Plugins/SQLPlayList/HTML/Fishbone/html/images/sqlplaylist_mix.gif
  37. share/logitechmediaserver/Plugins/SQLPlayList/LICENSE.txt
  38. share/logitechmediaserver/Plugins/SQLPlayList/MixHandler.pm
  39. share/logitechmediaserver/Plugins/SQLPlayList/Mixes/sqlplaylist.cb.mix.xml
  40. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomalbums.sql.values.xml
  41. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomalbumsforartist.sql.values.xml
  42. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomalbumsfordecade.sql.values.xml
  43. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomalbumsforgenre.sql.values.xml
  44. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomalbumsforplaylist.sql.values.xml
  45. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomalbumsforyear.sql.values.xml
  46. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomartists.sql.values.xml
  47. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomforalbum.sql.values.xml
  48. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomforartist.sql.values.xml
  49. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomfordecade.sql.values.xml
  50. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomforgenre.sql.values.xml
  51. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomforplaylist.sql.values.xml
  52. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomforyear.sql.values.xml
  53. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomtracks.sql.values.xml
  54. share/logitechmediaserver/Plugins/SQLPlayList/Playlists/randomyears.sql.values.xml
  55. share/logitechmediaserver/Plugins/SQLPlayList/Plugin.pm
  56. share/logitechmediaserver/Plugins/SQLPlayList/README.txt
  57. share/logitechmediaserver/Plugins/SQLPlayList/Settings.pm
  58. share/logitechmediaserver/Plugins/SQLPlayList/Template/Reader.pm
  59. share/logitechmediaserver/Plugins/SQLPlayList/Templates/advanced.sql.template
  60. share/logitechmediaserver/Plugins/SQLPlayList/Templates/advanced.sql.xml
  61. share/logitechmediaserver/Plugins/SQLPlayList/Templates/advancedwithrating.sql.template
  62. share/logitechmediaserver/Plugins/SQLPlayList/Templates/advancedwithrating.sql.xml
  63. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomalbums.sql.template
  64. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomalbums.sql.xml
  65. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomartists.sql.template
  66. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomartists.sql.xml
  67. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforrating.sql.template
  68. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforrating.sql.xml
  69. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforratingandartist.sql.template
  70. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforratingandartist.sql.xml
  71. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforratingandgenre.sql.template
  72. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforratingandgenre.sql.xml
  73. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforratingandyear.sql.template
  74. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomforratingandyear.sql.xml
  75. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomfrommixer.sql.template
  76. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomfrommixer.sql.xml
  77. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomplaylisttracks.sql.template
  78. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomplaylisttracks.sql.xml
  79. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomtracks.sql.template
  80. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomtracks.sql.xml
  81. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomweightedtracks.sql.template
  82. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomweightedtracks.sql.xml
  83. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomyears.sql.template
  84. share/logitechmediaserver/Plugins/SQLPlayList/Templates/randomyears.sql.xml
  85. share/logitechmediaserver/Plugins/SQLPlayList/Templates/simple.sql.template
  86. share/logitechmediaserver/Plugins/SQLPlayList/Templates/simple.sql.xml
  87. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforalbum.sql.template
  88. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforalbum.sql.xml
  89. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforartist.sql.template
  90. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforartist.sql.xml
  91. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedfordecade.sql.template
  92. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedfordecade.sql.xml
  93. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforgenre.sql.template
  94. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforgenre.sql.xml
  95. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforplaylist.sql.template
  96. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforplaylist.sql.xml
  97. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforyear.sql.template
  98. share/logitechmediaserver/Plugins/SQLPlayList/Templates/topratedforyear.sql.xml
  99. share/logitechmediaserver/Plugins/SQLPlayList/install.xml
  100. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Constants.pm
  101. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Lite.pm
  102. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Lite/Deserializer/XMLSchema1999.pm
  103. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Lite/Deserializer/XMLSchema2001.pm
  104. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Lite/Deserializer/XMLSchemaSOAP1_1.pm
  105. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Lite/Deserializer/XMLSchemaSOAP1_2.pm
  106. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Lite/Utils.pm
  107. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Packager.pm
  108. share/logitechmediaserver/Plugins/SQLPlayList/lib/SOAP/Transport/HTTP.pm
  109. share/logitechmediaserver/Plugins/SQLPlayList/strings.txt
  110. @owner
  111. @group
  112. @mode
Collapse this list.
Dependency lines:
  • logitechmediaserver-sqlplaylist>0:audio/logitechmediaserver-sqlplaylist
To install the port:
cd /usr/ports/audio/logitechmediaserver-sqlplaylist/ && make install clean
To add the package, run one of these commands:
  • pkg install audio/logitechmediaserver-sqlplaylist
  • pkg install logitechmediaserver-sqlplaylist
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: logitechmediaserver-sqlplaylist
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1463782116 SHA256 (logitechmediaserver/SQLPlayList-2.5.3859.zip) = b0363cbd0433ebae58e6357cee26ce40548f7b8b87ae4a7dae9bbff4a4bfdd53 SIZE (logitechmediaserver/SQLPlayList-2.5.3859.zip) = 188051

No package information for this port in our database
Sometimes this happens. Not all ports have packages. Perhaps there is a build error. Check the fallout link: pkg-fallout
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Runtime dependencies:
  1. slimserver.pl : audio/logitechmediaserver
  2. install.xml : audio/logitechmediaserver-dynamicplaylist
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
audio_logitechmediaserver-sqlplaylist
USES:
zip
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. http://downloads.isaksson.info/download/do/downloadapplication?name=slimserver-sqlplaylist&filename=/
Collapse this list.

Number of commits found: 7

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
2.5.3859_1
25 Apr 2023 15:17:15
commit hash: feb1fa34f58ea796656b86a81c2a2996b0b03c96commit hash: feb1fa34f58ea796656b86a81c2a2996b0b03c96commit hash: feb1fa34f58ea796656b86a81c2a2996b0b03c96commit hash: feb1fa34f58ea796656b86a81c2a2996b0b03c96 files touched by this commit
Christian Weisgerber (naddy) search for other commits by this committer
audio/opus: bump consumers after update to 1.4
07 Sep 2022 21:58:51
commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)
2.5.3859
07 Sep 2022 21:10:59
commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
2.5.3859
20 Jul 2022 14:20:54
commit hash: 213b0b7a75cfb93729483fb1f59b236448f06a13commit hash: 213b0b7a75cfb93729483fb1f59b236448f06a13commit hash: 213b0b7a75cfb93729483fb1f59b236448f06a13commit hash: 213b0b7a75cfb93729483fb1f59b236448f06a13 files touched by this commit
Tobias C. Berner (tcberner) search for other commits by this committer
audio: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  <dmagda+libsamplerate@ee.ryerson.ca>
  *  <trasz@FreeBSD.org>
  *  Adam Weinberger
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Aleksander Fafula <alex@bsdguru.org>
  *  Alex Allan <alex@kamaz.org.uk>
  *  Alexander Botero-Lowry <alex@foxybanana.com>
  *  Alexander Kojevnikov <alexander@kojevnikov.com>
  *  Alexander Nedotsukov <bland@FreeBSD.org>
  *  Alexander Vereeken <Alexander88207@protonmail.com>
(Only the first 15 lines of the commit message are shown above View all of this commit message)
2.5.3859
06 Apr 2021 14:31:07
commit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344eb files touched by this commit
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
2.5.3859
06 Sep 2019 12:38:31
Revision:511310Original commit files touched by this commit
adamw search for other commits by this committer
Return Mark Dixon's ports to the heap.

He put a ton of work into these, so our thanks to him for giving us
all that time and effort.

Submitted by:	Mark Dixon
2.5.3859
05 Oct 2016 22:50:25
Revision:423393Original commit files touched by this commit
woodsb02 search for other commits by this committer
Move audio/squeezeboxserver to audio/logitechmediaserver

audio/squeezeboxserver:
- Move to audio/logitechmediaserver
- Update to 7.9.0 pre-release (git commit from 7.9 branch on 2016.09.30)
- Change default install and database locations to suit new PORTNAME
- Remove softsqueeze.sh as it is no longer bundled with the server
- Add /usr/local/etc/newsyslog.conf.d/, don't edit /etc/newsyslog.conf
- Add LICENSE details
- Update maintainer (previous maintainer timeout)
- Use customized perl modules provided in distfile and slimserver-vendor
  GitHub repo, rather than using perl dependencies from ports
- Changed install method to now copy directly to stagedir instead of an
  intermediate step to TMP_SLIMDIR
(Only the first 15 lines of the commit message are shown above View all of this commit message)

Number of commits found: 7