Mariadb installation failed

Troubleshooting
21

result:

root@DietPi:~# lsattr /mnt/dietpi_userdata/mysql
--------------e------- /mnt/dietpi_userdata/mysql/debian-10.5.flag
--------------e------- /mnt/dietpi_userdata/mysql/ib_logfile0
--------------e------- /mnt/dietpi_userdata/mysql/demo.file
--------------e------- /mnt/dietpi_userdata/mysql/ibdata1
root@DietPi:~#
22

Ah let’s see the directory itself:

lsattr -d /mnt/dietpi_userdata/mysql
23 
root@DietPi:~# lsattr -d /mnt/dietpi_userdata/mysql
--------------e------- /mnt/dietpi_userdata/mysql
root@DietPi:~#
24

That all looks fine. Let’s try something new and create an additional directory for testing.

mkdir /mnt/dietpi_userdata/mysql2
chmod 755 /mnt/dietpi_userdata/mysql2
chown mysql:mysql /mnt/dietpi_userdata/mysql2
sudo -u mysql -g mysql touch /mnt/dietpi_userdata/mysql2/demo.file
25

strange, becouse the result is the same…

root@DietPi:~# mkdir /mnt/dietpi_userdata/mysql2
chmod 755 /mnt/dietpi_userdata/mysql2
chown mysql:mysql /mnt/dietpi_userdata/mysql2
sudo -u mysql -g mysql touch /mnt/dietpi_userdata/mysql2/demo.file
touch: '/mnt/dietpi_userdata/mysql2/demo.file' elérése sikertelen: Engedély megtagadva
26

out of curiosity, let’s try with a different user.

rm -f /mnt/dietpi_userdata/mysql2/demo.file
chown www-data:www-data /mnt/dietpi_userdata/mysql2
sudo -u www-data -g www-data touch /mnt/dietpi_userdata/mysql2/demo.file
27

:pensive:

root@DietPi:~# rm -f /mnt/dietpi_userdata/mysql2/demo.file
chown www-data:www-data /mnt/dietpi_userdata/mysql2
sudo -u www-data -g www-data touch /mnt/dietpi_userdata/mysql2/demo.file
touch: '/mnt/dietpi_userdata/mysql2/demo.file' elérése sikertelen: Engedély megtagadva
28

quite strange, not sure how this is possible. Just out of interest, can you check for kernel error messages.

dmesg -l 0,1,2,3
29 
root@DietPi:~# dmesg -l 0,1,2,3
[    0.183416] DMAR: [Firmware Bug]: No firmware reserved region can cover this RMRR [0x0000000088800000-0x000000008cffffff], contact BIOS vendor for fixes                                  
[    0.840489] ACPI BIOS Error (bug): Could not resolve symbol [\_SB.PCI0.SAT1], AE_NOT_FOUND (20200925/dswload2-162)         
[    0.840518] ACPI Error: AE_NOT_FOUND, During name lookup/catalog (20200925/psobject-220)                                   
[    5.556894] sd 0:0:0:0: [sdb] No Caching mode page found
[    5.556897] sd 0:0:0:0: [sdb] Assuming drive cache: write through                                                          
[    6.189747] iwlwifi 0000:02:00.0: firmware: failed to load iwl-debug-yoyo.bin (-2)                                         
[    6.192586] firmware_class: See https://wiki.debian.org/Firmware for information about missing firmware                    
[    8.710687] Bluetooth: hci0: Reading supported features failed (-16)                                                       
root@DietPi:~#
30

at least no critical errors there.

@MichaIng other ideas on this strange behaviour

31

Let’s check the parent directories:

ls -dl /mnt/dietpi_userdata /mnt
lsattr -d /mnt/dietpi_userdata /mnt

What kind of hardware is it actually? And do you have SELinux or something similar enabled?

32

Result:

root@DietPi:~# ls -dl /mnt/dietpi_userdata /mnt

