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

EneTar

• May 17, 2016 03:55

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

  • May 17, 2016 09:50

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

  0
• 

  EneTar

  • May 17, 2016 09:59

  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

  0
• 

  EneTar

  • May 19, 2016 08:48

  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?

  0
• 

  rpvw

  • May 19, 2016 11:49

  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

  0
• 

  EneTar

  • May 24, 2016 08:56

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

  0
• 

  cPanelMichael

  • June 01, 2016 16:49

  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.

  0
• 

  EneTar

  • June 01, 2016 17:06

  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?

  0
• 

  cPanelMichael

  • June 01, 2016 20:43

  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.

  0
• 

  EneTar

  • June 09, 2016 11:08

  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
  

  0
• 

  cPanelMichael

  • June 15, 2016 17:39

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

  0

Please sign in to leave a comment.