My dumps started from lines:

Warning: Using a password on the command line interface can be insecure.
mysqldump: Couldn't find table: "log_customer"
mysqldump: Couldn't find table: "log_quote"
mysqldump: Couldn't find table: "log_summary"
mysqldump: Couldn't find table: "log_summary_type"
mysqldump: Couldn't find table: "log_url"
mysqldump: Couldn't find table: "log_url_info"
mysqldump: Couldn't find table: "log_visitor"
mysqldump: Couldn't find table: "log_visitor_info"
mysqldump: Couldn't find table: "log_visitor_online"
mysqldump: Couldn't find table: "index_event"
mysqldump: Couldn't find table: "index_process_event"
-- MySQL dump 10.13  Distrib 5.6.28, for Linux (x86_64)

Your script can't remove first one. Please, fix it ASAP!!!

After deploying I can access admin panel (get 404) because admin/url/custom_path is not empty and admin/url/use_custom_path = 1.

Please, fix it ASAP!!!!

I tried to install using this command from magento-sparta repo: m2install.sh -s git --git-branch 2.1.11 --sample-data yes --ee -f The installation finished successfully and only after I've finished testing, I've noticed that it installed develop branch instead (because there was no 2.1.11 branch). Please break installation if the branch has not been found rather then installing develop branch.

My ~/.m2install.conf contained the line INSTALL_EE=1

and it was not possible to turn it off and install only CE in the interactive mode:

Magento EE will be installed
Confirm That the Entered Data Is Correct? (y/N) N
Git CE repository (default: [email protected]:magento-sparta/magento2ce.git): 
Git EE repository (default: [email protected]:magento-sparta/magento2ee.git): 
Git branch (default: MDVA-369): 
Do you want to install Enterprise Edition (y/N) N
Enter Server Name of Document Root (default: http://web2.sparta.corp.magento.com/): 
Enter Base Path (default: dev/kmuntianu/MDVA-369): 
Enter DB Host (default: sparta-db): 
Enter DB User (default: kmuntianu): 
Enter DB Password: 
Enter DB Name (default: kmuntianu_mdva369): 
Do you want to install Sample Data (y/N) N
--------------------------------------------------
Magento code will be downloaded from GIT
Git CE repository: [email protected]:magento-sparta/magento2ce.git
Git EE repository: [email protected]:magento-sparta/magento2ee.git
Git branch: MDVA-369
BASE URL: http://web2.sparta.corp.magento.com/dev/kmuntianu/MDVA-369/
BASE PATH: dev/kmuntianu/MDVA-369
DB PARAM: kmuntianu@sparta-db
DB NAME: kmuntianu_mdva369
DB PASSWORD: 
MAGE MODE: dev
BACKEND FRONTNAME: admin
ADMIN NAME: admin
ADMIN PASSWORD: 123123q
ADMIN FIRSTNAME: Admin
ADMIN LASTNAME: Test
ADMIN EMAIL: [email protected]
TIMEZONE: America/Chicago
LANGUAGE: en_US
CURRENCY: USD
Sample Data will NOT be installed.
Magento EE will be installed
Confirm That the Entered Data Is Correct? (y/N)

…e mysql dump file

We started to see the m2install failed due to below error messages

pv "./php74.database.sql.gz" | gunzip -cf | gunzip -cf | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/'
| sed -e 's/TRIGGER[ ][`][A-Za-z0-9_]*[`][.]/TRIGGER /'
| sed -e 's/AFTER[ ]\(INSERT\)\{0,1\}\(UPDATE\)\{0,1\}\(DELETE\)\{0,1\}[ ]ON[ ][`][A-Za-z0-9_]*[`][.]/AFTER \1\2\3 ON /'
| grep -v 'mysqldump: Couldn.t find table' | grep -v 'Warning: Using a password'
| mysql -hdb.us-west-2.prd.sparta.ceng.magento.com -uhawi --password="Uz5AXJZWMF3TF_34" --force hawi_492563
ERROR at line 616782: Unknown command '\"'.======================================================================================> ] 64% ETA 0:02:10
ERROR at line 616782: Unknown command '\"'.

This was because the below error was seen in the actual line (616782 in above example):

mysqldump: Couldn't execute 'SHOW FIELDS FROM `inventory_stock_1`': View 'shortys.inventory_stock_1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)

So "grep -v 'mysqldump: Couldn.t execute'" should address it.

Added:

generic function for disabling selected module after install generic function for disabling modules prior install (in app/etc/config.php file) as post original file overwrite function option to skip post original file overwrite actions

