Compile MPD with SQLite support

[dakkusingh]

Hi Guys,
Do you know if the MPD version is compiled with SQLite support already?

or

Do you have steps to compile a MPD version with SQLite support?

[dakkusingh]

nevermind, I got it working like so:
I added the following repos to my sources.list

nano /etc/apt/sources.list
deb http://ftp.debian.org/debian jessie main non-free 
deb-src http://ftp.debian.org/debian jessie main non-free

Did an update

apt-get update

Then in uninstalled the MPD version Volumio ships with:

root@HiFiPi:/usr/bin# dpkg -r mpd
(Reading database ... 177455 files and directories currently installed.)
Removing mpd (0.19.19-1) ...
Processing triggers for man-db (2.7.0.2-5) ...

And i installed the alternative version with:

root@HiFiPi:/usr/bin# apt-get install mpd
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are no longer required:
  libwebrtc-audio-processing-0 rtkit
Use 'apt-get autoremove' to remove them.
Suggested packages:
  icecast2 pulseaudio
The following NEW packages will be installed:
  mpd
0 upgraded, 1 newly installed, 0 to remove and 192 not upgraded.
Need to get 0 B/305 kB of archives.
After this operation, 858 kB of additional disk space will be used.
Selecting previously unselected package mpd.
(Reading database ... 177433 files and directories currently installed.)
Preparing to unpack .../mpd_0.19.1-1.1_armhf.deb ...
Unpacking mpd (0.19.1-1.1) ...
Processing triggers for systemd (215-17+deb8u5) ...
Processing triggers for man-db (2.7.0.2-5) ...
Setting up mpd (0.19.1-1.1) ...
Installing new version of config file /etc/default/mpd ...
Installing new version of config file /etc/init.d/mpd ...

Configuration file '/etc/mpd.conf'
 ==> Modified (by you or by a script) since installation.
 ==> Package distributor has shipped an updated version.
   What would you like to do about it ?  Your options are:
    Y or I  : install the package maintainer's version
    N or O  : keep your currently-installed version
      D     : show the differences between the versions
      Z     : start a shell to examine the situation
 The default action is to keep your current version.
*** mpd.conf (Y/I/N/O/D/Z) [default=N] ? 
Processing triggers for systemd (215-17+deb8u5) ...

[dakkusingh]

here is what I see in the log now.

Nov 09 15:16 : client: [3] process command "sticker set song "music-mp3/mysong .mp3" rating "10""
Nov 09 15:16 : client: [3] command returned 0

[dakkusingh]

and for clarity, here is what this MPD version supports:

root@HiFiPi:/home/pi# /usr/bin/mpd -V
Music Player Daemon 0.19.1

Copyright (C) 2003-2007 Warren Dukes <warren.dukes@gmail.com>
Copyright (C) 2008-2014 Max Kellermann <max@duempel.org>
This is free software; see the source for copying conditions.  There is NO
warranty; not even MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.


Database plugins:
 simple proxy upnp

Storage plugins:
 local smbclient nfs

Neighbor plugins:
 smbclient upnp

