Mariadb startet nach Update nicht

[Krautmaster]

Servus zusammen.

Ich habe eine truenas VM mit iocage und darin eine quasi Standard mariadb / Nextcloud Instanz.

Lief bis heute morgen 1a. Dann ein pgk Upgrade und wie es scheint wurde mariadb von 10.4.17 auf 10.4.19 geupdatet.

Sobald ich das jail neu gestartet habe geht leider nix mehr. Ich kann den Service MySQL starten aber wenn ich den Status Abfrage kommt "Not running"

Es fehlen auch die Socks. Die sind eigentlich auf /tmp konfiguriert.

Kein offensichtliches Log sagt mir wieso der MySQL Server nicht startet.

Jemand ne Idee? Können auch gern gemeinsam kurz drauf schauen.

 

[madmax2010]

was steht denn in den entsprechenden logs?
hast du mal syslog nebenher scrollen lassen?

 

[Krautmaster]

Ich weiß nicht genau wie anstellen. Ich hab es nach dieser Anleitung vor etwa 2 Jahren Mal aufgesetzt: https://www.samueldowling.com/2020/...n-freenas-iocage-jail-with-hardened-security/
Ohne das härten.
Kann diesen iocage nicht ganz einordnen was logs angeht.

Unter var Logs MySQL ist nur alter Log Bestand, nichts was auf einen Versuch des Service Start hindeuten würde. Genauso in der .err Datei im MySQL root

Schon Mal vielen herzlichen Dank ich bin Grad am Phone ich kann Mal rudimentäre config und Start Daten nachher hier posten

 

[madmax2010]

schau doch mal in der Config wo die Log dateien landen sollen.

 

[Krautmaster]

Ja ich hab in der server.cnf und my.cnf geschaut. Alles Standard bis auf den Socks pfad auf /tmp

Das Error Log da schreib er erst gar nicht wenn ich es umbenenne und den Service starten will. Und ne Socks bekomme ich nie zu Gesicht.

Ich stell dir nachher Mal alles was ich bisher ausprobiert habe hier rein. Für jemand der damit mehr zu tun hat ist es vermutlich ne Sache von 2 min, vllt übersehe ich einfach etwas.

 

[bin/bash]

Vielleicht ist eine Funktion jetzt DEPRECATED, z.B. Sockets nicht mehr in /tmp erlaubt
Am besten du schaust in den Fehlerlog des Mysql Servers.

 

[Krautmaster]

ja das mit dem Fehlerlog versuche ich ja aber daran scheitert es leider schon. So jetzt bin ich am PC, jetzt dampf ich mal alles raus was helfen könnte:

FreeBSD nextcloud 12.2-RELEASE-p6 FreeBSD 12.2-RELEASE-p6 df578562304(HEAD) TRUENAS amd64

mariadb104-client-10.4.19 Multithreaded SQL database (client)
mariadb104-server-10.4.19 Multithreaded SQL database (server)

Server startet nicht

root@nextcloud:~ # cat /usr/local/etc/mysql/my.cnf
#
# This group is read both by the client and the server
# use it for options that affect everything, see
# https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#option-groups
#
[client-server]
port = 3306
socket = /tmp/mysql.sock
#socket = /var/run/mysql/mysql.sock
#
# include *.cnf from the config directory
#
!includedir /usr/local/etc/mysql/conf.d/

Server.cnf

root@nextcloud:/usr/local/etc/mysql/conf.d # cat server.cnf
# Options specific to server applications, see
# https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#server-option-groups

# Options specific to all server programs
[server]

# Options specific to MariaDB server programs
[server-mariadb]

#
# Options for specific server tools
#

[mysqld]
user = mysql
# port = 3306 # inherited from /usr/local/etc/mysql/my.cnf
# socket = /var/run/mysql/mysql.sock # inherited from /usr/local/etc/mysql/my.cnf
bind-address = 127.0.0.1
basedir = /usr/local
datadir = /var/db/mysql
net_retry_count = 16384
log_error = /var/log/mysql/mysqld.err
# [mysqld] configuration for ZFS
# From https://www.percona.com/resources/technical-presentations/zfs-mysql-percona-technical-webinar
# Create separate datasets for data and logs, eg
# zroot/mysql compression=on recordsize=128k atime=off
# zroot/mysql/data recordsize=16k
# zroot/mysql/logs
# datadir = /var/db/mysql/data
# innodb_log_group_home_dir = /var/db/mysql/log
# audit_log_file = /var/db/mysql/log/audit.log
# general_log_file = /var/db/mysql/log/general.log
# log_bin = /var/db/mysql/log/mysql-bin
# relay_log = /var/db/mysql/log/relay-log
# slow_query_log_file = /var/db/mysql/log/slow.log
# innodb_doublewrite = 0
# innodb_flush_method = O_DSYNC

# Options read by mysqld_safe
# Renamed from [mysqld_safe] starting with MariaDB 10.4.6.
[mariadb_safe]

# Options read my mariabackup
[mariabackup]

# Options read by mysql_upgrade
# Renamed from [mysql_upgrade] starting with MariaDB 10.4.6.
[mariadb-upgrade]

# Specific options read by the mariabackup SST method
[sst]

# Options read by mysqlbinlog
# Renamed from [mysqlbinlog] starting with MariaDB 10.4.6.
[mariadb-binlog]

# Options read by mysqladmin
# Renamed from [mysqladmin] starting with MariaDB 10.4.6.
[mariadb-admin]

root@nextcloud:/usr/local/etc/mysql/conf.d #

tail -100 mysqld.err

