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: | |
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
[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]#