Prior to 2.2.4 the table_prefix in the env.php ended with a coma:

    'table_prefix' => '',

while the 2.2.4 wit the new array declaration don't require the coma anymore:

    'table_prefix' => ''

This lead to the failure of configure_db step, because getTablePrefix() returns single quote character as the table prefix:

$ grep table_prefix ee224/app/etc/env.php
    'table_prefix' => ''
$ grep table_prefix ee224/app/etc/env.php | head -n1 | sed "s/[a-z'_ ]*[=][>][ ]*[']//" | sed "s/['][,]//"
'

The following function should be reworked:

function getTablePrefix()
{
    echo $(grep 'table_prefix' app/etc/env.php | head -n1 | sed "s/[a-z'_ ]*[=][>][ ]*[']//" | sed "s/['][,]//")
    return 0;
}

In current implementation on OS X tar -tf "$1" | grep -v vendor | fgrep pub/index.php | sed 's/pub[/]index[.]php//' | sort | head -1 | tr -cd '/' | wc -c would produce a wrong resulting command because of wc output formatting tar --strip-components= 1 -xf ./......

One of the solution use SQL MODE sql_mode=NO_AUTO_VALUE_ON_ZERO

• It shouldn't override all sql modes
• It should be per session

Some solutions:

• SET @@sql_mode = CONCAT(@@sql_mode, ',', 'NO_AUTO_VALUE_ON_ZERO');
• Open up a session using expect and push data into the expect statement
• mysql -u root "password" "database-name" < cat set_sql_mode.sql merchant_file.sql
• { echo "SET MODE"; gunzip -cf DBDUMP.sql.gz | gunzip -cf; } | sed -e 's/DEFINER[ ]=[ ][^*]**/*/' | less -S
• { echo "#SET MODE"; pv DBDUMP.sql.gz | gunzip -cf | gunzip -cf; } | sed -e 's/DEFINER[ ]=[ ][^*]**/*/' | mysql -uroot -p root_c -hdb
• CMD="${CMD}
  | gunzip -cf | sed -e '1iSET @@session.sql_mode = CONCAT(@@session.sql_mode,,, NO_AUTO_VALUE_ON_ZERO);' | sed -e 's/DEFINER[ ]=[ ][^*]**/*/' | ........

Mysqldump adds next headers:

--MySQL dump 10.13  Distrib 5.5.54, for debian-linux-gnu (x86_64)
--
-- Host: example.host    Database: magento_prod
-- ------------------------------------------------------
-- Server version       5.6.27-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

Faced with an issue, that you can't install Magento 2 from GIT if set version as a branch. For example: v2.4.2-p1.

Run command: m2install.sh -s git -v v2.4.2-p1 --es-port 9207 --es-host magento2elastic7

Error on installing stage:

Running schema recurring...
[Progress: 416 / 842]
Module 'Magento_WishlistAnalytics':
[Progress: 417 / 842]
Module 'Magento_WishlistGraphQl':
[Progress: 418 / 842]
[Progress: 419 / 842]
Installing search configuration...

In SearchConfig.php line 81:

  Could not validate a connection to Elasticsearch. No alive nodes found in your cluster