root@nextcloud:/var/log/mysql # tail -100 mysqld.err
2021-04-19 20:35:03 0 [Note] InnoDB: FTS optimize thread exiting.
2021-04-19 20:35:03 0 [Note] InnoDB: Starting shutdown...
2021-04-19 20:35:03 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool
2021-04-19 20:35:03 0 [Note] InnoDB: Instance 0, restricted to 2006 pages due to innodb_buf_pool_dump_pct=25
2021-04-19 20:35:03 0 [Note] InnoDB: Buffer pool(s) dump completed at 210419 20:35:03
2021-04-19 20:35:04 0 [Note] InnoDB: Shutdown completed; log sequence number 22042105715; transaction id 24867616
2021-04-19 20:35:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-04-19 20:35:04 0 [Note] /usr/local/libexec/mysqld: Shutdown complete

2021-04-19 20:35:14 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-04-19 20:35:14 0 [Note] InnoDB: Uses event mutexes
2021-04-19 20:35:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-04-19 20:35:14 0 [Note] InnoDB: Number of pools: 1
2021-04-19 20:35:14 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-04-19 20:35:14 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-04-19 20:35:14 0 [Note] InnoDB: Completed initialization of buffer pool
2021-04-19 20:35:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-04-19 20:35:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-04-19 20:35:14 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-04-19 20:35:14 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-04-19 20:35:14 0 [Note] InnoDB: 10.4.17 started; log sequence number 22042105715; transaction id 24867617
2021-04-19 20:35:14 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2021-04-19 20:35:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-04-19 20:35:14 0 [Note] Server socket created on IP: '127.0.0.1'.
2021-04-19 20:35:14 0 [Note] Reading of all Master_info entries succeeded
2021-04-19 20:35:14 0 [Note] Added new Master_info '' to hash table
2021-04-19 20:35:14 0 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '10.4.17-MariaDB' socket: '/tmp/mysql.sock' port: 3306 FreeBSD Ports
2021-04-19 20:35:18 0 [Note] InnoDB: Buffer pool(s) load completed at 210419 20:35:18
2021-05-13 0:32:37 0 [Note] /usr/local/libexec/mysqld (initiated by: unknown): Normal shutdown
2021-05-13 0:32:37 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-05-13 0:32:37 0 [Note] InnoDB: FTS optimize thread exiting.
2021-05-13 0:32:37 0 [Note] InnoDB: Starting shutdown...
2021-05-13 0:32:37 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool
2021-05-13 0:32:37 0 [Note] InnoDB: Instance 0, restricted to 2006 pages due to innodb_buf_pool_dump_pct=25
2021-05-13 0:32:37 0 [Note] InnoDB: Buffer pool(s) dump completed at 210513 0:32:37
2021-05-13 0:32:38 0 [Note] InnoDB: Shutdown completed; log sequence number 22894910641; transaction id 26415466
2021-05-13 0:32:38 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-05-13 0:32:38 0 [Note] /usr/local/libexec/mysqld: Shutdown complete

2021-05-13 1:46:57 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-05-13 1:46:57 0 [Note] InnoDB: Uses event mutexes
2021-05-13 1:46:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-13 1:46:57 0 [Note] InnoDB: Number of pools: 1
2021-05-13 1:46:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-13 1:46:57 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-05-13 1:46:57 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-13 1:46:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-13 1:46:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-13 1:46:57 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-13 1:46:57 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-05-13 1:46:57 0 [Note] InnoDB: Waiting for purge to start
2021-05-13 1:46:57 0 [Note] InnoDB: 10.4.17 started; log sequence number 22894910641; transaction id 26415467
2021-05-13 1:46:57 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2021-05-13 1:46:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-13 1:46:57 0 [Note] Server socket created on IP: '127.0.0.1'.
2021-05-13 1:46:57 0 [Note] Reading of all Master_info entries succeeded
2021-05-13 1:46:57 0 [Note] Added new Master_info '' to hash table
2021-05-13 1:46:57 0 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '10.4.17-MariaDB' socket: '/tmp/mysql.sock' port: 3306 FreeBSD Ports
2021-05-13 1:47:00 0 [Note] InnoDB: Buffer pool(s) load completed at 210513 1:47:00
2021-06-14 13:53:37 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-14 13:53:37 0 [Note] InnoDB: Uses event mutexes
2021-06-14 13:53:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-14 13:53:37 0 [Note] InnoDB: Number of pools: 1
2021-06-14 13:53:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-06-14 13:53:37 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-06-14 13:53:37 0 [Note] InnoDB: Completed initialization of buffer pool
2021-06-14 13:53:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=23815892675
2021-06-14 13:53:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-06-14 13:53:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-06-14 13:53:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-06-14 13:53:37 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-06-14 13:53:37 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-06-14 13:53:37 0 [Note] InnoDB: Waiting for purge to start
2021-06-14 13:53:37 0 [Note] InnoDB: 10.4.17 started; log sequence number 23815892684; transaction id 27919701
2021-06-14 13:53:37 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2021-06-14 13:53:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-06-14 13:53:37 0 [Note] Server socket created on IP: '127.0.0.1'.
2021-06-14 13:53:38 0 [Note] Reading of all Master_info entries succeeded
2021-06-14 13:53:38 0 [Note] Added new Master_info '' to hash table
2021-06-14 13:53:38 0 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '10.4.17-MariaDB' socket: '/tmp/mysql.sock' port: 3306 FreeBSD Ports
2021-06-14 13:53:40 0 [Note] InnoDB: Buffer pool(s) load completed at 210614 13:53:40
2021-07-03 12:04:21 170441 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2021-07-03 12:04:21 170442 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2021-07-03 12:09:41 170591 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2021-07-03 12:09:41 170592 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2021-07-03 12:14:10 170671 [Warning] Aborted connection 170671 to db: 'nextcloud' user: 'ncadmin' host: 'localhost' (Got an error reading communication packets)
2021-07-03 12:15:00 0 [Note] /usr/local/libexec/mysqld (initiated by: unknown): Normal shutdown
2021-07-03 12:15:00 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-07-03 12:15:00 0 [Note] InnoDB: FTS optimize thread exiting.
2021-07-03 12:15:00 0 [Note] InnoDB: Starting shutdown...
2021-07-03 12:15:00 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool
2021-07-03 12:15:00 0 [Note] InnoDB: Instance 0, restricted to 2006 pages due to innodb_buf_pool_dump_pct=25
2021-07-03 12:15:00 0 [Note] InnoDB: Buffer pool(s) dump completed at 210703 12:15:00
2021-07-03 12:15:01 0 [Note] InnoDB: Shutdown completed; log sequence number 24231631590; transaction id 28701817
2021-07-03 12:15:01 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-03 12:15:01 0 [Note] /usr/local/libexec/mysqld: Shutdown complete

