Problem with the database

Need help with MPD?
Post Reply
kartable
Posts: 3
Joined: December 21st, 2020, 2:48 pm

Problem with the database

Post by kartable »

Hello everyone,

I have installed mpd and mpc on my Raspberry Pi 3B+ as well as 2 nodes in Node-RED to see what's going on.

I have a playlist in /var/lib/mpd/playlists called radio.m3u with just a few inputs.

And I can hear perfectly well one of the webradios, but always the same... and I can't figure out what to do?

I have tried mpc update and restarting mpd with sudo /etc/init.d/mpd restart. When I select a station in the list, the one that is rendered is always the same.

It must be a problem with the database. After some modifications in the playlist, mpc says I have 42 stations where I have just 8.
max
Forum team
Posts: 1254
Joined: January 15th, 2013, 3:43 pm

Re: Problem with the database

Post by max »

> It must be a problem with the database

No, because the database is not involved here.

Read https://www.musicpd.org/help/
kartable
Posts: 3
Joined: December 21st, 2020, 2:48 pm

Re: Problem with the database

Post by kartable »

max wrote: December 22nd, 2020, 4:23 am No, because the database is not involved here.
Excuse me if I'm completely wrong.

My mpd --version

Code: Select all

Music Player Daemon 0.21.5 (0.21.5)

Copyright 2003-2007 Warren Dukes <warren.dukes@gmail.com>
Copyright 2008-2018 Max Kellermann <max.kellermann@gmail.com>
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 udisks nfs curl

Neighbor plugins:
 smbclient upnp udisks

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
 [hybrid_dsd] m4a
 [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 adx 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 opus psp pva qcp qt r3d ra ram rl2 rm rmvb roq rpl rvc shn smk snd sol son spx str swf tak 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]

Filters:
 libsamplerate soxr

Tag plugins:
 id3tag

Output plugins:
 shout null fifo pipe alsa 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 archive alsa tidal qobuz curl ffmpeg smbclient nfs mms cdio_paranoia

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

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

Other features:
 avahi dbus udisks epoll icu inotify ipv6 systemd tcp un
My mpd.conf where I just modified the audio_output

Code: Select all

# An example configuration file for MPD.
# Read the user manual for documentation: http://www.musicpd.org/doc/user/
# or /usr/share/doc/mpd/html/user.html


# Files and directories #######################################################
#
# This setting controls the top directory which MPD will search to discover the
# available audio files and add them to the daemon's online database. This
# setting defaults to the XDG directory, otherwise the music directory will be
# be disabled and audio files will only be accepted over ipc socket (using
# file:// protocol) or streaming files over an accepted protocol.
#
music_directory		"/var/lib/mpd/music"
#
# This setting sets the MPD internal playlist directory. The purpose of this
# directory is storage for playlists created by MPD. The server will use
# playlist files not created by the server but only if they are in the MPD
# format. This setting defaults to playlist saving being disabled.
#
playlist_directory		"/var/lib/mpd/playlists"
#
# This setting sets the location of the MPD database. This file is used to
# load the database at server start up and store the database while the
# server is not up. This setting defaults to disabled which will allow
# MPD to accept files over ipc socket (using file:// protocol) or streaming
# files over an accepted protocol.
#
db_file			"/var/lib/mpd/tag_cache"
#
# These settings are the locations for the daemon log files for the daemon.
# These logs are great for troubleshooting, depending on your log_level
# settings.
#
# The special value "syslog" makes MPD use the local syslog daemon. This
# setting defaults to logging to syslog, or to journal if mpd was started as
# a systemd service.
#
log_file			"/var/log/mpd/mpd.log"
#
# This setting sets the location of the file which stores the process ID
# for use of mpd --kill and some init scripts. This setting is disabled by
# default and the pid file will not be stored.
#
pid_file			"/run/mpd/pid"
#
# This setting sets the location of the file which contains information about
# most variables to get MPD back into the same general shape it was in before
# it was brought down. This setting is disabled by default and the server
# state will be reset on server start up.
#
state_file			"/var/lib/mpd/state"
#
# The location of the sticker database.  This is a database which
# manages dynamic information attached to songs.
#
sticker_file                   "/var/lib/mpd/sticker.sql"
#
###############################################################################


