Owncloud not working after installing Mycroft Topic is solved

[GreenGentleman]

I just installed Mycroft, but during the installation process, my Owncloud stopped working. It worked before just fine, and I'm not really sure where the error could come from.

Going to my ip, I'll get the expected 403, going to the Owncloud subdomain, I'll get an empty page. The owncloud client gets an empty response, too.

My htop:

Code: Select all

 5561 mycroft    164M   0 66.7  3:29.91 /mnt/dietpi_userdata/mycroft-data/.mycroft/precise/precise-engine/precise-engine /mnt/dietpi_userdata/mycroft-dat  763 mycroft    106M   0  0.0  5:00.70 python3 -m mycroft.skills
  769 mycroft   94956   0  0.0  4:48.18 python3 -m mycroft.client.speech
  766 mycroft   83180   0  0.0  0:14.56 python3 -m mycroft.audio
  760 mycroft   62360   0  0.0  1:53.97 python3 -m mycroft.messagebus.service
  772 mycroft   61860   0  0.0  1:35.62 python3 -m mycroft.client.enclosure
  692 root      29092   0  0.0  0:00.32 php-fpm: master process (/etc/php/7.3/fpm/php-fpm.conf)
 5713 www-data  20112   0  0.0  0:00.33 php-fpm: pool www
 5772 www-data  20108   0  0.0  0:00.29 php-fpm: pool www
 5652 www-data  20104   0  0.0  0:00.40 php-fpm: pool www
 5260 www-data  19940   0  0.0  0:00.68 php-fpm: pool www
  375 root      19092   0  0.0  0:05.23 /usr/bin/python3 /usr/bin/fail2ban-server -xf start
    1 root       9188   0  0.0  0:02.00 /sbin/init
  706 www-data   8640   0  0.0  0:21.67 /usr/sbin/lighttpd -D -f /etc/lighttpd/lighttpd.conf
  108 root       8156   0  0.0  0:00.34 /lib/systemd/systemd-journald
  413 pihole     6704 -10  0.0  0:05.80 /usr/bin/pihole-FTL
  724 root       5476   0  0.0  0:00.34 -bash
  348 root       5440   0  0.0  0:00.01 /sbin/dhclient -4 -v -i -pf /run/dhclient.eth0.pid -lf /var/lib/dhcp/dhclient.eth0.leases -I -df /var/lib/dhcp/dh  239 root       5112  19  0.0  0:00.06 /usr/sbin/alsactl -E HOME=/run/alsa -s -n 19 -c rdaemon
  141 root       4628   0  0.0  0:00.15 /lib/systemd/systemd-udevd
  616 redis      4412   0  0.0  0:06.94 /usr/bin/redis-server 127.0.0.1:6379
 6052 root       3516   0 66.7  0:00.05 htop
  596 root       2628   0  0.0  0:03.65 /usr/sbin/dropbear -p 22 -W 65536
  777 root       2536   0  0.0  0:00.01 /usr/sbin/cron -f
  233 root       2528   0  0.0  0:00.01 /usr/bin/vmtouch -l /boot/dietpi /boot/dietpi.txt
 5127 root       1856   0  0.0  0:00.00 /sbin/mount.ntfs /dev/sda1 /mnt/extern -o rw,noatime,lazytime,permissions,big_writes
  594 root       1544   0  0.0  0:00.00 /usr/sbin/dropbear -p 22 -W 65536
  588 root       1404   0  0.0  0:00.00 /sbin/agetty -o -p -- \u --noclear tty1 linux
 5559 mycroft     552   0  0.0  0:00.01 /mnt/dietpi_userdata/mycroft-data/.mycroft/precise/precise-engine/precise-engine /mnt/dietpi_userdata/mycroft-dat  245 root         96   0  0.0  0:00.99 /usr/sbin/rngd -r /dev/hwrng

[Joulinar]

Hi,

pls can you check status of all services. Somehow I'm missing the database service on your htop view

Code: Select all

dietpi-services status

[GreenGentleman]

Code: Select all

root@DietPi:/var/log/mycroft# dietpi-services status
[ SUB1 ] DietPi-Services > status
[  OK  ] DietPi-Services | redis-server         active (running) since Mon 2020-11-09 18:11:08 GMT; 1h 15min ago
[FAILED] DietPi-Services | ● mariadb.service - MariaDB 10.3.25 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; disabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Mon 2020-11-09 18:11:09 GMT; 1h 15min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 624 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
  Process: 625 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 627 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: 687 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
 Main PID: 687 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Nov 09 18:11:08 DietPi systemd[1]: Starting MariaDB 10.3.25 database server...