root@nextcloud:/var/log/mysql #

passend zu diesen Uhrzeiten meine History Befehle. Erst das upgrade, die weiteren commands wie update haben nicht getan

306 21:02 su -m www -c 'php /usr/local/www/nextcloud/occ maintenance:mode --off'
307 12:02 pkg update
308 12:02 pkg upgrade
309 12:04 mariadb-upgrade --datadir=/tmp
310 12:04 mysql_upgrade -u root -p
311 12:05 su -m www -c 'php /usr/local/www/nextcloud/occ db:add-missing-indices'
312 12:07 su -m www -c 'php /usr/local/www/nextcloud/occ integrity:check-core'

root@nextcloud:/tmp # sh -x /usr/local/etc/rc.d/mysql-server start

• . /etc/rc.subr
• : 6824
• export RC_PID
• [ -n '' ]
• _rc_subr_loaded=YES
• SYSCTL=/sbin/sysctl
• SYSCTL_N='/sbin/sysctl -n'
• SYSCTL_W=/sbin/sysctl
• PROTECT=/usr/bin/protect
• ID=/usr/bin/id
• IDCMD='if [ -x /usr/bin/id ]; then /usr/bin/id -un; fi'
• PS='/bin/ps -ww'
• JID=0
• rc_service=/usr/local/etc/rc.d/mysql-server
• _rc_namevarlist='program chroot chdir env flags fib nice user group groups prepend'
• kenv -q rc.debug
• name=mysql
• rcvar=mysql_enable
• load_rc_config mysql
• local _name _rcvar_val _var _defval _v _msg _new _d
• _name=mysql
• false
• [ -r /etc/defaults/rc.conf ]
• debug 'Sourcing /etc/defaults/rc.conf'
• . /etc/defaults/rc.conf
• rc_info=NO
• rc_startmsgs=YES
• rcshutdown_timeout=90
• early_late_divider=FILESYSTEMS
• always_force_depends=NO
• apm_enable=NO
• apmd_enable=NO
• apmd_flags=''
• ddb_enable=NO
• ddb_config=/etc/ddb.conf
• devd_enable=YES
• devd_flags=''
• devmatch_enable=YES
• devmatch_blacklist=''
• kldxref_enable=YES
• kldxref_clobber=NO
• kldxref_module_path=''
• powerd_enable=NO
• powerd_flags=''
• tmpmfs=AUTO
• tmpsize=20m
• tmpmfs_flags=-S
• varmfs=AUTO
• varsize=32m
• varmfs_flags=-S
• mfs_type=auto
• populate_var=AUTO
• cleanvar_enable=YES
• local_startup=/usr/local/etc/rc.d
• script_name_sep=' '
• rc_conf_files='/etc/rc.conf /etc/rc.conf.local'
• zfs_enable=NO
• zfsd_enable=NO
• gptboot_enable=YES
• gbde_autoattach_all=NO
• gbde_devices=NO
• gbde_attach_attempts=3
• gbde_lockdir=/etc
• geli_devices=''
• geli_groups=''
• geli_tries=''
• geli_default_flags=''
• geli_autodetach=YES
• root_rw_mount=YES
• root_hold_delay=30
• fsck_y_enable=NO
• fsck_y_flags='-T ffs:-R -T ufs:-R'
• background_fsck=YES
• background_fsck_delay=60
• growfs_enable=NO
• netfs_types='nfs:NFS smbfs:SMB'
• extra_netfs_types=NO
• hostname=''
• hostid_enable=YES
• hostid_file=/etc/hostid
• nisdomainname=NO
• dhclient_program=/sbin/dhclient
• dhclient_flags=''
• background_dhclient=NO
• synchronous_dhclient=NO
• defaultroute_delay=30
• defaultroute_carrier_delay=5
• netif_enable=YES
• netif_ipexpand_max=2048
• wpa_supplicant_program=/usr/sbin/wpa_supplicant
• wpa_supplicant_flags=-s
• wpa_supplicant_conf_file=/etc/wpa_supplicant.conf
• firewall_enable=NO
• firewall_script=/etc/rc.firewall
• firewall_type=UNKNOWN
• firewall_quiet=NO
• firewall_logging=NO
• firewall_logif=NO
• firewall_flags=''
• firewall_coscripts=''
• firewall_client_net=192.0.2.0/24
• firewall_simple_iif=ed1
• firewall_simple_inet=192.0.2.16/28
• firewall_simple_oif=ed0
• firewall_simple_onet=192.0.2.0/28
• firewall_myservices=''
• firewall_allowservices=''
• firewall_trusted=''
• firewall_logdeny=NO
• firewall_nologports='135-139,445 1026,1027 1433,1434'
• firewall_nat_enable=NO
• firewall_nat_interface=''
• firewall_nat_flags=''
• firewall_nat64_enable=NO
• firewall_nptv6_enable=NO
• firewall_pmod_enable=NO
• dummynet_enable=NO
• ipfw_netflow_enable=NO
• ip_portrange_first=NO
• ip_portrange_last=NO
• ike_enable=NO
• ike_program=/usr/local/sbin/isakmpd
• ike_flags=''
• ipsec_enable=NO
• ipsec_file=/etc/ipsec.conf
• natd_program=/sbin/natd
• natd_enable=NO
• natd_interface=''
• natd_flags=''
• ipfilter_enable=NO
• ipfilter_program=/sbin/ipf
• ipfilter_rules=/etc/ipf.rules
• ipfilter_flags=''
• ippool_enable=NO
• ippool_program=/sbin/ippool
• ippool_rules=/etc/ippool.tables
• ippool_flags=''
• ipnat_enable=NO
• ipnat_program=/sbin/ipnat
• ipnat_rules=/etc/ipnat.rules
• ipnat_flags=''
• ipmon_enable=NO
• ipmon_program=/sbin/ipmon
• ipmon_flags=-Ds
• ipfs_enable=NO
• ipfs_program=/sbin/ipfs
• ipfs_flags=''
• pf_enable=NO
• pf_rules=/etc/pf.conf
• pf_program=/sbin/pfctl
• pf_flags=''
• pflog_enable=NO
• pflog_logfile=/var/log/pflog
• pflog_program=/sbin/pflogd
• pflog_flags=''
• ftpproxy_enable=NO
• ftpproxy_flags=''
• pfsync_enable=NO
• pfsync_syncdev=''
• pfsync_syncpeer=''
• pfsync_ifconfig=''
• tcp_extensions=YES
• log_in_vain=0
• tcp_keepalive=YES
• tcp_drop_synfin=NO
• icmp_drop_redirect=NO
• icmp_log_redirect=NO
• network_interfaces=auto
• cloned_interfaces=''
• sppp_interfaces=''
• ppp_enable=NO
• ppp_program=/usr/sbin/ppp
• ppp_mode=auto
• ppp_nat=YES
• ppp_profile=papchap
• ppp_user=root
• hostapd_program=/usr/sbin/hostapd
• hostapd_enable=NO
• syslogd_enable=YES
• syslogd_program=/usr/sbin/syslogd
• syslogd_flags=-s
• syslogd_oomprotect=YES
• altlog_proglist=''
• inetd_enable=NO
• inetd_program=/usr/sbin/inetd
• inetd_flags='-wW -C 60'
• iscsid_enable=NO
• iscsictl_enable=NO
• iscsictl_flags=-Aa
• hastd_enable=NO
• hastd_program=/sbin/hastd
• hastd_flags=''
• ctld_enable=NO
• local_unbound_enable=NO
• local_unbound_tls=NO
• blacklistd_enable=NO
• blacklistd_flags=''
• resolv_enable=YES
• kdc_enable=NO
• kdc_program=/usr/libexec/kdc
• kdc_flags=''
• kadmind_enable=NO
• kadmind_program=/usr/libexec/kadmind
• kpasswdd_enable=NO
• kpasswdd_program=/usr/libexec/kpasswdd
• kfd_enable=NO
• kfd_program=/usr/libexec/kfd
• kfd_flags=''
• ipropd_master_enable=NO
• ipropd_master_program=/usr/libexec/ipropd-master
• ipropd_master_flags=''
• ipropd_master_keytab=/etc/krb5.keytab
• ipropd_master_slaves=''
• ipropd_slave_enable=NO
• ipropd_slave_program=/usr/libexec/ipropd-slave
• ipropd_slave_flags=''
• ipropd_slave_keytab=/etc/krb5.keytab
• ipropd_slave_master=''
• gssd_enable=NO
• gssd_program=/usr/sbin/gssd
• gssd_flags=''
• rwhod_enable=NO
• rwhod_flags=''
• rarpd_enable=NO
• rarpd_flags=-a
• bootparamd_enable=NO
• bootparamd_flags=''
• pppoed_enable=NO
• pppoed_provider='*'
• pppoed_flags='-P /var/run/pppoed.pid'
• pppoed_interface=fxp0
• sshd_enable=NO
• sshd_program=/usr/sbin/sshd
• sshd_flags=''
• ftpd_enable=NO
• ftpd_program=/usr/libexec/ftpd
• ftpd_flags=''
• amd_enable=NO
• amd_program=/usr/sbin/amd
• amd_flags='-a /.amd_mnt -l syslog /host /etc/amd.map /net /etc/amd.map'
• amd_map_program=NO
• autofs_enable=NO
• automount_flags=''
• automountd_flags=''
• autounmountd_flags=''
• nfs_client_enable=NO
• nfs_access_cache=60
• nfs_server_enable=NO
• nfs_server_flags='-u -t'
• nfs_server_managegids=NO
• mountd_enable=NO
• mountd_flags='-r -S'
• weak_mountd_authentication=NO
• nfs_reserved_port_only=NO
• nfs_bufpackets=''
• rpc_lockd_enable=NO
• rpc_lockd_flags=''
• rpc_statd_enable=NO
• rpc_statd_flags=''
• rpcbind_enable=NO
• rpcbind_program=/usr/sbin/rpcbind
• rpcbind_flags=''
• rpc_ypupdated_enable=NO
• keyserv_enable=NO
• keyserv_flags=''
• nfsv4_server_enable=NO
• nfscbd_enable=NO
• nfscbd_flags=''
• nfsuserd_enable=NO
• nfsuserd_flags=''
• timed_enable=NO
• timed_flags=''
• ntpdate_enable=NO
• ntpdate_program=/usr/sbin/ntpdate
• ntpdate_flags=-b
• ntpdate_config=/etc/ntp.conf
• ntpdate_hosts=''
• ntpd_enable=NO
• ntpd_program=/usr/sbin/ntpd
• ntpd_config=/etc/ntp.conf
• ntpd_sync_on_start=NO
• ntpd_flags=''
• ntp_src_leapfile=/etc/ntp/leap-seconds
• ntp_db_leapfile=/var/db/ntpd.leap-seconds.list
• ntp_leapfile_sources=https://www.ietf.org/timezones/data/leap-seconds.list
• ntp_leapfile_fetch_opts=-mq
• ntp_leapfile_expiry_days=30
• ntp_leapfile_fetch_verbose=NO
• nis_client_enable=NO
• nis_client_flags=''
• nis_ypset_enable=NO
• nis_ypset_flags=''
• nis_server_enable=NO
• nis_server_flags=''
• nis_ypxfrd_enable=NO
• nis_ypxfrd_flags=''
• nis_yppasswdd_enable=NO
• nis_yppasswdd_flags=''
• nis_ypldap_enable=NO
• nis_ypldap_flags=''
• bsnmpd_enable=NO
• bsnmpd_flags=''
• defaultrouter=NO
• static_arp_pairs=''
• static_ndp_pairs=''
• static_routes=''
• gateway_enable=NO
• routed_enable=NO
• routed_program=/sbin/routed
• routed_flags=-q
• arpproxy_all=NO
• forward_sourceroute=NO
• accept_sourceroute=NO
• hcsecd_enable=NO
• hcsecd_config=/etc/bluetooth/hcsecd.conf
• sdpd_enable=NO
• sdpd_control=/var/run/sdp
• sdpd_groupname=nobody
• sdpd_username=nobody
• bthidd_enable=NO
• bthidd_config=/etc/bluetooth/bthidd.conf
• bthidd_hids=/var/db/bthidd.hids
• bthidd_evdev_support=AUTO
• rfcomm_pppd_server_enable=NO
• rfcomm_pppd_server_profile='one two'
• rfcomm_pppd_server_one_channel=1
• rfcomm_pppd_server_two_channel=3
• ubthidhci_enable=NO
• netwait_enable=NO
• netwait_timeout=60
• netwait_if_timeout=30
• icmp_bmcastecho=NO
• ipv6_network_interfaces=auto
• ipv6_activate_all_interfaces=NO
• ipv6_defaultrouter=NO
• ipv6_static_routes=''
• ipv6_gateway_enable=NO
• ipv6_cpe_wanif=NO
• ipv6_privacy=NO
• route6d_enable=NO
• route6d_program=/usr/sbin/route6d
• route6d_flags=''
• ipv6_default_interface=NO
• rtsol_flags=''
• rtsold_enable=NO
• rtsold_flags=-a
• rtadvd_enable=NO
• rtadvd_interfaces=''
• stf_interface_ipv4addr=''
• stf_interface_ipv4plen=0
• stf_interface_ipv6_ifid=0:0:0:1
• stf_interface_ipv6_slaid=0000
• ipv6_ipv4mapping=NO
• ipv6_ipfilter_rules=/etc/ipf6.rules
• ip6addrctl_enable=YES
• ip6addrctl_verbose=NO
• ip6addrctl_policy=AUTO
• keyboard=''
• keymap=NO
• keyrate=NO
• keybell=NO
• keychange=NO
• cursor=NO
• scrnmap=NO
• font8x16=NO
• font8x14=NO
• font8x8=NO
• blanktime=300
• saver=NO
• moused_nondefault_enable=YES
• moused_enable=NO
• moused_type=auto
• moused_port=/dev/psm0
• moused_flags=''
• mousechar_start=NO
• allscreens_flags=''
• allscreens_kbdflags=''
• mta_start_script=/etc/rc.sendmail
• sendmail_enable=NO
• sendmail_pidfile=/var/run/sendmail.pid
• sendmail_procname=/usr/sbin/sendmail
• sendmail_flags='-L sm-mta -bd -q30m'
• sendmail_cert_create=YES
• sendmail_submit_enable=YES
• sendmail_submit_flags='-L sm-mta -bd -q30m -ODaemonPortOptions=Addr=localhost'
• sendmail_outbound_enable=YES
• sendmail_outbound_flags='-L sm-queue -q30m'
• sendmail_msp_queue_enable=YES
• sendmail_msp_queue_flags='-L sm-msp-queue -Ac -q30m'
• sendmail_rebuild_aliases=NO
• auditd_enable=NO
• auditd_program=/usr/sbin/auditd
• auditd_flags=''
• auditdistd_enable=NO
• auditdistd_program=/usr/sbin/auditdistd
• auditdistd_flags=''
• cron_enable=YES
• cron_program=/usr/sbin/cron
• cron_dst=YES
• cron_flags=''
• cfumass_enable=NO
• cfumass_dir=/var/cfumass
• cfumass_image=/var/tmp/cfumass.img
• lpd_enable=NO
• lpd_program=/usr/sbin/lpd
• lpd_flags=''
• nscd_enable=NO
• chkprintcap_enable=NO
• chkprintcap_flags=-d
• dumpdev=NO
• dumpon_flags=''
• dumpdir=/var/crash
• savecore_enable=YES
• savecore_flags='-m 10'
• service_delete_empty=NO
• crashinfo_enable=YES
• crashinfo_program=/usr/sbin/crashinfo
• quota_enable=NO
• check_quotas=YES
• quotaon_flags=-a
• quotaoff_flags=-a
• quotacheck_flags=-a
• accounting_enable=NO
• ibcs2_enable=NO
• ibcs2_loaders=coff
• firstboot_sentinel=/firstboot
• sysvipc_enable=NO
• linux_enable=NO
• clear_tmp_enable=NO
• clear_tmp_X=YES
• ldconfig_insecure=NO
• ldconfig_paths='/usr/lib/compat /usr/local/lib /usr/local/lib/compat/pkg'
• ldconfig32_paths='/usr/lib32 /usr/lib32/compat'
• ldconfigsoft_paths='/usr/libsoft /usr/libsoft/compat /usr/local/libsoft'
• ldconfig_paths_aout='/usr/lib/compat/aout /usr/local/lib/aout'
• ldconfig_local_dirs=/usr/local/libdata/ldconfig
• ldconfig_local32_dirs=/usr/local/libdata/ldconfig32
• ldconfig_localsoft_dirs=/usr/local/libdata/ldconfigsoft
• kern_securelevel_enable=NO
• kern_securelevel=-1
• update_motd=YES
• entropy_boot_file=/boot/entropy
• entropy_file=/entropy
• entropy_dir=/var/db/entropy
• entropy_save_sz=4096
• entropy_save_num=8
• harvest_mask=511
• dmesg_enable=YES
• watchdogd_enable=NO
• watchdogd_flags=''
• devfs_rulesets='/etc/defaults/devfs.rules /etc/devfs.rules'
• devfs_system_ruleset=''
• devfs_set_rulesets=''
• devfs_load_rulesets=YES
• performance_cx_lowest=NONE
• performance_cpu_freq=NONE
• economy_cx_lowest=Cmax
• economy_cpu_freq=NONE
• virecover_enable=YES
• ugidfw_enable=NO
• bsdextended_script=/etc/rc.bsdextended
• newsyslog_enable=YES
• newsyslog_flags=-CN
• mixer_enable=YES
• opensm_enable=NO
• rctl_enable=YES
• rctl_rules=/etc/rctl.conf
• iovctl_files=''
• jail_enable=NO
• jail_conf=/etc/jail.conf
• jail_confwarn=YES
• jail_parallel_start=NO
• jail_list=''
• jail_reverse_stop=NO
• [ -z '' ]
• source_rc_confs_defined=yes
• [ -r /etc/defaults/vendor.conf ]
• source_rc_confs
• local i sourced_files
• sourced_files=:/etc/rc.conf:
• [ -r /etc/rc.conf ]
• . /etc/rc.conf
• cron_flags=' -J 15'
• sendmail_enable=NO
• sendmail_submit_enable=NO
• sendmail_outbound_enable=NO
• sendmail_msp_queue_enable=NO
• syslogd_flags='-c -ss'
• ipv6_activate_all_interfaces=YES
• apache24_enable=yes
• mysql_enable=yes
• redis_enable=yes
• php_fpm_enable=yes
• sourced_files=:/etc/rc.conf::/etc/rc.conf.local:
• [ -r /etc/rc.conf.local ]
• _rc_conf_loaded=true
• [ -n mysql ]
• _d=/etc
• [ -f /etc/rc.conf.d/mysql ]
• [ -d /etc/rc.conf.d/mysql ]
• _d=/usr/local/etc
• [ -f /usr/local/etc/rc.conf.d/mysql ]
• [ -d /usr/local/etc/rc.conf.d/mysql ]
• eval '_defval=$mysql_enable_defval'
• _defval=''
• [ -n '' ]
• : yes
• : mysql
• : /var/db/mysql
• : /var/db/mysql/my.cnf
• command=/usr/sbin/daemon
• procname=/usr/local/libexec/mysqld
• start_precmd=mysql_prestart
• start_postcmd=mysql_poststart
• [ -n '' ]
• [ -n '' -a -n start ]
• /bin/hostname
• mysql_pidfile=/var/db/mysql/nextcloud.pid
• pidfile=/var/db/mysql/nextcloud.pid
• mysql_install_db=/usr/local/bin/mysql_install_db
• mysql_install_db_args='--basedir=/usr/local --datadir=/var/db/mysql --force'
• command_args='-c -f /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/nextcloud.pid '
• run_rc_command start
• _return=0
• rc_arg=start
• [ -z mysql ]
• shift 1
• rc_extra_args=''
• _rc_prefix=''
• eval '_override_command=$mysql_program'
• _override_command=''
• command=/usr/sbin/daemon
• _keywords='start stop restart rcvar enable disable delete enabled describe extracommands '
• rc_pid=''
• _pidcmd=''
• _procname=/usr/local/libexec/mysqld
• [ -n /usr/local/libexec/mysqld ]
• [ -n /var/db/mysql/nextcloud.pid ]
• _pidcmd='rc_pid=$(check_pidfile /var/db/mysql/nextcloud.pid /usr/local/libexec/mysqld )'
• _keywords='start stop restart rcvar enable disable delete enabled describe extracommands status poll'
• [ -z start ]
• [ start '=' enabled ]
• [ -n '' ]
• eval 'rc_flags=$mysql_flags'
• rc_flags=''
• eval '_chdir=$mysql_chdir' '_chroot=$mysql_chroot' '_nice=$mysql_nice' '_user=$mysql_user' '_group=$mysql_group' '_groups=$mysql_groups' '_fib=$mysql_fib' '_env=$mysql_env' '_prepend=$mysql_prepend' '_login_class=${mysql_login_class:-daemon}' '_limits=$mysql_limits' '_oomprotect=$mysql_oomprotect' '_env_file=$mysql_env_file'
• _chdir='' _chroot='' _nice='' _user=mysql _group='' _groups='' _fib='' _env='' _prepend='' _login_class=daemon _limits='' _oomprotect='' _env_file=''
• [ -n '' ]
• [ -n mysql ]
• eval if [ -x /usr/bin/id '];' then /usr/bin/id '-un;' fi
• [ -x /usr/bin/id ]
• /usr/bin/id -un
• [ mysql '=' root ]
• [ -z '' ]
• eval 'rc_pid=$(check_pidfile' /var/db/mysql/nextcloud.pid /usr/local/libexec/mysqld ')'
• check_pidfile /var/db/mysql/nextcloud.pid /usr/local/libexec/mysqld
• _pidfile=/var/db/mysql/nextcloud.pid
• _procname=/usr/local/libexec/mysqld
• _interpreter=''
• [ -z /var/db/mysql/nextcloud.pid -o -z /usr/local/libexec/mysqld ]
• [ ! -f /var/db/mysql/nextcloud.pid ]
• debug 'pid file (/var/db/mysql/nextcloud.pid): not readable.'
• return
• rc_pid=''
• [ start '!=' start ]
• [ -n mysql_enable -a start '!=' rcvar -a start '!=' stop -a start '!=' delete -a start '!=' enable -a start '!=' describe ]
• checkyesno mysql_enable
• eval '_value=$mysql_enable'
• _value=yes
• debug 'checkyesno: mysql_enable is set to yes.'
• return 0
• [ start '=' start -a -z '' -a -n '' ]
• eval '_cmd=$start_cmd' '_precmd=$start_precmd' '_postcmd=$start_postcmd'
• _cmd='' _precmd=mysql_prestart _postcmd=mysql_poststart
• [ -n '' ]
• [ ! -x /usr/sbin/daemon ]
• _run_rc_precmd
• check_required_before start
• local _f
• return 0
• [ -n mysql_prestart ]
• debug 'run_rc_command: start_precmd: mysql_prestart '
• eval 'mysql_prestart '
• mysql_prestart
• local dir
• [ -f /etc/my.cnf ]
• [ -f /etc/mysql/my.cnf ]
• [ ! -d /var/db/mysql/mysql/. ]
• [ '' '=' '' ]
• mysql_rundir=/var/run/mysql
• [ ! -d /var/run/mysql ]
• return 0
• _return=0
• [ 0 -ne 0 ]
• check_required_after start
• local _f _args
• return 0
• return 0
• check_startmsgs
• [ -n '' ]
• return 0
• echo 'Starting mysql.'

Starting mysql.

• [ -n '' ]
• _cd=''
• _doit='/usr/sbin/daemon -c -f /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/nextcloud.pid '
• [ -n mysql ]
• _doit=$'su -m mysql -c \'sh -c "/usr/sbin/daemon -c -f /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/nextcloud.pid "\''
• [ -n '' ]
• [ -n '' ]
• _doit=$' limits -C daemon su -m mysql -c \'sh -c "/usr/sbin/daemon -c -f /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/nextcloud.pid "\''
• _run_rc_doit $' limits -C daemon su -m mysql -c \'sh -c "/usr/sbin/daemon -c -f /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/nextcloud.pid "\''
• debug $'run_rc_command: doit: limits -C daemon su -m mysql -c \'sh -c "/usr/sbin/daemon -c -f /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/nextcloud.pid "\''
• eval $' limits -C daemon su -m mysql -c \'sh -c "/usr/sbin/daemon -c -f /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/nextcloud.pid "\''
• limits -C daemon su -m mysql -c 'sh -c "/usr/sbin/daemon -c -f /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/nextcloud.pid "'
• _return=0
• [ 0 -ne 0 ]
• return 0
• _run_rc_postcmd
• [ -n mysql_poststart ]
• debug 'run_rc_command: start_postcmd: mysql_poststart '
• eval 'mysql_poststart '
• mysql_poststart
• local 'timeout=15'
• [ ! -f /var/db/mysql/nextcloud.pid -a 15 -gt 0 ]
• timeout=14
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 14 -gt 0 ]
• timeout=13
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 13 -gt 0 ]
• timeout=12
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 12 -gt 0 ]
• timeout=11
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 11 -gt 0 ]
• timeout=10
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 10 -gt 0 ]
• timeout=9
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 9 -gt 0 ]
• timeout=8
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 8 -gt 0 ]
• timeout=7
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 7 -gt 0 ]
• timeout=6
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 6 -gt 0 ]
• timeout=5
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 5 -gt 0 ]
• timeout=4
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 4 -gt 0 ]
• timeout=3
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 3 -gt 0 ]
• timeout=2
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 2 -gt 0 ]
• timeout=1
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 1 -gt 0 ]
• timeout=0
• sleep 1
• [ ! -f /var/db/mysql/nextcloud.pid -a 0 -gt 0 ]
• return 0
• _return=0
• return 0
• [ -n '' ]
• return 0