Decoders plugins:
 [mad] mp3 mp2
 [mpg123] mp3
 [vorbis] ogg oga
 [oggflac] ogg oga
 [flac] flac
 [opus] opus ogg oga
 [sndfile] wav aiff aif au snd paf iff svx sf voc w64 pvf xi htk caf sd2
 [audiofile] wav au aiff aif
 [dsdiff] dff
 [dsf] dsf
 [faad] aac
 [mpcdec] mpc
 [wavpack] wv
 [modplug] 669 amf ams dbm dfm dsm far it med mdl mod mtm mt2 okt s3m stm ult umx xm
 [mikmod] amf dsm far gdm imf it med mod mtm s3m stm stx ult uni xm
 [sidplay] sid mus str prg P00
 [wildmidi] mid
 [fluidsynth] mid
 [adplug] amd d00 hsc laa rad raw sa2
 [ffmpeg] 16sv 3g2 3gp 4xm 8svx aa3 aac ac3 afc aif aifc aiff al alaw amr anim apc ape asf atrac au aud avi avm2 avs bap bfi c93 cak cin cmv cpk daud dct divx dts dv dvd dxa eac3 film flac flc fli fll flx flv g726 gsm gxf iss m1v m2v m2t m2ts m4a m4b m4v mad mj2 mjpeg mjpg mka mkv mlp mm mmf mov mp+ mp1 mp2 mp3 mp4 mpc mpeg mpg mpga mpp mpu mve mvi mxf nc nsv nut nuv oga ogm ogv ogx oma ogg omg psp pva qcp qt r3d ra ram rl2 rm rmvb roq rpl rvc shn smk snd sol son spx str swf tgi tgq tgv thp ts tsp tta xa xvid uv uv2 vb vid vob voc vp6 vmd wav webm wma wmv wsaud wsvga wv wve
 [gme] ay gbs gym hes kss nsf nsfe sap spc vgm vgz
 [pcm]

Output plugins:
 shout null fifo pipe alsa roar ao oss openal pulse jack httpd recorder

Encoder plugins:
 null vorbis opus lame wave flac

Archive plugins:
 [bz2] bz2
 [zzip] zip
 [iso] iso

Input plugins:
 file alsa archive curl ffmpeg smbclient nfs mms cdio_paranoia

Playlist plugins:
 extm3u m3u pls xspf asx rss soundcloud cue embcue

Protocols:
 file:// http:// https:// mms:// mmsh:// mmst:// mmsu:// gopher:// rtp:// rtsp:// rtmp:// rtmpt:// rtmps:// smb:// nfs:// cdda:// alsa://

[dakkusingh]

and SQLlite Support is here:

