�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fdebian%2F'>debian</a>/</p><hr><h3>✏️ Editing: mariadb-server.preinst</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>#!/bin/bash
#
# summary of how this script can be called:
#        * &lt;new-preinst&gt; install
#        * &lt;new-preinst&gt; install &lt;old-version&gt;
#        * &lt;new-preinst&gt; upgrade &lt;old-version&gt;
#        * &lt;old-preinst&gt; abort-upgrade &lt;new-version&gt;
#

set -e

# shellcheck source=/dev/null
. /usr/share/debconf/confmodule

# Just kill the invalid insserv.conf.d directory without fallback
if [ -d &quot;/etc/insserv.conf.d/mariadb/&quot; ]
then
  rm -rf &quot;/etc/insserv.conf.d/mariadb/&quot;
fi

if [ -n &quot;$DEBIAN_SCRIPT_DEBUG&quot; ]
then
  set -v -x
  DEBIAN_SCRIPT_TRACE=1
fi
${DEBIAN_SCRIPT_TRACE:+ echo &quot;#42#DEBUG# RUNNING $0 $*&quot; 1&gt;&amp;2 }

export PATH=$PATH:/sbin:/usr/sbin:/bin:/usr/bin
mariadb_datadir=/var/lib/mysql
mariadb_upgradedir=/var/lib/mysql-upgrade

MARIADBD_USERS=&quot;root&quot;

# Check if user &#039;mysql&#039; exists before referring to it in pgrep
# to avoid pgrep erroring on &#039;invalid user name&#039;
if id mysql &gt;/dev/null 2&gt;&amp;1
then
  MARIADBD_USERS=&quot;$MARIADBD_USERS,mysql&quot;
fi

# Try to stop the server in a sane way. If it does not success let the admin
# do it himself. No database directories should be removed while the server
# is running! Another mariadbd in e.g. a different chroot is fine for us.
stop_server() {
  # Return immediately if there are no mysqld processes running on a host
  # (leave containerized processes with the same name in other namespaces)
  # as there is no point in trying to shutdown in that case.
  if ! pgrep -x -u &quot;$MARIADBD_USERS&quot; --nslist pid --ns $$ &quot;mysqld|mariadbd&quot; &gt; /dev/null
  then
    return
  fi

  set +e
  invoke-rc.d mariadb stop
  invoke-rc.d mysql stop # Backwards compatibility
  errno=$?
  set -e

  # systemctl could emit exit code 100=no init script (fresh install)
  if [ &quot;$errno&quot; != 0 ] &amp;&amp; [ &quot;$errno&quot; != 100 ]
  then
    echo &quot;Attempt to stop MariaDB/MySQL server returned exitcode $errno&quot; 1&gt;&amp;2
    echo &quot;There is a MariaDB/MySQL server running, but we failed in our attempts to stop it.&quot; 1&gt;&amp;2
    echo &quot;Stop it yourself and try again!&quot; 1&gt;&amp;2
    db_stop
    exit 1
  fi
}

################################ main() ##########################

# @TODO: Rewrite this to use the new upstream /var/lib/mysql_upgrade_info file
# instead of the legacy /var/lib/debian-XX.X.flag file
this_version=__MARIADB_MAJOR_VER__
max_upgradeable_version=5.7

# Check if a flag file is found that indicates a previous MariaDB or MySQL
# version was installed. If multiple flags are found, check which one was
# the biggest version number.
for flag in &quot;$mariadb_datadir&quot;/debian-*.flag
do

  # The for loop leaves $flag as the query string if there are no results,
  # so the check below is needed to stop further processing when there are
  # no real results.
  if [ &quot;$flag&quot; = &quot;$mariadb_datadir/debian-*.flag&quot; ]
  then
    break
  fi

  # The whole flag_version thing should be rewritten, so ignore minor Shellcheck
  # nag for now
  # shellcheck disable=SC2001
  flag_version=$(echo &quot;$flag&quot; | sed &#039;s/.*debian-\([0-9\.]\+\).flag/\1/&#039;)

  # Initialize value if empty
  if [ -z &quot;$found_version&quot; ]
  then
    found_version=$flag_version
  fi

  # Update value if now bigger then before
  if dpkg --compare-versions &quot;$flag_version&quot; &#039;&gt;&gt;&#039; &quot;$found_version&quot;
  then
    found_version=$flag_version
  fi

done


# If an upgrade is detected, proceed with it automatically without
# requiring any user interaction.
#
# However, if the user attempts to downgrade, warn about the incompatibility.
# Downgrade is detected if the flag version is bigger than $this_version
# (e.g. 10.1 &gt; 10.0) or the flag version is smaller than 10.0 but bigger
# than $max_upgradeable_version.
if [ -n &quot;$found_version&quot; ]
then

  # MySQL 8.0 in Ubuntu has a bug in packaging and the file is name wrongly
  # &#039;debian-5.7.flag&#039;, so in case &#039;5.7&#039; was encountered an extra check needs to
  # be done to see is there is a file called undo_001, which is a sign of 8.0.
  if [ &quot;$found_version&quot; == &quot;5.7&quot; ] &amp;&amp; [ -f &quot;$mariadb_datadir/undo_001&quot; ]
  then
    # Seems to be a 8.0, flag has wrongly 5.7 (know bug)
    found_version=8.0
  fi

  echo &quot;$mariadb_datadir: found previous version $found_version&quot;

  if dpkg --compare-versions &quot;$found_version&quot; &#039;&gt;&gt;&#039; &quot;$this_version&quot;
  then
    downgrade_detected=true
  fi

  if dpkg --compare-versions &quot;$found_version&quot; &#039;&gt;&gt;&#039; &quot;$max_upgradeable_version&quot; \
    &amp;&amp; dpkg --compare-versions &quot;$found_version&quot; &#039;&lt;&lt;&#039; &quot;10.0&quot;
  then
    downgrade_detected=true
  fi

fi

# If there is no debian-*.flag, and no version was detected, but a file that
# indicated MySQL 8.0 is found (undo_001 is created by default in MySQL 8.0+
# installs), then that file is enough of additional indication to trigger the
# move of the data directory.
if [ -z &quot;$found_version&quot; ] &amp;&amp;
   [ -z &quot;$(find $mariadb_datadir/debian-*.flag 2&gt; /dev/null)&quot; ] &amp;&amp;
   [ -f &quot;$mariadb_datadir/undo_001&quot; ]
then
  echo &quot;$mariadb_datadir: no server version flag found, assuming MySQL 8.0 data encountered&quot;
  downgrade_detected=true
  found_version=&quot;previous&quot; # Just use dummy name as we don&#039;t know real version
fi

# Don&#039;t abort dpkg if downgrade is detected (as was done previously).
# Instead simply move the old datadir and create a new for this_version.
if [ -n &quot;$downgrade_detected&quot; ]
then
  db_input critical &quot;mariadb-server/old_data_directory_saved&quot; || true
  db_go
  echo &quot;The file $mariadb_datadir/debian-$found_version.flag indicates a&quot; 1&gt;&amp;2
  echo &quot;version that cannot automatically be upgraded. Therefore the&quot; 1&gt;&amp;2
  echo &quot;previous data directory will be renamed to $mariadb_datadir-$found_version and&quot; 1&gt;&amp;2
  echo &quot;a new data directory will be initialized at $mariadb_datadir.&quot; 1&gt;&amp;2
  echo &quot;Please manually export/import your data (e.g. with mysqldump) if needed.&quot; 1&gt;&amp;2
  mv -f &quot;$mariadb_datadir&quot; &quot;$mariadb_datadir-$found_version&quot;
  # Also move away the old debian.cnf file that included credentials that are
  # no longer valid. If none existed, ignore error and let dpkg continue.
  mv -f /etc/mysql/debian.cnf &quot;/etc/mysql/debian.cnf-$found_version&quot; || true
fi

# to be sure
stop_server

# If we use NIS then errors should be tolerated. It&#039;s up to the
# user to ensure that the mysql user is correctly setup.
# Beware that there are two ypwhich one of them needs the 2&gt;/dev/null!
if test -n &quot;$(command -v ypwhich 2&gt;/dev/null)&quot;  &amp;&amp;  ypwhich &gt; /dev/null 2&gt;&amp;1
then
  set +e
fi

#
# Now we have to ensure the following state:
# /etc/passwd: mysql:x:100:101:MariaDB Server:/nonexistent:/bin/false
# /etc/group:  mysql:x:101:
#
# Sadly there could any state be present on the system so we have to
# modify everything carefully i.e. not doing a chown before creating
# the user etc...
#

# creating mysql group if he isn&#039;t already there
if ! getent group mysql &gt;/dev/null
then
  # Adding system group: mysql.
  addgroup --system mysql &gt;/dev/null
fi

# creating mysql user if he isn&#039;t already there
if ! getent passwd mysql &gt;/dev/null
then
  # Adding system user: mysql.
  adduser \
    --system \
    --disabled-login \
    --ingroup mysql \
    --no-create-home \
    --home /nonexistent \
    --gecos &quot;MariaDB Server&quot; \
    --shell /bin/false \
    mysql &gt;/dev/null 2&gt;&amp;1
fi

# end of NIS tolerance zone
set -e

# if there&#039;s a symlink, let&#039;s store where it&#039;s pointing, because otherwise
# it&#039;s going to be lost in some situations
for dir in DATADIR LOGDIR
do
  checkdir=$(eval echo &quot;$&quot;$dir)
  if [ -L &quot;$checkdir&quot; ]
  then
    # Use mkdir option &#039;Z&#039; to create with correct SELinux context.
    mkdir -pZ &quot;$mariadb_upgradedir&quot;
    cp -dT &quot;$checkdir&quot; &quot;$mariadb_upgradedir/$dir.link&quot;
  fi
done

# creating mysql home directory
if [ ! -d $mariadb_datadir ] &amp;&amp; [ ! -L $mariadb_datadir ]
then
  # Use mkdir option &#039;Z&#039; to create with correct SELinux context.
  mkdir -Z $mariadb_datadir
fi

# As preset blocksize of GNU df is 1024 then available bytes is $df_available_blocks * 1024
# 4096 blocks is then lower than 4 MB
df_available_blocks=&quot;$(LC_ALL=C BLOCKSIZE=&#039;&#039; df --output=avail &quot;$mariadb_datadir&quot; | tail -n 1)&quot;
if [ &quot;$df_available_blocks&quot; -lt &quot;4096&quot; ]
then
  echo &quot;ERROR: There&#039;s not enough space in $mariadb_datadir/&quot; 1&gt;&amp;2
  db_stop
  exit 1
fi

# Since the home directory was created before putting the user into
# the mysql group and moreover we cannot guarantee that the
# permissions were correctly *before* calling this script, we fix them now.
# In case we use NIS and no mysql user is present then this script should
# better fail now than later..
# The &quot;set +e&quot; is necessary as e.g. a &quot;.journal&quot; of a ext3 partition is
# not chgrp&#039;able (#318435).
set +e
find $mariadb_datadir ! -uid &quot;$(id -u mysql)&quot; -print0 | xargs -0 -r chown mysql
find $mariadb_datadir -follow -not -group mysql -print0 2&gt;/dev/null \
  | xargs -0 --no-run-if-empty chgrp mysql
set -e

db_stop

#DEBHELPER#
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fdebian'>🔙 Back</a></p>