Operating System: Debian 9.0 (Stretch) or compatible This application will update ISPConfig 3 on your server. Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: Creating backup of "/usr/local/ispconfig" directory... Creating backup of "/etc" directory... mysqldump: Error: 'Can't create/write to file '/tmp/#sql_779c_2.MAI' (Errcode: 13 "Permission denied")' when trying to dump tablespaces mysqldump: Couldn't execute 'show fields from `aps_instances`': Can't create/write to file '/tmp/#sql_779c_0.MAI' (Errcode: 13 "Permission denied") (1) Checking ISPConfig database .. OK Starting incremental database update. Loading SQL patch file: /tmp/update_stable.sh.TP5ADB51Nd/ispconfig3_install/install/sql/incremental/upd_dev_collection.sql Reconfigure Permissions in master database? (yes,no) [no]: Service 'firewall_server' has been detected (currently disabled) do you want to enable and configure it? (yes,no) [no]: Reconfigure Services? (yes,no,selected) [yes]: Configuring Postfix Configuring Dovecot Configuring Mailman Configuring Spamassassin Configuring Amavisd Configuring Getmail Configuring BIND Configuring Pureftpd Configuring Apache Configuring vlogger Skipping config of Apps vhost Configuring Jailkit Configuring Database Updating ISPConfig ISPConfig Port [10001]: Create new ISPConfig SSL certificate (yes,no) [no]: Reconfigure Crontab? (yes,no) [yes]: Updating Crontab Restarting services ... PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_stable.sh.TP5ADB51Nd/ispconfig3_install/install/lib/mysql.lib.php on line 207 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_stable.sh.TP5ADB51Nd/ispconfig3_install/install/lib/mysql.lib.php on line 207 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_stable.sh.TP5ADB51Nd/ispconfig3_install/install/lib/mysql.lib.php on line 207 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_stable.sh.TP5ADB51Nd/ispconfig3_install/install/lib/mysql.lib.php on line 207 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_stable.sh.TP5ADB51Nd/ispconfig3_install/install/lib/mysql.lib.php on line 207 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_stable.sh.TP5ADB51Nd/ispconfig3_install/install/lib/mysql.lib.php on line 207 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_stable.sh.TP5ADB51Nd/ispconfig3_install/install/lib/mysql.lib.php on line 207 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_stable.sh.TP5ADB51Nd/ispconfig3_install/install/lib/mysql.lib.php on line 207 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_stable.sh.TP5ADB51Nd/ispconfig3_install/install/lib/mysql.lib.php on line 207 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_stable.sh.TP5ADB51Nd/ispconfig3_install/install/lib/mysql.lib.php on line 207 Update finished. now mariadb not run root@server1:/etc/mysql# systemctl status mariadb.service ● mariadb.service - MariaDB 10.1.38 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mysql.service.d └─limits.conf Active: failed (Result: exit-code) since Fri 2019-08-02 09:49:40 EDT; 3min 48s ago Docs: man:mysqld(8) mariadb.com/kb/en/library/systemd/ Process: 7027 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Process: 6940 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: 6934 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 6933 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 7027 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" Aug 02 09:49:39 server1 systemd[1]: Starting MariaDB 10.1.38 database server... Aug 02 09:49:39 server1 mysqld[7027]: 2019-08-02 9:49:39 139961785515392 [Note] /usr/sbin/mysqld (mysqld 10.1.38-MariaDB-0+deb9u1) starting as process 7027 ... Aug 02 09:49:40 server1 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Aug 02 09:49:40 server1 systemd[1]: Failed to start MariaDB 10.1.38 database server. Aug 02 09:49:40 server1 systemd[1]: mariadb.service: Unit entered failed state. Aug 02 09:49:40 server1 systemd[1]: mariadb.service: Failed with result 'exit-code'.
hi. root@server1:/tmp# php --version PHP 7.0.33-9+0~20190712.17+debian9~1.gbp3af52c (cli) (built: Jul 12 2019 14:11:19) ( NTS ) Copyright (c) 1997-2017 The PHP Group Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies with Zend OPcache v7.0.33-9+0~20190712.17+debian9~1.gbp3af52c, Copyright (c) 1999-2017, by Zend Technologies root@server1:/tmp# root@server1:/tmp# df -h Filesystem Size Used Avail Use% Mounted on udev 967M 0 967M 0% /dev tmpfs 196M 21M 176M 11% /run /dev/sda1 20G 7.4G 12G 40% / tmpfs 979M 0 979M 0% /dev/shm tmpfs 5.0M 4.0K 5.0M 1% /run/lock tmpfs 979M 0 979M 0% /sys/fs/cgroup
It seems as if the /tmp directory of your server is not writable for MariaDB. Try to run: chmod 1777 /tmp and then start MariaDB again.