root@HiFiPi:/home/pi# apt-cache show mpd | grep sql
Depends: adduser, lsb-base, init-system-helpers (>= 1.18~), libadplug-2.2.1-0 (>= 2.2.1-0), libao4 (>= 1.1.0), libasound2 (>= 1.0.18), libaudiofile1 (>= 0.3.6), libavahi-client3 (>= 0.6.16), libavahi-common3 (>= 0.6.16), libavcodec56 (>= 6:11~beta1) | libavcodec-extra-56 (>= 6:11), libavformat56 (>= 6:11~beta1), libavutil54 (>= 6:11~beta1), libbz2-1.0, libc6 (>= 2.17), libcdio-cdda1 (>= 0.83), libcdio-paranoia1 (>= 0.83), libcdio13 (>= 0.83), libcurl3-gnutls (>= 7.18.0), libdbus-1-3 (>= 1.0.2), libexpat1 (>= 2.0.1), libfaad2 (>= 2.7), libflac8 (>= 1.3.0), libfluidsynth1, libgcc1 (>= 1:4.4.0), libglib2.0-0 (>= 2.12.0), libgme0 (>= 0.5.5), libicu52 (>= 52~m1-1~), libid3tag0 (>= 0.15.1b), libiso9660-8 (>= 0.83), libjack-jackd2-0 (>= 1.9.5~dfsg-14) | libjack-0.116, libmad0 (>= 0.15.1b-3), libmikmod3 (>= 3.3.3), libmms0 (>= 0.4), libmodplug1, libmp3lame0, libmpcdec6 (>= 1:0.1~r435), libmpdclient2 (>= 2.9), libmpg123-0 (>= 1.13.7), libnfs4 (>= 1.9.3), libogg0 (>= 1.1.0), libopenal1 (>= 1.14), libopus0 (>= 1.1), libpulse0 (>= 0.99.1), libresid-builder0c2a, libroar2, libsamplerate0 (>= 0.1.7), libshout3, libsidplay2, libsidutils0, libsmbclient (>= 2:4.0.3+dfsg1), libsndfile1 (>= 1.0.20), libsoxr0 (>= 0.1.0), libsqlite3-0 (>= 3.5.9), libstdc++6 (>= 4.9), libsystemd0, libupnp6 (>= 1.4.3), libvorbis0a (>= 1.2.3), libvorbisenc2 (>= 1.1.2), libvorbisfile3 (>= 1.1.2), libwavpack1 (>= 4.40.0), libwildmidi1 (>= 0.2.3), libwrap0 (>= 7.6-4~), libyajl2 (>= 2.0.4), libzzip-0-13 (>= 0.13.56), zlib1g (>= 1:1.1.4)
Depends: adduser, lsb-base, init-system-helpers (>= 1.18~), libadplug-2.2.1-0 (>= 2.2.1-0), libao4 (>= 1.1.0), libasound2 (>= 1.0.18), libaudiofile1 (>= 0.3.6), libavahi-client3 (>= 0.6.16), libavahi-common3 (>= 0.6.16), libavcodec56 (>= 6:11~beta1) | libavcodec-extra-56 (>= 6:11), libavformat56 (>= 6:11~beta1), libavutil54 (>= 6:11~beta1), libbz2-1.0, libc6 (>= 2.17), libcdio-cdda1 (>= 0.83), libcdio-paranoia1 (>= 0.83), libcdio13 (>= 0.83), libcurl3-gnutls (>= 7.18.0), libdbus-1-3 (>= 1.0.2), libexpat1 (>= 2.0.1), libfaad2 (>= 2.7), libflac8 (>= 1.3.0), libfluidsynth1, libgcc1 (>= 1:4.4.0), libglib2.0-0 (>= 2.12.0), libgme0 (>= 0.5.5), libicu52 (>= 52~m1-1~), libid3tag0 (>= 0.15.1b), libiso9660-8 (>= 0.83), libjack-jackd2-0 (>= 1.9.5~dfsg-14) | libjack-0.116, libmad0 (>= 0.15.1b-3), libmikmod3 (>= 3.3.3), libmms0 (>= 0.4), libmodplug1, libmp3lame0, libmpcdec6 (>= 1:0.1~r435), libmpdclient2 (>= 2.9), libmpg123-0 (>= 1.13.7), libnfs4 (>= 1.9.3), libogg0 (>= 1.1.0), libopenal1 (>= 1.14), libopus0 (>= 1.1), libpulse0 (>= 0.99.1), libresid-builder0c2a, libroar2, libsamplerate0 (>= 0.1.7), libshout3, libsidplay2, libsidutils0, libsmbclient (>= 2:4.0.3+dfsg1), libsndfile1 (>= 1.0.20), libsoxr0 (>= 0.1.0), libsqlite3-0 (>= 3.5.9), libstdc++6 (>= 4.9), libsystemd0, libupnp6 (>= 1.4.3), libvorbis0a (>= 1.2.3), libvorbisenc2 (>= 1.1.2), libvorbisfile3 (>= 1.1.2), libwavpack1 (>= 4.40.0), libwildmidi1 (>= 0.2.3), libwrap0 (>= 7.6-4~), libyajl2 (>= 2.0.4), libzzip-0-13 (>= 0.13.56), zlib1g (>= 1:1.1.4)
root@HiFiPi:/home/pi# 

[dakkusingh]

and finally the dpkg info

