Drupal 維護

modi config_split

# 找出命令是什麼
drush | grep config-split
# config-split:
#  config-split:export (csex) Export only split configuration to a directory.
#  config-split:import (csim) Import only config from a split.

mkdir /var/www/files/config/split -p

# 匯出
drush csex csbak -y

# 匯入
drush csim csbak -y

clone-site [OPTION] [<remote>:]<source> [<destination>]

options:
  -y	Never prompt

clone-site drupal try1

clone-site 192.168.1.1:druapl

bind "set disable-completion on"
bash -c "cat > /var/www/bin/clone-site" << "EOF2"
#!/bin/bash

usage="Usage: ${0##*/} [OPTION] [<remote>:]<source> [<destination>]

Clone site

options:
  -y		Never prompt"

Prompt=1
POSITIONAL=()

while (( "$#" )); do
  case "$1" in
    -h|--h*) echo "$usage"; exit 1;;
    -y|--y) Prompt=0; shift;;
    *)
    POSITIONAL+=("$1") # save it in an array for later
    shift;;
  esac
done
set -- "${POSITIONAL[@]}" # restore positional parameters

if [[ $1 = *:* ]]; then
  remoteHost=${1%%:*}
  remoteHost=${remoteHost,,}
  sourceSite=${1##*:}

  if [[ -z $sourceSite ]]; then
    echo "$usage"
    exit 1
  fi

  if [[ -z $2 ]]; then
    localSite=$sourceSite
  else
    localSite=$2
  fi

  sourceLocation=$remoteHost:$sourceSite

  # Will continue when resolveip fails
  if [[ $remoteHost = ${HOSTNAME,,} ]] || [[ $HOSTNAME = $(resolveip -s $remoteHost) ]]; then
    echo "Error: The remote host is the current host!" >&2
    exit 1
  fi
else
  if [[ -z $1 ]] || [[ -z $2 ]]; then
    echo "$usage"
    exit 1
  fi

  if [[ $1 = $2 ]]; then
    echo "Error: The source destination is the same!" >&2
    exit 1
  fi

  sourceSite=$1
  localSite=$2
  sourceLocation=$sourceSite
fi

if [[ $Prompt -eq 1 ]]; then
  read -p "clone-site $sourceLocation to $localSite? [Y/n] " yn
  yn=${yn:-y}

  if [[ $yn != Y ]] && [[ $yn != y ]]; then
    exit 1
  fi
fi

if [[ -z $remoteHost ]]; then
  sudo sh -c "chown -R www-data:www-data /var/www/$localSite; chmod -Rf 774 /var/www/$localSite" 2> /dev/null
fi

# Exit immediately on error
set -e

echo rsync $sourceLocation to $localSite
if [[ -n $remoteHost ]]; then
  sudo rsync -az --info=progress2 root@$remoteHost:/var/www/$sourceSite/ \
  --delete --chmod=775 --chown=www-data:www-data /var/www/$localSite

  echo Export soruce database $sourceLocation
  ssh root@$remoteHost "mysqldump -uroot -p$mysqlpw --host=localhost --port=3306 $sourceSite" > /var/www/$localSite/_srcdb.sql
else
  sudo rsync -a --chown=www-data:www-data --chmod=775 --info=progress2 --delete /var/www/$sourceSite/ /var/www/$localSite
  echo Export soruce database $sourceLocation
  mysqldump -uroot -p$mysqlpw --host=localhost --port=3306 $sourceSite > /var/www/$localSite/_srcdb.sql
fi

NC='\033[0m' # No Color
YELLOW='\033[1;33m'

echo -e "${YELLOW}***Now you can maintain the original site.***${NC}"

echo Create database $localSite
mysql -uroot -p$mysqlpw --host=localhost --port=3306 --protocol=tcp -n<<EOF
drop database if exists $localSite;
create database $localSite;
grant all privileges on $localSite.* to '$localSite'@'localhost' identified by '$webdbpw';
use mysql;
update user set plugin='mysql_native_password' where user='$localSite';
flush privileges;
EOF

echo Import table $localSite
mysql -u$localSite -p$webdbpw --host=localhost --port=3306 $localSite < /var/www/$localSite/_srcdb.sql
echo rm /var/www/$localSite/_srcdb.sql

if [[ $sourceSite != $localSite ]]; then
  echo -e "${YELLOW}"
  if [ -f "/var/www/$localSite/sites/default/settings.php" ]; then
    echo change settings.php
    src="\n *\$databases *\[ *'default' *\] *\[ *'default' *\] *= *array *(\n *'database' *=> *'[0-9a-zA-Z]\+' *, *\n *'username' *=> *'[0-9a-zA-Z]\+' *, *"
    trs="\n\$databases\['default'\]\['default'\] = array (\n  'database' => '$localSite',\n  'username' => '$localSite',"
    sed -z -i "s/$src/$trs/" /var/www/$localSite/sites/default/settings.php
    sudo chown www-data:www-data /var/www/$localSite/sites/default/settings.php
    dbProfile=$(sed -n "/\$databases\['default'\]\['default'\] = array (/ {N;/'database' => '$localSite'/!q;N;/'username' => '$localSite'/!q;N;p}" /var/www/$localSite/sites/default/settings.php)
    if [[ -z $dbProfile ]]; then
      echo "*** Can not find database parameters! ***"
      echo $(grep "^ *\$databases\[ *'default' *\] *\[ *'default' *\] *= *array *(" -A3 /var/www/$localSite/sites/default/settings.php)
    else
      echo $dbProfile
      cd /var/www/$localSite
      drush cr
    fi
  else
    echo "*** Can not find /var/www/$localSite/sites/default/settings.php! ***"
  fi
fi
EOF2
bind "set disable-completion off"
sudo chmod +x /var/www/bin/clone-site

bind "set disable-completion on"
bash -c "cat > /var/www/bin/drop-site" << "EOF2"
#!/bin/bash

tab='	'
nl='
'
IFS=" $tab$nl"

usage="Usage: ${0##*/} [OPTION] site

Drop site

options:
  -y		Never prompt"

Prompt=1
POSITIONAL=()

while (( "$#" )); do
  case "$1" in
    -h|--h*) echo "$usage"; exit 1;;
    -y|--y) Prompt=0; shift;;
    *)
    POSITIONAL+=("$1") # save it in an array for later
    shift;;
  esac