setup:install [--remote-storage-driver REMOTE-STORAGE-DRIVER] [--remote-storage-prefix REMOTE-STORAGE-PREFIX] [--remote-storage-bucket REMOTE-STORAGE-BUCKET] [--remote-storage-region REMOTE-STORAGE-REGION] [--remote-storage-key REMOTE-STORAGE-KEY] [--remote-storage-secret REMOTE-STORAGE-SECRET] [--consumers-wait-for-messages CONSUMERS-WAIT-FOR-MESSAGES] [--backend-frontname BACKEND-FRONTNAME] [--enable-debug-logging ENABLE-DEBUG-LOGGING] [--enable-syslog-logging ENABLE-SYSLOG-LOGGING] [--amqp-host AMQP-HOST] [--amqp-port AMQP-PORT] [--amqp-user AMQP-USER] [--amqp-password AMQP-PASSWORD] [--amqp-virtualhost AMQP-VIRTUALHOST] [--amqp-ssl AMQP-SSL] [--amqp-ssl-options AMQP-SSL-OPTIONS] [--key KEY] [--db-host DB-HOST] [--db-name DB-NAME] [--db-user DB-USER] [--db-engine DB-ENGINE] [--db-password DB-PASSWORD] [--db-prefix DB-PREFIX] [--db-model DB-MODEL] [--db-init-statements DB-INIT-STATEMENTS] [-s|--skip-db-validation] [--http-cache-hosts HTTP-CACHE-HOSTS] [--db-ssl-key DB-SSL-KEY] [--db-ssl-cert DB-SSL-CERT] [--db-ssl-ca DB-SSL-CA] [--db-ssl-verify] [--session-save SESSION-SAVE] [--session-save-redis-host SESSION-SAVE-REDIS-HOST] [--session-save-redis-port SESSION-SAVE-REDIS-PORT] [--session-save-redis-password SESSION-SAVE-REDIS-PASSWORD] [--session-save-redis-timeout SESSION-SAVE-REDIS-TIMEOUT] [--session-save-redis-persistent-id SESSION-SAVE-REDIS-PERSISTENT-ID] [--session-save-redis-db SESSION-SAVE-REDIS-DB] [--session-save-redis-compression-threshold SESSION-SAVE-REDIS-COMPRESSION-THRESHOLD] [--session-save-redis-compression-lib SESSION-SAVE-REDIS-COMPRESSION-LIB] [--session-save-redis-log-level SESSION-SAVE-REDIS-LOG-LEVEL] [--session-save-redis-max-concurrency SESSION-SAVE-REDIS-MAX-CONCURRENCY] [--session-save-redis-break-after-frontend SESSION-SAVE-REDIS-BREAK-AFTER-FRONTEND] [--session-save-redis-break-after-adminhtml SESSION-SAVE-REDIS-BREAK-AFTER-ADMINHTML] [--session-save-redis-first-lifetime SESSION-SAVE-REDIS-FIRST-LIFETIME] [--session-save-redis-bot-first-lifetime SESSION-SAVE-REDIS-BOT-FIRST-LIFETIME] [--session-save-redis-bot-lifetime SESSION-SAVE-REDIS-BOT-LIFETIME] [--session-save-redis-disable-locking SESSION-SAVE-REDIS-DISABLE-LOCKING] [--session-save-redis-min-lifetime SESSION-SAVE-REDIS-MIN-LIFETIME] [--session-save-redis-max-lifetime SESSION-SAVE-REDIS-MAX-LIFETIME] [--session-save-redis-sentinel-master SESSION-SAVE-REDIS-SENTINEL-MASTER] [--session-save-redis-sentinel-servers SESSION-SAVE-REDIS-SENTINEL-SERVERS] [--session-save-redis-sentinel-verify-master SESSION-SAVE-REDIS-SENTINEL-VERIFY-MASTER] [--session-save-redis-sentinel-connect-retries SESSION-SAVE-REDIS-SENTINEL-CONNECT-RETRIES] [--cache-backend CACHE-BACKEND] [--cache-backend-redis-server CACHE-BACKEND-REDIS-SERVER] [--cache-backend-redis-db CACHE-BACKEND-REDIS-DB] [--cache-backend-redis-port CACHE-BACKEND-REDIS-PORT] [--cache-backend-redis-password CACHE-BACKEND-REDIS-PASSWORD] [--cache-backend-redis-compress-data CACHE-BACKEND-REDIS-COMPRESS-DATA] [--cache-backend-redis-compression-lib CACHE-BACKEND-REDIS-COMPRESSION-LIB] [--cache-id-prefix CACHE-ID-PREFIX] [--allow-parallel-generation] [--page-cache PAGE-CACHE] [--page-cache-redis-server PAGE-CACHE-REDIS-SERVER] [--page-cache-redis-db PAGE-CACHE-REDIS-DB] [--page-cache-redis-port PAGE-CACHE-REDIS-PORT] [--page-cache-redis-password PAGE-CACHE-REDIS-PASSWORD] [--page-cache-redis-compress-data PAGE-CACHE-REDIS-COMPRESS-DATA] [--page-cache-redis-compression-lib PAGE-CACHE-REDIS-COMPRESSION-LIB] [--page-cache-id-prefix PAGE-CACHE-ID-PREFIX] [--lock-provider LOCK-PROVIDER] [--lock-db-prefix LOCK-DB-PREFIX] [--lock-zookeeper-host LOCK-ZOOKEEPER-HOST] [--lock-zookeeper-path LOCK-ZOOKEEPER-PATH] [--lock-file-path LOCK-FILE-PATH] [--document-root-is-pub DOCUMENT-ROOT-IS-PUB] [--base-url BASE-URL] [--language LANGUAGE] [--timezone TIMEZONE] [--currency CURRENCY] [--use-rewrites USE-REWRITES] [--use-secure USE-SECURE] [--base-url-secure BASE-URL-SECURE] [--use-secure-admin USE-SECURE-ADMIN] [--admin-use-security-key ADMIN-USE-SECURITY-KEY] [--admin-user [ADMIN-USER]] [--admin-password [ADMIN-PASSWORD]] [--admin-email [ADMIN-EMAIL]] [--admin-firstname [ADMIN-FIRSTNAME]] [--admin-lastname [ADMIN-LASTNAME]] [--search-engine SEARCH-ENGINE] [--elasticsearch-host ELASTICSEARCH-HOST] [--elasticsearch-port ELASTICSEARCH-PORT] [--elasticsearch-enable-auth ELASTICSEARCH-ENABLE-AUTH] [--elasticsearch-username ELASTICSEARCH-USERNAME] [--elasticsearch-password ELASTICSEARCH-PASSWORD] [--elasticsearch-index-prefix ELASTICSEARCH-INDEX-PREFIX] [--elasticsearch-timeout ELASTICSEARCH-TIMEOUT] [--cleanup-database] [--sales-order-increment-prefix SALES-ORDER-INCREMENT-PREFIX] [--use-sample-data] [--enable-modules [ENABLE-MODULES]] [--disable-modules [DISABLE-MODULES]] [--convert-old-scripts [CONVERT-OLD-SCRIPTS]] [-i|--interactive] [--safe-mode [SAFE-MODE]] [--data-restore [DATA-RESTORE]] [--dry-run [DRY-RUN]] [--magento-init-params MAGENTO-INIT-PARAMS]

