Please error update ISPConfig 3.1.14p2 mariadb not run

Discussion in 'Installation/Configuration' started by ElectroSoft, Aug 2, 2019.

  1. ElectroSoft

    ElectroSoft New Member

    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'.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Please post the output of:

    php --version

    and

    df -h
     
    ElectroSoft likes this.
  3. ElectroSoft

    ElectroSoft New Member

    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
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Check that the mysql root password is correct in /usr/local/ispconfig/server/lib/mysql_clientdb.conf
     
    ElectroSoft likes this.
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
    ElectroSoft likes this.
  6. ElectroSoft

    ElectroSoft New Member

    yes work, thanks.
     

Share This Page