letzten Einträge der err da

2020-09-26 12:03:47 34429034496 [Note] Reading of all Master_info entries succeeded
2020-09-26 12:03:47 34429034496 [Note] Added new Master_info '' to hash table
2020-09-26 12:03:47 34429034496 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '10.2.32-MariaDB' socket: '/tmp/mysql.sock' port: 3306 FreeBSD Ports
2020-09-26 12:03:50 34728667904 [Note] InnoDB: Buffer pool(s) load completed at 200926 12:03:50
2020-10-21 8:45:17 34429034496 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-21 8:45:17 34429034496 [Note] InnoDB: Uses event mutexes
2020-10-21 8:45:17 34429034496 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-21 8:45:17 34429034496 [Note] InnoDB: Number of pools: 1
2020-10-21 8:45:17 34429034496 [Note] InnoDB: Using SSE2 crc32 instructions
2020-10-21 8:45:17 34429034496 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-21 8:45:17 34429034496 [Note] InnoDB: Completed initialization of buffer pool
2020-10-21 8:45:17 34429034496 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-21 8:45:17 34429034496 [Note] InnoDB: Starting crash recovery from checkpoint LSN=15834734311
2020-10-21 8:45:18 34429034496 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-10-21 8:45:18 34429034496 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-21 8:45:18 34429034496 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-21 8:45:18 34429034496 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-21 8:45:18 34429034496 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-21 8:45:18 34429034496 [Note] InnoDB: 5.7.30 started; log sequence number 15834734320
2020-10-21 8:45:18 34728667904 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2020-10-21 8:45:18 34429034496 [Note] Plugin 'FEEDBACK' is disabled.
2020-10-21 8:45:18 34429034496 [Note] Recovering after a crash using tc.log
2020-10-21 8:45:18 34429034496 [Note] Starting crash recovery...
2020-10-21 8:45:18 34429034496 [Note] Crash recovery finished.
2020-10-21 8:45:18 34429034496 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-21 8:45:18 34429034496 [Note] Reading of all Master_info entries succeeded
2020-10-21 8:45:18 34429034496 [Note] Added new Master_info '' to hash table
2020-10-21 8:45:18 34429034496 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '10.2.32-MariaDB' socket: '/tmp/mysql.sock' port: 3306 FreeBSD Ports
2020-10-21 8:45:20 34728667904 [Note] InnoDB: Buffer pool(s) load completed at 201021 8:45:20
2020-10-22 14:53:02 34728652544 [Note] /usr/local/libexec/mysqld (initiated by: unknown): Normal shutdown
2020-10-22 14:53:02 34728652544 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-22 14:53:02 34728661504 [Note] InnoDB: FTS optimize thread exiting.
2020-10-22 14:53:02 34728652544 [Note] InnoDB: Starting shutdown...
2020-10-22 14:53:02 34728667904 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool
2020-10-22 14:53:02 34728667904 [Note] InnoDB: Instance 0, restricted to 2048 pages due to innodb_buf_pool_dump_pct=25
2020-10-22 14:53:02 34728667904 [Note] InnoDB: Buffer pool(s) dump completed at 201022 14:53:02
2020-10-22 14:53:03 34728652544 [Note] InnoDB: Shutdown completed; log sequence number 15877867710
2020-10-22 14:53:03 34728652544 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-22 14:53:03 34728652544 [Note] /usr/local/libexec/mysqld: Shutdown complete

