Bug #78792 Installer Console doesn't show the server package that correspond to the bundle
Submitted: 9 Oct 2015 21:58 Modified: 18 Aug 2022 15:57
Reporter: Jose Gabriel Valencia Ornelas Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S3 (Non-critical)
Version:1.4.11 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[9 Oct 2015 21:58] Jose Gabriel Valencia Ornelas
Description:
this bug is related to http://bugs.mysql.com/bug.php?id=75171

when is installed using the quiet command to use the MySQL Installer Console sometimes doesn't allow to install the server package that it shipped in the bundle, it start in the previous version, however if the user specify exactly the version to use, the installer allows to install the version shipped.

How to repeat:
Download the latest bundle mysql-installer-community-5.6.27.0.msi

install with quiet command to don't start the GUI
C:\Program Files (x86)\MySQL\MySQL Installer for Windows>msiexec /i mysql-instal
ler-community-5.6.27.0.msi /qn

try to install some version of 5.6

C:\Program Files (x86)\MySQL\MySQL Installer for Windows>MySQLInstallerConsole.e
xe install server;5.6;x64:*:type=config;openfirewall=true;generallog=true;binlog
=true;serverid=3306;enable_tcpip=true;port=3306;rootpasswd=root;installdir="c:\M
ySQL\MySQL Server 5.6":type=user;username=user;password=password;role=DBManager
=================== Start Initialization ===================
MySQL Installer is running in Community mode

Attempting to update manifest.
Initializing product requirements
Loading product catalog
Checking for product catalog snippets
Checking for product packages in the bundle
Categorizing product catalog
Finding all installed packages.
Your product catalog was last updated at 09/10/2015 04:03:04 p. m.
=================== End Initialization ===================

Install MySQL Server 5.6.26-X64? [Y/N]^C

but if is specified exactly the version 5.6.27 works fine

C:\Program Files (x86)\MySQL\MySQL Installer for Windows>MySQLInstallerConsole.e
xe install server;5.6.27;x64:*:type=config;openfirewall=true;generallog=true;bin
log=true;serverid=3306;enable_tcpip=true;port=3306;rootpasswd=root;installdir="c
:\MySQL\MySQL Server 5.6":type=user;username=user;password=password;role=DBManag
er
=================== Start Initialization ===================
MySQL Installer is running in Community mode

Attempting to update manifest.
Initializing product requirements
Loading product catalog
Checking for product catalog snippets
Checking for product packages in the bundle
Categorizing product catalog
Finding all installed packages.
Your product catalog was last updated at 09/10/2015 04:03:04 p. m.
=================== End Initialization ===================

The following products will be installed.
    MySQL Server 5.6.27-X64
Press [Y] to continue, any other character to abort.Y
[Install]  MySQL Server 5.6.27 X64...................done!
Product installations done.

MySQL Server 5.6.27 - Users can only be specified when installing new products.
Starting product configurations ...

Configuring MySQL Server 5.6.27
Stopping Server [if necessary] - Done!
Writing configuration file - Done!
Updating firewall - Done!
Adjusting Windows service [if necessary] - Done!
Updating server - Done!
Initializing Database [if necessary] - Done!
Starting Server - Done!
Applying security settings - Done!
Creating user accounts - Done!
Updating Start Menu Link - Done!
Configuration of MySQL Server 5.6.27 has completed successfully!
Finished configuring all selected products.

NOTE: if the user execute an update to the catalog, then the installer shows correctly the 5.6.27 

C:\Program Files (x86)\MySQL\MySQL Installer for Windows>MySQLInstallerConsole.e
xe update
=================== Start Initialization ===================
MySQL Installer is running in Community mode

Initializing product requirements
Loading product catalog
Checking for product catalog snippets
Checking for product packages in the bundle
Categorizing product catalog
Finding all installed packages.
Your product catalog was last updated at 09/10/2015 04:03:04 p. m.
=================== End Initialization ===================

Connected to remote catalog host
Catalog download completed successfully
Initializing product requirements
Loading product catalog
Checking for product catalog snippets
Checking for product packages in the bundle
Categorizing product catalog
Finding all installed packages.
Update done

C:\Program Files (x86)\MySQL\MySQL Installer for Windows>MySQLInstallerConsole.e
xe install server;5.6;x64:*:type=config;openfirewall=true;generallog=true;binlog
=true;serverid=3306;enable_tcpip=true;port=3306;rootpasswd=root;installdir="c:\M
ySQL\MySQL Server 5.6":type=user;username=user;password=password;role=DBManager
=================== Start Initialization ===================
MySQL Installer is running in Community mode

Attempting to update manifest.
Initializing product requirements
Loading product catalog
Checking for product catalog snippets
Checking for product packages in the bundle
Categorizing product catalog
Finding all installed packages.
Your product catalog was last updated at 09/10/2015 04:49:49 p. m.
=================== End Initialization ===================

Install MySQL Server 5.6.27-X64? [Y/N]^C

Suggested fix:
The problem looks to be an issue reading the catalog files, before doing the update the 5.6.27 are not in the products.xml, instead the entries are in  a snippets file snippets.xml, the installer it suppose to "merge" those two files when the catalog is being loaded, but apparently is not taking in consideration this snippet file when is displaying the options to install, when the update is downloaded and applied then entries for 5.6.27 are now in the products.xml and snippet file is empty or doesn't exists

please make sure that the list of severs take care the snippet file or generate that list after the merge of snippet.xml and products.xml is done to ensure that display the current server available
[21 Jul 2022 18:07] Jose Ramirez
Posted by developer:
 
When running the CLI in silent mode, a commercial settings file was automatically created even if the Installer bundle was GPL. This caused incorrected products to be shown when attempting to install products. This has been corrected and now the correct settings file is being created accordingly.
[18 Aug 2022 15:57] Christine Cole
Posted by developer:
 
Fixed in MySQL Installer 1.6.4 by another work item. No changelog entry needed.