[Ubuntu 18] Mailpasswörter abgelehnt nach DB Update

[SentinelKnight]

Moin!

Nach dem Update von MariaDB auf v 10.6.4 habe ich keinen Zugriff mehr auf meine Mailkonten. Auch über den Keyhelp Webmail ist es nicht möglich, auf die Konten zuzugreifen. Ändern der Passwörter führte nicht zum Erfolg.

In der mail.log beginnt nach dem Update der Errorlog mit vielen unterschiedlichen mysql Fehlern, z.B:

Code: Select all

keyhelp dovecot: auth-worker(2731): Error: mysql(localhost): Connect failed to database (keyhelp): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) - waiting for 5 seconds before retry

oder

Code: Select all

keyhelp postfix/trivial-rewrite[1796]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)

Ich habe die Zugangsdaten mit dem mysql Benutzernamen/Passwort von Keyhelp in folgenden Dateien abgeglichen:

Code: Select all

/etc/dovecot/dovecot-sql.conf
/etc/postfix/mysql-virtual-alias-maps.cf
/etc/postfix/mysql-virtual-mailbox-domains.cf
/etc/postfix/mysql-virtual-mailbox-maps.cf
/etc/amavis/conf.d/50-user
/etc/keyhelp/config/config.json
/etc/proftpd/sql.conf 
/home/keyhelp/www/roundcube/plugins/password/config.inc.php
/home/keyhelp/www/rainloop/data/_data_/_default_/configs/plugin-change-password-custom-sql.ini

Alles stimmt überein.

Die Datenbank selbst ist auch da, ich kann mich einloggen und sehe die Variablen. Die Prozesse laufen auch.

Was übersehe ich? Rechteproblem? Datenbank Inkompatibilität?

Danke für den Input. LG

[Alexander]

Die Kompatibilität von KeyHelp mit MariaDB 10.6 wurde nicht getestet. Mag sein, das 10.6 einige Sachen anders handelt als die Vorgänger.

KeyHelp geht davon aus das die Version, die das Betriebssystem vorgibt auf dem Server läuft.
Das heißt KeyHelp ist 100% kompatibel bis einschließlich MariaDB 10.5.x (aufgrund von Debian 11).
Darüber hinaus erfolgten keinerlei Tests. Das wird erst akut wenn nächstes Jahr Ubuntu 22 erscheint.

[SentinelKnight]

Herrjeh, das wird es dann wohl sein. Danke für die Info, ich schaue mal wie ich sauber auf die 10.5 downgraden kann... ;(

[SentinelKnight]

Update:

Die Datenbank wurde nun sauber auf 10.3.31 neu installiert. Das Backup der Datenbank ist eingespielt.
Keyhelp ist erreichbar, Webseiten & Webshop ist auch erreichar.

Folgende Fehler bestehen:

Kein Zugriff auf Mailkonten über Mailclients (keine Verbindung)
Kein Zugriff auf Mailkonten über Webmail mit Benutzer / Passwort

FTP Dienst ist offline und lässt sich nicht über das Interface starten (Leider konnte die Operation nicht korrekt durchgeführt werden. (Berechtigungen korrekt?)

Amavis Dienst ist offline und kann nicht gestartet werden (Leider konnte die Operation nicht korrekt durchgeführt werden. (Berechtigungen korrekt?)

Der Zugriff auf "Server-Dienst-Verwaltung" dauert deutlich länger als sonst.

Gibt es Lösungsansätze?

Ist in der /etc/keyhelp/config/config.json der "root" der mysql root gemeint? Die Werte username/passwort sind für mich unbekannt.

[SentinelKnight]

Ich habe mal versucht auf die DB zuzugreifen. nach Eingabe von mysql kommt das:

Code: Select all

ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded

[OlliTheDarkness]

Ich habe mal versucht auf die DB zuzugreifen. nach Eingabe von mysql kommt das:

Code: Select all

ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded

Schau mal die conf ( /etc/mysql ) durch, welche wie aussehn sollte :

mariadb.cnf

Code: Select all

# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 0. "/etc/mysql/my.cnf" symlinks to this file, reason why all the rest is read.
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# If you are new to MariaDB, check out https://mariadb.com/kb/en/basic-mariadb-articles/

#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]
# Port or socket location where to connect
# port = 3306
socket = /run/mysqld/mysqld.sock

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/

debian.cnf

Code: Select all

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = root
password = 
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = root
password = 
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr

mariadb.conf.d/50-server.cnf

Code: Select all

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]

#
# * Basic Settings
#

user                    = mysql
pid-file                = /run/mysqld/mysqld.pid
basedir                 = /usr
datadir                 = /var/lib/mysql
tmpdir                  = /tmp
lc-messages-dir         = /usr/share/mysql
lc-messages             = en_US
skip-external-locking

# Broken reverse DNS slows down connections considerably and name resolve is
# safe to skip if there are no "host by domain name" access grants
#skip-name-resolve

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1

#
# * Fine Tuning
#

#key_buffer_size        = 128M
#max_allowed_packet     = 1G
#thread_stack           = 192K
#thread_cache_size      = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
#myisam_recover_options = BACKUP
#max_connections        = 100
#table_cache            = 64

#
# * Logging and Replication
#

# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# Recommend only changing this at runtime for short testing periods if needed!
#general_log_file       = /var/log/mysql/mysql.log
#general_log            = 1

# When running under systemd, error logging goes via stdout/stderr to journald
# and when running legacy init error logging goes to syslog due to
# /etc/mysql/conf.d/mariadb.conf.d/50-mysqld_safe.cnf
# Enable this if you want to have error logging into a separate file
#log_error = /var/log/mysql/error.log
# Enable the slow query log to see queries with especially long duration
#slow_query_log_file    = /var/log/mysql/mariadb-slow.log
#long_query_time        = 10
#log_slow_verbosity     = query_plan,explain
#log-queries-not-using-indexes
#min_examined_row_limit = 1000

# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id              = 1
#log_bin                = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
#max_binlog_size        = 100M

#
# * SSL/TLS
#

# For documentation, please read
# https://mariadb.com/kb/en/securing-connections-for-client-and-server/
#ssl-ca = /etc/mysql/cacert.pem
#ssl-cert = /etc/mysql/server-cert.pem
#ssl-key = /etc/mysql/server-key.pem
#require-secure-transport = on

#
# * Character sets
#

# MySQL/MariaDB default is Latin1, but in Debian we rather default to the full
# utf8 4-byte character set. See also client.cnf
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci

#
# * InnoDB
#

# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# Most important is to give InnoDB 80 % of the system RAM for buffer use:
# https://mariadb.com/kb/en/innodb-system-variables/#innodb_buffer_pool_size
#innodb_buffer_pool_size = 8G

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.5 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.5]

mariadb.conf.d/90-tuning.cnf

Code: Select all

#
# KeyHelp Tuning Settings
# System-Memory > 2 GB
#

[mysqld]

# mySQL Tuning
max_connections         = 200
key_buffer_size         = 250M
max_allowed_packet      = 16M
thread_stack            = 256K
tmp_table_size          = 128M
max_heap_table_size     = 128M
thread_cache_size       = 150
table_cache             = 8192
table_definition_cache  = 4096
open_files_limit        = 16544

# InnoDB Configuration
innodb_file_per_table   = 1
innodb_buffer_pool_size = 500M

# Query Cache Configuration
query_cache_limit       = 64M
query_cache_size        = 512M
query_cache_type        = 1

[SentinelKnight]

mail.err wird geflutet:

Code: Select all

Oct 30 15:51:49 keyhelp dovecot: imap-login: Error: Timeout waiting for handshake from auth server. my pid=8002, input bytes=0
Oct 30 15:52:13 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 15:52:13 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 15:53:13 keyhelp postfix/cleanup[8214]: error: unsupported dictionary type: mysql
Oct 30 15:54:36 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 15:54:36 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 15:55:26 keyhelp postfix/smtpd[8430]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8430]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8432]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8432]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8434]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8434]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8435]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8435]: error: unsupported dictionary type: mysql
Oct 30 15:55:36 keyhelp postfix/smtpd[8430]: fatal: no SASL authentication mechanisms
Oct 30 15:55:36 keyhelp postfix/smtpd[8434]: fatal: no SASL authentication mechanisms
Oct 30 15:55:36 keyhelp postfix/smtpd[8435]: fatal: no SASL authentication mechanisms
Oct 30 15:55:36 keyhelp postfix/smtpd[8432]: fatal: no SASL authentication mechanisms
Oct 30 15:55:36 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 15:55:36 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 15:56:37 keyhelp postfix/smtpd[8535]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8535]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8536]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8536]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8537]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8537]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8538]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8538]: error: unsupported dictionary type: mysql
Oct 30 15:56:48 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 15:56:48 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 15:56:48 keyhelp postfix/smtpd[8537]: fatal: no SASL authentication mechanisms
Oct 30 15:58:05 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 15:58:05 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 15:58:05 keyhelp postfix/smtpd[8536]: fatal: no SASL authentication mechanisms

Die mail.log ebenfalls:

Code: Select all

Oct 30 16:00:26 keyhelp postfix/smtpd[8898]: error: unsupported dictionary type: mysql
Oct 30 16:00:26 keyhelp postfix/smtpd[8898]: error: unsupported dictionary type: mysql
Oct 30 16:00:26 keyhelp postfix/smtpd[8898]: connect from mail.bso-server.de[88.99.136.45]
Oct 30 16:00:26 keyhelp postfix/smtpd[8900]: error: unsupported dictionary type: mysql
Oct 30 16:00:26 keyhelp postfix/smtpd[8900]: error: unsupported dictionary type: mysql
Oct 30 16:00:26 keyhelp postfix/smtpd[8900]: connect from mail.bso-server.de[88.99.136.45]
Oct 30 16:00:26 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 16:00:26 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 16:00:26 keyhelp postfix/smtpd[8898]: fatal: no SASL authentication mechanisms
Oct 30 16:00:27 keyhelp postfix/master[1894]: warning: process /usr/lib/postfix/sbin/smtpd pid 8898 exit status 1
Oct 30 16:00:27 keyhelp postfix/master[1894]: warning: /usr/lib/postfix/sbin/smtpd: bad command startup -- throttling
Oct 30 16:00:36 keyhelp postfix/smtpd[8900]: fatal: no SASL authentication mechanisms
Oct 30 16:00:37 keyhelp postfix/master[1894]: warning: process /usr/lib/postfix/sbin/smtpd pid 8900 exit status 1

[SentinelKnight]

Den ERROR 1524 habe ich erstmal behoben, indem ich mit

sudo mysqld_safe --skip-grant-tables &

auf sql zugreifen konnte und dort ein root PW vergeben habe. Nun kann ich mich auch sauber in mysql einloggen.

In der mariadb.ncf fehlte das:

Code: Select all

socket = /run/mysqld/mysqld.sock

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/

Die debian.cnf sieht so aus:

Code: Select all

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = ****************
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = ******************
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr

Die 50-server.cnf passt bis auf die letzten Zeilen:

Code: Select all

[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]
plugin_load_add = auth_socket

# This group is only read by MariaDB-10.6 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.6]

Die 90-tuning.cnf passt.

[OlliTheDarkness]

mail.err wird geflutet:

Code: Select all

