mysql transfer fails after update to WHM 9.7.2

[deddy]

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: '[email protected]' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42
DBI connect('mysql:localhost','root',...) failed: Access denied for user: '[email protected]' (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: '[email protected]' (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.

 

[deddy]

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: '[email protected]' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42
DBI connect('mysql:localhost','root',...) failed: Access denied for user: '[email protected]' (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: '[email protected]' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42
Done
Copying mailman lists....Done

 

[NNNils]

we have the same problem here.

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

 

[deddy]

Yes the databases itself are copied but not the user and their privs.
That's very strange.

Without mysql user no access

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

 

[NNNils]

I reported this as a bug.

 

[NNNils]

Is there an easy way to copy mysql users manually?

 

[NNNils]

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.

 

[deddy]

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)

 

[NNNils]

Please tell this to cpanel:

http://bugzilla.cpanel.net/show_bug.cgi?id=1200

if more people say the same, they will start to work on it faster, I suppose.

 

[NNNils]

We finally fixed by:

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

 

[splat]

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.

 

[NNNils]

Just DBI without anything else after it.

 

[splat]

Thanks.

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

 

[NNNils]

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.

 

[myusername]

Hi NNNils,

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

 

[NNNils]

good to hear

 

[dufus]

Yes, removing " symbols from root and password values helped me as well!
I tried many other suggestions without any luck before...

Thanks a lot!

 

[bking]

I am having the same problem. Will try removing the quotes in the .my.cnf file though.

 

[myBox]

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: '[email protected]' (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 ?

 

[myBox]

Solved

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

and your are all set