dietpi 7.6 - mariaDB not installed in frist run Topic is solved

Having issues with your DietPi installation or found a bug? Post it here.
Post Reply
bigjr
Posts: 5
Joined: Thu Sep 30, 2021 6:39 pm

dietpi 7.6 - mariaDB not installed in frist run

Post by bigjr »

Hello,
Sy im new in the dietpi world... im install the dietip the first time, iwant install nextcloud and wordpress... but i have a issuse with mariaDB. So no software work with DB. there are no error.log under /var/log/mysql/ . Hope you can help me... ty bigjr

Code: Select all

journalctl -u mariadb
-- Journal begins at Tue 2021-07-13 19:29:24 CEST, ends at Thu 2021-09-30 18:37:45 CEST. --
Sep 30 11:55:52 datengrab systemd[1]: Starting MariaDB 10.5.11 database server...
Sep 30 11:55:53 datengrab mariadbd[748]: 2021-09-30 11:55:53 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.11-MariaDB-1) starting as process 748 ...
Sep 30 11:55:53 datengrab mariadbd[748]: 2021-09-30 11:55:53 0 [Warning] Can't create test file /var/lib/mysql/datengrab.lower-test
Sep 30 11:55:53 datengrab mariadbd[748]: [92B blob data]
Sep 30 11:55:53 datengrab mariadbd[748]: 2021-09-30 11:55:53 0 [ERROR] Aborting
Sep 30 11:55:53 datengrab systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 30 11:55:53 datengrab systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 30 11:55:53 datengrab systemd[1]: Failed to start MariaDB 10.5.11 database server.
Sep 30 13:55:39 datengrab systemd[1]: Starting MariaDB 10.5.11 database server...
Sep 30 13:55:39 datengrab mariadbd[7291]: 2021-09-30 13:55:39 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.11-MariaDB-1) starting as process 7291 ...
Sep 30 13:55:39 datengrab mariadbd[7291]: 2021-09-30 13:55:39 0 [Warning] Can't create test file /var/lib/mysql/datengrab.lower-test
Sep 30 13:55:39 datengrab mariadbd[7291]: [92B blob data]
Sep 30 13:55:39 datengrab mariadbd[7291]: 2021-09-30 13:55:39 0 [ERROR] Aborting
Sep 30 13:55:39 datengrab systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 30 13:55:39 datengrab systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 30 13:55:39 datengrab systemd[1]: Failed to start MariaDB 10.5.11 database server.
User avatar
Joulinar
Posts: 5998
Joined: Sat Nov 16, 2019 12:49 am

Re: dietpi 7.6 - mariaDB not installed in frist run

Post by Joulinar »

Pls can you share some more details on your system

Required Information
  • DietPi version | cat /boot/dietpi/.version
  • Distro version | echo $G_DISTRO_NAME $G_RASPBIAN
  • Kernel version | uname -a
  • SBC model | echo $G_HW_MODEL_NAME
Starting MariaDB version 10.5, error.log has been disabled by package maintainer in MariaDB server configuration.
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
bigjr
Posts: 5
Joined: Thu Sep 30, 2021 6:39 pm

Re: dietpi 7.6 - mariaDB not installed in frist run

Post by bigjr »

Here the answer of your request:

Code: Select all

 
cat /boot/dietpi/.version
G_DIETPI_VERSION_CORE=7
G_DIETPI_VERSION_SUB=6
G_DIETPI_VERSION_RC=2
G_GITBRANCH='master'
G_GITOWNER='MichaIng'
G_LIVE_PATCH_STATUS[0]='not applicable'
G_LIVE_PATCH_STATUS[1]='applied'
G_LIVE_PATCH_STATUS[2]='applied'
G_LIVE_PATCH_STATUS[3]='applied'
G_LIVE_PATCH_STATUS[4]='applied'

echo $G_DISTRO_NAME $G_RASPBIAN
bullseye 0 

uname -a
Linux datengrab 5.10.60-v8+ #1449 SMP PREEMPT Wed Aug 25 15:01:33 BST 2021 aarch64 GNU/Linux

echo $G_HW_MODEL_NAME
RPi 4 Model B (aarch64)

User avatar
Joulinar
Posts: 5998
Joined: Sat Nov 16, 2019 12:49 am

Re: dietpi 7.6 - mariaDB not installed in frist run

Post by Joulinar »

ok let's enable error.log first

Code: Select all

nano /etc/mysql/mariadb.conf.d/50-server.cnf
remove the hash # infront of the error.log configuration.

once done safe the file and do 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
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
bigjr
Posts: 5
Joined: Thu Sep 30, 2021 6:39 pm

Re: dietpi 7.6 - mariaDB not installed in frist run

Post by bigjr »

:-)

Code: Select all

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.

cat: /var/log/mysql/error.log: Datei oder Verzeichnis nicht gefunden (sy im german ) not found

readlink /var/lib/mysql
/mnt/dietpi_userdata/mysql

readlink -f /var/lib/mysql
/mnt/2321401e-42e8-4d2f-b3d6-2d86a8c96f32/dietpi_userdata/mysql
----

systemctl status mariadb.service
● mariadb.service - MariaDB 10.5.11 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; disabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Thu 2021-09-30 19:39:42 CEST; 6min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 1600 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 1601 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 
 ----
 Sep 30 19:39:30 datengrab systemd[1]: Starting MariaDB 10.5.11 database server...