Oct 30 15:51:49 keyhelp dovecot: imap-login: Error: Timeout waiting for handshake from auth server. my pid=8002, input bytes=0
Oct 30 15:52:13 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 15:52:13 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 15:53:13 keyhelp postfix/cleanup[8214]: error: unsupported dictionary type: mysql
Oct 30 15:54:36 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 15:54:36 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 15:55:26 keyhelp postfix/smtpd[8430]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8430]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8432]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8432]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8434]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8434]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8435]: error: unsupported dictionary type: mysql
Oct 30 15:55:26 keyhelp postfix/smtpd[8435]: error: unsupported dictionary type: mysql
Oct 30 15:55:36 keyhelp postfix/smtpd[8430]: fatal: no SASL authentication mechanisms
Oct 30 15:55:36 keyhelp postfix/smtpd[8434]: fatal: no SASL authentication mechanisms
Oct 30 15:55:36 keyhelp postfix/smtpd[8435]: fatal: no SASL authentication mechanisms
Oct 30 15:55:36 keyhelp postfix/smtpd[8432]: fatal: no SASL authentication mechanisms
Oct 30 15:55:36 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 15:55:36 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 15:56:37 keyhelp postfix/smtpd[8535]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8535]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8536]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8536]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8537]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8537]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8538]: error: unsupported dictionary type: mysql
Oct 30 15:56:37 keyhelp postfix/smtpd[8538]: error: unsupported dictionary type: mysql
Oct 30 15:56:48 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 15:56:48 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 15:56:48 keyhelp postfix/smtpd[8537]: fatal: no SASL authentication mechanisms
Oct 30 15:58:05 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 15:58:05 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 15:58:05 keyhelp postfix/smtpd[8536]: fatal: no SASL authentication mechanisms

Die mail.log ebenfalls:

Code: Select all

Oct 30 16:00:26 keyhelp postfix/smtpd[8898]: error: unsupported dictionary type: mysql
Oct 30 16:00:26 keyhelp postfix/smtpd[8898]: error: unsupported dictionary type: mysql
Oct 30 16:00:26 keyhelp postfix/smtpd[8898]: connect from mail.bso-server.de[88.99.136.45]
Oct 30 16:00:26 keyhelp postfix/smtpd[8900]: error: unsupported dictionary type: mysql
Oct 30 16:00:26 keyhelp postfix/smtpd[8900]: error: unsupported dictionary type: mysql
Oct 30 16:00:26 keyhelp postfix/smtpd[8900]: connect from mail.bso-server.de[88.99.136.45]
Oct 30 16:00:26 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 16:00:26 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 16:00:26 keyhelp postfix/smtpd[8898]: fatal: no SASL authentication mechanisms
Oct 30 16:00:27 keyhelp postfix/master[1894]: warning: process /usr/lib/postfix/sbin/smtpd pid 8898 exit status 1
Oct 30 16:00:27 keyhelp postfix/master[1894]: warning: /usr/lib/postfix/sbin/smtpd: bad command startup -- throttling
Oct 30 16:00:36 keyhelp postfix/smtpd[8900]: fatal: no SASL authentication mechanisms
Oct 30 16:00:37 keyhelp postfix/master[1894]: warning: process /usr/lib/postfix/sbin/smtpd pid 8900 exit status 1

Was mir hier auffällt ist das Dovecot einen falschen Driver verwendet, es muss sql und nicht mysql heißen.

Schau mal in die /etc/dovecot/dovecot.conf , Zeile 45 und 50 da sollte driver = sql stehen.

Und in der /etc/postfix/main.cf , ab Zeile 92 sollte

# Virtual domains, users, and aliases
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf

stehen.

Mir scheint als wenn du nicht nur am MySQL rumgedoktort hast ^^

[MLan]

Code: Select all

apt-get install postfix-mysql

könnte da weiterhelfen

[OlliTheDarkness]

Code: Select all

apt-get install postfix-mysql

könnte da weiterhelfen

Stimmt, wenn er Mysql via apt vorher geworfen hat wird das Paket , da Abhängig, mit weggeflogen sein.

[SentinelKnight]

In der dovecot.conf steht:

