[Eisfair] [E1 5.10.70-eisfair-64-VIRT] MariaDB 10.3 startet nach Reboot nicht

[Martin Faderbauer]

ich habe jetzt zur probe den Log-Pfad auf /tmp umgelegt
dann kommt.

> fmsrv03 # /usr/lib/mysql/103/bin/mysqld_safe --defaults-file=/etc/mysql/my103.cnf --skip-grant-table --skip-networking
> 211106 15:20:43 mysqld_safe Logging to '/tmp/mysqld.log'.
> 211106 15:20:43 mysqld_safe Starting mysqld daemon with databases from /srv/mysql/103

im /tmp/mysql.log ist dann

> 211106 15:20:43 mysqld_safe Starting mysqld daemon with databases from /srv/mysql/103
> 2021-11-06 15:20:43 0 [Note] Using unique option prefix 'skip-grant-table' is error-prone and can break in the future. Please u
> 2021-11-06 15:20:43 0 [Note] /usr/lib/mysql/103/bin/mysqld (mysqld 10.3.29-MariaDB) starting as process 9134 ...
> 2021-11-06 15:20:43 0 [Note] InnoDB: Using Linux native AIO
> 2021-11-06 15:20:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 2021-11-06 15:20:43 0 [Note] InnoDB: Uses event mutexes
> 2021-11-06 15:20:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
> 2021-11-06 15:20:43 0 [Note] InnoDB: Number of pools: 1
> 2021-11-06 15:20:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
> 2021-11-06 15:20:43 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
> 2021-11-06 15:20:43 0 [Note] InnoDB: Completed initialization of buffer pool
> 2021-11-06 15:20:43 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. S
> 2021-11-06 15:20:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
> 2021-11-06 15:20:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
> 2021-11-06 15:20:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
> 2021-11-06 15:20:43 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
> 2021-11-06 15:20:43 0 [Note] InnoDB: Waiting for purge to start
> 2021-11-06 15:20:43 0 [Note] InnoDB: 10.3.29 started; log sequence number 1625461; transaction id 20
> 2021-11-06 15:20:43 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mysql/103/ib_buffer_pool
> 2021-11-06 15:20:43 0 [Note] Plugin 'FEEDBACK' is disabled.
> 2021-11-06 15:20:43 0 [Note] InnoDB: Buffer pool(s) load completed at 211106 15:20:43
> 2021-11-06 15:20:43 0 [Note] Reading of all Master_info entries succeeded
> 2021-11-06 15:20:43 0 [Note] Added new Master_info '' to hash table
> 2021-11-06 15:20:43 0 [Note] /usr/lib/mysql/103/bin/mysqld: bereit für Verbindungen.
> Version: '10.3.29-MariaDB'  Socket: '/run/mysql/103/mysql.sock'  Port: 0  eisfair-64 build


Jetzt ist die Frage wie müssen die rechte und User für
/var
und
/var/log
und /var/log/mysql Gesetz werden?

Am 06.11.2021 um 15:00 schrieb Martin Faderbauer:
>> fmsrv03 # /usr/lib/mysql/103/bin/mysqld_safe 
>> --defaults-file=/etc/mysql/my103.cnf --skip-grant-table --skip-networking
>> 211106 14:48:49 mysqld_safe Logging to '/var/log/mysqld/103/mysqld.log'.
>> 211106 14:48:49 mysqld_safe Starting mysqld daemon with databases from 
>> /srv/mysql/103
>> /usr/lib/mysql/103/bin/mysqld_safe_helper: Can't create/write to file 
>> '/var/log/mysqld/103/mysqld.log/mysqld.log' (Errcode: 13 "Permission 
>> denied")
>> fmsrv03 #
> 
> ich glaube wir haben eine Spur die rechte sollten aber Passen
>> fmsrv03 # ls -l /var/log/mysqld
>> total 8
>> drwxr-xr-x 2 mysql mysql 4096 Nov  5 11:36 103
>> fmsrv03 #
> 
> 
> Am 06.11.2021 um 14:25 schrieb Holger Bruenjes:
>> /usr/lib/mysql/103/bin/mysqld_safe 
>> --defaults-file=/etc/mysql/my103.cnf --skip-grant-table --skip-networking