Vagrant provision for Drupal 9 failing on mysql

[marcgetter]

#1859

Issue Type

• Bug Report / Support Request

Your Environment

Vagrant 2.2.10
VirtualBox 6.1.14r140239
ansible 2.9.11
  config file = None
  configured module search path = ['/Users/marc.getter/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/local/Cellar/ansible/2.9.11/libexec/lib/python3.8/site-packages/ansible
  executable location = /usr/local/bin/ansible
  python version = 3.8.5 (default, Jul 21 2020, 10:48:26) [Clang 11.0.3 (clang-1103.0.32.62)]

Your OS

• macOS 10.15.6

Full console output

TASK [geerlingguy.php-mysql : Install PHP MySQL dependencies (Debian).] ********
fatal: [genesis]: FAILED! => {"cache_update_time": 1600374266, "cache_updated": false, "changed": false, "msg": "'/usr/bin/apt-get -y -o \"Dpkg::Options::=--force-confdef\" -o \"Dpkg::Options::=--force-confold\"      install 'php7.3-mysql'' failed: E: Sub-process /usr/bin/dpkg returned an error code (1)\n", "rc": 100, "stderr": "E: Sub-process /usr/bin/dpkg returned an error code (1)\n", "stderr_lines": ["E: Sub-process /usr/bin/dpkg returned an error code (1)"], "stdout": "Reading package lists...\nBuilding dependency tree...\nReading state information...\nThe following packages were automatically installed and are no longer required:\n  python-asn1crypto python-cffi-backend python-crypto python-cryptography\n  python-enum34 python-httplib2 python-idna python-ipaddress python-jinja2\n  python-markupsafe python-paramiko python-pkg-resources python-pyasn1\n  python-setuptools python-six python-yaml sshpass\nUse 'sudo apt autoremove' to remove them.\nThe following NEW packages will be installed:\n  php7.3-mysql\n0 upgraded, 1 newly installed, 0 to remove and 80 not upgraded.\nNeed to get 116 kB of archives.\nAfter this operation, 441 kB of additional disk space will be used.\nGet:1 http://ppa.launchpad.net/ondrej/php/ubuntu bionic/main amd64 php7.3-mysql amd64 7.3.22-1+ubuntu18.04.1+deb.sury.org+1 [116 kB]\nFetched 116 kB in 1s (163 kB/s)\nSelecting previously unselected package php7.3-mysql.\r\n(Reading database ... \r(Reading database ... 5%\r(Reading database ... 10%\r(Reading database ... 15%\r(Reading database ... 20%\r(Reading database ... 25%\r(Reading database ... 30%\r(Reading database ... 35%\r(Reading database ... 40%\r(Reading database ... 45%\r(Reading database ... 50%\r(Reading database ... 55%\r(Reading database ... 60%\r(Reading database ... 65%\r(Reading database ... 70%\r(Reading database ... 75%\r(Reading database ... 80%\r(Reading database ... 85%\r(Reading database ... 90%\r(Reading database ... 95%\r(Reading database ... 100%\r(Reading database ... 74865 files and directories currently installed.)\r\nPreparing to unpack .../php7.3-mysql_7.3.22-1+ubuntu18.04.1+deb.sury.org+1_amd64.deb ...\r\nUnpacking php7.3-mysql (7.3.22-1+ubuntu18.04.1+deb.sury.org+1) ...\r\nSetting up php7.3-mysql (7.3.22-1+ubuntu18.04.1+deb.sury.org+1) ...\r\n\r\nCreating config file /etc/php/7.3/mods-available/mysqlnd.ini with new version\r\n\r\nCreating config file /etc/php/7.3/mods-available/mysqli.ini with new version\r\n\r\nCreating config file /etc/php/7.3/mods-available/pdo_mysql.ini with new version\r\nProcessing triggers for php7.3-fpm (7.3.22-1+ubuntu18.04.1+deb.sury.org+1) ...\r\nJob for php7.3-fpm.service failed because the control process exited with error code.\r\nSee \"systemctl status php7.3-fpm.service\" and \"journalctl -xe\" for details.\r\ninvoke-rc.d: initscript php7.3-fpm, action \"restart\" failed.\r\n\u001b[0;1;31m*\u001b[0m php7.3-fpm.service - The PHP 7.3 FastCGI Process Manager\r\n   Loaded: loaded (/lib/systemd/system/php7.3-fpm.service; enabled; vendor preset: enabled)\r\n   Active: \u001b[0;1;31mfailed\u001b[0m (Result: exit-code) since Thu 2020-09-17 20:27:39 UTC; 7ms ago\r\n     Docs: man:php-fpm7.3(8)\r\n  Process: 5674 ExecStopPost=/usr/lib/php/php-fpm-socket-helper remove /run/php/php-fpm.sock /etc/php/7.3/fpm/pool.d/www.conf 73 (code=exited, status=0/SUCCESS)\r\n  Process: 5673 ExecStart=/usr/sbin/php-fpm7.3 --nodaemonize --fpm-config /etc/php/7.3/fpm/php-fpm.conf \u001b[0;1;31m(code=exited, status=78)\u001b[0m\r\n Main PID: 5673 (code=exited, status=78)\r\n\r\nSep 17 20:27:39 local systemd[1]: Starting The PHP 7.3 FastCGI Process Manager...\r\nSep 17 20:27:39 local php-fpm7.3[5673]: [17-Sep-2020 20:27:39] ERROR: unable to bind listening socket for address '127.0.0.1:9000': Address already in use (98)\r\nSep 17 20:27:39 local php-fpm7.3[5673]: [17-Sep-2020 20:27:39] ERROR: FPM initialization failed\r\nSep 17 20:27:39 local systemd[1]: \u001b[0;1;39m\u001b[0;1;31m\u001b[0;1;39mphp7.3-fpm.service: Main process exited, code=exited, status=78/n/a\u001b[0m\r\nSep 17 20:27:39 local systemd[1]: \u001b[0;1;39m\u001b[0;1;31m\u001b[0;1;39mphp7.3-fpm.service: Failed with result 'exit-code'.\u001b[0m\r\nSep 17 20:27:39 local systemd[1]: \u001b[0;1;31m\u001b[0;1;39m\u001b[0;1;31mFailed to start The PHP 7.3 FastCGI Process Manager.\u001b[0m\r\ndpkg: error processing package php7.3-fpm (--configure):\r\n installed php7.3-fpm package post-installation script subprocess returned error exit status 1\r\nProcessing triggers for php7.3-cli (7.3.22-1+ubuntu18.04.1+deb.sury.org+1) ...\r\nErrors were encountered while processing:\r\n php7.3-fpm\r\n", "stdout_lines": ["Reading package lists...", "Building dependency tree...", "Reading state information...", "The following packages were automatically installed and are no longer required:", "  python-asn1crypto python-cffi-backend python-crypto python-cryptography", "  python-enum34 python-httplib2 python-idna python-ipaddress python-jinja2", "  python-markupsafe python-paramiko python-pkg-resources python-pyasn1", "  python-setuptools python-six python-yaml sshpass", "Use 'sudo apt autoremove' to remove them.", "The following NEW packages will be installed:", "  php7.3-mysql", "0 upgraded, 1 newly installed, 0 to remove and 80 not upgraded.", "Need to get 116 kB of archives.", "After this operation, 441 kB of additional disk space will be used.", "Get:1 http://ppa.launchpad.net/ondrej/php/ubuntu bionic/main amd64 php7.3-mysql amd64 7.3.22-1+ubuntu18.04.1+deb.sury.org+1 [116 kB]", "Fetched 116 kB in 1s (163 kB/s)", "Selecting previously unselected package php7.3-mysql.", "(Reading database ... ", "(Reading database ... 5%", "(Reading database ... 10%", "(Reading database ... 15%", "(Reading database ... 20%", "(Reading database ... 25%", "(Reading database ... 30%", "(Reading database ... 35%", "(Reading database ... 40%", "(Reading database ... 45%", "(Reading database ... 50%", "(Reading database ... 55%", "(Reading database ... 60%", "(Reading database ... 65%", "(Reading database ... 70%", "(Reading database ... 75%", "(Reading database ... 80%", "(Reading database ... 85%", "(Reading database ... 90%", "(Reading database ... 95%", "(Reading database ... 100%", "(Reading database ... 74865 files and directories currently installed.)", "Preparing to unpack .../php7.3-mysql_7.3.22-1+ubuntu18.04.1+deb.sury.org+1_amd64.deb ...", "Unpacking php7.3-mysql (7.3.22-1+ubuntu18.04.1+deb.sury.org+1) ...", "Setting up php7.3-mysql (7.3.22-1+ubuntu18.04.1+deb.sury.org+1) ...", "", "Creating config file /etc/php/7.3/mods-available/mysqlnd.ini with new version", "", "Creating config file /etc/php/7.3/mods-available/mysqli.ini with new version", "", "Creating config file /etc/php/7.3/mods-available/pdo_mysql.ini with new version", "Processing triggers for php7.3-fpm (7.3.22-1+ubuntu18.04.1+deb.sury.org+1) ...", "Job for php7.3-fpm.service failed because the control process exited with error code.", "See \"systemctl status php7.3-fpm.service\" and \"journalctl -xe\" for details.", "invoke-rc.d: initscript php7.3-fpm, action \"restart\" failed.", "\u001b[0;1;31m*\u001b[0m php7.3-fpm.service - The PHP 7.3 FastCGI Process Manager", "   Loaded: loaded (/lib/systemd/system/php7.3-fpm.service; enabled; vendor preset: enabled)", "   Active: \u001b[0;1;31mfailed\u001b[0m (Result: exit-code) since Thu 2020-09-17 20:27:39 UTC; 7ms ago", "     Docs: man:php-fpm7.3(8)", "  Process: 5674 ExecStopPost=/usr/lib/php/php-fpm-socket-helper remove /run/php/php-fpm.sock /etc/php/7.3/fpm/pool.d/www.conf 73 (code=exited, status=0/SUCCESS)", "  Process: 5673 ExecStart=/usr/sbin/php-fpm7.3 --nodaemonize --fpm-config /etc/php/7.3/fpm/php-fpm.conf \u001b[0;1;31m(code=exited, status=78)\u001b[0m", " Main PID: 5673 (code=exited, status=78)", "", "Sep 17 20:27:39 local systemd[1]: Starting The PHP 7.3 FastCGI Process Manager...", "Sep 17 20:27:39 local php-fpm7.3[5673]: [17-Sep-2020 20:27:39] ERROR: unable to bind listening socket for address '127.0.0.1:9000': Address already in use (98)", "Sep 17 20:27:39 local php-fpm7.3[5673]: [17-Sep-2020 20:27:39] ERROR: FPM initialization failed", "Sep 17 20:27:39 local systemd[1]: \u001b[0;1;39m\u001b[0;1;31m\u001b[0;1;39mphp7.3-fpm.service: Main process exited, code=exited, status=78/n/a\u001b[0m", "Sep 17 20:27:39 local systemd[1]: \u001b[0;1;39m\u001b[0;1;31m\u001b[0;1;39mphp7.3-fpm.service: Failed with result 'exit-code'.\u001b[0m", "Sep 17 20:27:39 local systemd[1]: \u001b[0;1;31m\u001b[0;1;39m\u001b[0;1;31mFailed to start The PHP 7.3 FastCGI Process Manager.\u001b[0m", "dpkg: error processing package php7.3-fpm (--configure):", " installed php7.3-fpm package post-installation script subprocess returned error exit status 1", "Processing triggers for php7.3-cli (7.3.22-1+ubuntu18.04.1+deb.sury.org+1) ...", "Errors were encountered while processing:", " php7.3-fpm"]}

Summary

I am working on using Composer, BLT, and Drupal VM to setup a Drupal 9 development environment.

Since there is not a composer project for Drupal 9 yet, I started with a basic Drupal 8 BLT installation using the instructions here:

https://docs.acquia.com/blt/install/creating-new-project/

I then followed the instructions here to upgrade to Drupal 9

https://support.acquia.com/hc/en-us/articles/360045796154-Upgrading-from-BLT-11-to-BLT-12

I was able to get through all of the composer dependency issues but I'm not facing the above issue when I execute vagrant up.

There is indication that I need to install mysql within composer but that is only supported for Drupal 9 and not 9.1. This installation is Drupal 9.1.

[oxyc]

See #2076, closing as a duplicate.