░░ Subject: A start job for unit mariadb.service has begun execution
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░ 
░░ A start job for unit mariadb.service has begun execution.
░░ 
░░ The job identifier is 628.
Sep 30 19:39:30 datengrab mariadbd[1597]: 2021-09-30 19:39:30 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.11-MariaDB-1) starting as process 1597 ...
Sep 30 19:39:30 datengrab mariadbd[1597]: 2021-09-30 19:39:30 0 [Warning] Can't create test file /var/lib/mysql/datengrab.lower-test
Sep 30 19:39:30 datengrab mariadbd[1597]: [92B blob data]
Sep 30 19:39:30 datengrab mariadbd[1597]: 2021-09-30 19:39:30 0 [ERROR] Aborting
Sep 30 19:39:30 datengrab systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░ 
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░ 
░░ The process' exit code is 'exited' and its exit status is 1.
Sep 30 19:39:30 datengrab systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░ 
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Sep 30 19:39:30 datengrab systemd[1]: Failed to start MariaDB 10.5.11 database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░ 
░░ A start job for unit mariadb.service has finished with a failure.
░░ 
░░ The job identifier is 628 and the job result is failed.
Sep 30 19:39:42 datengrab systemd[1]: Starting MariaDB 10.5.11 database server...
░░ Subject: A start job for unit mariadb.service has begun execution
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░ 
░░ A start job for unit mariadb.service has begun execution.
░░ 
░░ The job identifier is 700.
Sep 30 19:39:42 datengrab mariadbd[1653]: 2021-09-30 19:39:42 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.11-MariaDB-1) starting as process 1653 ...
Sep 30 19:39:42 datengrab mariadbd[1653]: 2021-09-30 19:39:42 0 [Warning] Can't create test file /var/lib/mysql/datengrab.lower-test
Sep 30 19:39:42 datengrab mariadbd[1653]: [92B blob data]
Sep 30 19:39:42 datengrab mariadbd[1653]: 2021-09-30 19:39:42 0 [ERROR] Aborting
Sep 30 19:39:42 datengrab systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░ 
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░ 
░░ The process' exit code is 'exited' and its exit status is 1.
Sep 30 19:39:42 datengrab systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░ 
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Sep 30 19:39:42 datengrab systemd[1]: Failed to start MariaDB 10.5.11 database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://www.debian.org/support
░░ 
░░ A start job for unit mariadb.service has finished with a failure.
░░ 
░░ The job identifier is 700 and the job result is failed.
   
    
    
    Process: 1603 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: 1653 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
   Main PID: 1653 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"
        CPU: 192ms

Sep 30 19:39:42 datengrab systemd[1]: Starting MariaDB 10.5.11 database server...
Sep 30 19:39:42 datengrab mariadbd[1653]: 2021-09-30 19:39:42 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.11-MariaDB-1) starting as process 1653 ...
Sep 30 19:39:42 datengrab mariadbd[1653]: 2021-09-30 19:39:42 0 [Warning] Can't create test file /var/lib/mysql/datengrab.lower-test
Sep 30 19:39:42 datengrab mariadbd[1653]: [92B blob data]
Sep 30 19:39:42 datengrab mariadbd[1653]: 2021-09-30 19:39:42 0 [ERROR] Aborting
Sep 30 19:39:42 datengrab systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 30 19:39:42 datengrab systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 30 19:39:42 datengrab systemd[1]: Failed to start MariaDB 10.5.11 database server.
root@datengrab:~# 

User avatar
Joulinar
Posts: 5998
Joined: Sat Nov 16, 2019 12:49 am

Re: dietpi 7.6 - mariaDB not installed in frist run

Post by Joulinar »

no error.log still? did you activated it? Could you check pls

Code: Select all

cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep error.log
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
bigjr
Posts: 5
Joined: Thu Sep 30, 2021 6:39 pm

Re: dietpi 7.6 - mariaDB not installed in frist run

Post by bigjr »

Hy,
i have actived.. but still no error.log file

Code: Select all

cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep error.log
# When running under systemd, error logging goes via stdout/stderr to journald
# and when running legacy init error logging goes to syslog due to
# Enable this if you want to have error logging into a separate file
log_error = /var/log/mysql/error.log
 
but if im right understand from the code in first post.... the MariaDB is start.. but there is [92B blob data] to stop the .. ihave read for [92B blob data] ... but icant change the length..its looking for me i have no user to login MariaDB
Only the first max_sort_length bytes of the column are used when sorting. The default value of max_sort_length is 1024. You can make more bytes significant in sorting or grouping by increasing the value of max_sort_length at server startup or runtime. Any client can change the value of its session max_sort_length variable:

Code: Select all

mysql> SET max_sort_length = 2000;
mysql> SELECT id, comment FROM t
    -> ORDER BY comment;

Code: Select all

Sep 30 11:55:53 datengrab mariadbd[748]: 2021-09-30 11:55:53 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.11-MariaDB-1) starting as process 748 ...
Sep 30 11:55:53 datengrab mariadbd[748]: 2021-09-30 11:55:53 0 [Warning] Can't create test file /var/lib/mysql/datengrab.lower-test
Sep 30 11:55:53 datengrab mariadbd[748]: [92B blob data]
bigjr
Posts: 5
Joined: Thu Sep 30, 2021 6:39 pm

Re: dietpi 7.6 - mariaDB not installed in frist run

Post by bigjr »

Hello,
i have make a new setup... with the same image .... idk why but now is running :? :roll:
User avatar
Joulinar
Posts: 5998
Joined: Sat Nov 16, 2019 12:49 am

Re: dietpi 7.6 - mariaDB not installed in frist run

Post by Joulinar »

Maybe database installation got corrupted on your first try. I guess something we will not find out 8)
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
Post Reply