Ich raffs nicht wieso die DB nicht hoch kommt. Ich finde auch keine socks.

Ergänzung (3. Juli 2021)

Vielleicht ist eine Funktion jetzt DEPRECATED, z.B. Sockets nicht mehr in /tmp erlaubt
Am besten du schaust in den Fehlerlog des Mysql Servers.

ich hab auch schon den Standard Pfad versucht, ich mein das einzige was ich da angepasst hab ist entsprechend der Anleitung das

socket = /tmp/mysql.sock
#socket = /var/run/mysql/mysql.sock

macht aber keinen Unterschied. Ich wüsste gern noch in welchem Log was zum Umstand stehen könnte dass der Server nicht läuft.

Ich hab rekursive Snapshots von 0 Uhr davon:

Theoretisch müsste ich damit zurückfallen können, allerdings ist rekursives ZFS snapshot restore ja auch schon wieder ne Sache für sich.

 

[Krautmaster]

mir gehts etwas wie diesem Knilch
https://forums.freebsd.org/threads/unable-to-start-mysql-server-service.76571/

root@nextcloud:/usr/local/etc/mysql #
root@nextcloud:/usr/local/etc/mysql # sysrc mysql_args="--initialize-insecure --user=mysql"
mysql_args: -> --initialize-insecure --user=mysql
root@nextcloud:/usr/local/etc/mysql # sysrc mysql_enable="YES"
mysql_enable: yes -> YES
root@nextcloud:/usr/local/etc/mysql # service mysql-server start
Starting mysql.
root@nextcloud:/usr/local/etc/mysql # service mysql-server status
mysql is not running.
root@nextcloud:/usr/local/etc/mysql # sysrc mysql_args="--skip-grant-tables"
mysql_args: --initialize-insecure --user=mysql -> --skip-grant-tables
root@nextcloud:/usr/local/etc/mysql # service mysql-server status
mysql is not running.
root@nextcloud:/usr/local/etc/mysql # service mysql-server start
Starting mysql.
root@nextcloud:/usr/local/etc/mysql # mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
root@nextcloud:/usr/local/etc/mysql # sysrc -x mysql_args
root@nextcloud:/usr/local/etc/mysql # service mysql-server start
Starting mysql.
root@nextcloud:/usr/local/etc/mysql # service mysql-server status
mysql is not running.
root@nextcloud:/usr/local/etc/mysql #

 

[Krautmaster]

Ich hab jetzt die Holzhammer Methode angewendet und mittels eines Script einen rekursiven Rollback gemacht auf gestern Nacht. Das ging soweit und danach läuft auch wieder die Cloud.

Ich gehe morgen nochmal explizit hin und mache erstmal das Update der Maria DB auf 10.5. , und immer snapshots dazwischen.

 

[RalphS]

Nächstes Mal einfach mariadbd - oder mysqld oder was die Service-Binary bei Dir ist -- auf der Konsole laufen lassen.

Praktisch alle daemons können von der Kommandozeile aus gestartet werden und haben einen foreground und/oder debugmodus eingebaut. Da landet dann stderr auf der Konsole.

 

[madmax2010]

Praktisch alle daemons können von der Kommandozeile aus gestartet werden und haben einen foreground und/oder debugmodus eingebaut.

dort findest du wie das geht: /usr/local/etc/rc.d/mysql-server - auch als welcher user der Prozess gern gestartet werden will.

Wenn ich auf die screenshots oben schaue, wuerde ich beinahe von einem Permission Problem ausgehen. Wenn alle stricke reissen: Dump die Datenbank, wirf mariadb mit alles Einstellungen runter und installier es frisch, leg die DB neu an und importier den Dump