mysql transfer fails after update to WHM 9.7.2

deddy

Well-Known Member
Oct 13, 2003
147
1
168
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

Well-Known Member
Oct 13, 2003
147
1
168
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
 
Last edited:

NNNils

Well-Known Member
Sep 17, 2002
580
0
166
we have the same problem here.

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

deddy

Well-Known Member
Oct 13, 2003
147
1
168
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:
 

NNNils

Well-Known Member
Sep 17, 2002
580
0
166
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

Well-Known Member
Oct 13, 2003
147
1
168
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:
 

NNNils

Well-Known Member
Sep 17, 2002
580
0
166
We finally fixed by:

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

splat

Member
Sep 6, 2003
5
0
151
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.
 

splat

Member
Sep 6, 2003
5
0
151
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.
 

NNNils

Well-Known Member
Sep 17, 2002
580
0
166
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.
 

dufus

Registered
Sep 18, 2004
1
0
151
Yes, removing " symbols from root and password values helped me as well!
I tried many other suggestions without any luck before...

Thanks a lot!
 

myBox

Active Member
Jan 6, 2004
40
0
156
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

Active Member
Jan 6, 2004
40
0
156
Solved

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

and your are all set :)