MySQL Bugs: #59940: mysqlmanager can't startup

Bug #59940	mysqlmanager can't startup
Submitted:	4 Feb 2011 10:17	Modified:	28 Feb 2011 3:26
Reporter:	Masaru Kawabata	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Instance Manager	Severity:	S3 (Non-critical)
Version:	5.1.50, 5.1.53	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
hello.

i tried to start mysqlmanager but it was faild.
i found error in log file below.

[ERROR] Password is too long (55). Max length: 41.User line: 'WARNING: This program is deprecated and will be removed in 6.0.'.
[ERROR] Password is too long (-16843009). Max length: 976894522.User line: 'WARNING: This program is deprecated and will be removed in 6.0.'.
[ERROR] Manager: password file (/etc/mysqlmanager.passwd) corrupted.
[ERROR] Angel: Manager exited abnormally (exit code: 11).
[ERROR] Angel: Manager exited abnormally (exit code: 2).

is it bug? if it's not, how can i fix this?

turely yours.

How to repeat:
--- my.cnf ---
[manager]
default-mysqld-path = /usr/sbin/mysqld
password-file = /etc/mysqlmanager.passwd
log = /var/log/mysql/manager.log
run-as-service
socket=/tmp/manager.sock
pid-file=/tmp/manager.pid
port = 1999
user = mysql

--- mysqlmanager password setting command ---
mysqlmanager --print-password-line --username=manager --password=manager >> /etc/mysqlmanager.passwd

--- Instance Manager startup command ---
mysqlmanager
** there are output error messages after this command **

i tried command below, but it wasn't change.

mysqlmanager --print-password-line --username=manager --password=manager > /etc/mysqlmanager.passwd

Thank you for the report.

Verified as described. Thought it will be considered "Won't Fix" as we are deprecating this tool.

Tool is obsoleted and issue will not be fixed

Thanks for your answer. I close this report.

This problem is caused incorrect value written at password file when add user.

[root@beta bin]# ./mysqlmanager --print-password-line  --username=mike --password=mikepass >> /etc/mysqlmanager.passwd

[root@beta bin]# cat /etc/mysqlmanager.passwd

WARNING: This program is deprecated and will be removed in 6.0.

[3195/139916852504320] [14/10/24 23:05:37] [INFO] IM: started.
[3195/139916852504320] [14/10/24 23:05:37] [INFO] Loading config file 'my.cnf'...
Creating record for new user.
mike:*BBF1F551DD9DD96A01E66EC7DDC073911BAD17BA
[3195/139916852504320] [14/10/24 23:05:37] [INFO] IM: finished.

[root@beta bin]# ./mysqlmanager --drop-user --username=mike

WARNING: This program is deprecated and will be removed in 6.0.

[3199/139923551938304] [14/10/24 23:05:56] [INFO] IM: started.
[3199/139923551938304] [14/10/24 23:05:56] [INFO] Loading config file 'my.cnf'...
[3199/139923551938304] [14/10/24 23:05:56] [INFO] Loading the password database...
[3199/139923551938304] [14/10/24 23:05:56] [ERROR] Password is too long (55). Max length: 41.User line: 'WARNING: This program is deprecated and will be removed in 6.0.'.
[3199/139923551938304] [14/10/24 23:05:56] [ERROR] Password is too long (-2114388248). Max length: 1.User line: '/etc/mysqlmanager.passwd'.
Error: password file (/etc/mysqlmanager.passwd) corrupted.
[3199/139923551938304] [14/10/24 23:05:56] [INFO] IM: finished.

You can avoid this bug using "grep" command
[root@beta bin]# ./mysqlmanager --print-password-line  --username=mike --password=mikepass | grep '\:\*' >> /etc/mysqlmanager.passwd

[root@beta bin]# cat /etc/mysqlmanager.passwd 
mike:*BBF1F551DD9DD96A01E66EC7DDC073911BAD17BA
### Add mike2
[root@beta bin]# ./mysqlmanager --print-password-line  --username=mike2 --password=mikepass2 | grep '\:\*' >> /etc/mysqlmanager.passwd
[root@beta bin]# cat /etc/mysqlmanager.passwd
mike:*BBF1F551DD9DD96A01E66EC7DDC073911BAD17BA
mike2:*A1A3372F5AD32496F585C5F502C607092CB3E2F9
### drop mike
[root@beta bin]# ./mysqlmanager --drop-user --username=mike

WARNING: This program is deprecated and will be removed in 6.0.

[3139/140175024674560] [14/10/24 22:44:59] [INFO] IM: started.
[3139/140175024674560] [14/10/24 22:44:59] [INFO] Loading config file 'my.cnf'...
[3139/140175024674560] [14/10/24 22:44:59] [INFO] Loading the password database...
[3139/140175024674560] [14/10/24 22:44:59] [INFO] Loaded user 'mike'.
[3139/140175024674560] [14/10/24 22:44:59] [INFO] Loaded user 'mike2'.
[3139/140175024674560] [14/10/24 22:44:59] [INFO] The password database loaded successfully.
[3139/140175024674560] [14/10/24 22:44:59] [INFO] IM: finished.
[root@beta bin]# 
###
[root@beta bin]# cat /etc/mysqlmanager.passwd
mike2:*A1A3372F5AD32496F585C5F502C607092CB3E2F9
[root@beta bin]#