Nov 09 18:11:09 DietPi mysqld[687]: 2020-11-09 18:11:09 0 [Note] /usr/sbin/mysqld (mysqld 10.3.25-MariaDB-0+deb10u1) starting as process 687 ...
Nov 09 18:11:09 DietPi mysqld[687]: 2020-11-09 18:11:09 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32186)
Nov 09 18:11:09 DietPi mysqld[687]: 2020-11-09 18:11:09 0 [Warning] Can't create test file /var/lib/mysql/DietPi.lower-test
Nov 09 18:11:09 DietPi mysqld[687]: [97B blob data]
Nov 09 18:11:09 DietPi mysqld[687]: 2020-11-09 18:11:09 0 [ERROR] Aborting
Nov 09 18:11:09 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Nov 09 18:11:09 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Nov 09 18:11:09 DietPi systemd[1]: Failed to start MariaDB 10.3.25 database server.
[  OK  ] DietPi-Services | php7.3-fpm           active (running) since Mon 2020-11-09 18:11:10 GMT; 1h 15min ago
[  OK  ] DietPi-Services | lighttpd             active (running) since Mon 2020-11-09 18:11:10 GMT; 1h 15min ago
[  OK  ] DietPi-Services | mycroft              active (running) since Mon 2020-11-09 18:11:11 GMT; 1h 15min ago
[  OK  ] DietPi-Services | cron                 active (running) since Mon 2020-11-09 18:11:11 GMT; 1h 15min ago
[  OK  ] DietPi-Services | dropbear             active (running) since Mon 2020-11-09 18:11:08 GMT; 1h 15min ago
[  OK  ] DietPi-Services | fail2ban             active (running) since Mon 2020-11-09 18:10:15 GMT; 1h 16min ago
[  OK  ] DietPi-Services | pihole-FTL           active (running) since Mon 2020-11-09 18:10:16 GMT; 1h 16min ago
[  OK  ] DietPi-Services | dietpi-ramlog        active (exited) since Mon 2020-11-09 18:10:15 GMT; 1h 16min ago
[  OK  ] DietPi-Services | dietpi-preboot       active (exited) since Mon 2020-11-09 18:10:15 GMT; 1h 16min ago
[  OK  ] DietPi-Services | dietpi-boot          active (exited) since Mon 2020-11-09 18:11:08 GMT; 1h 15min ago
[  OK  ] DietPi-Services | dietpi-postboot      active (exited) since Mon 2020-11-09 18:11:08 GMT; 1h 15min ago
[ INFO ] DietPi-Services | dietpi-wifi-monitor  inactive (dead)

MariaDB said goodbye, it seems. A reboot didn't help, the problem persists.

[Joulinar]

pls provide following

Code: Select all

systemctl restart mariadb.service
journalctl -u mariadb
cat /var/log/mysql/error.log
readlink /var/lib/mysql
readlink -f /var/lib/mysql

[GreenGentleman]

Code: Select all

root@DietPi:~# systemctl restart mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
root@DietPi:~# journalctl -u mariadb
-- Logs begin at Thu 2019-02-14 10:11:58 GMT, end at Mon 2020-11-09 21:17:02 GMT. --
Nov 09 18:11:08 DietPi systemd[1]: Starting MariaDB 10.3.25 database server...
Nov 09 18:11:09 DietPi mysqld[687]: 2020-11-09 18:11:09 0 [Note] /usr/sbin/mysqld (mysqld 10.3.25-MariaDB-0+deb10u1) sta
rting as process 687 ...
Nov 09 18:11:09 DietPi mysqld[687]: 2020-11-09 18:11:09 0 [Warning] Could not increase number of max_open_files to more
than 16384 (request: 32186)
Nov 09 18:11:09 DietPi mysqld[687]: 2020-11-09 18:11:09 0 [Warning] Can't create test file /var/lib/mysql/DietPi.lower-t
est
Nov 09 18:11:09 DietPi mysqld[687]: [97B blob data]
Nov 09 18:11:09 DietPi mysqld[687]: 2020-11-09 18:11:09 0 [ERROR] Aborting
Nov 09 18:11:09 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/F
AILURE
Nov 09 18:11:09 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Nov 09 18:11:09 DietPi systemd[1]: Failed to start MariaDB 10.3.25 database server.
Nov 09 21:16:47 DietPi systemd[1]: Starting MariaDB 10.3.25 database server...
Nov 09 21:16:47 DietPi mysqld[12153]: 2020-11-09 21:16:47 0 [Note] /usr/sbin/mysqld (mysqld 10.3.25-MariaDB-0+deb10u1) s
tarting as process 12153 ...
Nov 09 21:16:47 DietPi mysqld[12153]: 2020-11-09 21:16:47 0 [Warning] Could not increase number of max_open_files to mor
e than 16384 (request: 32186)
Nov 09 21:16:47 DietPi mysqld[12153]: 2020-11-09 21:16:47 0 [Warning] Can't create test file /var/lib/mysql/DietPi.lower
-test
Nov 09 21:16:47 DietPi mysqld[12153]: [97B blob data]
Nov 09 21:16:47 DietPi mysqld[12153]: 2020-11-09 21:16:47 0 [ERROR] Aborting
Nov 09 21:16:47 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/F
AILURE
Nov 09 21:16:47 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Nov 09 21:16:47 DietPi systemd[1]: Failed to start MariaDB 10.3.25 database server.
root@DietPi:~# cat /var/log/mysql/error.log
root@DietPi:~# readlink /var/lib/mysql
/mnt/dietpi_userdata/mysql
root@DietPi:~# readlink -f /var/lib/mysql
/mnt/dietpi_userdata/mysql

