Full backup problem

[simonlee]

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:

[simonlee]

Please...

cPanel.net Support Ticket Number:

[Guile]

Same problem here...

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

cPanel.net Support Ticket Number:

[sparek-3]

Did you set the MySQL Root password in your WHM?

cPanel.net Support Ticket Number:

[Guile]

Originally posted by sparek-3
Did you set the MySQL Root password in your WHM?

cPanel.net Support Ticket Number:

yes...

cPanel.net Support Ticket Number:

[Guile]

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:

[perlchild]

Originally posted by Guile
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:

That might be some kind of non-alpha character confusing mysql into thinking there is no password there

cPanel.net Support Ticket Number:

[sparek-3]

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:

[Guile]

Originally posted by Guile
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:

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:

[Guile]

Originally posted by sparek-3
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:

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:

[sparek-3]

From the shell type:

mysql mysql

then at the mysql prompt type:

select Host from user where user="root";

What is displayed? Do you see a row that says localhost ?

cPanel.net Support Ticket Number:

[Guile]

Originally posted by sparek-3
From the shell type:

mysql mysql

then at the mysql prompt type:

select Host from user where user="root";

What is displayed? Do you see a row that says localhost ?

cPanel.net Support Ticket Number:

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:

[sparek-3]

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:

update user set Host='<your servers hostname>' where Host='<what is is showing>';
flush privileges;

cPanel.net Support Ticket Number:

[Guile]

Originally posted by sparek-3
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:

update user set Host='<your servers hostname>' where Host='<what is is showing>';
flush privileges;

cPanel.net Support Ticket Number:

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:

[sparek-3]

What script are you using that generates this error?

cPanel.net Support Ticket Number: