The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Password Modification returns errors

Discussion in 'General Discussion' started by sahostking, Mar 24, 2014.

  1. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    299
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
    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.
     
  2. Sys Admin

    Sys Admin Well-Known Member

    Joined:
    Apr 29, 2007
    Messages:
    67
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Have you tried to update cPanel by running /scripts/upcp --force ?
     
  3. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    299
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
    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?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please remove the following entry from /etc/my.cnf and then restart MySQL:

    Code:
    skip-name-resolve
    Let us know if this helps.

    Thank you.
     
  5. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    299
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
    Tried and it seems to have worked. Thanks
     
  6. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    569
    Likes Received:
    15
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

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

    DennisAng Registered

    Joined:
    Nov 22, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mandayulong, Rizal, Philippines, Philippines
    cPanel Access Level:
    Root Administrator
    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
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page