Error establishing a database connection. When using Wordpress 6.2

[cabsil22]

Hi there and thanks for the amazing work you've done.

When using this in my .env:

#Site image
SITE_IMAGE=wordpress
SITE_VERSION=6.2

The WP cli doesn't work.

I'm don't know how to troubleshoot further. I ran into the problem when trying to use the update site name script provided in the wordpress folder.

I may have tracked it down to the Wordpress version. It works when I use 4.6 for the site version.

Any pointers on how to troubleshoot would be awesome!

Thanks again.

edit:
The output i get when trying to run wp.sh is: (I replaced my domain with "site" in the following)

...:/home/root/server/sites/dev2.site.org/compose# ./wp.sh
/snap/docker/2746/lib/python3.6/site-packages/paramiko/transport.py:32: CryptographyDeprecationWarning: Python 3.6 is no longer supported by the Python core team. Therefore, support for it is deprecated in cryptography. The next release of cryptography (40.0) will be the last to support Python 3.6.
from cryptography.hazmat.backends import default_backend
Creating site-m0dff_wpcli_run ... done
Error: Error establishing a database connection.
ERROR: 1

[cabsil22]

I have found that it has something to do with the different syntax of the wp-config file.

If I replace the following lines with hard coded definitions instead of getenv_docker() methods, it works.

`define( 'DB_NAME', getenv_docker('WORDPRESS_DB_NAME', 'wordpress') );

/** Database username */
define( 'DB_USER', getenv_docker('WORDPRESS_DB_USER', 'example username') );

/** Database password */
define( 'DB_PASSWORD', getenv_docker('WORDPRESS_DB_PASSWORD', 'example password') );

/**

• Docker image fallback values above are sourced from the official WordPress installation wizard:
• https://github.com/WordPress/WordPress/blob/f9cc35ebad82753e9c86de322ea5c76a9001c7e2/wp-admin/setup-config.php#L216-L230
• (However, using "example username" and "example password" in your database is strongly discouraged. Please use strong, random credentials!)
  */

/** Database hostname */
define( 'DB_HOST', getenv_docker('WORDPRESS_DB_HOST', 'mysql') );

/** Database charset to use in creating database tables. */
define( 'DB_CHARSET', getenv_docker('WORDPRESS_DB_CHARSET', 'utf8') );

/** The database collate type. Don't change this if in doubt. */
define( 'DB_COLLATE', getenv_docker('WORDPRESS_DB_COLLATE', '') );`

[cabsil22]

As mentioned, I'm pretty new to all this. So I don't know how to implement a fix for this yet, but I did find people discussing what looks like the problem.

docker-library/docs#1911

[cabsil22]

I chased this down to an issue with the tatemz/wp-cli image used in the https://github.com/evertramos/docker-wordpress repo.

I solved my issue by changing to the official wordpress:cli image and adding env variables to it.

See:
evertramos/docker-wordpress#67