Password Modification returns errors

sahostking

• March 24, 2014 03:36

When using Password Modification in WHM I get the following errors returned. Any ideas? Password Modification The password for website has been changed. Password for "website" has been changed. Updating ftp passwords for website Ftp password files updated. Ftp vhost passwords synced Error from MySQL query: DBD::mysql::db do failed: Can't find any matching row in the user table at /usr/local/cpanel/Cpanel/Mysql.pm line 1195. Error from MySQL query: DBD::mysql::db do failed: Can't find any matching row in the user table at /usr/local/cpanel/Cpanel/Mysql.pm line 1195. Error from MySQL query: DBD::mysql::db do failed: Can't find any matching row in the user table at /usr/local/cpanel/Cpanel/Mysql.pm line 1195.

• 

  Sys Admin

  • March 24, 2014 11:10

  Have you tried to update cPanel by running /scripts/upcp --force ?

  0
• 

  sahostking

  • March 26, 2014 08:48

  Yes I have tried that before. I notice the only thing we changed was the my.cnf file. Can't see how that could cause it. Here it is below: --------------------------------------------------------------------- [mysqld] default-storage-engine=MyISAM datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock local-infile=0 skip-name-resolve myisam_use_mmap=1 max_connections=100 max_user_connections = 30 log-error = /var/log/mysqld.log log-slow-queries=/var/log/mysql-slow.log #long_query_time = 0.1 query_cache_type = 1 query_cache_size = 75M query_cache_limit = 2M join_buffer_size=1M read_rnd_buffer_size=1M max_allowed_packet = 32M tmp_table_size=25M max_heap_table_size=25M table_open_cache = 7500 thread_cache_size = 25 open_files_limit=30000 key_buffer_size = 500M myisam_sort_buffer_size = 256M userstat = 1 --------------------------------------------------------------------- any ideas?

  0
• 

  cPanelMichael

  • April 02, 2014 20:04

  Hello :) Please remove the following entry from /etc/my.cnf and then restart MySQL: skip-name-resolve
  Let us know if this helps. Thank you.

  0
• 

  sahostking

  • April 05, 2014 22:35

  Tried and it seems to have worked. Thanks

  0
• 

  cPanelPeter cPanel Staff

  • April 06, 2014 13:51

  Hello, Glad to hear it, thank you for updating this thread with the outcome.

  0
• 

  DennisAng

  • November 22, 2014 09:01

  hi! iam also having this problem mysql version is 5.5.4 but my config only has these. [mysqld] innodb_file_per_table=1 local-infile=0 open_files_limit=50000 innodb_buffer_pool_size=134217728 max_allowed_packet=268435456

  0
• 

  cPanelMichael

  • November 25, 2014 15:14

  [quote="DennisAng, post: 1776221">hi! iam also having this problem mysql version is 5.5.4
  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

Please sign in to leave a comment.