[Joulinar]

there is no error.log?

can you check

Code: Select all

ls -la /var/log/mysql/

as well pls post

Code: Select all

ls -la /var/lib/mysql/

and pls try to create the test file, this seems to be failing on your log

Code: Select all

sudo -u mysql -g mysql touch /var/lib/mysql/DietPi.lower-test

[GreenGentleman]

Code: Select all

root@DietPi:/# ls -la /var/log/mysql/
total 0
drwxr-s---  2 mysql adm   60 Oct 29 16:07 .
drwxr-xr-t 10 root  root 500 Nov  9 15:14 ..
-rw-rw----  1 mysql adm    0 Nov  9 16:17 error.log
root@DietPi:/# ls -la /var/lib/mysql/
ls: cannot access '/var/lib/mysql/': No such file or directory
root@DietPi:/# sudo -u mysql -g mysql touch /var/lib/mysql/DietPi.lower-test
touch: cannot touch '/var/lib/mysql/DietPi.lower-test': No such file or directory

edit:

Code: Select all

root@DietPi:/var/lib# ls -la
total 96
drwxr-xr-x 24 root   root   4096 Nov  9 10:50 .
drwxr-xr-x 12 root   root   4096 Oct 29 16:04 ..
drwxr-xr-x  2 root   root   4096 Nov  9 21:44 alsa
drwxr-xr-x  3 root   root   4096 Nov  9 10:53 apt
drwxr-xr-x  2 root   root   4096 Aug 24 21:19 dhcp
drwxr-xr-x  2 root   root   4096 Nov 13  2019 dhcpcd5
drwxrwxr-x  5 dietpi dietpi 4096 Oct 29 15:56 dietpi
drwxr-xr-x  7 root   root   4096 Nov  9 10:54 dpkg
drwxr-xr-x  2 root   root   4096 Oct 29 17:12 fail2ban
drwxr-xr-x  2 root   root   4096 Apr 20  2020 git
drwxr-xr-x  2 root   root   4096 Nov  9 12:18 letsencrypt
drwxr-xr-x  2 root   root   4096 Aug 24 21:25 misc
lrwxrwxrwx  1 root   root     26 Oct 29 16:06 mysql -> /mnt/dietpi_userdata/mysql
drwxr-xr-x  2 root   root   4096 Aug 24 21:25 pam
drwxr-xr-x  4 root   root   4096 Oct 29 16:08 php
drwx------  3 root   root   4096 Aug 24 21:25 polkit-1
drwx------  2 root   root   4096 Aug 24 19:39 private
drwxr-xr-x  2 root   root   4096 Oct 29 16:17 python
drwxr-xr-x  3 root   root   4096 Oct 29 16:17 raspberrypi
drwxr-x---  2 redis  redis  4096 Nov  9 18:10 redis
drwxr-xr-x  3 root   root   4096 Aug 24 21:25 sudo
drwxr-xr-x  8 root   root   4096 Aug 24 21:18 systemd
drwxr-xr-x  3 root   root   4096 Oct 29 16:10 ucf
drwx------  2 root   root   4096 Aug 24 19:39 udisks2
drwxr-xr-x  2 root   root   4096 Aug 24 21:25 usbutils

[Joulinar]

can you have a look to

Code: Select all

ls -la /mnt/dietpi_userdata/
ls -la /mnt/dietpi_userdata/mysql

[GreenGentleman]

root@DietPi:/# ls -la /mnt/dietpi_userdata/
total 32
drwxr-xr-x 8 root root 4096 Nov 9 15:19 .
drwxr-xr-x 8 root root 4096 Nov 9 15:14 ..
drwxrwxr-x 2 dietpi dietpi 4096 Nov 9 15:18 Music
drwxrwxr-x 2 dietpi dietpi 4096 Nov 9 15:18 Pictures
drwxrwxr-x 2 dietpi dietpi 4096 Nov 9 15:18 Video
drwxrwxr-x 2 dietpi dietpi 4096 Nov 9 15:18 downloads
drwxr-xr-x 11 mycroft mycroft 4096 Nov 9 15:26 mycroft-core
drwxr-xr-x 9 mycroft mycroft 4096 Nov 9 17:40 mycroft-data
root@DietPi:/# ls -la /mnt/dietpi_userdata/mysql
ls: cannot access '/mnt/dietpi_userdata/mysql': No such file or directory
root@DietPi:/#

[Joulinar]

this is really bad new. You are missing the entire database folder, including everything that is needed to start MariaDB. no chance to get this up without this folder.