Unable to install Horde webmail: Access denied for user 'horde'@'127.0.0.1' (using password: YES)

Created:

2016-11-16 12:40:55 UTC

Modified:

2017-04-24 12:15:28 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to install Horde webmail: Access denied for user 'horde'@'127.0.0.1' (using password: YES)

Applicable to:

  • Plesk 11.0 for Windows

Symptoms

An attempt to install Horde fails with the following error:

MSI: Error! Critical action 'Creating Horde database schema...' has been failed:
Command "C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\mysql.exe" -uhorde -***** horde < "C:\\Inetpub\\vhosts\\webmail\\horde\\scripts\\sql\\create.mysql.sql" failed with code 1.
Output:
ERROR 1045 (28000): Access denied for user 'horde'@'127.0.0.1' (using password: YES)

at (CmdAction::Commit line 434)
at Execute action Creating Horde database schema...(executeList line 309)
Failed to install 'C:\\ParallelsInstaller\\parallels\\PANEL-WIN_11.0.9\\dist-msi-Microsoft-2003-i386\\webmail.msi': Fatal error during installation. (Error code 1603)

ERROR: Action sequence 'install: installing Horde webmail...' of package 'webmail' has been failed with code 1603
Not all packages were installed.
Please, contact product technical support.

The following error can be observed in the C:\\ParallelsInstaller\\autoinstall3.log :

MSI: (14:03:57) Successful action Creating Horde database...
MSI: (14:03:57) Start action Creating Horde database schema...
Creating Horde database schema...
MSI: Execute "C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\mysql.exe" -uhorde -p0LqS0iv7p6KN horde < "C:\\Inetpub\\vhosts\\webmail\\horde\\scripts\\sql\\create.mysql.sql"
MSI: Critical action 'Creating Horde database schema...' has been failed:
Command "C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\mysql.exe" -uhorde -***** horde < "C:\\Inetpub\\vhosts\\webmail\\horde\\scripts\\sql\\create.mysql.sql" failed with code 1.
Output:
ERROR 1045 (28000): Access denied for user 'horde'@'127.0.0.1' (using password: YES)

at (CmdAction::Commit line 434)
at Execute action Creating Horde database schema...(executeList line 309)
MSI: Error! Critical action 'Creating Horde database schema...' has been failed:
Command "C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\mysql.exe" -uhorde -***** horde < "C:\\Inetpub\\vhosts\\webmail\\horde\\scripts\\sql\\create.mysql.sql" failed with code 1.
Output:
ERROR 1045 (28000): Access denied for user 'horde'@'127.0.0.1' (using password: YES)

Cause

Configuration file of client MySQL server ( %plesk_dir%/Databases/MySQL/data/my.ini ) includes the following strings that prevents user to connect to 127.0.0.1 host:

skip-name-resolve   
skip-host-cache

The skip-name-resolve option disables DNS host name lookups. In this case, the server uses only IP addresses and not host names to match connecting hosts to rows in the MySQL grant tables. So the bindings in %SystemRoot%\\system32\\drivers\\etc\\hosts will not be read.

The skip-host-cache disables the host cache that is enabled by default.

Please refer to this manual for additional information.

Resolution

  1. Сomment out the skip-name-resolve and skip-host-cache options in the client MySQL server configuration file (default location is %plesk_dir%/Databases/MySQL/data/my.ini ).

  2. Restart MySQL Server.

    To do that you may use Start > All Program > Parallels Plesk Panel > Plesk Service Monitor

  3. Try to install Horde webmail.

    You may use the "%plesk_bin%\\ai.exe" --console command to run autoinstaller.

Have more questions? Submit a request
Please sign in to leave a comment.