[gelöst] Problem mit mariadb-server

[cas]

Hallo,
schon seit einiger Zeit gibt es ein Problem mit mariadb-server auf cinamon bei jedem DU, jedoch nicht bei KDE.
Auch apt install -f hilft nicht.

Code Select Expand


# apt install -f
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut.       
Statusinformationen werden eingelesen.... Fertig
0 aktualisiert, 0 neu installiert, 0 zu entfernen und 87 nicht aktualisiert.
2 nicht vollständig installiert oder entfernt.
Nach dieser Operation werden 0 B Plattenplatz zusätzlich benutzt.
mariadb-server-10.1 (10.1.22-4) wird eingerichtet ...
dpkg: Fehler beim Bearbeiten des Paketes mariadb-server-10.1 (--configure):
Unterprozess installiertes post-installation-Skript gab den Fehlerwert 1 zurück
dpkg: Abhängigkeitsprobleme verhindern Konfiguration von mariadb-server:
mariadb-server hängt ab von mariadb-server-10.1 (>= 10.1.22-4); aber:.........]
  Paket mariadb-server-10.1 ist noch nicht konfiguriert.............................]
Fortschritt: [  0%] [...................................................................]
dpkg: Fehler beim Bearbeiten des Paketes mariadb-server (--configure):.......................]
Abhängigkeitsprobleme - verbleibt unkonfiguriert..................................................]
Fehler traten auf beim Bearbeiten von:..................................................................]
mariadb-server-10.1[.........................................................................................]
mariadb-server 0%] [.............................................................................................]
E: Sub-process /usr/bin/dpkg returned an error code (1)


Auch

Code Select Expand

apt purge mariadb-server
apt install mariadb-server hat nichts geholfen.

Bin jetzt etwas ratlos.

C

[bluelupo]

Hi cas,

evtl. irgendwelche mariadb* Reste installiert die die Installation von mariadb-server verhindern?

[devil]

Das ist ein Bug. Hier gibts nen Workaround: https://lists.debian.org/debian-kde/2017/05/msg00000.html

[piper]

Try this first

Code Select Expand

apt purge mysql* mariadb*

Remove what is found here

Code Select Expand

find / -name mysql*

Code Select Expand

apt clean

Code Select Expand

rm /var/cache/apt/archives/mariadb*

Code Select Expand

rm /var/cache/apt/archives/mysql*

Possibly these symbolic links are pointing to missing files

Code Select Expand

rm /etc/systemd/system/mysqld.service
rm /etc/systemd/system/mysql.service

This won't hurt either

Code Select Expand

rm -R /etc/mysql
rm -R /varl/lib/mysql

** IMPORTANT **    REBOOT  then

Code Select Expand

apt install mariadb-server


Let us know any other errors, you might have to run 

Code Select Expand

dpkg-reconfigure mariadb-server-10.1

[cas]

danke devil.

Hier gibts nen Workaround: https://lists.debian.org/debian-kde/2017/05/msg00000.html

die wichtige Zeile daraus  ist

Code Select Expand


Then I do, as plain user,

$ akonadictl stop

[cas]

wow, an incredibly detailed deinstallation guide. This bug seems to be nasty. 

Try this first

Code Select Expand

apt purge mysql* mariadb*

devil's workaraound is necessary to do this

Remove what is found here

Code Select Expand

find / -name mysql*

I didn't do this. I have several TB under /disks , which took too long and I was too lazy to do it otherwise.

Code Select Expand

apt clean

I noticed that "clean" is not part of the man page of apt

Code Select Expand

rm /var/cache/apt/archives/mariadb*

Code Select Expand

rm /var/cache/apt/archives/mysql*

Possibly these symbolic links are pointing to missing files

Code Select Expand

rm /etc/systemd/system/mysqld.service
rm /etc/systemd/system/mysql.service

This won't hurt either

Code Select Expand

rm -R /etc/mysql
rm -R /varl/lib/mysql

very thorough instructions, but the mentioned stuff wasn't there anymore. apt purge/clean did its job.

** IMPORTANT **    REBOOT  then

Code Select Expand

apt install mariadb-server

from my KDE machine (after reboot and install), which also had problems, as I just noticed:

Code Select Expand


root@kde:~# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.1.22-MariaDB- Debian 9.0

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> Bye


Let us know any other errors, you might have to run 

Code Select Expand

dpkg-reconfigure mariadb-server-10.1

This command didn't ask or show anything, which I assume is a good sign.

Code Select Expand

root@kde:~# dpkg-reconfigure mariadb-server-10.1
root@kde:~#


Thanks piper!

[devil]

Actualy, all you have to do is

Code Select Expand

akonadictl stop as in the mail I referred to. The problem is that mariadb sees akonadi as a running instance of itself and can't update while it's running, but can't stop it either.

[devil]

fixed: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=861782

[piper]

devil : danke

also besides

Code Select Expand

akonadictl stop

this works also

Code Select Expand

/etc/init.d/mysql stop

and then check with

Code Select Expand

systemctl status mysql

[cas]

Warum einfach, wenn es auch kompliziert geht?

Trotzdem danke.

C

[piper]

My mother when alive, said I was complicated 

[cas]

My mother doesn't say it, but she thinks the same of me.