eximstats failing due to mysql

[Devil Inside]

running Current 10.1 build 4
MySQL 4.1.10a-standard

Eximstats keep failing on 2 of my servers.

When I restart cpanel I receive this error:
Starting eximstats: DBI connect('eximstats:localhost','eximstats',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /usr/local/cpanel/bin/eximstats line 262
Can't Connect at /usr/local/cpanel/bin/eximstats line 265.

I have checked the box to use mysql 4.0 password in teak settings.

Anyone have any ideas?
cPanel techs said to rebuild the database and instructed me on how to do so. However, when I try - the root pass is continually rejected.

I've tried resetting the pass - but it hasn't helped.

[Devil Inside]

Anyone have even a guess?

cPanel tech support hasn't responded to me in over 24 hours. Somehow they always do that to me. I'll submit a ticket - get a response in under 20 minutes. Email back in less than 5 minutes - and *POOF* they disappear for a day or two.

Does cPanel have some policy for their techs that tickets must be acknowledged quickly or something? Because that first response is usually pretty vague and/or flat out unhelpful.

[DigitalN]

login to the box

Does

# mysql eximstats

Drop you into mysql ?

If so

> check table sends;

> repair table sends;

> check table smtp;

> repair table smtp;

> quit;

# /etc/init.d/exim restart

# /etc/init.d/chkservd restart

Also check what version of mysql is running, maybe rpm -qa | grep -i mysql

Restart mysql

# /etc/init.d/mysql stop

# /etc/init.d/mysql start

[Devil Inside]

Thanks much for the reply. I really appreciate it.

Unforunately it didn't help. Though the tables did need repairing

Still getting the connection error...

still haven't heard back from cPanel regarding of my tickets - and another one as yet to be replied to at all

[[iG]]

This is an error where the perl module DBD-MySQL is not upto date.

I am assuming you are using MySQL.

You need to update to the latest DBD-MySQL which is what eximstats uses to connect to MySQL.

Once you do that, it will work fine.

[[iG]]

Hi,

If you are running RedHat/Fedora, this should work...

rpm -Uhv ftp://195.220.108.108/linux/fedora/c...004-4.i386.rpm

[Realist]

I have the same problem and so far no luck in fixing it?

[Aric1]

Add old-passwords to my.cnf in the [MySQL] section and restart MySQL or check the use old passwords in 4.1 box in Tweak Settings in WHM.

[[iG]]

Add old-passwords to my.cnf in the [MySQL] section and restart MySQL or check the use old passwords in 4.1 box in Tweak Settings in WHM.

Nothing there?

[gemby]

Yep, i confirm that nothing above works, eximstats would not start, R161 + mysql 4.1.....

[Devil Inside]

R161 doesn't have the check box for using version 4.0 passwords in tweak settings. And I gather other mysql database connections will also fail due to this.

You need build 162 or more recent for the check box to be available.

Anyhow - I finally got a response from a cPanel tech.. now listen up cuz it might help all of you...

Please check this now.

Which is total crap since he never logged into the server *unless it was only as admin...*

I get a nifty email whenever someone su - to root...

That was almost 24 hours ago. Which again, I replied to ina timely manner (1 hour or so) stating whatever he did, didn't work.

I guess I'll hear from him again in a day or so... still no reply to the second ticket regarding another server. My guess is someone deleted it thinking it was a duplicate ticket. Same subject/body - just different IP's.

[iceboxman]

login to the box

Does

# mysql eximstats

Drop you into mysql ?

If so

> check table sends;

> repair table sends;

> check table smtp;

> repair table smtp;

> quit;

# /etc/init.d/exim restart

# /etc/init.d/chkservd restart

Also check what version of mysql is running, maybe rpm -qa | grep -i mysql

Restart mysql

# /etc/init.d/mysql stop

# /etc/init.d/mysql start

Wow! this actually worked for me. I figured I'd give it a shot and was pleasantly surprised.

[sumith]

really coool

[EMS]

Got this happening on one server right now and I've tried everything to no avail.

Still getting Client does not support authentication protocol requested by server etc.

I've tried everything in this thread and also /scripts/mysqlup --force but nothing seems to fix it. This is happening after a mysql upgrade to 4.1 today and the old passwords option is ticked in the settings.

[forlinuxsupport]

Hi

Here is a solution if you ever get the error message below.

It might be related to me upgrading mysql from 4.0 to 4.1.

When restarting cpanel it gives.
Starting eximstats: DBI connect('eximstats:localhost','eximstats',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /usr/local/cpanel/bin/eximstats line 264 Can't Connect at /usr/local/cpanel/bin/eximstats line 267.

This is probably due to mysql being upgraded by still using the old version of the DBI and DBD::mysql perl modules.

$cpan
cpan> get DBD::mysql
(This should download the DBD module
cpan> quit

$ cd /home/.cpan/build or cd /root/.cpan/build
$ cd DBD-mysql-3.0002
$ perl Makefile.PL
$ make && make install

Now try restart cpanel ( /etc/init.d/cpanel restart )

No more eximstats error
Hope this can help someone

Cheers
Andy