why mysql server sometimes failed to install ?

[goldeneaglesteam]

hi,

i create this custom action to install mysql server 5.7.21

Code: Select all

community install server;5.7.21;X86:*:servertype=Server;Port=3309;ServiceName=mysqlss;passwd=123 -silent

Capture.PNG (13.93 KiB) Viewed 10012 times

i tested it on windows 7 sp1 & windows 8 & windows 10, it run fine but sometimes i found that "mysqlss" service created but mysql server not installed.
why mysql server sometimes failed to install ?
1- there any way to prevent create the service if the mysql server not installed successfully?
2- any method to delete the service if i uninstalled the program ?
3- there are any application instead mysql server and work fine (mysql cluster,....)?

[Daniel]

Hello,

To troubleshoot your MySql installation I would recommend you to try manually installing it (e.g. running the same install command line outside of the setup package process) and try to create an installation log.

To prevent or undo the service creation, you could try to develop your own custom action which will delete the service if the server was not installed properly. However, you should run a small research about how to implement such design.

To delete the service on setup uninstall you could use another custom action which will run a service uninstall operation. The custom action should be configured to run only on uninstall. You can configure this from Execution Condition section in the right pane settings of your custom action.

As a starting point for your setup project you could have a look on our "How to install mysql server 5.0 and Connector silently" and "MySql server installation fails with MySQLInstallerConsole as custom action" threads.

All the best,
Daniel

[goldeneaglesteam]

i checked Log file C:\ProgramData\MySQL\MySQL Installer for Windows\Logs

Code: Select all

mysql-installer Information: 10 : Configuration file found.
mysql-installer Information: 10 : Loaded configuration.
mysql-installer Information: 10 : Saving configuration.
mysql-installer Information: 10 : Package - setting up controller
mysql-installer Information: 10 : Loading controllers from C:\Program Files (x86)\MySQL\MySQL Installer for Windows\MySQLInstaller.Core.dll
mysql-installer Information: 10 : Loading controllers from C:\Program Files (x86)\MySQL\MySQL Installer for Windows\StandardPlugins.dll
mysql-installer Information: 10 : Creating configuration controller for: mysql-server.
mysql-installer Information: 10 : Product configuration controller created.
mysql-installer Information: 10 : Package - Initializing controller
mysql-installer Information: 10 : Package - Installed - Loading controller state
mysql-installer Information: 10 : Product Configuration Controller - Initializing controller
mysql-installer Information: 10 : Product Configuration Controller - Loading Settings state
mysql-installer Information: 10 : Controller Settings - Load Load Defaults For Install - load and set default settings
mysql-installer Information: 10 : Server Settings - Load Ini Defaults - setting initial ini values
mysql-installer Information: 10 : Beginning changes for MySQL Server 5.7.21 with options REBOOT=ReallySuppress  ADDLOCAL=ALL INSTALLDIR="C:\Program Files (x86)\MySQL\MySQL Server 5.7" INSTALLLOCATION="C:\Program Files (x86)\MySQL\MySQL Server 5.7" ARPINSTALLLOCATION="C:\Program Files (x86)\MySQL\MySQL Server 5.7" INSTALL_ROOT="C:\Program Files (x86)\MySQL\MySQL Server 5.7"  DATADIR="C:\ProgramData\MySQL\MySQL Server 5.7" ALLUSERS=1
mysql-installer Information: 10 : MySQL Server 5.7.21's change state request failed.
mysql-installer Information: 10 : Server Settings - Load Ini Defaults - setting initial ini values
mysql-installer Information: 10 : Starting configuration of MySQL Server 5.7.21
mysql-installer Information: 10 : Attempting to create firewall rule with command: netsh.exe  firewall delete portopening protocol=TCP port=3306 profile=ALL
mysql-installer Information: 10 : Adding firewall rule for mysqlss on port 3309.
mysql-installer Information: 10 : Attempting to create firewall rule with command: netsh.exe  firewall add portopening protocol=TCP port=3309 profile=ALL name=mysqlss mode=ENABLE scope=ALL
mysql-installer Information: 10 : Successfully added firewall rule.
mysql-installer Information: 10 : Attempting to grant Network Service require filesystem permissions.
mysql-installer Information: 10 : Granted permissions.
mysql-installer Information: 10 : Adding new service
mysql-installer Information: 10 : New service added
mysql-installer Information: 10 : Attempting to run MySQL Server with --initialize-insecure option...
mysql-installer Information: 10 : Starting process for MySQL Server 5.7.21...
mysql-installer Information: 10 : Finished configuration of MySQL Server 5.7.21 with state ConfigurationError

