The MySQL password I used contained a # in the middle. It's a valid mysql password, and I could use it to log in from any client.

When I entered the password during the Aegir install.sh process, I would get an error message as in #894004. I couldn't see a problem with my setup, so I tried changing the root password. Then the Aegir install.sh worked perfectly.

Comments

anarcat’s picture

Status: Active » Fixed

We don't handle the mysql root password in install.sh anymore.

petrpo’s picture

Issue tags: +notes

Hello,

in 2 days of searching and going around a hot pot :-) I luckily have found this issue. I have the same problem. I had '++' in the end of root password and installation script ended with error :

The following settings will be used:
Aegir frontend URL: localhost.localdomain
Master server FQDN: localhost.localdomain
Aegir root: /var/aegir
Aegir user: aegir
Web group: www-data
Web server: apache
Aegir DB host: localhost
Aegir DB user: root
Aegir DB password:
Drush make version: 6.x-2.0-beta9
Aegir version: 0.4-beta2
Aegir platform path: /var/aegir/hostmaster-0.4-beta2
Aegir makefile: /var/aegir/.drush/provision/aegir.make
Client email: my-email@gmeyl.com

Do you really want to proceed with the install (y/n): y
The external command could not be executed due to an application error. [error]
SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES) [error]
Drush command could not be completed. [error]
Output from failed command : [error]

Fatal error: Call to a member function quote() on a non-object in
/var/aegir/.drush/provision/db/db.drush.inc on line 326

Output from failed command : [error]

Output from failed command : [error]

An error occurred at function : drush_provision_hostmaster_install [error]

After changing of root password to chars and numbers installation was done without problems.

Petr

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

ToRum’s picture

Problem also occurs for MySQL password saved in .drush/server_localhost.alias.drushrc.php: if it contains special chars like "#" the connection is lost (even when editing/saving by web interface). The web interface and/or Provision should properly escape this # character.

ToRum’s picture

Status: Closed (fixed) » Needs work
anarcat’s picture

Title: install.sh does not properly escape the mysql root password » installer does not properly escape the mysql root password
Issue tags: +installer
Mark F’s picture

i'm getting a very similar problem using Aegir 1.3.

butler360’s picture

Same here with 1.3, would not connect with # in password.

Steven Jones’s picture

Version: 6.x-0.4-alpha3 » 6.x-1.x-dev
Assigned: Unassigned » Steven Jones

I'm fairly certain that this is a really easy fix, just need to urlencode things as they are saved into the context. Just need to test things, and a fix should be committed shortly.

Steven Jones’s picture

Status: Fixed » Closed (fixed)
Issue tags: -notes, -installer

Automatically closed -- issue fixed for 2 weeks with no activity.

  • Commit d6c8b83 on 6.x-1.x, dev-ssl-ip-allocation-refactor, dev-1205458-move_sites_out_of_platforms, 7.x-3.x, dev-subdir-multiserver, 6.x-2.x-backports, dev-helmo-3.x by Steven Jones:
    Issue #983056 by Steven Jones: Fixed installer does not properly escape...
  • Commit 95845b5 on 7.x-2.x, dev-ssl-ip-allocation-refactor, dev-1205458-move_sites_out_of_platforms, 7.x-3.x, dev-subdir-multiserver, 6.x-2.x-backports, dev-helmo-3.x by Steven Jones:
    Issue #983056 by Steven Jones: Fixed installer does not properly escape...