Mariadb Topic is solved

Having issues with your DietPi installation, or, found a bug? Post it here.
User avatar
DutchFlash
Posts: 22
Joined: Tue Jun 12, 2018 2:31 pm
Location: Netherlands(Rotterdam)

Re: Mariadb

Post by DutchFlash »

Code: Select all

ls -la /mnt/hd500/dietpi_userdata/mysql
total 122968
drwxr-xr-x 7 mysql   mysql     4096 Jun 22 21:09 .
drwxr-xr-x 9 root    root      4096 Jun 22 16:25 ..
-rw-rw---- 1 proftpd mysql    16384 Jun 22 16:35 aria_log.00000001
-rw-rw---- 1 proftpd mysql       52 Jun 22 16:35 aria_log_control
-rw-r--r-- 1 root    root         0 Jun 22 16:35 debian-10.3.flag
-rw-r--r-- 1 mysql   mysql        0 Jun 22 21:14 demo.file
-rw-rw---- 1 mysql   mysql      900 Jun 22 16:35 ib_buffer_pool
-rw-rw---- 1 proftpd mysql 50331648 Jun 22 18:54 ib_logfile0
-rw-rw---- 1 proftpd mysql 50331648 Jun 22 15:25 ib_logfile1
-rw-rw---- 1 proftpd mysql 12582912 Jun 22 16:35 ibdata1
-rw-rw---- 1 mysql   mysql 12582912 Jun 22 18:55 ibtmp1
-rw-rw---- 1 proftpd mysql        0 Jun 22 15:26 multi-master.info
drwx------ 2 proftpd mysql     4096 Jun 22 15:26 mysql
-rw-rw---- 1 root    mysql       16 Jun 22 15:26 mysql_upgrade_info
drwx------ 2     110 mysql    12288 Apr  2 17:11 nextcloud
drwx------ 2 proftpd mysql     4096 Jun 22 15:26 performance_schema
drwx------ 2     110 mysql     4096 Nov 28  2019 phpmyadmin
-rw-rw---- 1 mysql   mysql    24576 Jun 22 18:55 tc.log
drwx------ 2 proftpd mysql     4096 Jun 22 15:27 wordpress
root@DietPi:~#
User avatar
Joulinar
Posts: 2085
Joined: Sat Nov 16, 2019 12:49 am

Re: Mariadb

Post by Joulinar »

there you go. Files and folders are owned by user proftpd. There are as well folders with unknown user ID 110. Did you have done anything with FTP and/or copied data??

You can do following to change owner back to user mysql

Code: Select all

chown -R mysql:mysql /mnt/hd500/dietpi_userdata/mysql
systemctl restart mariadb.service
systemctl status mariadb.service
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
User avatar
DutchFlash
Posts: 22
Joined: Tue Jun 12, 2018 2:31 pm
Location: Netherlands(Rotterdam)

Re: Mariadb

Post by DutchFlash »

Did not move/copied anything with proftpd.

This solution works for me:

You can do following to change owner back to user mysql

Code: Select all

chown -R mysql:mysql /mnt/hd500/dietpi_userdata/mysql
systemctl restart mariadb.service
systemctl status mariadb.service
Mariadb start after a reboot

Many tnks, Your great. :D :D :D :D :D
User avatar
Joulinar
Posts: 2085
Joined: Sat Nov 16, 2019 12:49 am

Re: Mariadb

Post by Joulinar »

Graag gedaan
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
User avatar
DutchFlash
Posts: 22
Joined: Tue Jun 12, 2018 2:31 pm
Location: Netherlands(Rotterdam)

Re: Mariadb

Post by DutchFlash »

Your kidding with me ;) ;)

Je spreek schrijf nederlands. hahaha

Tnx.

Greetings. Nick
Post Reply