I'm trying to setup a local Nexcloud server with UBOS, but I get a problem with mysql server (or is it mariaDB?).
I followed all instructions in the UBOS webpage and got everything working. When I completer the ubos-admin createsite command I got the message "Cannot access MySQL database. File missing: /etc/mysql/root-defaults-ubos.cnf". In fact that file doesn't exist.
I tried the solution from the FAQ:
Code: Select all
sudo systemctl start mysqld.service
Code: Select all
Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xeu mysqld.service" for details.
Code: Select all
journalctl -xeu mysqld.service
-- Journal begins at Sat 2021-10-30 22:10:06 UTC, ends at Tue 2021-11-02 23:48:06 UTC. --
-- No entries --
Code: Select all
systemctl status mysqld.service
× mysqld.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Tue 2021-11-02 23:48:06 UTC; 2min 35s ago
Process: 6544 ExecStartPre=/usr/share/ubos-admin/bin/ubos-service-prestart mysqld (code=exited, status=0/SUCCESS)
Process: 6545 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 6547 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 6555 ExecStartPre=/usr/bin/mysql_install_db --user=mysql --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/ubos/lib/mysql (code=exited, status=1/FAILURE)
Process: 6618 ExecStopPost=/usr/share/ubos-admin/bin/ubos-service-poststop mysqld (code=exited, status=0/SUCCESS)
CPU: 1.119s
By the way, uname -a gives:
Code: Select all
Linux ubos-raspberry-pi2 5.10.42-1-ARCH #1 SMP Tue Jun 8 14:18:46 UTC 2021 armv7l GNU/Linux
- Raspberry Pi 3B+ inside a PiDesktop from Element14
UBOS running from a MicroSD card
Seagate 4TB HDD with external energy supply (plugged to the wall socket)
Ethernet cable