Special characters in password cause trouble.

While doing fresh install of CiviCRM 5.38.0 on top of WordPress 5.7 using the WordPress installer GUI I wanted to switch to a different database other than installing in WordPress DB. All my attempts to edit the configuration line would fail. CiviCRM Database mysql://wordpress:HIDDEN@localhost/wordpress| I eventually chose to use the WordPress DB and succeed. Later while reading the documentation about setting up a cron job I saw the warning about not to use certain special characters in passwords. So I went back and removed the # from my password and was able to install into a separate DB. My conclusion is that the edit GUI needs to include that warning about special characters.

Thanks for the report @applemuncy

I can confirm the report on both WP and Drupal 7.

Apache 2.4
MariaDB 10.3
php 7.3
WP 5.7.2
Drupal 7.8.1

Both used CiviCRM 5.38.0

AFAICS, the problem is limited to the installer. If you can produce a civicrm.settings.php file with a CIVICRM_DSN, then it will work. The main thing to note that is CIVICRM_DSN is a URL - which means that some symbols require %-encoding.

@applemuncy @kcristiano This patch should allow one to install on systems with funny passwords: https://github.com/civicrm/civicrm-core/pull/20713

PR has been merged into master (5.40) so closing this

closed

changed milestone to %5.40.0

mentioned in commit dd589f53

mentioned in commit 947f718c