Bug #82354 mysqlrouter init script hangs because a password prompt is waiting in the backgr
Submitted: 27 Jul 2016 8:38 Modified: 29 Aug 2019 19:15
Reporter: Alexander Manhart Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Router Severity:S3 (Non-critical)
Version:2.0.3 OS:Debian (Jessie)
Assigned to: Bogdan Kecman CPU Architecture:Any

[27 Jul 2016 8:38] Alexander Manhart
Description:
We use the repository of mysql (repo.mysql.com) with the newest packages of mysql-5.7, mysql-utilities-1.5.

Since Version 2.0.2 the Debian init script for mysqlrouter (/etc/init.d/mysqlrouter) isn't working with MySQL Fabric. The init script is hanging in the background and awaits the prompt for a password.

The reason is, that you changed "The configuration file no longer accepts a password for the Fabric Cache plugin. Instead, MySQL Router prompts for the password at startup."

How to repeat:
Install router 2.0.3 and fabric (mysql-utilities-1.5) from repo.mysql.com in Debian Jessie and try to connect/configure router with fabric+cache, e.g.:

/etc/mysql/fabric.cfg

[protocol.mysql]
address = localhost:32275
user = admin
password = xyz
disable_authentication = no
ssl_ca =
ssl_cert =
ssl_key =

/etc/mysqlrouter/mysqlrouter.ini

[fabric_cache]
address = 127.0.0.1:32275
user = admin
# password not working here since 2.0.2

[routing:intranet_ha]
bind_address = 0.0.0.0:7002
destinations = fabric+cache:///group/myservers?allow_primary_reads=yes
mode = read-only
[29 Aug 2019 19:15] Bogdan Kecman
Hi,

if you look at https://www.mysql.com/support/eol-notice.html

you will notice that since July 6, 2017 

MySQL Fabric is now covered under Oracle Lifetime Sustaining Support

Per Oracle's Lifetime Support policy, as of July 6, 2017, MySQL Fabric is covered under Oracle Sustaining Support.

Users are encouraged to migrate to MySQL InnoDB Cluster.
[29 Aug 2019 19:16] Bogdan Kecman
Hi,

Also wrt mysql utilities, same url

May 30, 2018

MySQL Utilities is now covered under Oracle Lifetime Sustaining Support

Per Oracle's Lifetime Support policy, as of May 30, 2018, MySQL Utilities is covered under Oracle Sustaining Support.

Users are encouraged to migrate to MySQL Shell.