done
set -- "${POSITIONAL[@]}" # restore positional parameters

if [ "$1" = "" ]; then
  echo "$usage"
  exit 1
fi

if [ $Prompt -eq 1 ]; then
  read -p "drop-site $1? [Y/n] " yn
  yn=${yn:-y}
  if [ "$yn" != "Y" ] && [ "$yn" != "y" ]; then
    exit 1
  fi
fi

echo rm $1
sudo rm /var/www/$1 -r

echo Drop database $1
mysql -uroot -p$mysqlpw --host=localhost --port=3306 --protocol=tcp -N<<EOF
drop database if exists $1;
drop user if exists '$1'@'localhost';
flush privileges;
EOF
EOF2
bind "set disable-completion off"
sudo chmod +x /var/www/bin/drop-site

bind "set disable-completion on"
bash -c "cat > /var/www/bin/modc-site" << "EOF"
#!/bin/bash -e

tab='	'
nl='
'
IFS=" $tab$nl"

usage="Usage: ${0##*/} [OPTION] source target

Compare modules

options:
  -c, --cr   		Clear cache"

clearCache=0
POSITIONAL=()

while (( "$#" )); do
  case "$1" in
    -h|--h*) echo "$usage"; exit 1;;
    -c|--cr) clearCache=1; shift;;
    *)
    POSITIONAL+=("$1") # save it in an array for later
    shift;;
  esac
done

set -- "${POSITIONAL[@]}" # restore positional parameters

if [ -z "$1" ] || [ -z "$2" ]; then
  echo "$usage"
  exit 1
fi

if [ "$1" = "$2" ]; then
  echo "Error: The source target is the same!" >&2
  exit 1
fi

fileName=_Module.txt

cd /var/www/$1
if [ $clearCache -eq 1 ]; then
  drush cr
fi
drush pm-list --fields display_name,version,status --type=module > $fileName

cd /var/www/$2
if [ $clearCache -eq 1 ]; then
  drush cr
fi
drush pm-list --fields display_name,version,status --type=module > $fileName

diff -y <(sed 's/\([ -]\)*/\1/g' /var/www/$1/$fileName | fold -s -w80) \
<(sed 's/\([ -]\)*/\1/g' /var/www/$2/$fileName | fold -s -w80) -W 160 | grep '[<|>]'

rm /var/www/$1/$fileName
rm /var/www/$2/$fileName
EOF

bind "set disable-completion off"
sudo chmod +x /var/www/bin/modc-site

bind "set disable-completion on"
bash -c "cat > /var/www/bin/clone-db" << "EOF2"
#!/bin/bash -e

tab='	'
nl='
'
IFS=" $tab$nl"

usage="Usage: ${0##*/} [OPTION] source target

Clone database

options:
  -y		Never prompt"

Prompt=1
POSITIONAL=()

while (( "$#" )); do
  case "$1" in
    -h|--h*) echo "$usage"; exit 1;;
    -y|--y) Prompt=0; shift;;
    *)
    POSITIONAL+=("$1") # save it in an array for later
    shift;;
  esac
done
set -- "${POSITIONAL[@]}" # restore positional parameters

if [ "$1" = "" ] || [ "$2" = "" ]; then
  echo "$usage"
  exit 1