# General music daemon options ################################################
#
# This setting specifies the user that MPD will run as. MPD should never run as
# root and you may use this setting to make MPD change its user ID after
# initialization. This setting is disabled by default and MPD is run as the
# current user.
#
user				"mpd"
#
# This setting specifies the group that MPD will run as. If not specified
# primary group of user specified with "user" setting will be used (if set).
# This is useful if MPD needs to be a member of group such as "audio" to
# have permission to use sound card.
#
#group                          "nogroup"
#
# This setting sets the address for the daemon to listen on. Careful attention
# should be paid if this is assigned to anything other then the default, any.
# This setting can deny access to control of the daemon. Choose any if you want
# to have mpd listen on every address. Not effective if systemd socket
# activation is in use.
#
# For network
bind_to_address		"localhost"
#
# And for Unix Socket
#bind_to_address		"/run/mpd/socket"
#
# This setting is the TCP port that is desired for the daemon to get assigned
# to.
#
#port				"6600"
#
# This setting controls the type of information which is logged. Available
# setting arguments are "default", "secure" or "verbose". The "verbose" setting
# argument is recommended for troubleshooting, though can quickly stretch
# available resources on limited hardware storage.
#
#log_level			"default"
#
# Setting "restore_paused" to "yes" puts MPD into pause mode instead
# of starting playback after startup.
#
#restore_paused "no"
#
# This setting enables MPD to create playlists in a format usable by other
# music players.
#
#save_absolute_paths_in_playlists	"no"
#
# This setting defines a list of tag types that will be extracted during the
# audio file discovery process. The complete list of possible values can be
# found in the user manual.
#metadata_to_use	"artist,album,title,track,name,genre,date,composer,performer,disc"
#
# This example just enables the "comment" tag without disabling all
# the other supported tags:
#metadata_to_use "+comment"
#
# This setting enables automatic update of MPD's database when files in
# music_directory are changed.
#
#auto_update    "yes"
#
# Limit the depth of the directories being watched, 0 means only watch
# the music directory itself.  There is no limit by default.
#
#auto_update_depth "3"
#
###############################################################################


# Symbolic link behavior ######################################################
#
# If this setting is set to "yes", MPD will discover audio files by following
# symbolic links outside of the configured music_directory.
#
#follow_outside_symlinks	"yes"
#
# If this setting is set to "yes", MPD will discover audio files by following
# symbolic links inside of the configured music_directory.
#
#follow_inside_symlinks		"yes"
#
###############################################################################


# Zeroconf / Avahi Service Discovery ##########################################
#
# If this setting is set to "yes", service information will be published with
# Zeroconf / Avahi.
#
#zeroconf_enabled		"yes"
#
# The argument to this setting will be the Zeroconf / Avahi unique name for
# this MPD server on the network. %h will be replaced with the hostname.
#
#zeroconf_name			"Music Player @ %h"
#
###############################################################################


# Permissions #################################################################
#
# If this setting is set, MPD will require password authorization. The password
# setting can be specified multiple times for different password profiles.
#
#password                        "password@read,add,control,admin"
#
# This setting specifies the permissions a user has who has not yet logged in.
#
#default_permissions             "read,add,control,admin"
#
###############################################################################


# Database #######################################################################
#

#database {
#       plugin "proxy"
#       host "other.mpd.host"
#       port "6600"
#}

# Input #######################################################################
#

input {
        plugin "curl"
#       proxy "proxy.isp.com:8080"
#       proxy_user "user"
#       proxy_password "password"
}

