The system cannot find the file specified. (Error code 2) at Unable to connect to pipe \\\\.\\pipe\\P_b5205128-88cd-4a50-8448-bd4caaf184fd

Refers to:

  • Plesk for Windows
  • Plesk 12.5 for Linux
  • Plesk 11.5 for Windows

Created:

2016-11-16 13:22:00 UTC

Modified:

2016-12-21 20:33:17 UTC

0

Was this article helpful?


Have more questions?

Submit a request

The system cannot find the file specified. (Error code 2) at Unable to connect to pipe \\\\.\\pipe\\P_b5205128-88cd-4a50-8448-bd4caaf184fd

Symptoms

Duting attempt to re-install MySQL server on Plesk. Installation is failing with error:

configuring MySQL server...
MSI: Error! Critical action 'Configuring MySQL Service...' has been failed:
Command "C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\mysqlmng.exe" --repair
-local-service failed with code 1.
Output:
The system cannot find the file specified. (Error code 2) at Unable to connect t
o pipe \\\\.\\pipe\\P_b5205128-88cd-4a50-8448-bd4caaf184fd
Failed to install 'C:\\ParallelsInstaller\\parallels\\PANEL-WIN_11.0.9\\dist-msi-Mic
rosoft-2003-i386\\mysql-server-configurator.msi': Fatal error during installation
. (Error code 1603)

ERROR: Action sequence 'install: configuring MySQL server...' of package 'mysql-
server-configurator' has been failed with code 1603
Not all packages were installed.
Please, contact product technical support.

"Plesk SQL Server" service is stopped. If you try to start it:

Windows could not start the Plesk SQL Server service on Local Computer.
Error 1067: The process terminated unexpectedly.

At the same time in Windows Logs -> Application found the EventID 100:

Error   8/17/2013 2:44:59 PM    MySQL   100 None
Do you already have another mysqld server running on port: 3306 ?

Cause

Improperly set registry value:

HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\PleskSQLServer\\ImagePath

It could be happen if somebody ran C:\\ParallelsInstaller\\parallels\\PANEL-WIN_11.0.9\\dist-msi-Microsoft-2003-i386\\mysql-admin.msi manually.

Resolution

  1. Repair HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\PleskSQLServer\ImagePath value.

  2. Check also that all sub-directories are present:

    C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\
    C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data\\
    C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\include\\
    C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\lib\\
    C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\scripts\\
    C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\share\\

Example of the my.ini :

    [PleskSQLServer]
port=8306
basedir=C:\\\\Program Files (x86)\\\\Parallels\\\\Plesk\\\\MySQL
datadir=C:\\\\Program Files (x86)\\\\Parallels\\\\Plesk\\\\MySQL\\\\Data
default-character-set=latin1
default-storage-engine=INNODB
query_cache_size=8M
table_cache=32
tmp_table_size=7M
thread_cache=32
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=2M
key_buffer_size=2M
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=300
key_buffer=4M
max_allowed_packet=1M
sort_buffer=256K
net_buffer_length=4K
old_passwords=0
tmpdir=C:\\\\Program Files (x86)\\\\Parallels\\\\Plesk\\\\MySQL\\\\Data
connect_timeout=20
[client]
port=8306
  1. Make sure that values of parameters like innodb_buffer_pool_size , innodb_log_file_size , innodb_additional_mem_pool_size do not exceed system resources. For additional information, please refer to MySQL documentation .
Have more questions? Submit a request
Please sign in to leave a comment.