Unable to connect to database locally
Opened this issue · 3 comments
Boosmith commented
I am getting this problem, starting from a blank project and using the Drupal8 Platform.sh template. Could be related to to https://github.com/lando/lando/issues/3111
ERROR 2003 (HY000): Can't connect to MySQL server on 'db' (111 "Connection refused")
and from lando pull -r database -m web/sites/default/files
Verifying your current project...
Verified project id: lp3e7dpy7tvvw
Verifying master is an active environment...
Verified the master environment is active
Verifying your ssh keys work are deployed to the project...
ERROR 2003 (HY000): Can't connect to MySQL server on 'db' (111 "Connection refused")
Destroying all current tables in database if needed...
Importing data from the database relationship into the main schema...
ERROR 2003 (HY000): Can't connect to MySQL server on 'db' (111 "Connection refused")
Also
lando pull -r database -m web/sites/default/files
Verifying you are authenticated against platform.sh...
+------------+--------------------------------------+
| Property | Value |
+------------+--------------------------------------+
| id | 713c64c0-cb09-476c-816a-5be711cb66e6 |
| first_name | London Borough of |
| last_name | Waltham Forest |
| username | lbwf |
| email | web.site@walthamforest.gov.uk |
+------------+--------------------------------------+
Verifying your current project...
Verified project id: lp3e7dpy7tvvw
Verifying master is an active environment...
Verified the master environment is active
Verifying your ssh keys work are deployed to the project...
ERROR 2003 (HY000): Can't connect to MySQL server on 'db' (111 "Connection refused")
Destroying all current tables in database if needed...
Importing data from the database relationship into the main schema...
ERROR 2003 (HY000): Can't connect to MySQL server on 'db' (111 "Connection refused")
This is from the logs
Andrews-MacBook-Pro-2 :: Sites/platformsh/temp-test1 ‹master*› % lando drush sql-drop
Attaching to temptest1_db_1
db_1 |
db_1 |
db_1 |
db_1 | STARTING UP
db_1 |
db_1 | ██ █████ ███ ██ ██████ ██████
db_1 | ██ ██ ██ ████ ██ ██ ██ ██ ██
db_1 | ██ ███████ ██ ██ ██ ██ ██ ██ ██
db_1 | ██ ██ ██ ██ ██ ██ ██ ██ ██ ██
db_1 | ███████ ██ ██ ██ ████ ██████ ██████
db_1 |
db_1 | The best local development tool in the galaxy!
db_1 |
db_1 |
db_1 | ===============================================================
db_1 |
db_1 |
db_1 | userperms 10:18:15.04 INFO ==> Symlinked users .gitconfig.
db_1 | userperms 10:18:15.05 INFO ==> Symlinked users known_hosts
db_1 | userperms 10:18:15.05 INFO ==> This is a debian container
db_1 | userperms 10:18:15.05 INFO ==> user-perms.sh kicking off as user uid=0(root) gid=0(root) groups=0(root)
db_1 | userperms 10:18:15.06 DEBUG ==> Lando ENVVARS set at
db_1 | userperms 10:18:15.06 DEBUG ==>
db_1 | userperms 10:18:15.06 DEBUG ==> ========================================
db_1 | userperms 10:18:15.06 DEBUG ==> LANDO_WEBROOT_USER : app
db_1 | userperms 10:18:15.06 DEBUG ==> LANDO_WEBROOT_GROUP : app
db_1 | userperms 10:18:15.06 DEBUG ==> LANDO_WEBROOT_UID : 1000
db_1 | userperms 10:18:15.07 DEBUG ==> LANDO_WEBROOT_GID : 1000
db_1 | userperms 10:18:15.07 DEBUG ==> LANDO_HOST_UID : 501
db_1 | userperms 10:18:15.07 DEBUG ==> LANDO_HOST_GID : 20
db_1 | userperms 10:18:15.07 DEBUG ==> ========================================
db_1 | userperms 10:18:15.07 DEBUG ==>
db_1 | userperms 10:18:15.07 INFO ==> Making sure correct user:group (app:app) exists...
db_1 | userperms 10:18:15.10 INFO ==> Remapping ownership to handle docker volume sharing...
db_1 | userperms 10:18:15.10 INFO ==> Resetting app:app from 1000:1000 to 501:20
db_1 | userperms 10:18:15.16 INFO ==> app:app is now running as uid=501(app) gid=20(dialout) groups=20(dialout),1000(app)!
db_1 | userperms 10:18:15.17 INFO ==> And here. we. go.
db_1 | userperms 10:18:15.17 INFO ==> Doing the permission sweep.
db_1 | loadkeys 10:18:15.24 INFO ==> Scanning /lando/keys for keys...
db_1 | loadkeys 10:18:15.25 INFO ==> Scanning /var/www/.ssh for keys...
db_1 | loadkeys 10:18:15.26 INFO ==> Scanning /user/.ssh for keys...
db_1 | loadkeys 10:18:15.27 INFO ==> Found keys /user/.ssh/acquia_rsa /user/.ssh/acquia_wf /user/.ssh/andy@n17digital.com.rsa /user/.ssh/atellio_rsa /user/.ssh/bitbucket_rsa /user/.ssh/code_enigma_rsa /user/.ssh/config /user/.ssh/config.bak /user/.ssh/git.codeenigma.com_rsa /user/.ssh/github_boosmith /user/.ssh/github_rsa /user/.ssh/id_rsa /user/.ssh/id_rsa.bkp /user/.ssh/id_rsa.pub.bkp /user/.ssh/known_hosts.old /user/.ssh/n17digital_rsa
db_1 | loadkeys 10:18:15.28 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/acquia_rsa...
db_1 | loadkeys 10:18:15.30 DEBUG ==> Checking whether /user/.ssh/acquia_rsa is a private key...
db_1 | loadkeys 10:18:15.31 DEBUG ==> Checking whether /user/.ssh/acquia_rsa is formatted correctly...
db_1 | loadkeys 10:18:15.32 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/acquia_wf...
db_1 | loadkeys 10:18:15.33 DEBUG ==> Checking whether /user/.ssh/acquia_wf is a private key...
db_1 | loadkeys 10:18:15.34 DEBUG ==> Checking whether /user/.ssh/acquia_wf is formatted correctly...
db_1 | loadkeys 10:18:15.35 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/andy@n17digital.com.rsa...
db_1 | loadkeys 10:18:15.36 DEBUG ==> Checking whether /user/.ssh/andy@n17digital.com.rsa is a private key...
db_1 | loadkeys 10:18:15.36 DEBUG ==> Checking whether /user/.ssh/andy@n17digital.com.rsa is formatted correctly...
db_1 | loadkeys 10:18:15.40 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/atellio_rsa...
db_1 | loadkeys 10:18:15.40 DEBUG ==> Checking whether /user/.ssh/atellio_rsa is a private key...
db_1 | loadkeys 10:18:15.41 DEBUG ==> Checking whether /user/.ssh/atellio_rsa is formatted correctly...
db_1 | loadkeys 10:18:15.43 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/bitbucket_rsa...
db_1 | loadkeys 10:18:15.45 DEBUG ==> Checking whether /user/.ssh/bitbucket_rsa is a private key...
db_1 | loadkeys 10:18:15.45 DEBUG ==> Checking whether /user/.ssh/bitbucket_rsa is formatted correctly...
db_1 | loadkeys 10:18:15.47 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/code_enigma_rsa...
db_1 | loadkeys 10:18:15.49 DEBUG ==> Checking whether /user/.ssh/code_enigma_rsa is a private key...
db_1 | loadkeys 10:18:15.50 DEBUG ==> Checking whether /user/.ssh/code_enigma_rsa is formatted correctly...
db_1 | loadkeys 10:18:15.51 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/config...
db_1 | loadkeys 10:18:15.52 DEBUG ==> Checking whether /user/.ssh/config is a private key...
db_1 | loadkeys 10:18:15.53 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/config.bak...
db_1 | loadkeys 10:18:15.56 DEBUG ==> Checking whether /user/.ssh/config.bak is a private key...
db_1 | loadkeys 10:18:15.56 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/git.codeenigma.com_rsa...
db_1 | loadkeys 10:18:15.57 DEBUG ==> Checking whether /user/.ssh/git.codeenigma.com_rsa is a private key...
db_1 | loadkeys 10:18:15.58 DEBUG ==> Checking whether /user/.ssh/git.codeenigma.com_rsa is formatted correctly...
db_1 | loadkeys 10:18:15.60 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/github_boosmith...
db_1 | loadkeys 10:18:15.63 DEBUG ==> Checking whether /user/.ssh/github_boosmith is a private key...
db_1 | loadkeys 10:18:15.64 DEBUG ==> Checking whether /user/.ssh/github_boosmith is formatted correctly...
db_1 | loadkeys 10:18:15.65 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/github_rsa...
db_1 | loadkeys 10:18:15.66 DEBUG ==> Checking whether /user/.ssh/github_rsa is a private key...
db_1 | loadkeys 10:18:15.68 DEBUG ==> Checking whether /user/.ssh/github_rsa is formatted correctly...
db_1 | loadkeys 10:18:15.69 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/id_rsa...
db_1 | loadkeys 10:18:15.71 DEBUG ==> Checking whether /user/.ssh/id_rsa is a private key...
db_1 | loadkeys 10:18:15.72 DEBUG ==> Checking whether /user/.ssh/id_rsa is formatted correctly...
db_1 | loadkeys 10:18:15.73 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/id_rsa.bkp...
db_1 | loadkeys 10:18:15.76 DEBUG ==> Checking whether /user/.ssh/id_rsa.bkp is a private key...
db_1 | loadkeys 10:18:15.77 DEBUG ==> Checking whether /user/.ssh/id_rsa.bkp is formatted correctly...
db_1 | loadkeys 10:18:15.78 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/id_rsa.pub.bkp...
db_1 | loadkeys 10:18:15.80 DEBUG ==> Checking whether /user/.ssh/id_rsa.pub.bkp is a private key...
db_1 | loadkeys 10:18:15.80 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/known_hosts.old...
db_1 | loadkeys 10:18:15.82 DEBUG ==> Checking whether /user/.ssh/known_hosts.old is a private key...
db_1 | loadkeys 10:18:15.82 DEBUG ==> Ensuring permissions and ownership of /user/.ssh/n17digital_rsa...
db_1 | loadkeys 10:18:15.83 DEBUG ==> Checking whether /user/.ssh/n17digital_rsa is a private key...
db_1 | loadkeys 10:18:15.85 DEBUG ==> Checking whether /user/.ssh/n17digital_rsa is formatted correctly...
db_1 | loadkeys 10:18:15.86 INFO ==> Using the following keys: /user/.ssh/acquia_rsa /user/.ssh/acquia_wf /user/.ssh/andy@n17digital.com.rsa /user/.ssh/bitbucket_rsa /user/.ssh/code_enigma_rsa /user/.ssh/git.codeenigma.com_rsa /user/.ssh/github_boosmith /user/.ssh/github_rsa /user/.ssh/id_rsa /user/.ssh/id_rsa.bkp /user/.ssh/n17digital_rsa
db_1 | platformsh-prepare 10:18:15.88 INFO ==> Ensuring needed files are unmounted...
db_1 | /dev/vda1 on /etc/hosts type ext4 (rw,relatime)
db_1 | platformsh-prepare 10:18:15.89 INFO ==> unmounted /etc/hosts
db_1 | /dev/vda1 on /etc/resolv.conf type ext4 (rw,relatime)
db_1 | platformsh-prepare 10:18:15.91 INFO ==> unmounted /etc/resolv.conf
db_1 | platformsh-prepare 10:18:15.91 INFO ==> Ensuring needed directories exist...
db_1 | platformsh-prepare 10:18:15.94 DEBUG ==> Waiting for /run/shared/agent.sock to be ready...
db_1 | 2021-08-24 10:18:17,301 platformsh.agent DEBUG Running: /etc/platform/boot
db_1 | 2021-08-24 10:18:18,012 root INFO Generating grammar tables from /usr/lib/python2.7/lib2to3/Grammar.txt
db_1 | 2021-08-24 10:18:18,038 root INFO Generating grammar tables from /usr/lib/python2.7/lib2to3/PatternGrammar.txt
db_1 | 2021-08-24 10:18:18,455 platformsh.agent.service INFO Booting container.
db_1 | Generating public/private rsa key pair.
db_1 | Your identification has been saved in /run/rsa_hostkey.
db_1 | Your public key has been saved in /run/rsa_hostkey.pub.
db_1 | The key fingerprint is:
db_1 | SHA256:K7LKfh9jjTp+0kM0dL0SkiM7wmCR1PFBtOJVSARHspE host
db_1 | The key's randomart image is:
db_1 | +---[RSA 2048]----+
db_1 | |.o+=XO.o . |
db_1 | |.o EB.O o . |
db_1 | |.o o B + . . |
db_1 | | + = o . . |
db_1 | | o o .S. |
db_1 | | .o . |
db_1 | | .o* o |
db_1 | | . +=++ |
db_1 | | .+++=.. |
db_1 | +----[SHA256]-----+
db_1 | 2021-08-24 10:18:18,725 platformsh.agent DEBUG Finished: /etc/platform/boot
db_1 | lando 10:18:18.77 INFO ==> Lando handing off to: exec init
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
db_1 | runsvdir /etc/service: warning: unable to stat /etc/service: file does not exist
xaqrox commented
I'm also having the identical problem on Lando instances of multiple Platform.sh projects.
pirog commented
Here is the relevant lando issue: https://github.com/lando/lando/issues/3111
xaqrox commented
Seems to be resolved after the image reversion mentioned in the Lando issue: https://github.com/lando/lando/issues/3111#issuecomment-905095965