# QOBUZ input plugin
input {
        enabled    "no"
        plugin     "qobuz"
#        app_id     "ID"
#        app_secret "SECRET"
#        username   "USERNAME"
#        password   "PASSWORD"
#        format_id  "N"
}

# TIDAL input plugin
input {
        enabled      "no"
        plugin       "tidal"
#        token        "TOKEN"
#        username     "USERNAME"
#        password     "PASSWORD"
#        audioquality "Q"
}

# Decoder #####################################################################
#

decoder {
        plugin                  "hybrid_dsd"
        enabled                 "no"
#       gapless                 "no"
}

#
###############################################################################

# Audio Output ################################################################
#
# MPD supports various audio output types, as well as playing through multiple
# audio outputs at the same time, through multiple audio_output settings
# blocks. Setting this block is optional, though the server will only attempt
# autodetection for one sound card.
#
# An example of an ALSA output:
#
audio_output {
	type		"alsa"
	name		"My ALSA Device"
	device		"hw:1,0"	# optional
	mixer_type      "hardware"      # optional
	mixer_device	"default"	# optional
	mixer_control	"PCM"		# optional
	mixer_index	"0"		# optional
}
#
# An example of an OSS output:
#
#audio_output {
#	type		"oss"
#	name		"My OSS Device"
#	device		"/dev/dsp"	# optional
#	mixer_type      "hardware"      # optional
#	mixer_device	"/dev/mixer"	# optional
#	mixer_control	"PCM"		# optional
#}
#
# An example of a shout output (for streaming to Icecast):
#
#audio_output {
#	type		"shout"
#	encoder		"vorbis"		# optional
#	name		"My Shout Stream"
#	host		"localhost"
#	port		"8000"
#	mount		"/mpd.ogg"
#	password	"hackme"
#	quality		"5.0"
#	bitrate		"128"
#	format		"44100:16:1"
#	protocol	"icecast2"		# optional
#	user		"source"		# optional
#	description	"My Stream Description"	# optional
#	url             "http://example.com"    # optional
#	genre		"jazz"			# optional
#	public		"no"			# optional
#	timeout		"2"			# optional
#	mixer_type      "software"              # optional
#}
#
# An example of a recorder output:
#
#audio_output {
#       type            "recorder"
#       name            "My recorder"
#       encoder         "vorbis"                # optional, vorbis or lame
#       path            "/var/lib/mpd/recorder/mpd.ogg"
##      quality         "5.0"                   # do not define if bitrate is defined
#       bitrate         "128"                   # do not define if quality is defined
#       format          "44100:16:1"
#}
#
# An example of a httpd output (built-in HTTP streaming server):
#
#audio_output {
#	type		"httpd"
#	name		"My HTTP Stream"
#	encoder		"vorbis"		# optional, vorbis or lame
#	port		"8000"
#	bind_to_address "0.0.0.0"               # optional, IPv4 or IPv6
#	quality		"5.0"			# do not define if bitrate is defined
#	bitrate		"128"			# do not define if quality is defined
#	format		"44100:16:1"
#	max_clients     "0"                     # optional 0=no limit
#}
#
# An example of a pulseaudio output (streaming to a remote pulseaudio server)
# Please see README.Debian if you want mpd to play through the pulseaudio
# daemon started as part of your graphical desktop session!
#
#audio_output {
#	type		"pulse"
#	name		"My Pulse Output"
#	server		"remote_server"		# optional
#	sink		"remote_server_sink"	# optional
#}
#
# An example of a winmm output (Windows multimedia API).
#
#audio_output {
#	type		"winmm"
#	name		"My WinMM output"
#	device		"Digital Audio (S/PDIF) (High Definition Audio Device)" # optional
#		or
#	device		"0"		# optional
#	mixer_type	"hardware"	# optional
#}
#
# An example of an openal output.
#
#audio_output {
#	type		"openal"
#	name		"My OpenAL output"
#	device		"Digital Audio (S/PDIF) (High Definition Audio Device)" # optional
#}
#
## Example "pipe" output:
#
#audio_output {
#	type		"pipe"
#	name		"my pipe"
#	command		"aplay -f cd 2>/dev/null"
## Or if you're want to use AudioCompress
#	command		"AudioCompress -m | aplay -f cd 2>/dev/null"
## Or to send raw PCM stream through PCM:
#	command		"nc example.org 8765"
#	format		"44100:16:2"
#}
#
## An example of a null output (for no audio output):
#
#audio_output {
#	type		"null"
#	name		"My Null Output"
#	mixer_type      "none"                  # optional
#}
#
###############################################################################


