Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    330
    Likes Received:
    3
    Trophy Points:
    68
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. Sys Admin

    Sys Admin Well-Known Member

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

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    330
    Likes Received:
    3
    Trophy Points:
    68
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,442
    Likes Received:
    1,962
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    330
    Likes Received:
    3
    Trophy Points:
    68
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
    Tried and it seems to have worked. Thanks
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    575
    Likes Received:
    20
    Trophy Points:
    143
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Glad to hear it, thank you for updating this thread with the outcome.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,442
    Likes Received:
    1,962
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice