Using unique option prefix 'pass' is error-prone and can break in the future.

EneTar

Well-Known Member
Dec 19, 2015
156
12
18
Greece
cPanel Access Level
Root Administrator
I have successfully upgraded from MySQL to MariaDB 10.1 After the upgrade I get an this email from the server.

cPanel & WHM has determined that the following database tables are corrupt:

Database Error
mysql
Info: Using unique option prefix 'pass' is error-prone and can break in the future. Please use the full name 'password' instead.
whmxfer Info: Using unique option prefix 'pass' is error-prone and can break in the future. Please use the full name 'password' instead.
cphulkd Info: Using unique option prefix 'pass' is error-prone and can break in the future. Please use the full name 'password' instead.
modsec Info: Using unique option prefix 'pass' is error-prone and can break in the future. Please use the full name 'password' instead.
munin_innodb Info: Using unique option prefix 'pass' is error-prone and can break in the future. Please use the full name 'password' instead.
eximstats Info: Using unique option prefix 'pass' is error-prone and can break in the future. Please use the full name 'password' instead.
roundcube Info: Using unique option prefix 'pass' is error-prone and can break in the future. Please use the full name 'password' instead.
leechprotect Info: Using unique option prefix 'pass' is error-prone and can break in the future. Please use the full name 'password' instead.
horde Info: Using unique option prefix 'pass' is error-prone and can break in the future. Please use the full name 'password' instead.
I have tried /scripts/repairmysqllist but the issue remains. What am I supposed to do?
 

EneTar

Well-Known Member
Dec 19, 2015
156
12
18
Greece
cPanel Access Level
Root Administrator
Unfortunately I got the same email today from my server

Then I went again at /root/.my.cnf and the values was changed back to pass= instead of password. In the meantime I know that the server has been restarted and I guess it changes the value each time it restarts. So what should I do to keep the value password instead of pass?
 

rpvw

Well-Known Member
Jul 18, 2013
1,101
459
113
UK
cPanel Access Level
Root Administrator
I have no idea if this might work - but you might want to try looking at editing in WHM

Home » SQL Services » Manage MySQL® Profiles

Perhaps use the existing password for the root profile that is in the /root/.my.cnf file, and see if the my.cnf is regenerated with the password tag instead of pass
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,218
463
There is a profile active there but the file .my.cnf every time is regenerated with the word "pass" instead of "password"
Hello,

Could you verify the specific action you are taking to regenerate the /root/.my.cnf file? Also, please post the output from the following command:

Code:
cat /usr/local/cpanel/version
Thank you.
 

EneTar

Well-Known Member
Dec 19, 2015
156
12
18
Greece
cPanel Access Level
Root Administrator
I don't know how this file is regenerated but every time I edit the file manually and I change the word "pass" to "password" then after a day or two I open the file and the word is again "pass" instead of "password".
This morning I set the permissions of the file to 400 and I'm going to check again tomorrow or the day after.

My WHM, Cpanel version is 11.56.0.22

Do you have anything else to suggest?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,218
463
I've been unable to reproduce this issue on a test system. Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.
 

EneTar

Well-Known Member
Dec 19, 2015
156
12
18
Greece
cPanel Access Level
Root Administrator
It appeared to be some processes running to update mysql versions
This fixed it, or at least for now the parameter "pass" hasn't changed yet
Code:
# /scripts/update_local_rpm_versions --edit target_settings.MySQL50 uninstalled
# /scripts/update_local_rpm_versions --edit target_settings.MySQL51 uninstalled
# /scripts/update_local_rpm_versions --edit target_settings.MySQL55 uninstalled
# /scripts/update_local_rpm_versions --edit target_settings.MySQL56 uninstalled
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,218
463
Hello,

I'm happy to see you were able to determine the cause of the problem. Thank you for updating us with the outcome.