# Normalization automatic volume adjustments ##################################
#
# This setting specifies the type of ReplayGain to use. This setting can have
# the argument "off", "album", "track" or "auto". "auto" is a special mode that
# chooses between "track" and "album" depending on the current state of
# random playback. If random playback is enabled then "track" mode is used.
# See <http://www.replaygain.org> for more details about ReplayGain.
# This setting is off by default.
#
#replaygain			"album"
#
# This setting sets the pre-amp used for files that have ReplayGain tags. By
# default this setting is disabled.
#
#replaygain_preamp		"0"
#
# This setting sets the pre-amp used for files that do NOT have ReplayGain tags.
# By default this setting is disabled.
#
#replaygain_missing_preamp	"0"
#
# This setting enables or disables ReplayGain limiting.
# MPD calculates actual amplification based on the ReplayGain tags
# and replaygain_preamp / replaygain_missing_preamp setting.
# If replaygain_limit is enabled MPD will never amplify audio signal
# above its original level. If replaygain_limit is disabled such amplification
# might occur. By default this setting is enabled.
#
#replaygain_limit		"yes"
#
# This setting enables on-the-fly normalization volume adjustment. This will
# result in the volume of all playing audio to be adjusted so the output has
# equal "loudness". This setting is disabled by default.
#
#volume_normalization		"no"
#
###############################################################################

# Character Encoding ##########################################################
#
# If file or directory names do not display correctly for your locale then you
# may need to modify this setting.
#
filesystem_charset		"UTF-8"
#
###############################################################################
Portions of the log file, after I wanted to switch to position 3 in my playlist (position 2 was playing fine)

Code: Select all

Dec 22 09:10 : client: [34] opened from local
Dec 22 09:10 : player: played "http://direct.fipradio.fr/live/fip-midfi.mp3"
Dec 22 09:10 : client: [34] closed
Dec 22 09:10 : client: [33] closed
Dec 22 09:10 : client: [35] opened from 127.0.0.1:40196
Dec 22 09:11 : client: [35] closed
Dec 22 09:11 : client: [36] opened from 127.0.0.1:40244
Dec 22 09:12 : client: [37] opened from local
Dec 22 09:12 : client: [37] closed
Dec 22 09:12 : client: [36] closed
Dec 22 09:12 : exception: avformat_open_input() failed: Invalid data found when processing input
Dec 22 09:12 : exception: Failed to decode https://www.ecouter-en-direct.com/radio-fip/
Dec 22 09:12 : player: played "https://www.ecouter-en-direct.com/radio-fip/"
Dec 22 09:12 : exception: avformat_open_input() failed: Invalid data found when processing input
Dec 22 09:12 : exception: Failed to decode https://www.ecouter-en-direct.com/radio-nostalgie/
Dec 22 09:12 : player: played "https://www.ecouter-en-direct.com/radio-nostalgie/"
Dec 22 09:12 : exception: avformat_open_input() failed: Invalid data found when processing input
Dec 22 09:12 : exception: Failed to decode https://www.ecouter-en-direct.com/rire-et-chansons/
Dec 22 09:12 : player: played "https://www.ecouter-en-direct.com/rire-et-chansons/"
Dec 22 09:12 : client: [38] opened from 127.0.0.1:40268
Dec 22 09:12 : exception: avformat_open_input() failed: Invalid data found when processing input
Dec 22 09:12 : exception: Failed to decode https://www.ecouter-en-direct.com/radio-classic-jazz/
Dec 22 09:12 : player: played "https://www.ecouter-en-direct.com/radio-classic-jazz/"
Dec 22 09:12 : exception: avformat_open_input() failed: Invalid data found when processing input
Dec 22 09:12 : exception: Failed to decode https://www.ecouter-en-direct.com/radio-classique/
Dec 22 09:12 : player: played "https://www.ecouter-en-direct.com/radio-classique/"
What happens here? Even if my playlist has wrong links, position 3 should be fine and is not listed here in the logs.
Here is may playlist

Code: Select all

http://cdn.nrjaudio.fm/adwz1/fr/56660/mp3_128.mp3
http://direct.fipradio.fr/live/fip-midfi.mp3
http;//radiomeuh.ice.infomaniak.ch/radiomeuh-128.mp3
https://www.ecouter-en-direct.com/radio-fip/
https://www.ecouter-en-direct.com/radio-nostalgie/
https://www.ecouter-en-direct.com/rire-et-chansons/
https://www.ecouter-en-direct.com/radio-classic-jazz/
https://www.ecouter-en-direct.com/radio-classique/
max
Forum team
Posts: 1254
Joined: January 15th, 2013, 3:43 pm

Re: Problem with the database

Post by max »

Your MPD version is very old and unsupported, sorry.
kartable
Posts: 3
Joined: December 21st, 2020, 2:48 pm

Re: Problem with the database

Post by kartable »

I followed the instructions given on many sites* to install mpd on Raspberry Pi with Raspbian: simply

Code: Select all

sudo apt-get install mpd

My install is just a few days old. How can I update eventually?

*) including the documentation https://www.musicpd.org/doc/html/user.html
Last edited by kartable on December 22nd, 2020, 1:18 pm, edited 1 time in total.
max
Forum team
Posts: 1254
Joined: January 15th, 2013, 3:43 pm

Re: Problem with the database

Post by max »

> including the documentation https://www.musicpd.org/doc/html/user.html

Did you really read it? That very page says: "Debian and Ubuntu are infamous for shipping heavily outdated software. The MPD version in their respective stable releases are usually too old to be supported by this project."

> How can I update eventually?

Compile from source or get more up-to-date binary packages here: https://www.musicpd.org/download-unoff-debian/ (linked from https://www.musicpd.org/download.html)
kartable
Posts: 3
Joined: December 21st, 2020, 2:48 pm

Re: Problem with the database

Post by kartable »

You're right but nobody seems to care. I am following a tutorial with MPD and MPC on Raspberry and the settings seem obvious, with no warning at all.

I'm still enthousiastic about MPD which is so lightweight. It has worked fine till I realize there is this problem with my playlist where I added radios by hand after having loaded them. This has become apparently a mismatch.

Before installing the unofficial package, I suppose I have to uninstall my version?

Thanks for all
Last edited by kartable on December 22nd, 2020, 6:33 pm, edited 1 time in total.
max
Forum team
Posts: 1254
Joined: January 15th, 2013, 3:43 pm

Re: Problem with the database

Post by max »

No, don't uninstall anything - you can simply upgrade with apt/aptitude. This is seamless. Those packages are made by the same guy who also maintains the official Debian packages, he knows what he's doing.
kartable
Posts: 3
Joined: December 21st, 2020, 2:48 pm

Re: Problem with the database

Post by kartable »

That's great but maybe I don't need to change anything.

I've worked on the queue and solved my problem with just a few commands:
- clear (the queue)
- playlistinfo (to check that the queue has been flushed)
- mpc load radio
- playlistinfo (again, where I can see that the array in nodered is populated back as it should)
Post Reply