Bug 441750

Summary:	MySQL installation and setup
Product:	[Applications] amarok	Reporter:	empyreal <empyreal>
Component:	Collections/Local	Assignee:	Amarok Developers <amarok-bugs-dist>
Status:	RESOLVED FIXED
Severity:	wishlist	CC:	ralf-engels
Priority:	NOR
Version:	2.9.71
Target Milestone:	---
Platform:	Kubuntu
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description empyreal 2021-08-30 11:13:25 UTC

I have problems with mysql Failed to start MySQL Community Server
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' Solution for this is hard to find. It’s not a big deal. I’ll figure smth. out, but average user will be annoyed getting message about db at every start.

Amarok plays music without any problems.
Could it be made message not pop-up if MySQL fails, not available, etc?
Why MySQL is not optional?

Comment 1 empyreal 2021-09-03 11:22:33 UTC

Previous issue was solved by removing MySQL with REBOOT and reinstalling.

Amarok depends on libmariadb-dev mariadb-common libmariadb3. If you have MySQL server and client installed, you still need these. Can't we just use either MariaDB or MySQL? If Amarok depends on libmariadb-dev mariadb-common libmariadb3, let's use MariaDB only.

Issue with libmariadb-dev was solved by remove/install.
This do not affect Amarok basic functionality, but it's not good.

Setting up mariadb-common (1:10.5.12-0ubuntu0.21.04.1) ...
update-alternatives: error: alternative path /etc/mysql/mariadb.cnf doesn't exist
dpkg: error processing package mariadb-common (--configure):
 installed mariadb-common package post-installation script subprocess returned error exit status 2
dpkg: dependency problems prevent configuration of libmariadb3:amd64:
 libmariadb3:amd64 depends on mariadb-common; however:
  Package mariadb-common is not configured yet.

dpkg: error processing package libmariadb3:amd64 (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          Errors were encountered while processing:
 mariadb-common
 libmariadb3:amd64

Comment 2 Myriam Schweingruber 2021-09-03 12:23:10 UTC

You don't understand: MySQL has removed its embedded database support on which Amarok depends a while ago, so mariaDB is the only option. This is clearly stated in the README file, and anyone compiling or packaging Amarok needs to set the dependencies accordingly.
Of course you are free to use an external database setup, but that is not the default.

Comment 3 empyreal 2022-08-16 14:39:46 UTC

Got rid of Database Error message by removing it in sources.