[goldeneaglesteam]

2- i tried to install Mysql Server 8.0.12 (latest) and it seem that it have Mysql Server 8.0.12 X68 only , and i used this command action

Code: Select all

community install server;8.0.12;X64:*:servertype=Server;Port=3309;ServiceName=mysqlss;passwd=123 -silent

but this error appears also ..

Code: Select all

mysql-installer Information: 10 : Configuration file found.
mysql-installer Information: 10 : Loaded configuration.
mysql-installer Information: 10 : Saving configuration.
mysql-installer Information: 10 : Package - setting up controller
mysql-installer Information: 10 : Loading controllers from C:\Program Files (x86)\MySQL\MySQL Installer for Windows\MySQLInstaller.Core.dll
mysql-installer Information: 10 : Loading controllers from C:\Program Files (x86)\MySQL\MySQL Installer for Windows\StandardPlugins.dll
mysql-installer Information: 10 : Creating configuration controller for: mysql-server.
mysql-installer Information: 10 : Product configuration controller created.
mysql-installer Information: 10 : Package - Initializing controller
mysql-installer Information: 10 : Package - Installed - Loading controller state
mysql-installer Information: 10 : Product Configuration Controller - Initializing controller
mysql-installer Information: 10 : Product Configuration Controller - Loading Settings state
mysql-installer Information: 10 : Controller Settings - Load Load Defaults For Install - load and set default settings
mysql-installer Information: 10 : Server Settings - Load Ini Defaults - setting initial ini values
mysql-installer Information: 10 : Beginning changes for MySQL Server 8.0.12 with options REBOOT=ReallySuppress  ADDLOCAL=ALL INSTALLDIR="C:\Program Files\MySQL\MySQL Server 8.0" INSTALLLOCATION="C:\Program Files\MySQL\MySQL Server 8.0" ARPINSTALLLOCATION="C:\Program Files\MySQL\MySQL Server 8.0" INSTALL_ROOT="C:\Program Files\MySQL\MySQL Server 8.0"  DATADIR="C:\ProgramData\MySQL\MySQL Server 8.0" ALLUSERS=1
mysql-installer Information: 10 : MySQL Server 8.0.12's change state request failed.
mysql-installer Information: 10 : Server Settings - Load Ini Defaults - setting initial ini values
mysql-installer Information: 10 : Starting configuration of MySQL Server 8.0.12
mysql-installer Error: 50 : Value cannot be null.
Parameter name: path
mysql-installer Information: 10 : Attempting to delete a Windows Firewall rule with command: netsh.exe advfirewall firewall delete rule name="Port 3306" protocol=TCP localport=3306
mysql-installer Information: 10 : 
No rules match the specified criteria.


mysql-installer Information: 10 : An error occurred running netsh.exe delete:
The netsh.exe process did not return any error. Review the application log to see if there is a trace of the error.
mysql-installer Information: 10 : The attempt to delete a Windows Firewall rule failed.
You can add or delete a Windows Firewall rule manually by following the instructions at this URL:
http://windows.microsoft.com/en-US/windows-vista/Allow-a-program-to-communicate-through-Windows-Firewall
mysql-installer Information: 10 : Adding a Windows Firewall rule for mysqlss on port 3309.
mysql-installer Information: 10 : Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3309" protocol=TCP localport=3309 dir=in action=allow
mysql-installer Information: 10 : Ok.


mysql-installer Information: 10 : Successfully added the Windows Firewall rule.
mysql-installer Information: 10 : Attempting to grant Network Service require filesystem permissions.
mysql-installer Information: 10 : Granted permissions.
mysql-installer Information: 10 : Adding new service
mysql-installer Information: 10 : New service added
mysql-installer Information: 10 : Attempting to run MySQL Server with --initialize-insecure option...
mysql-installer Information: 10 : Starting process for MySQL Server 8.0.12...
mysql-installer Information: 10 : Finished configuration of MySQL Server 8.0.12 with state ConfigurationError

i tried to use cmd.exe and run this command and it work :

Code: Select all

C:\Program Files (x86)\MySQL\MySQL Installer for Windows\MySQLInstallerConsole.exe community install server;5.7.19;X86:*:servertype=Server;Port=3309;ServiceName=mysql7;passwd=123 -silent

[Daniel]

Hello,

I am afraid I cannot say why this error appears. If the manual installation of the MySQL Server fails too, then I would recommend you to try further investigating this on MySQL Server forums.

Thank you for your understanding.

All the best,
Daniel