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.

Full backup problem

Discussion in 'General Discussion' started by simonlee, Sep 2, 2003.

  1. simonlee

    simonlee Active Member

    Joined:
    Jan 19, 2003
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    6
    One of my customers try to backup his site to a remote ftp server and this error appears below the 'full backup in progress' page.

    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)'

    and below is the email that is sent to him.

    Can anybody here advise why it wont backup?

    :::::::::::::::::::::::::::::::::::::::::::::::::::::::::

    Can't call method "login" on an undefined value at /usr/local/cpanel/bin/ftpput line 24.
    --------------------------------------------------------
    Copying Mail files....Done
    Copying proftpd file....Done
    Copying www logs.............
    Done
    Grabbing mysql dbs...Done
    Grabbing mysql privs...Done
    Copying mailman lists....Done
    Copying mailman archives....Done
    Copying homedir....Done
    Copying cpuser file.......Done
    Copying quota info.......Done
    Storing Subdomains....
    Done
    Storing Parked Domains....
    Done
    Copying password.......Done
    Copying shell.......Done
    pkgacctfile is: /tmp/backup-8.2.2003_20-10-49_jase.tar.gz
    Creating Archive ....Done
    md5sum is: 56efdc8c06834dadd193d8d4f5541b46
    --------------------------------------------------------

    cPanel.net Support Ticket Number:
     
  2. simonlee

    simonlee Active Member

    Joined:
    Jan 19, 2003
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    6
    Anybody can help this?

    Please...

    cPanel.net Support Ticket Number:
     
  3. Guile

    Guile Well-Known Member

    Joined:
    Apr 25, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    Same problem here...

    Anyone know what this is about and how it can be fixed?

    cPanel.net Support Ticket Number:
     
  4. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,381
    Likes Received:
    23
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Did you set the MySQL Root password in your WHM?

    cPanel.net Support Ticket Number:
     
  5. Guile

    Guile Well-Known Member

    Joined:
    Apr 25, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    yes...

    cPanel.net Support Ticket Number:
     
  6. Guile

    Guile Well-Known Member

    Joined:
    Apr 25, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    I set mysql password again and tried it, same results.

    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)'

    cPanel.net Support Ticket Number:
     
  7. perlchild

    perlchild Well-Known Member

    Joined:
    Sep 1, 2002
    Messages:
    279
    Likes Received:
    0
    Trophy Points:
    16
    That might be some kind of non-alpha character confusing mysql into thinking there is no password there

    cPanel.net Support Ticket Number:
     
  8. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,381
    Likes Received:
    23
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Is there a .my.cnf file in /root/.my.cnf ? Does the file contain the correct root password to MySQL?

    cPanel.net Support Ticket Number:
     
  9. Guile

    Guile Well-Known Member

    Joined:
    Apr 25, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    I change the root mySQL password to "aaaaaa" temporarily and then tried it, same error.

    After password changed I checked out /root/.my.cnf which was also set to "aaaaaa".

    cPanel.net Support Ticket Number:
     
  10. Guile

    Guile Well-Known Member

    Joined:
    Apr 25, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    I check this out as well. The password that I set the root mySQL password to is the same in /root/.my.cnf.

    cPanel.net Support Ticket Number:
     
  11. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,381
    Likes Received:
    23
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    From the shell type:

    Code:
    mysql mysql
    
    then at the mysql prompt type:

    Code:
    select Host from user where user="root";
    
    What is displayed? Do you see a row that says localhost ?

    cPanel.net Support Ticket Number:
     
  12. Guile

    Guile Well-Known Member

    Joined:
    Apr 25, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    I see two under Hosts, first is localhost then I see one of the domains in the server. The thing is that that domain is not the server’s hostname, but just one of many domains on this whm/cpanle server.

    Should I change the second domain name listed under Hosts to the Hostname as it is set in WHM -> Edit Setup so that it matches?

    cPanel.net Support Ticket Number:
     
  13. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,381
    Likes Received:
    23
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Thats what I have on our servers. There are two Hosts listed for the root user in that database. localhost and the server hostname. You might try changing the other one to your server's hostname:

    Code:
    update user set Host='<your servers hostname>' where Host='<what is is showing>';
    flush privileges;
    
    cPanel.net Support Ticket Number:
     
  14. Guile

    Guile Well-Known Member

    Joined:
    Apr 25, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    Ok, I did this... It now shows the servers FQDN under the localhost in that table.

    Backup gives the same error though still... =(

    Also, the password in /root/.my.cnf matches to what I set it to.

    cPanel.net Support Ticket Number:
     
  15. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,381
    Likes Received:
    23
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    What script are you using that generates this error?

    cPanel.net Support Ticket Number:
     
  16. Guile

    Guile Well-Known Member

    Joined:
    Apr 25, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    Cpanel -> Backup -> Generate/Download a Full Backup then I generate a full backup to home directory. All I enter is a valid email and then I hit the generate a backup button. After a few seconds I get:

    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' l

    I did notice that a backup file is generated now, even though I get that error. But I am not sure if the proper mySQL information is in the backup file. How would I be able to verify this?

    cPanel.net Support Ticket Number:
     
  17. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,381
    Likes Received:
    23
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    It doesn't look like the script is trying to use a password to connect to the MySQL database. Since you have assigned a password to the root user a password is required to access any database using the root user. I'm not sure what could be causing this, perhaps someone who has a better understanding of the inner workings of CPanel can answer that question.

    cPanel.net Support Ticket Number:
     
  18. Guile

    Guile Well-Known Member

    Joined:
    Apr 25, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    sparek-3, thanks for al of your help! I hope somone can help me figure this out soon...

    cPanel.net Support Ticket Number:
     
  19. simonlee

    simonlee Active Member

    Joined:
    Jan 19, 2003
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    6
    Got this in the cPanel FAQ:

    Make sure root pass is in /root/.my.cnf

    This is usually the first root pass the box was given once cpanel is installed.

    If it still does not work, you will need to reset the mysqld root pass.

    First, stop the mysqld, usually /etc/rc.d/init.d/mysql stop

    Then stop chkservd to keep it from interfering with mysqld while you work on it with /etc/rc.d/init.d/chkservd stop

    Start up mysqld , but, without the grant tables, mysqld --skip-grant-tables -u mysql &

    Then change the pass..

    mysql -u root mysql UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; FLUSH PRIVILEGES;

    Now you just killall -9 mysqld and start it up normally with it's safe_mysqld script..

    cPanel.net Support Ticket Number:
     
  20. htremblay

    htremblay Member

    Joined:
    Aug 27, 2003
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Hi, I try that, but I still have the same problem :
    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)'

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page