lsattr -d /mnt/dietpi_userdata /mnt
drwxrwxrw-  8 root   root   4096 márc  15 16.17 /mnt
drwxrwxrw- 12 dietpi dietpi 4096 ápr   13 20.12 /mnt/dietpi_userdata
--------------e------- /mnt/dietpi_userdata
--------------e------- /mnt
root@DietPi:~#

I dont think I eneblad SELinux or something else. More or less thi is a fresh install and basic sattings.
Hardware is a Intel compute stick stk2m364cc

33

Do you have any idea how I can install Nextcloud? without fresh install? I want to left the setup of the deluge, deluge autoremove plus app and jellyfin.

34

personally, I don’t have an idea how to overcome this strange situation. I never have seen similar before.

35

I tried couple of thing and now when I touch no errror :slight_smile: :

root@DietPi:~# cd /mnt/dietpi_userdata/
chmod 777 ./mysql/
ls -la
sudo -u mysql -g mysql touch ./mysql/demo.file
összesen 80
drwxrwxrwx 11 dietpi         dietpi    4096 ápr   28 07.19 .
drwxrwxrw-  8 root           root      4096 márc  15 16.17 ..
drwxrwxrwx  4 debian-deluged root      4096 márc  22 13.26 deluge
-rwxrwxrwx  1 root           root      2035 márc   1 05.11 docker-compose.yml-immich
-rwxrwxrwx  1 root           root     10475 márc  10 16.01 docker-compose.yml-original
-rwxrwxrwx  1 root           root      9066 márc  14 08.05 docker-compose.yml-photoprism
drwx--x--- 12 root           root      4096 ápr   28 07.26 docker-data
drwxrwxr-x  2 dietpi         dietpi    4096 márc   9 09.58 downloads
-rwxrwxrwx  1 root           root      3384 márc  14 20.24 .env-Immich
drwxrwxrwx  2 filebrowser    root      4096 márc   8 12.28 filebrowser
-rwxrwxrwx  1 root           root      3372 márc  20 17.21 immich.env
drwxrwxrwx  9 jellyfin       jellyfin  4096 márc   8 16.49 jellyfin
-rwxrwxrwx  1 root           root         0 ápr   28 07.17 mariadb-database-backup.sql
drwxrwxr-x  2 dietpi         dietpi    4096 márc   8 12.28 Music
drwxrwxrwx  2 mysql          mysql     4096 ápr   28 07.23 mysql
drwxrwxr-x  2 dietpi         dietpi    4096 márc   8 12.17 Pictures
drwxrwxr-x  2 dietpi         dietpi    4096 márc   8 12.17 Video
root@DietPi:/mnt/dietpi_userdata#

root@DietPi:/mnt/dietpi_userdata# systemctl status mariadb
● mariadb.service - MariaDB 10.5.18 database server
     Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset: enabled)
    Drop-In: /etc/systemd/system/mariadb.service.d
             └─dietpi.conf
     Active: failed (Result: exit-code) since Fri 2023-04-28 07:26:28 BST; 9min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 738 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 742 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 744 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
    Process: 794 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
   Main PID: 794 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"
        CPU: 99ms

ápr 28 07:26:27 DietPi systemd[1]: Starting MariaDB 10.5.18 database server...
ápr 28 07:26:28 DietPi mariadbd[794]: 2023-04-28  7:26:28 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.18-MariaDB-0+deb11u1) starting as process 794 ...
ápr 28 07:26:28 DietPi mariadbd[794]: 2023-04-28  7:26:28 0 [Warning] Can't create test file /var/lib/mysql/DietPi.lower-test
ápr 28 07:26:28 DietPi mariadbd[794]: [92B blob data]
ápr 28 07:26:28 DietPi mariadbd[794]: 2023-04-28  7:26:28 0 [ERROR] Aborting
ápr 28 07:26:28 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
ápr 28 07:26:28 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
ápr 28 07:26:28 DietPi systemd[1]: Failed to start MariaDB 10.5.18 database server.
root@DietPi:/mnt/dietpi_userdata#
36

