Database port missing in Magento Setup Model

[tkn98]

The database connection in the Magento Setup Model does not take the database port setting into account.

[tkn98]

You can reporduce that by checking out an existing shop that needs setup updates and has the database on a non-standard port. In development mode, Magento gives in the browser a message like (shortened):

Please upgrade your database: Run "bin/magento setup:upgrade" from the Magento root directory. 
The following modules are outdated:
Magento_Customer schema: current version - 2.0.4, required version - 2.0.6
Magento_Customer data: current version - 2.0.4, required version - 2.0.6
Magento_Catalog schema: current version - 2.0.0, required version - 2.0.3
Magento_Catalog data: current version - 2.0.0, required version - 2.0.3
Magento_Quote schema: current version - 2.0.0, required version - 2.0.1
Magento_Quote data: current version - 2.0.0, required version - 2.0.1
Magento_Sales schema: current version - 2.0.0, required version - 2.0.1
Magento_Sales data: current version - 2.0.0, required version - 2.0.1
Magento_User schema: current version - 2.0.0, required version - 2.0.1
Magento_User data: current version - 2.0.0, required version - 2.0.1
[...]

You will see failure when running the suggested command like php -f bin/magento -- setup:upgrade, e.g. an exception message like:

  [Zend_Db_Adapter_Exception]                                                             
  SQLSTATE[28000] [1045] Access denied for user 'dbuser'@'localhost' (using password: YES)  

Which is Magento trying to connect to the database server running on the standard port (which is not the one configured) and it only get's an error because in this case the database-user and password is different. The flaw however is inherit: Magento does not use the configured database port for the information shema connection (!).

The PR #2735 leviates this issue however only for the port configuration. In general the flaw results in the different kind of configuration processing within the setup layer and other layers that instantiates via the older PDO DSN creating in near Zend_DB which only blacklists some configuration items (setup uses a whitelist of configuration items).

[tkn98]

There is consensus in #2735 discussion to block the "port" entry instead (which will solve this issue) , therefore I close it now. The internal Magento ticket is MAGETWO-47110.

Port is to be set via the "host" entry: <host>:<port> (this already works as of today).

No implementation date has been given yet.