Code: Select all

    passdb {
        driver = sql
        args = /etc/dovecot/dovecot-sql.conf
    }

    userdb {
        driver = sql
        args = /etc/dovecot/dovecot-sql.conf

In der main.cf steht wie von dir gefordert:

Code: Select all

# Virtual domains, users, and aliases
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf

apt-get install postfix-mysql habe ich ausgeführt und das System neu gestartet. Zugriff habe ich dennoch nicht, im Webmail bringt er den Output "Verbindung zum Speicherserver fehlgeschlagen."

Was habe ich gemacht?

Mir scheint als wenn du nicht nur am MySQL rumgedoktort hast ^^

Ja, nein, vielleicht - ich habe während der ganzen Geschichte NIE in den cfg´s rumgespielt, sondern alles nur über die Konsole installiert bzw gelöscht. Zum Schluss -vor dem letzten semi-erfolgreichen Ablauf habe ich dies gemacht:

apt-get remove --purge mysql
apt-get remove --purge mysql*
apt-get remove --purge mariadb
apt-get remove --purge mariadb*
apt-get --purge remove mariadb-server
apt-get --purge remove python-software-properties

danach
sudo apt update
sudo apt install mariadb-server
sudo apt-get install software-properties-common dirmngr apt-transport-https
sudo apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc'
sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] https://mirror.wtnet.de/mariadb/repo/10.6/ubuntu bionic main'
sudo apt install mysql-server
sudo mysql_secure_installation

[OlliTheDarkness]

Du hast Post.

[SentinelKnight]

Wahrscheinlich fehlt noch etwas, warum auch der FTP nicht laufen will (untergeordnetes Problem) und weshalb der Amavis nicht startet.

Ich weiß, dass ich dem mysql root ein PW gegeben habe (notiert).

Aktueller mail.err (Auszug):

Code: Select all

Oct 30 19:10:36 keyhelp postfix/smtpd[4854]: fatal: no SASL authentication mechanisms
Oct 30 19:10:36 keyhelp postfix/smtpd[4853]: fatal: no SASL authentication mechanisms
Oct 30 19:10:36 keyhelp postfix/smtpd[4852]: fatal: no SASL authentication mechanisms
Oct 30 19:10:50 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 19:10:50 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 19:11:48 keyhelp postfix/smtpd[4964]: fatal: no SASL authentication mechanisms
Oct 30 19:11:50 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 19:11:50 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 19:11:50 keyhelp postfix/smtpd[4962]: fatal: no SASL authentication mechanisms
Oct 30 19:12:46 keyhelp dovecot: pop3-login: Error: Timeout waiting for handshake from auth server. my pid=5051, input bytes=0
Oct 30 19:12:50 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 19:12:50 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 19:14:02 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 19:14:02 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 19:14:02 keyhelp postfix/smtpd[5411]: fatal: no SASL authentication mechanisms

[OlliTheDarkness]

Wahrscheinlich fehlt noch etwas, warum auch der FTP nicht laufen will (untergeordnetes Problem) und weshalb der Amavis nicht startet.

Ich weiß, dass ich dem mysql root ein PW gegeben habe (notiert).

Aktueller mail.err (Auszug):

Code: Select all

Oct 30 19:10:36 keyhelp postfix/smtpd[4854]: fatal: no SASL authentication mechanisms
Oct 30 19:10:36 keyhelp postfix/smtpd[4853]: fatal: no SASL authentication mechanisms
Oct 30 19:10:36 keyhelp postfix/smtpd[4852]: fatal: no SASL authentication mechanisms
Oct 30 19:10:50 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 19:10:50 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 19:11:48 keyhelp postfix/smtpd[4964]: fatal: no SASL authentication mechanisms
Oct 30 19:11:50 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 19:11:50 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 19:11:50 keyhelp postfix/smtpd[4962]: fatal: no SASL authentication mechanisms
Oct 30 19:12:46 keyhelp dovecot: pop3-login: Error: Timeout waiting for handshake from auth server. my pid=5051, input bytes=0
Oct 30 19:12:50 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 19:12:50 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 19:14:02 keyhelp dovecot: auth: Fatal: Unknown database driver 'mysql'
Oct 30 19:14:02 keyhelp dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 30 19:14:02 keyhelp postfix/smtpd[5411]: fatal: no SASL authentication mechanisms

Deine Probleme hängen ALLE mit dem MySQL zusammen, weil ALLE Anwendungen (Mail, FTP etc) ihre Daten (Adresse, Benutzer und und und) aus der DB erhalten.