hmm database server still seems to have issues. PLs reboot your system and check following again.

sudo -u mysql -g mysql touch /var/lib/mysql/demo.file
journalctl -u mariadb
readlink /var/lib/mysql
readlink -f /var/lib/mysql
37 
root@DietPi:~# sudo -u mysql -g mysql touch /var/lib/mysql/demo.file
journalctl -u mariadb
readlink /var/lib/mysql
readlink -f /var/lib/mysql
touch: '/var/lib/mysql/demo.file' elérése sikertelen: Engedély megtagadva
-- Journal begins at Fri 2023-04-28 08:08:37 BST, ends at Fri 2023-04-28 08:09:02 BST. --
ápr 28 08:08:43 DietPi systemd[1]: Starting MariaDB 10.5.18 database server...
ápr 28 08:08:44 DietPi mariadbd[832]: 2023-04-28  8:08:44 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.18-MariaDB-0+deb11u1) starting as process 832 ...
ápr 28 08:08:44 DietPi mariadbd[832]: 2023-04-28  8:08:44 0 [Warning] Can't create test file /var/lib/mysql/DietPi.lower-test
ápr 28 08:08:44 DietPi mariadbd[832]: [92B blob data]
ápr 28 08:08:44 DietPi mariadbd[832]: 2023-04-28  8:08:44 0 [ERROR] Aborting
ápr 28 08:08:44 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
ápr 28 08:08:44 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
ápr 28 08:08:44 DietPi systemd[1]: Failed to start MariaDB 10.5.18 database server.
/mnt/dietpi_userdata/mysql
/mnt/dietpi_userdata/mysql
root@DietPi:~#
38

can you check this again. Would be interesting to see where it breaks

39 
root@DietPi:~# cd /
sudo -u mysql -g mysql touch /mnt/dietpi_userdata/mysql/demo.file
cd /mnt/
sudo -u mysql -g mysql touch ./dietpi_userdata/mysql/demo.file
cd /mnt/dietpi_userdata/
sudo -u mysql -g mysql touch ./mysql/demo.file
cd /mnt/dietpi_userdata/mysql/
sudo -u mysql -g mysql touch ./demo.file
touch: '/mnt/dietpi_userdata/mysql/demo.file' elérése sikertelen: Engedély megtagadva
touch: './dietpi_userdata/mysql/demo.file' elérése sikertelen: Engedély megtagadva
root@DietPi:/mnt/dietpi_userdata/mysql#
40 
root@DietPi:/mnt/dietpi_userdata/mysql# cd /
root@DietPi:/# sudo -u mysql -g mysql touch /mnt/dietpi_userdata/mysql/demo.file
touch: '/mnt/dietpi_userdata/mysql/demo.file' elérése sikertelen: Engedély megtagadva
root@DietPi:/# cd /mnt/
root@DietPi:/mnt# sudo -u mysql -g mysql touch ./mysql/demo.file
touch: './mysql/demo.file' elérése sikertelen: Engedély megtagadva
root@DietPi:/mnt# cd /mnt/dietpi_userdata/
root@DietPi:/mnt/dietpi_userdata# sudo -u mysql -g mysql touch ./mysql/demo.file
root@DietPi:/mnt/dietpi_userdata# sudo -u mysql -g mysql touch ./mysql/demo.file
root@DietPi:/mnt/dietpi_userdata# cd /mnt/dietpi_userdata/mysql/
root@DietPi:/mnt/dietpi_userdata/mysql# sudo -u mysql -g mysql touch ./mysql/demo.file
touch: './mysql/demo.file' elérése sikertelen: Nincs ilyen fájl vagy könyvtár
root@DietPi:/mnt/dietpi_userdata/mysql#