fi

if [ "$1" = "$2" ]; then
  echo "Error: The source target is the same!" >&2
  exit 1
fi

if [ $Prompt -eq 1 ]; then
  read -p "clone-db $1 to $2? [Y/n] " yn
  yn=${yn:-y}
  if [ "$yn" != "Y" ] && [ "$yn" != "y" ]; then
    exit 1
  fi
fi

echo mysqldump $1
mysqldump -uroot -p$mysqlpw --host=localhost --port=3306 $1 > /var/www/$2/_srcdb.sql

echo create database $2
mysql -uroot -p$mysqlpw --host=localhost --port=3306 --protocol=tcp -n<<EOF
drop database if exists $2;
create database $2;
grant all privileges on $2.* to '$2'@'localhost' identified by '$webdbpw';
use mysql;
update user set plugin='mysql_native_password' where user='$2';
flush privileges;
EOF

echo Import table $2
mysql -u$2 -p$webdbpw --host=localhost --port=3306 $2 < /var/www/$2/_srcdb.sql

rm /var/www/$2/_srcdb.sql

cd /var/www/$2
drush cr
EOF2
bind "set disable-completion off"

sudo chmod +x /var/www/bin/clone-db

/* Layer the bar just above the trays and above contextual link triggers. */
.toolbar-oriented .toolbar-bar {
  z-index: 502; (1)
}

/* Layer the bar just above the trays and above contextual link triggers. */
/*** MY-PATCH 502 to 1032 ***/
.toolbar-oriented .toolbar-bar {
  z-index: 1032;
}

# 先備份原始檔案
cp core/modules/toolbar/css/toolbar.module.css /var/www/files/patch/toolbar.module.css.src

nano core/modules/toolbar/css/toolbar.module.css
# 502 修改為  1032

# 產生 patch
diff -u /var/www/files/patch/toolbar.module.css.src \
core/modules/toolbar/css/toolbar.module.css \
> /var/www/files/patch/toolbar.module.css.patch

# 備份本次修改結果
cp core/modules/toolbar/css/toolbar.module.css /var/www/files/patch/toolbar.module.css.patched

# 下次更新時, 再次執行
patch -i /var/www/files/patch/toolbar.module.css.patch core/modules/toolbar/css/toolbar.module.css

# 檢查 .z-index
grep -A 4 'Layer the bar just above the trays and above contextual link triggers' \
core/modules/toolbar/css/toolbar.module.css

<VirtualHost *:80>
  DocumentRoot /var/www/drupal
  RewriteEngine on

  ErrorDocument 404 /html/404.php (1)
  ErrorDocument 403 /html/404.php (1)

  RewriteCond expr "%{REMOTE_ADDR} -ipmatch '192.168.1.0/24'" (2)
  RewriteRule .? - [L] (2)
  RewriteCond %{REQUEST_URI} (/[uU][sS][eE][rR]|/[aA][dD][mM][iI][nN]) (3)
  RewriteRule .? - [L,R=404] (3)

  <FilesMatch "(install|update).php"> (4)
    Order deny,allow
    deny from all
    Allow from 192.168.1.0/24 (5)
  </FilesMatch>

  <Directory /var/www/drupal>
    AllowOverride None
    Include /var/www/drupal/.htaccess
  </Directory>
</VirtualHost>

Require ip 192.168.1.1
Require ip 192.168.1.0/255.255.255.0
Require ip 192.168.1.0/24

# 先備份原始檔案
cp .htaccess /var/www/files/patch/.htaccess.src

nano .htaccess
# 加入允許 php 規則。

# 產生 patch
diff -u /var/www/files/patch/.htaccess.src \
.htaccess \
> /var/www/files/patch/.htaccess.patch

# 備份本次修改結果
cp .htaccess /var/www/files/patch/.htaccess.patched

# 下次 drupal 更新時, 再次執行
patch -i /var/www/files/patch/.htaccess.patch .htaccess

# 檢查結果
grep -A 5 '# custom modules or to run another PHP application in the same directory.' \
.htaccess

<?php
  http_response_code(404); (1)
  $lant='en';
  $url=$_SERVER['REQUEST_URI'];
  if (preg_match('~^/zh-hant(?:/|$)~i', $url)) {
      $lang='zh-TW';
  } elseif (preg_match('~^/zh-hans(?:/|$)~i', $url)) {
      $lang='zh-CN';
  } else {
      $lang=strtok($_SERVER['HTTP_ACCEPT_LANGUAGE'], ',');
  }
  switch ($lang) {
      case 'zh-TW':
          include '404_tw.html'; (2)
          break;
      case 'zh-CN':
          include '404_cn.html';
          break;
      default:
          include '404_en.html';
  }

