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

[EneTar]

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?

 

[ssfred]

Hello

Please check if your /root/.my.cnf file uses the parameter "pass". If so change it to the full parameter "password" and try.

 

[EneTar]

Thank you for your answer I just did what you said, I think it works! When repairing a database I don't get those "pass" warnings

 

[EneTar]

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]

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

 

[EneTar]

There is a profile active there but the file .my.cnf every time is regenerated with the word "pass" instead of "password"

 

[cPanelMichael]

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:

cat /usr/local/cpanel/version

Thank you.

 

[EneTar]

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]

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]

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

# /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]

Hello,

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