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.

mysql transfer fails after update to WHM 9.7.2

Discussion in 'General Discussion' started by deddy, Sep 6, 2004.

  1. deddy

    deddy Well-Known Member

    Joined:
    Oct 13, 2003
    Messages:
    131
    Likes Received:
    0
    Trophy Points:
    16
    Attemping to package account...
    We will be spliting the archive!!
    stdin: is not a tty
    Copying Reseller Config...Done
    Copying SSL Certificates, CSRS, and Keys...Done
    Copying Mail files....Done
    Copying proftpd file....Done
    Copying www logs.............
    Done
    Grabbing mysql dbs...DBI connect('mysql:localhost','root',...) failed: Access denied for user: 'root@localhost' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42
    DBI connect('mysql:localhost','root',...) failed: Access denied for user: 'root@localhost' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42
    Done
    Grabbing mysql privs...DBI connect('mysql:localhost','root',...) failed: Access denied for user: 'root@localhost' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42
    Done
    Copying mailman lists....Done

    No idea why.
    It's a DBI problem. SSH access to mysql is working.
     
  2. deddy

    deddy Well-Known Member

    Joined:
    Oct 13, 2003
    Messages:
    131
    Likes Received:
    0
    Trophy Points:
    16
    I downgraded to the stable version.

    DBI connect error persists

    It could also be a Fedora Core 2 problem :(

    Cron Daemon /scripts/upcp message:

    Copying proftpd file....Done
    Grabbing mysql dbs...DBI connect('mysql:localhost','root',...) failed: Access denied for user: 'root@localhost' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42
    DBI connect('mysql:localhost','root',...) failed: Access denied for user: 'root@localhost' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42
    Done
    Grabbing mysql privs...DBI connect('mysql:localhost','root',...) failed: Access denied for user: 'root@localhost' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42
    Done
    Copying mailman lists....Done
     
    #2 deddy, Sep 7, 2004
    Last edited: Sep 8, 2004
  3. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    we have the same problem here.

    I noticed by the way that databases and tables are copied anyway, but are not accessible somehow.
     
  4. deddy

    deddy Well-Known Member

    Joined:
    Oct 13, 2003
    Messages:
    131
    Likes Received:
    0
    Trophy Points:
    16
    Yes the databases itself are copied but not the user and their privs.
    That's very strange.

    Without mysql user no access :mad:

    None of the available 1045 solutions is able to get rid of
    that problem.

    /root/.my.cnf which is used by cPanel DBI looks good and got
    the correct root mysql password.

    It is working fine but it is not working with DBI connect :confused:
     
  5. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    I reported this as a bug.
     
  6. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    Is there an easy way to copy mysql users manually?
     
  7. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    Cpanel support says:

    the root password for the remote server is incorrect in /root/.my.cnf
    Closing as this is not a bug but a user error.

    I set password in my.cnf to the same as the mysql root pass but this does not seem to help.
     
  8. deddy

    deddy Well-Known Member

    Joined:
    Oct 13, 2003
    Messages:
    131
    Likes Received:
    0
    Trophy Points:
    16
    If cPanel is really that saying they are definitively wrong.
    The same password who is visible in the /root/.my.cnf
    file is running problemfree by

    mysql mysql -u root -pXXXXXX

    Creation of mySQL databases are working.
    mysqladmin is working.

    Everything is working with this bloody password
    with the exeption of DBI connect, which fails.

    This happens on Fedora Core 2 (32bit) and
    on Fedora Core 2 (64bit) :eek:
     
  9. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
  10. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    We finally fixed by:

    1. removed the " from your my.cnf file so "root" --> root and "password" --> password
    2. reinstalled dbi perl module
     
  11. splat

    splat Member

    Joined:
    Sep 6, 2003
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Illinois
    May I ask what dbi perl module you reinstalled (when I serch in WHM there is a list of many) and how you went about reinstalling it?

    I would really appreciate your help, I have been battling this for days.
     
  12. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    Just DBI without anything else after it.
     
  13. splat

    splat Member

    Joined:
    Sep 6, 2003
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Illinois
    Thanks.

    I found that I needed to edit /root/.my.cnf and then things worked. /.my.cnf (without /root) is what cPanel was editting.
     
  14. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    It's possible that only 1 of the 2 things I mentioned is enough to bring it back to work. I did both and it worked after that.
     
  15. myusername

    myusername Well-Known Member
    PartnerNOC

    Joined:
    Mar 6, 2003
    Messages:
    691
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    chown -R us.*yourbase*
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Hi NNNils,

    Simply removing the " and restarting mysql server did the trick for me.
     
  16. NNNils

    NNNils Well-Known Member

    Joined:
    Sep 17, 2002
    Messages:
    580
    Likes Received:
    0
    Trophy Points:
    16
    good to hear
     
  17. dufus

    dufus Registered

    Joined:
    Sep 18, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Yes, removing " symbols from root and password values helped me as well!
    I tried many other suggestions without any luck before...

    Thanks a lot!
     
  18. bking

    bking Well-Known Member

    Joined:
    Mar 1, 2004
    Messages:
    206
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Sydney
    I am having the same problem. Will try removing the quotes in the .my.cnf file though.
     
  19. myBox

    myBox Active Member

    Joined:
    Jan 6, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    same problem not resolved!

    I have the same problem, it started when I upgraded cpanel to the latest.

    then I opened the file /usr/local/cpanel/Cpanel/Mysql.pm line 43 and noticed that cpanel was looking for a password which is not set!

    I created the /root/.my.cnf and put a password.

    after that it started working but with one error.

    now the database are appearing in cpanel and you can make users and everything except an error is visible in the mysql admin page.

    DBI connect('mysql:localhost','root',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at /usr/local/cpanel/Cpanel/Mysql.pm line 43

    only this line where before it was many lines.

    this line is appearing under usernames, databases, and access hosts.

    how to get rid of this ? I tried to delete but it did not go!

    any other ways to delete it ?
     
  20. myBox

    myBox Active Member

    Joined:
    Jan 6, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    Solved

    to solve the problem just change mysql root password from WHM.

    and your are all set :)
     
Loading...

Share This Page