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.

Account Restore Failed (mysql user)

Discussion in 'General Discussion' started by ipvhost, Nov 10, 2010.

  1. ipvhost

    ipvhost Member

    Joined:
    Mar 25, 2008
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    hello

    Everything belongs de6985 was deleted from the server.

    I try to restore the account I get this error:


    Restore Backups
    Restoring de6985
    Extracting tarball................... Done
    Extracting Domain....Done
    Generating Account....


    Account Creation Status: failed (Sorry, a mysql user with the name de6985 already exists.)


    Account Restore Failed... Restore failed.


    thanks,
     
  2. ipvhost

    ipvhost Member

    Joined:
    Mar 25, 2008
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Ok, I solved the problem... It was the update to WHM 11.28.28(RELEASE), i downgrade to WHM 11.26.20(Stable) and everything is back to normal.



    It was another problem when the version WHM 11.28.28 was running on server, when I add a domain from "Addons Domains" or I create a subdomain from "Subdomains" and when I try to access the domain or subdomain it show the /cgi-sys/defaultwebpage.cgi.
     
  3. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    We do not recommend downgrading between different versions, such as 11.28 to 11.26. I am glad that it worked in your case, but this can very often cause more problems than it solves.

    Note that 11.28 will eventually make its way into the STABLE tier as well, so you are only delaying the move to 11.28 at this point. The best course of action would be to submit a ticket so that we can help you with the update to 11.28, because what you have described is not normal and should not be happening due to a cPanel update.
     
  4. diegoalberto.me

    diegoalberto.me Registered

    Joined:
    Sep 3, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    How to solve the original problem, I have already deleted the user on mysql with the "DROP USER nnn" and double checked that the user nnn was not present on any mysql database tables.

    How can I restore the account then?

    Thanks
     
  5. CyberFunk

    CyberFunk Registered

    Joined:
    Jun 26, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Log into your webserver as root and run:
    grep -Rl USERNAME /var/cpanel/databases/

    You will get a list of files where needed username is still placed.
     
    #5 CyberFunk, Jul 11, 2011
    Last edited: Jul 11, 2011
  6. WebCraker

    WebCraker Registered

    Joined:
    Jan 4, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Try using --force with the restore command

    Code:
    /scripts/restorepkg --force user.tar.gz
     
Loading...

Share This Page