eximstats failed (problems with perl 5.8.7)

[pava]

Hello,
i write from italy, sorry for my english

I have upgrade perl to version 5.8.7 and when i restart cpanel service, it's ok... but... if i go in service status on WHM i see that EXIMSTATS is failed!!

So i go in my root shell and write:

root@web /# /scripts/restartsrv_eximstats

root@web /# install_driver(mysql) failed: Can't locate loadable object for module DBD::mysql in @INC (@INC contains: /usr/local/cpanel /usr/lib/perl5/5.8.7/i686-linux /usr/lib/perl5/5.8.7 /usr/lib/perl5/site_perl/5.8.7/i686-linux /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.6.2 /usr/lib/perl5/site_perl .) at (eval 6) line 3
Compilation failed in require at (eval 6) line 3.
Perhaps a module that DBD::mysql requires hasn't been fully installed
at /usr/local/cpanel/bin/eximstats line 236

anyone can help me... Thanks...

 

[easyhoster1]

Try running from root and see if this corrects your issue.

/scripts/installdbi

Then;

/usr/local/cpanel/bin/checkperlmodules

 

[pava]

I try but i see this error....

root@web ~# /scripts/installdbi
[.......]
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cc -c -I/usr/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBI -I/usr/include/mysql -g -pipe -march=i386 -mcpu=i686 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-a liasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O 2 -DVERSION=\"4.004\" -DXS_VERSION=\"4.004\" -fpic "-I/usr/lib/perl5/5.8.7/i68 6-linux/CORE" dbdimp.c
dbdimp.c: In function `mysql_st_fetch':
dbdimp.c:3429: error: too few arguments to function `mysql_dr_error'
dbdimp.c:3593: error: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_st_FETCH_internal':
dbdimp.c:3931: error: too few arguments to function `mysql_dr_error'
dbdimp.c:3945: error: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_bind_ph':
dbdimp.c:4264: error: too few arguments to function `mysql_dr_error'
dbdimp.c:4291: error: too few arguments to function `mysql_dr_error'
dbdimp.c:4303: error: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_db_reconnect':
dbdimp.c:4465: error: too few arguments to function `mysql_dr_error'
make: *** [dbdimp.o] Error 1
CAPTTOFU/DBD-mysql-4.004.tar.gz
/usr/bin/make -- NOT OK

Running make install
Make had returned bad status, install seems impossible
Net::DNS is up to date (0.59).
perlmod--Install done
root@web ~#

please help me...

 

[easyhoster1]

Does the eximstats db exsist? You can check in WHM and open phpadmin.

 

[pava]

yes, it's exist with 2 table inside (smtp and sends)

 

[easyhoster1]

Ok...try going into WHM >> Service Configuration >> Service Manager and click save. Then see if it will go green.

 

[chirpy]

I try but i see this error....

root@web ~# /scripts/installdbi
[.......]
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cc -c -I/usr/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBI -I/usr/include/mysql -g -pipe -march=i386 -mcpu=i686 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-a liasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O 2 -DVERSION=\"4.004\" -DXS_VERSION=\"4.004\" -fpic "-I/usr/lib/perl5/5.8.7/i68 6-linux/CORE" dbdimp.c
dbdimp.c: In function `mysql_st_fetch':
dbdimp.c:3429: error: too few arguments to function `mysql_dr_error'
dbdimp.c:3593: error: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_st_FETCH_internal':
dbdimp.c:3931: error: too few arguments to function `mysql_dr_error'
dbdimp.c:3945: error: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_bind_ph':
dbdimp.c:4264: error: too few arguments to function `mysql_dr_error'
dbdimp.c:4291: error: too few arguments to function `mysql_dr_error'
dbdimp.c:4303: error: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_db_reconnect':
dbdimp.c:4465: error: too few arguments to function `mysql_dr_error'
make: *** [dbdimp.o] Error 1
CAPTTOFU/DBD-mysql-4.004.tar.gz
/usr/bin/make -- NOT OK

Running make install
Make had returned bad status, install seems impossible
Net::DNS is up to date (0.59).
perlmod--Install done
root@web ~#

please help me...

You need to install the older DBD:mysql perl module as this latest ones has problems on som Os's (RHEv3/CentOSv3 IIRC). You can grab it from cpan.org, DBD-mysql-4.001 is the version that you need:

wget http://search.cpan.org/CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.001.tar.gz

Then install it manually by untarring the file, cd into the directory and run:

perl Makefile.PL
make
make install