<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Pedro,</p>
<p>Your MariaDB solution works as far as I can tell. Wish I knew
this before I spent 2 months on the SQLite solution;-(</p>
<p>Still, learned a lot in the process</p>
<p>Here is what I did</p>
<p>1) Installed Kubuntu 19.10 (on a VM)</p>
<p>2) Installed all prerequiste software as per your docker; the
only thing I added was libphonon4qt5-dev</p>
<p>apt-get install -y cmake extra-cmake-modules g++ git
libmariadb-dev libmariadbd-dev pkg-config \<br>
qtdeclarative5-dev qtscript5-dev libqt5svg5-dev
qtquickcontrols2-5-dev qtwebengine5-dev \<br>
libkf5archive-dev libkf5attica-dev libkf5codecs-dev
libkf5config-dev libkf5configwidgets-dev libkf5coreaddons-dev
libkf5crash-dev \<br>
libkf5dbusaddons-dev libkf5declarative-dev libkf5dnssd-dev
libkf5globalaccel-dev libkf5guiaddons-dev libkf5i18n-dev
libkf5iconthemes-dev \<br>
libkf5kcmutils-dev libkf5kio-dev libkf5newstuff-dev
libkf5notifications-dev libkf5notifyconfig-dev libkf5package-dev
libkf5solid-dev \<br>
libkf5texteditor-dev libkf5threadweaver-dev
libkf5widgetsaddons-dev libkf5windowsystem-dev libkf5wallet-dev
kirigami2-dev \<br>
gettext libtag1-dev libtag-extras-dev libavcodec-dev
libavformat-dev libavdevice-dev libavutil-dev libswscale-dev
libpostproc-dev \<br>
libgpod-dev libgdk-pixbuf2.0-dev libmygpo-qt-dev libmtp-dev
libcurl4-openssl-dev libxml2-dev libssl-dev libgcrypt20-dev \<br>
libfftw3-dev libloudmouth1-dev libofa0-dev liblastfm5-dev
libgmock-dev libphonon4qt5-dev<br>
</p>
<p>3) cloned amarok <br>
</p>
<p>4) built/installed amarok (my dev environment is under /kdedev)</p>
<p>cmake -DCMAKE_INSTALL_PREFIX=$HOME/kdedev -j4
-DCMAKE_VERBOSE_MAKEFILE=TRUE -DCMAKE_BUILD_TYPE=Debug
-DMYSQLCONFIG_EXECUTABLE=/usr/bin/mariadb_config
-DMYSQL_INCLUDE_DIR=/usr/include/mariadb ../../src/amarok/</p>
<p>cmake --build .</p>
<p>make install</p>
<p>amarok runs, I can add my music and play from a random playlist.
Have not done any extesnive testing, but think you have found a
solution for installation for (U/Ku)bunto without the embedded
MySql.</p>
<p>Thanks,</p>
<p>Leo</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 28/2/20 1:46 am, Pedro de Carvalho
Gomes wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CABwArfqiYhbwGt5DcCSwhrjrcZJR4NxetYqHWk4MXy5+Vupa6g@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hi,
<div><br>
</div>
<div>Is this branch available somewhere? I may take a lot and
help you with that.<br>
<br>
About the (K)Ubuntu 19+: indeed it comes with Mysql 8, which
no longer supports Mysql Embedded. Still Ubuntu 19.10 provides
MariaDB 10.3 as alternative, which has a compatible library
(libmariadbd) that works exactly the same as mysql </div>
<div><br>
</div>
<div>At the following bug report I have attached a Docker image
for Ubuntu 19.10 that builds Amarok packages with MariaDB.
Even if you are not familiar with Docker, you can use it as a
reference to build your own Amarok. Let me know if you have
issues building it.</div>
<div><br>
<a href="https://bugs.kde.org/show_bug.cgi?id=414407"
moz-do-not-send="true">https://bugs.kde.org/show_bug.cgi?id=414407</a><br>
<br>
Pedro</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Feb 25, 2020 at 8:20
PM subscription1 <<a href="mailto:llsubscr@zudiewiener.com"
moz-do-not-send="true">llsubscr@zudiewiener.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Given
that there is no support for the embedded MySql in (native)
Ubuntu <br>
19+ I've started an implementation of SQLite as a possible
alternative.<br>
<br>
I've created a branch that creates the SQLite DB, loads albums
and <br>
creates/plays dynamic playlists.<br>
<br>
There is (obviously) more work to do, but it's a start,<br>
<br>
Not sure where this should go next (if at all).<br>
<br>
Cheers,<br>
<br>
Leo<br>
<br>
</blockquote>
</div>
</blockquote>
</body>
</html>