MySQL Bugs: #82354: mysqlrouter init script hangs because a password prompt is waiting in the backgr

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

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

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.

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.