MySQL Forums
Forum List  »  Utilities

Login-path configuration on mysql-utilities
Posted by: D BA
Date: July 20, 2018 12:19AM

Hello,

I try to use mysql-utilities (1.6.1-2) with login-path from my Ubuntu desktop (4.13.0-45-generic #50~16.04.1-Ubuntu SMP) to MySQL server 5.7.22 on Ubuntu server 16.04 (4.4.0-116-generic #140-Ubuntu SMP).
(I try to format this post but I didn't find the shortcut for code ...)


# Create the login paths
mysql_config_editor set --login-path="master" --host="pre-testmysqldba01x" --user="test" --password

mysql_config_editor set --login-path="slave" --host="pre-testmysqldba02x" --user="test" --password

# Show config editor information
mysql_config_editor print --all
[slave]
user = test
password = *****
host = pre-testmysqldba02x
[master]
user = test
password = *****
host = pre-testmysqldba01x

# Test configuration
mysql --login-path=master

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 24
Server version: 5.7.22-0ubuntu0.16.04.1-log (Ubuntu)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show variables like '%hostname%';
+---------------+----------------------+
| Variable_name | Value |
+---------------+----------------------+
| hostname | pre-testmysqldba01x |
+---------------+----------------------+
1 row in set (0.00 sec)

mysql --login-path=slave
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37
Server version: 5.7.22-0ubuntu0.16.04.1-log (Ubuntu)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show variables like '%hostname%';
+---------------+----------------------+
| Variable_name | Value |
+---------------+----------------------+
| hostname | pre-testmysqldba02x |
+---------------+----------------------+
1 row in set (0.00 sec)

# MySQL server info
mysqlserverinfo --server=master --format=grid
ERROR: Server connection values invalid: ('Missing connection value for port or socket option', 0).
mysqlserverinfo --server=master:3306 --format=grid
ERROR: Access denied for user 'test'@'pre-testmysqldba01x' using password: YES
mysqlserverinfo --server=master:3306:/var/run/mysqld/mysqld.sock --format=grid
ERROR: Access denied for user 'test'@'pre-testmysqldba01x' using password: YES

Same error, if I add inside the login-path, the information port and socket...

# Check Replication command
mysqlrplcheck --master=master --slave=slave
Usage: mysqlrplcheck --master=root@localhost:3306 --slave=root@localhost:3310

mysqlrplcheck: error: Master connection values invalid: Missing connection value for port or socket option.

mysqlrplcheck --master=master:3306:/var/run/mysqld/mysqld.sock --slave=slave:3306:/var/run/mysqld/mysqld.sock
ERROR: You must specify two different servers for the operation.

# Without login-path
mysqlserverinfo --server=test:test@pre-testmysqldba01x, it's working
mysqlserverinfo --server=test:test@pre-testmysqldba02x, it's working

mysqlrplcheck --master=test:test@pre-testmysqldba01x:3306:/var/run/mysqld/mysqld.sock --slave=test:test@pre-testmysqldba02x:3306:/var/run/mysqld/mysqld.sock
WARNING: Using a password on the command line interface can be insecure.
ERROR: You must specify two different servers for the operation.

I also note that mysql-utilities is not working on the current machine:
mysql@pre-testmysqldba02x:mysqlserverinfo --server=test:test@pre-testmysqldba02x
WARNING: Using a password on the command line interface can be insecure.
ERROR: Access denied for user 'test'@'pre-testmysqldba02x' using password: YES

mysql> select user, host from mysql.user;
+---------------+----------------------+
| user | host |
+---------------+----------------------+
| test | % |
| test | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+---------------+----------------------+
5 rows in set (0.00 sec)

Is-it a misuse, a bug or a missing dependent package(s) ?



Edited 1 time(s). Last edit at 07/20/2018 12:23AM by D BA.

Options: ReplyQuote


Subject
Views
Written By
Posted
Login-path configuration on mysql-utilities
2584
July 20, 2018 12:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.