=> afterInstall

Looks like caused by incorrect conditions here:

...
    CMD="${BIN_PHP} ${BIN_MAGE} setup:install \
    --base-url=${BASE_URL} \
    --db-host=${DB_HOST} \
    --db-name=${DB_NAME} \
    --db-user=${DB_USER} \
    --admin-firstname=${ADMIN_FIRSTNAME} \
    --admin-lastname=${ADMIN_LASTNAME} \
    --admin-email=${ADMIN_EMAIL} \
    --admin-user=${ADMIN_NAME} \
    --admin-password=${ADMIN_PASSWORD} \
    --language=${LANGUAGE} \
    --currency=${CURRENCY} \
    --timezone=${TIMEZONE} \
    --use-rewrites=1 \
    --backend-frontname=${BACKEND_FRONTNAME}"
    if [ "${DB_PASSWORD}" ]; then
        CMD="${CMD} --db-password=${DB_PASSWORD}"
    fi
    if isElasticSearchRequired && isElasticSearchConfigIsAvailable
    then
            local searchEngine="$(getRecommendedSearchEngineForVersion)"
            CMD="${CMD} --search-engine=$searchEngine --elasticsearch-host=$(getESConfigHost $searchEngine) --elasticsearch-port=$(getESConfigPort $searchEngine) --elasticsearch-index-prefix=${DB_NAME}"
    fi
    runCommand
}

function isElasticSearchRequired()
{
  checkIfBasedOnDevelopBranch && return 0
  versionIsHigherThan "$(getMagentoVersion)" "2.4" && return 0
  return 255
}

function isElasticSearchConfigIsAvailable()
{
  [[ "$ELASTICSEARCH_HOST" ]] && [[ "$ELASTICSEARCH_PORT" ]] && return 0
  local searchEngine="$1"
  if [[ ! "$searchEngine" ]]
  then
    searchEngine="$(getRecommendedSearchEngineForVersion)"
  fi
  local eshost=$(getESConfigHost "$searchEngine")
  local esport=$(getESConfigPort "$searchEngine")
  [[ "$eshost" ]] && [[ "$esport" ]] && return 0
  return 255
}

INSERT INTO `core_config_data` (`config_id`, `scope`, `scope_id`, `path`, `value`) VALUES (NULL, 'default', '0', 'admin/security/password_is_forced', '0') ON DUPLICATE KEY UPDATE `value` = 0;

There's a bug in the updateMagentoEnvFile(). It generates and executed a PHP code which throws the error:

PHP Warning:  Class 'Tightenco\Collect\Support\Arr' not found in vendor/tightenco/collect/src/Collect/Support/alias.php on line 16
PHP Parse error:  syntax error, unexpected '=' in vendor/tightenco/collect/src/Collect/Support/Arr.php on line 388

As a result a generated env.php is empty.

• Create directory "websites"
• Create subdirectory for each website
  • websites/website-code/
  • Create in entry point "websites/website-code/index.php"
  • Modify entry point and set website code