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

[4 Feb 2011 10:17] Masaru Kawabata
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 **
[4 Feb 2011 10:58] Masaru Kawabata
i tried command below, but it wasn't change.

mysqlmanager --print-password-line --username=manager --password=manager > /etc/mysqlmanager.passwd
[4 Feb 2011 18:21] Sveta Smirnova
Thank you for the report.

Verified as described. Thought it will be considered "Won't Fix" as we are deprecating this tool.
[25 Feb 2011 0:40] Omer Barnir
Tool is obsoleted and issue will not be fixed
[28 Feb 2011 3:26] Masaru Kawabata
Thanks for your answer. I close this report.
[24 Oct 2014 2:01] Min Cho
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]#