root@HiFiPi:/home/pi# dpkg -s mpd
Package: mpd
Status: install ok installed
Priority: optional
Section: sound
Installed-Size: 838
Maintainer: mpd maintainers <pkg-mpd-maintainers@lists.alioth.debian.org>
Architecture: armhf
Version: 0.19.1-1.1
Depends: adduser, lsb-base, init-system-helpers (>= 1.18~), libadplug-2.2.1-0 (>= 2.2.1-0), libao4 (>= 1.1.0), libasound2 (>= 1.0.18), libaudiofile1 (>= 0.3.6), libavahi-client3 (>= 0.6.16), libavahi-common3 (>= 0.6.16), libavcodec56 (>= 6:11~beta1) | libavcodec-extra-56 (>= 6:11), libavformat56 (>= 6:11~beta1), libavutil54 (>= 6:11~beta1), libbz2-1.0, libc6 (>= 2.17), libcdio-cdda1 (>= 0.83), libcdio-paranoia1 (>= 0.83), libcdio13 (>= 0.83), libcurl3-gnutls (>= 7.18.0), libdbus-1-3 (>= 1.0.2), libexpat1 (>= 2.0.1), libfaad2 (>= 2.7), libflac8 (>= 1.3.0), libfluidsynth1, libgcc1 (>= 1:4.4.0), libglib2.0-0 (>= 2.12.0), libgme0 (>= 0.5.5), libicu52 (>= 52~m1-1~), libid3tag0 (>= 0.15.1b), libiso9660-8 (>= 0.83), libjack-jackd2-0 (>= 1.9.5~dfsg-14) | libjack-0.116, libmad0 (>= 0.15.1b-3), libmikmod3 (>= 3.3.3), libmms0 (>= 0.4), libmodplug1, libmp3lame0, libmpcdec6 (>= 1:0.1~r435), libmpdclient2 (>= 2.9), libmpg123-0 (>= 1.13.7), libnfs4 (>= 1.9.3), libogg0 (>= 1.1.0), libopenal1 (>= 1.14), libopus0 (>= 1.1), libpulse0 (>= 0.99.1), libresid-builder0c2a, libroar2, libsamplerate0 (>= 0.1.7), libshout3, libsidplay2, libsidutils0, libsmbclient (>= 2:4.0.3+dfsg1), libsndfile1 (>= 1.0.20), libsoxr0 (>= 0.1.0), libsqlite3-0 (>= 3.5.9), libstdc++6 (>= 4.9), libsystemd0, libupnp6 (>= 1.4.3), libvorbis0a (>= 1.2.3), libvorbisenc2 (>= 1.1.2), libvorbisfile3 (>= 1.1.2), libwavpack1 (>= 4.40.0), libwildmidi1 (>= 0.2.3), libwrap0 (>= 7.6-4~), libyajl2 (>= 2.0.4), libzzip-0-13 (>= 0.13.56), zlib1g (>= 1:1.1.4)
Suggests: avahi-daemon, icecast2, mpd-client, pulseaudio
Breaks: avahi-daemon (<< 0.6.31-3)
Conffiles:
 /etc/default/mpd 3c14cbf987fe72c18b70927bfc021bfe
 /etc/init.d/mpd a5e421cc0a13f1ccb1dbf37630f84bd3
 /etc/logrotate.d/mpd 60ada2fe692d332f6d7be3199ba657c5
 /etc/mpd.conf 8d6e0ca847f4d302cf06b6d75e22987b
 /etc/xdg/autostart/mpd.desktop 6074648feb84dd36dd9a6933a251e9ab
Description: Music Player Daemon
 Music Player Daemon (MPD) is a server that allows remote access for
 playing audio files (Ogg-Vorbis, FLAC, MP3, Wave, and AIFF), streams
 (Ogg-Vorbis, MP3) and managing playlists.  Gapless playback, buffered
 output, and crossfading support is also included.  The design focus is
 on integrating a computer into a stereo system that provides control
 for music playback over a TCP/IP network.  The goals are to be easy to
 install and use, to have minimal resource requirements (it has been
 reported to run fine on a Pentium 75), and to remain stable and
 flexible.
 .
 The daemon is controlled through a client which need not run on the
 same computer mpd runs on.  The separate client and server design
 allows users to choose a user interface that best suites their tastes
 independently of the underlying daemon (this package) which actually
 plays music.
Homepage: http://www.musicpd.org/