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.

From Ensim: ERROR 1045 (28000): Access denied for user domainuser@localhost

Discussion in 'Migrate to cPanel' started by antispam, Nov 26, 2012.

  1. antispam

    antispam Member

    Joined:
    Nov 26, 2012
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    I've searched google and the forum but didn't find anything relevant (except a bug for Plesk migration).

    I have a CPanel server (11.34.0 b9) into which I've migrated ~100 sites from Ensim servers (v. 10.3.6). In the last few days a problem occurs to sites migrated: Databases are not migrated automatically.
    Moreover, on these new sites after migration, new databases created in CPanel by the account owners do not appear in their "Mysql Databases" CPanel frontend and creation of new DB users from CPanel fails. (But DBs still exist, work and are administered through PhpMyAdmin).

    The Databases on remote servers are read fine, mysql user grants are read fine too ("enXim Grabbing mysql grants...Done"). Everything else seems fine in migrating, however, when trying to restore DBs:

    --- Log Detail ---
    Restoring MySQL databases....
    Restoring database domain_com_data......
    ERROR 1045 (28000): Access denied for user 'domainuser'@'localhost' (using password: YES) Restoration of MySQL database (domain_com_data) failed with error: Execution of /usr/bin/mysql --defaults-file=/home/domainuser/._.work.B7JRsZ2m_lP7nWC3 -B -A --force domain_com_data exited with value: 1
    Saved to /home/domainuser/domain_com_data.1353978676
    Done
    Done
    Restoring MySQL privs
    Done
    Reloading MySQL
    Done
    --- Log Detail End---

    After that the import continues and finishes successfully.
    ("Transfer Complete - Account Copy Process Complete")

    Now, I've read somewhere for db users not to exceed 16 characters and they do not.
    There's lot of free disk space
    There are no problems creating new DBs or DB users on the other accounts (previously imported).
    MySQL general log only shows an entry "connect Access denied for user 'domainuser'@'localhost' (using password: YES)", after a few root@localhost successful connections.

    On the last accounts (having this issue) sometimes the databases appear in CPanel, but there is an extra DB named "ERROR 1045 (28000): Access denied for user 'domainuser'@'localhost' (using password: YES)", as in Clipboard-1.jpg .
    However, some other times no DB appears. If the account owner tries to delete the DB, all DBs disappear from his CPanel.

    Some 100 sites were migrated fine in the last few months and continue to operate fine. But the last 12 sites appear to have this consistent issue.

    Any thoughts?
     
  2. bbrink68

    bbrink68 Active Member

    Joined:
    Nov 27, 2012
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    Re: From Ensim: ERROR 1045 (28000): Access denied for user domainuser@local

    That is interesting, I know this may sound stupid but have you tried re-granting root priviliges again?

    Drop into a mysql prompt:
    Code:
    GRANT ALL PRIVILEGES on *.* to 'user'@'IP' IDENTIFIED BY '*UserPass*';
    You should use the cPanel users creds here obviously...try using the IP instead of "localhost" as there could be some DNS problems resolving localhost into 127.0.0.1 or whatever yours is.

    Worth a shot although that error in cPanel interface seems to be more concerning. This almost seems like a bug with cPanel and perhaps a forced update may be in order?

    SSH into server:
    Code:
    /scripts/upcp --force
    Probably the error is deeper than that but someone with a similar problem reported success with the following:
    Good Luck!
     
    #2 bbrink68, Nov 27, 2012
    Last edited: Nov 27, 2012
  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
    Re: From Ensim: ERROR 1045 (28000): Access denied for user domainuser@local

    Note that we do offer free migration assistance. Details are available here:

    Migrate to cPanel | cPanel, Inc.

    If you submit a ticket, our migrations team would be happy to look at this particular problem for you.
     
  4. antispam

    antispam Member

    Joined:
    Nov 26, 2012
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Re: From Ensim: ERROR 1045 (28000): Access denied for user domainuser@local

    Thanks bbring68,


    > That is interesting, I know this may sound stupid but have you tried re-granting root priviliges again?
    I have, nothing is solved.

    >Drop into a mysql prompt:
    Code:
    GRANT ALL PRIVILEGES on *.* to 'user'@'IP' IDENTIFIED BY '*UserPass*';
    That's not easy: The user domainuser@localhost is created during the execution of CPanel Site Transfer Script. Right after creating the user, the script tries to restore the DB as domainuser@localhost tries and fails.

    >SSH into server:
    Code:
    /scripts/upcp --force
    Tried, no luck.

    Probably the error is deeper than that but someone with a similar problem reported success with the following:
    Code:
    grant all on hibernate.* to 'testuser'@'%' identified by 'testuser';
    grant all on hibernate.* to 'testuser'@'localhost' identified by 'testuser';
    Show Grants shows exactly this.

    Another peculiar thing: There is an entry in mysql.Db with Database Name "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (u". Seriously, all that inside the double quotes is the DB name!!!
    As root, I drop this database, it really disappears, but when a specific cpanel user goes to the "MySQL Databases" module in CPanel, this database is recreated. There is no such db in /var/lib/mysql, of course.

    Ideas anyone?
     
  5. SB-Nick

    SB-Nick Well-Known Member

    Joined:
    Aug 26, 2008
    Messages:
    134
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Re: From Ensim: ERROR 1045 (28000): Access denied for user domainuser@local

    Did you try querying mysql for all the mysql users on the mysql.user table and see if the usernames are being created properly? If database names are created but usernames are missing maybe cPanel isnt catching them correctly.
     
Loading...

Share This Page