Note: My apologies for the lousy title of this issue. I meant to go back and work on that before submitting!

I had a root password with a "[" symbol in the password. After the install completed, Aegir worked fine except the localhost server would not verify due to an error that Aegir could not access "root@localhost". Upon inspection, the "[" was saved to the hosting_db_server password field as an escaped character. To get the site to verify, I had to change the password in the database.

Let me know if you have any questions and if I can dig more to help resolve.

Thanks!
shrop

Comments

notzach’s picture

notzach commented

I had the same problem running Aegir 6.x-1.6 on RHEL 6.

steven jones’s picture

steven jones commented
Title: MySQL root password » MySQL root password incorrectly escaped in frontend
Priority: Normal » Major

Titles are easy to fix.

@shrop I'd love to get this fixed, was the password incorrectly escaped in the DB, is that what you're saying?

shrop’s picture

shrop commented

Yes. I actually saw it in the db escaped. I changed it there and it worked on verify. Notzach told me that he changed it in the Aegir interface and it fixed things too. So it appears to be an install only issue at this point. Let me know if I can test anything or provide additional info.

steven jones’s picture

steven jones commented

Okay, for clarity, can you confirm that if my MySQL root password was say:

root[pass

Then that would fail along the line somewhere?

shrop’s picture

shrop commented

Yep. It fails if the password if "root[pass", but only when you enter the during the install process. Looks like it works in a running Aegir instance, if you try to change the pw for the master mysql server.

The verify of localhost is what actually fails because it can't connect to the mysql server with an incorrect password.

steven jones’s picture

steven jones commented
Assigned: Unassigned » steven jones

Let's have a look at what's going on here.

steven jones’s picture

steven jones commented
Status: Active » Fixed

Ah, so the installer was importing the DB password incorrectly, I think this means that you should now be able to use special characters in the DB password!

commit:1826305e921c9a2eafc0a9c1d56c1c641f9cdded

steven jones’s picture

steven jones commented

@shrop Huge thanks for the bug report.

shrop’s picture

shrop commented

Thanks for fixing this up for us all! :)

omega8cc’s picture

omega8cc commented
Version: 6.x-1.7 » 6.x-2.x-dev
Status: Fixed » Patch (to be ported)

This patch is missing in 6.x-2.x

steven jones’s picture

steven jones commented
Status: Patch (to be ported) » Fixed

Done in 7cb11bc3589695f0c45b48eb79f65e2fbd383d6f

Status: Fixed » Closed (fixed)

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

Anonymous’s picture

(not verified) commented
Issue summary: View changes

Added note about the title of the issue

  • Commit 7cb11bc on 6.x-2.x, dev-ssl-ip-allocation-refactor, dev-1205458-move_sites_out_of_platforms, 7.x-3.x, dev-588728-views-integration, dev-1403208-new_roles, dev-helmo-3.x by Steven Jones: 
    Issue #1485746 by shrop, Steven Jones: Fixed MySQL root password...

  • Commit 7cb11bc on 6.x-2.x, dev-ssl-ip-allocation-refactor, dev-1205458-move_sites_out_of_platforms, 7.x-3.x, dev-588728-views-integration, dev-1403208-new_roles, dev-helmo-3.x by Steven Jones: 
    Issue #1485746 by shrop, Steven Jones: Fixed MySQL root password...