| Bug #74547 | mysqlserverinfo tries to access error log on the client instead of on the serve | ||
|---|---|---|---|
| Submitted: | 24 Oct 2014 11:33 | Modified: | 22 Jun 2015 13:14 |
| Reporter: | Daniël van Eeden (OCA) | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Utilities | Severity: | S3 (Non-critical) |
| Version: | 1.5.2, 1.6.0-1 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[24 Oct 2014 13:53]
MySQL Verification Team
Hello Daniël, Thank you for the report. Thanks, Umesh
[24 Oct 2014 13:54]
MySQL Verification Team
//
[root@ushastry Downloads]# rpm -qa|grep -i mysql
mysql-workbench-commercial-6.2.3-1.el6.x86_64
mysql-utilities-extra-1.6.0-1.el6.noarch
mysql-connector-python-2.0.1-1.el6.noarch
mysql-utilities-1.6.0-1.el6.noarch
[root@ushastry Downloads]# mysqlserverinfo --server=ushastry:123@x.x.x.x --format=vertical
WARNING: Using a password on the command line interface can be insecure.
# Source on 10.178.59.73: ... connected.
************************* 1. row *************************
server: x.x.x.x:3306
config_file:
binary_log: master-bin.000003
binary_log_pos: 319
relay_log:
relay_log_pos:
version: 5.6.22-enterprise-commercial-advanced-log
datadir: /tmp/master/
basedir: /data/ushastry/server/mysql-advanced-5.6.22
plugin_dir: /data/ushastry/server/mysql-advanced-5.6.22/lib/plugin/
general_log: OFF
general_log_file:
general_log_file_size:
log_error: /tmp/master/cluster-repo.err
log_error_file_size:
slow_query_log: OFF
slow_query_log_file:
slow_query_log_file_size:
1 row.
# List of Warnings:
WARNING: Unable to get information about 'error log' size. Please check if the file '/tmp/master/cluster-repo.err' exists or if you have the necessary Operating System permissions to access it.
#...done.
// strace
stat("/tmp/master/cluster-repo.err", 0x7fff60b24370) = -1 ENOENT (No such file or directory)
[29 Oct 2014 18:02]
Chuck Bell
This utility, mysqlserverinfo, is designed to be run on the local server, not a remote server. Even so, it is possible we need to add a check for accessing a remote server.
Description: When running "mysqlserverinfo --server=usr:pwd@hst --format=vertical -------------------------------------------- # List of Warnings: WARNING: Unable to get information about 'error log' size. Please check if the file '/path/to/my/error.log' exists or if you have the necessary Operating System permissions to access it. -------------------------------------------- From strace: stat("/path/to/my/error.log", 0x7ffffd2706c0) = -1 ENOENT (No such file or directory) How to repeat: Run mysqlserverinfo against remote server. Make sure the full path of the error log on the server doesn't exist on the client. Suggested fix: Make sure you read the errorlog on the correct host.