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.

Weird cpses error messages

Discussion in 'General Discussion' started by flycast, Nov 30, 2013.

  1. flycast

    flycast Member

    Joined:
    Feb 20, 2011
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    I am getting weird cpses error messages on certain users. I have noticed the error when I create a new account in the last week. I thought it was related to the function I wrote to hook into the Account::Create - post hook but I do not think so now. It happens randomly when I create a new user - on average about 50% of the time.

    When it happens it seems to stay broken on that account. I can reproduce it reliably by logging into the affected account using cPanel and then click on phpmyadmin. While cPanel redirects to phpmyadmin there is a message at the top of the screen that says:

    When the error happens I get:
    Under normal conditions (when the bug does not happen) you get:
    The issue it is causing me is the function I wrote creates a Wordpress install after a new account is set up. The API I am using (I've tried both Softtacular and Installatron) tries to set up a new dbuser but is getting these warning messages returned instead. The Softtacular and Installatron API does not know what to do with the messages. Softacular just fails with a:
    nstallatron gives me a:

    About a week ago I upgraded to MySQL 5.5.32 and then rebuilt PHP.
     
    #1 flycast, Nov 30, 2013
    Last edited: Nov 30, 2013
  2. flycast

    flycast Member

    Joined:
    Feb 20, 2011
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Turned out it was leftover session files - that is - cpses_[ahashofsomekind].
    I was developing. I created an account, logged in, tried some stuff and then just closed the browser tab rather than log out. After that I deleted the account. When I would recreate the account with the same username it was getting session files crossed.
     
  3. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    I believe those session files should be deleted upon account termination. I've opened case 84485 to have this examined.
     
  4. Nixie86

    Nixie86 Registered

    Joined:
    Jan 2, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Reseller Owner
    Could this be caused by any other reason? This is the only reference to this error that I found on the web. We saw this, and cleared all browser history before creating new account, and still showing this error. We backed up from a different hosted location and restoring to new location, if that makes a difference.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Your access level is listed as "Reseller Owner". Do you have root access to your system? If so, please 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.
     
  6. ccork79

    ccork79 Registered
    PartnerNOC

    Joined:
    Jun 30, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Michael,

    Can you post the resolution for this error? We're seeing the same error on other servers.


    Thanks!
     
  7. 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,

    There is presently no solution as we have not seen any tickets with this error. In order for us to investigate and find a solution, please open a support ticket using the link in my signature. Then please post the ticket number here in this thread so we can update it accordingly.
     
  8. ccork79

    ccork79 Registered
    PartnerNOC

    Joined:
    Jun 30, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Support Ticket Opened:

    Your Request id is: 4490491
     
  9. ccork79

    ccork79 Registered
    PartnerNOC

    Joined:
    Jun 30, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Here's the resolution from cPanel Support Staff member Citizen Kepler:

    =====
    Hello,

    It appears that a few session specific MySQL users were left behind when an session was closed improperly. I have gone and cleared up the remains of these sessions, and the error is no longer appearing.

    For reference, below is the work preformed to resolve this error:

    1) I ran a grep for the sessions that were currently in effect:

    # grep "cpses_" /var/cpanel/databases/

    2) I removed the following sections from any user's yaml that matched the

    cpses_########":
    dbs: {}
    server: X.X.X.X

    3) I removed each of the cpses_######## lines from /var/cpanel/databases/users.db

    4) I ran the following command to update the user-data:

    # /scripts/update_db_cache

    5) I then removed all of the cpses_######## users from the mysql.user table to remove the users from mysql. This can be accomplished from the command line or from WHM>> PhpMyAdmin

    Thanks, Please let us know if you have any questions.

    --
    Citizen Kepler
    Technical Analyst
    cPanel Inc.
    =====

    Thanks again for the speedy help.



    Chris
     
  10. CitizenK

    CitizenK Well-Known Member

    Joined:
    Jun 5, 2012
    Messages:
    64
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    On The Road
    cPanel Access Level:
    Root Administrator
    I am glad that I could help ccork79

    Thanks for the shout out. :)
     
  11. Skimice

    Skimice Registered

    Joined:
    Apr 28, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    This is an older post but I ran into this same problem and tried the fix above but found that there weren't any entries for the specific user I was having problems with in the /var/cpanel/databases directory. My fix was actually pretty simple, I just reset the password for the user which forced a change for the MSQL password and allowed me to login.
     
Loading...

Share This Page