How to solve alike "linking CXX executable" issues

Question

My attempts to compile to get Gerbera, a popular DLNA server running proved futile. The dependencies seem to be alright. The documentation doesn't mention any make flags needed. So when I try to make, building reaches 100% and then fails on

[100%] Linking CXX executable gerbera

with the following message:

/usr/bin/ld: liblibgerbera.a(sqlite_database.cc.o): undefined reference to symbol 'sqlite3_mprintf'
/usr/bin/ld: /lib/x86_64-linux-gnu/libsqlite3.so.0: error adding symbols: DSO missing from command line
clang: error: linker command failed with exit code 1 (use -v to see invocation)
make[2]: *** [CMakeFiles/gerbera.dir/build.make:98: gerbera] Error 1
make[1]: *** [CMakeFiles/Makefile2:78: CMakeFiles/gerbera.dir/all] Error 2
make: *** [Makefile:130: all] Error 2

I am unfamiliar with this kind of issue, so would be grateful if someone explained it to me or, if possible, helped me to fix it

Answer 1

I tried building from the standard instructions and also found problems. However I did manage to build it in the end as follows:

Install Dependencies

sudo apt install uuid-dev libsqlite3-dev libmysqlclient-dev libmagic-dev libexif-dev libcurl4-openssl-dev libspdlog-dev libpugixml-dev libavutil-dev libavcodec-dev libavformat-dev libavdevice-dev libavfilter-dev libavresample-dev libswscale-dev libswresample-dev libpostproc-dev duktape-dev libmatroska-dev libsystemd-dev libtag1-dev libfmt-dev ffmpeg git cmake autoconf libtool

Build/Install spdlog

During my first "configure" I received a message stating that there would be a conflict with the Ubuntu provided spdlog. Here we build and install our own with the correct flags set.

git clone https://github.com/gabime/spdlog
cd spdlog
cmake -D "SPDLOG_FMT_EXTERNAL:BOOL=true" .
make
sudo make install

Download gerbera

git clone https://github.com/gerbera/gerbera.git

Build/Install libupnp

The library provided by Ubuntu is too old so we need to build and install a newer version. The gerbera source provides a script to do this for us.

cd gerbera/scripts/
chmod +x install-pupnp.sh
sudo ./install-pupnp.sh

Build/Install gerbera

From the folder holding the gerbera root folder you downloaded:

mkdir build
cd build
cmake -DWITH_MAGIC=1 -DWITH_MYSQL=1 -DWITH_CURL=1 -DWITH_JS=1 -DWITH_TAGLIB=1 -DWITH_AVCODEC=1 -DWITH_EXIF=1 -DWITH_LASTFM=0 -DWITH_SYSTEMD=1 ../gerbera
make
sudo make install

The above all worked when I tried it on a fresh install of Ubuntu 20.04.

Alternative

If you'd rather not build gerbera yourself, there is a Ubuntu PPA available. Therefore, you could install gerbera easily as follows:

sudo add-apt-repository ppa:stephenczetty/gerbera-updates
sudo apt-get update
sudo apt install gerbera