wget --content-on-error <site>/zh-hant/notexists -O /var/www/drupal/html/404_tw.html
wget --content-on-error <site>/zh-hans/notexists -O /var/www/drupal/html/404_cn.html
wget --content-on-error <site>/en/notexists -O /var/www/drupal/html/404_en.html

<VirtualHost *:80>
  DocumentRoot /var/www/files/site/html (1)
  RewriteEngine on
  RewriteCond %{REQUEST_URI} !=/favicon.ico (2)
  ErrorDocument 503 /503.php (3)
  RewriteCond %{REQUEST_URI} !/503.php$ [NC] (4)
  RewriteRule .* - [R=503,L] (5)
</VirtualHost>

<?php
  $lant='en';
  $url=$_SERVER['REQUEST_URI'];
  if (preg_match('~^/zh-hant(?:/|$)~i', $url)) {
      $lang='zh-TW'; (1)
  } elseif (preg_match('~^/zh-hans(?:/|$)~i', $url)) {
      $lang='zh-CN'; (2)
  } else {
      $lang=strtok($_SERVER['HTTP_ACCEPT_LANGUAGE'], ','); (3)
  }

  switch ($lang) {
      case 'zh-TW':
          include '503_tw.html'; (4)
          break;
      case 'zh-CN':
          include '503_cn.html';
          break;
      default:
          include '503_en.html';
  }

# 設定網站維護
drush state:set system.maintenance_mode 1 --input-format=integer
drush cr

wget --content-on-error <site>/zh-hant/ -O /var/www/files/site/html/503_tw.html
wget --content-on-error <site>/zh-hans/ -O /var/www/files/site/html/503_cn.html
wget --content-on-error <site>/en/ -O /var/www/files/site/html/503_en.html

# 回復正常
drush state:set system.maintenance_mode 0 --input-format=integer
drush cr

<!DOCTYPE html>
<html lang="zh-hant" dir="ltr"
  prefix="content: http://purl.org/rss/1.0/modules/content/  dc: http://purl.org/dc/terms/  foaf: http://xmlns.com/foaf/0.1/  og: http://ogp.me/ns#  rdfs: http://www.w3.org/2000/01/rdf-schema#  schema: http://schema.org/  sioc: http://rdfs.org/sioc/ns#  sioct: http://rdfs.org/sioc/types#  skos: http://www.w3.org/2004/02/skos/core#  xsd: http://www.w3.org/2001/XMLSchema# ">

<head>
  <meta charset="utf-8" />
  <meta name="MobileOptimized" content="width" />
  <meta name="HandheldFriendly" content="true" />
  <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  <meta http-equiv="x-ua-compatible" content="ie=edge" />
  <link rel="shortcut icon" href="/favicon.ico" type="image/vnd.microsoft.icon" />

  <title>網站正在進行維護 | 我的網站</title>

  <style type="text/css">
    body {
      font-family: helvetica, arial, sans-serif;
      font-size: 16px;
    }

    #maintenance-page {
      margin-top: 40px;
      border: 0px;
      width: 800px;
      margin-left: auto;
      margin-right: auto;
    }
  </style>
</head>

<body>
  <div id="maintenance-page">
    <strong>
      <span style="color: #9d408d">我的網站</span>
    </strong>
    <section>
      <h1>網站正在進行維護</h1>
      我的網站 正在維護中，很快就會回來，請稍候。
    </section>
  </div>
</body>

</html>

sudo a2dissite drupal
sudo a2ensite drupal503
sudo service apache2 reload

sudo a2dissite drupal503
sudo a2ensite drupal
sudo service apache2 reload

{
    // Use IntelliSense to learn about possible attributes.
    // Hover to view descriptions of existing attributes.
    // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
    "version": "0.2.0",
    "configurations": [
        {
            "name": "Listen for XDebug",
            "type": "php",
            "request": "launch",
            "port": 9000,
            "pathMappings": { (1)
                "/home/ubuntu": "${workspaceRoot}",
              }
        },
        {
            "name": "Launch currently open script",
            "type": "php",
            "request": "launch",
            "program": "${file}",
            "cwd": "${fileDirname}",
            "port": 9000
        }
    ]
}

/etc/php/7.3/apache2/conf.d/20-xdebug.ini (1)
/etc/php/7.3/cli/conf.d/20-xdebug.ini (1)
/etc/php/7.3/fpm/conf.d/20-xdebug.ini (1)
/etc/php/7.3/mods-available/xdebug.ini

sudo phpdismod xdebug
sudo service php7.3-fpm restart

sudo netstat -tlpn
# 確定已關閉 PHP Web server 再重啟 Web 服務器
# sudo service nginx start
# sudo service apache2 start

sudo phpenmod xdebug (1)
sudo ln -s /etc/php/7.3/mods-available/xdebug.ini /etc/php/7.3/cli/conf.d/20-xdebug.ini (2)
sudo service php7.3-fpm restart