Welcome, Guest. Please login or register.
Did you miss your activation email?

Author Topic: [DE] [gelöst] Problem mit mariadb-server  (Read 11647 times)

Offline cas

  • User
  • Posts: 401
[DE] [gelöst] Problem mit mariadb-server
« on: 2017/05/03, 19:48:34 »
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]
# 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]
apt purge mariadb-server
apt install mariadb-server
hat nichts geholfen.

Bin jetzt etwas ratlos.

C
« Last Edit: 2017/05/05, 01:54:24 by cas »

Offline bluelupo

  • User
  • Posts: 2.068
    • BluelupoMe
Re: Problem mit mariadb-server
« Reply #1 on: 2017/05/03, 20:24:14 »
Hi cas,

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

Offline devil

  • Administrator
  • User
  • *****
  • Posts: 4.838
Re: Problem mit mariadb-server
« Reply #2 on: 2017/05/03, 20:36:29 »
Das ist ein Bug. Hier gibts nen Workaround: https://lists.debian.org/debian-kde/2017/05/msg00000.html

Offline piper

  • User
  • Posts: 1.785
  • we are the priests ... of the temples of syrinx
Re: Problem mit mariadb-server
« Reply #3 on: 2017/05/03, 20:36:45 »
Try this first


Code: [Select]
apt purge mysql* mariadb*
Remove what is found here

Code: [Select]
find / -name mysql*
Code: [Select]
apt clean

Code: [Select]
rm /var/cache/apt/archives/mariadb*
Code: [Select]
rm /var/cache/apt/archives/mysql*
Possibly these symbolic links are pointing to missing files

Code: [Select]
rm /etc/systemd/system/mysqld.service
rm /etc/systemd/system/mysql.service

This won't hurt either

Code: [Select]
rm -R /etc/mysql
rm -R /varl/lib/mysql

** IMPORTANT **    REBOOT  then

Code: [Select]
apt install mariadb-server

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

Code: [Select]
dpkg-reconfigure mariadb-server-10.1
Free speech isn't just fucking saying what you want to say, it's also hearing what you don't want to fucking hear

I either give too many fucks or no fucks at all, it's like I cannot find a middle ground for a moderate fuck distribution, it's like what the fuck

Offline cas

  • User
  • Posts: 401
Re: Problem mit mariadb-server
« Reply #4 on: 2017/05/04, 00:08:54 »
danke devil.
Hier gibts nen Workaround: https://lists.debian.org/debian-kde/2017/05/msg00000.html

die wichtige Zeile daraus  ist
Code: [Select]
Then I do, as plain user,

$ akonadictl stop

Offline cas

  • User
  • Posts: 401
Re: Problem mit mariadb-server
« Reply #5 on: 2017/05/04, 00:44:40 »
wow, an incredibly detailed deinstallation guide. This bug seems to be nasty.  ;)

Try this first


Code: [Select]
apt purge mysql* mariadb*
devil's workaraound is necessary to do this




Quote

Remove what is found here

Code: [Select]
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.




Quote
Code: [Select]
apt clean
I noticed that "clean" is not part of the man page of apt




Quote
Code: [Select]
rm /var/cache/apt/archives/mariadb*
Code: [Select]
rm /var/cache/apt/archives/mysql*
Possibly these symbolic links are pointing to missing files

Code: [Select]
rm /etc/systemd/system/mysqld.service
rm /etc/systemd/system/mysql.service

This won't hurt either

Code: [Select]
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.





Quote
** IMPORTANT **    REBOOT  then

Code: [Select]
apt install mariadb-server

from my KDE machine (after reboot and install), which also had problems, as I just noticed:
Code: [Select]
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





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

Code: [Select]
dpkg-reconfigure mariadb-server-10.1
This command didn't ask or show anything, which I assume is a good sign.

Code: [Select]
root@kde:~# dpkg-reconfigure mariadb-server-10.1
root@kde:~#


Thanks piper!
« Last Edit: 2017/05/04, 00:47:57 by cas »

Offline devil

  • Administrator
  • User
  • *****
  • Posts: 4.838
Re: Problem mit mariadb-server
« Reply #6 on: 2017/05/04, 11:17:50 »
Actualy, all you have to do is
Code: [Select]
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.

Offline devil

  • Administrator
  • User
  • *****
  • Posts: 4.838

Offline piper

  • User
  • Posts: 1.785
  • we are the priests ... of the temples of syrinx
Re: Problem mit mariadb-server
« Reply #8 on: 2017/05/04, 19:57:23 »
devil : danke :P

also besides

Code: [Select]
akonadictl stop
this works also

Code: [Select]
/etc/init.d/mysql stop
and then check with

Code: [Select]
systemctl status mysql
« Last Edit: 2017/05/04, 20:01:58 by piper »
Free speech isn't just fucking saying what you want to say, it's also hearing what you don't want to fucking hear

I either give too many fucks or no fucks at all, it's like I cannot find a middle ground for a moderate fuck distribution, it's like what the fuck

Offline cas

  • User
  • Posts: 401
Re: Problem mit mariadb-server
« Reply #9 on: 2017/05/05, 01:53:54 »
Warum einfach, wenn es auch kompliziert geht?

Trotzdem danke.

C

Offline piper

  • User
  • Posts: 1.785
  • we are the priests ... of the temples of syrinx
Re: [gelöst] Problem mit mariadb-server
« Reply #10 on: 2017/05/05, 02:30:00 »
My mother when alive, said I was complicated 
Free speech isn't just fucking saying what you want to say, it's also hearing what you don't want to fucking hear

I either give too many fucks or no fucks at all, it's like I cannot find a middle ground for a moderate fuck distribution, it's like what the fuck

Offline cas

  • User
  • Posts: 401
Re: [gelöst] Problem mit mariadb-server
« Reply #11 on: 2017/05/05, 06:43:25 »
My mother doesn't say it, but she thinks the same of me.