[Case 46461] Check Perl Modules : SQL::Statement cannot be installed for Cpanel/WHM.

[computerwis]

Hi,
I have the latest cpanel/whm with MySQL 5.1 installed and unable to install perl module SQL::Statement. Here is the error log.

The system keeps auto install it but it fails, do you know which dependency are still missing?

Thank You

[This module is required by cPanel, and the system may not function correctly until it is installed, and functional.  Below is the results of the auto-install attempt:

Test Run
==============
Can't locate SQL/Statement.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.8/x86_64-linux /usr/local/lib/perl5/5.8.8 /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux /usr/local/lib/perl5/site_perl/5.8.8 /usr/local/lib/perl5/site_perl .) at - line 1.
BEGIN failed--compilation aborted at - line 1.


Installer Run
==============
Testing connection speed...(using fast method)...Done
Ping:1 (ticks) Testing connection speed to mirrors.24-7-solutions.net using pureperl...(29250.00 bytes/s)...Done
Ping:1 (ticks) Testing connection speed to cpan.pair.com using pureperl...(19400.00 bytes/s)...Done
Ping:1 (ticks) Testing connection speed to cpan.erlbaum.net using pureperl...(257.20 bytes/s)...Done
Three usable mirrors located
Mirror Check passed for mirrors.24-7-solutions.net (/index.html)
Disabling /bin/wget since LWP is available at /usr/local/cpanel/Cpanel/cPCPAN/Config.pm line 82.
Disabling /bin/ftp since Net::FTP is available at /usr/local/cpanel/Cpanel/cPCPAN/Config.pm line 87.
commit: wrote '/usr/local/lib/perl5/5.8.8/CPAN/Config.pm'
Going to read '/home/.cpan/Metadata'
 Database was generated on Wed, 26 Jan 2011 06:46:16 GMT
Running install for module 'SQL::Statement'
Running make for R/RE/REHSACK/SQL-Statement-1.32.tar.gz
CPAN: Digest::SHA loaded ok (v5.50)
CPAN: Compress::Zlib loaded ok (v2.033)
Checksum for /home/.cpan/sources/authors/id/R/RE/REHSACK/SQL-Statement-1.32.tar.gz ok
CPAN: Archive::Tar loaded ok (v1.76)
SQL-Statement-1.32
SQL-Statement-1.32/t
SQL-Statement-1.32/t/04idents.t
SQL-Statement-1.32/t/03import.t
SQL-Statement-1.32/t/SQLtest.pm
SQL-Statement-1.32/t/17quoting.t
SQL-Statement-1.32/t/02execute.t
SQL-Statement-1.32/t/00error.t
SQL-Statement-1.32/t/01prepare.t
SQL-Statement-1.32/t/09ops.t
SQL-Statement-1.32/t/08join.t
SQL-Statement-1.32/t/TestLib.pm
SQL-Statement-1.32/t/06virtual.t
SQL-Statement-1.32/t/12eval.t
SQL-Statement-1.32/t/23dialects.t
SQL-Statement-1.32/t/10limit.t
SQL-Statement-1.32/t/05simple.t
SQL-Statement-1.32/lib
SQL-Statement-1.32/lib/SQL
SQL-Statement-1.32/lib/SQL/Dialects
SQL-Statement-1.32/lib/SQL/Dialects/ANSI.pm
SQL-Statement-1.32/lib/SQL/Dialects/Role.pm
SQL-Statement-1.32/lib/SQL/Dialects/AnyData.pm
SQL-Statement-1.32/lib/SQL/Dialects/CSV.pm
SQL-Statement-1.32/lib/SQL/Statement
SQL-Statement-1.32/lib/SQL/Statement/TermFactory.pm
SQL-Statement-1.32/lib/SQL/Statement/Structure.pod
SQL-Statement-1.32/lib/SQL/Statement/GetInfo.pm
SQL-Statement-1.32/lib/SQL/Statement/Term.pm
SQL-Statement-1.32/lib/SQL/Statement/Syntax.pod
SQL-Statement-1.32/lib/SQL/Statement/RAM.pm
SQL-Statement-1.32/lib/SQL/Statement/Placeholder.pm
SQL-Statement-1.32/lib/SQL/Statement/Roadmap.pod
SQL-Statement-1.32/lib/SQL/Statement/Function.pm
SQL-Statement-1.32/lib/SQL/Statement/Util.pm
SQL-Statement-1.32/lib/SQL/Statement/Embed.pod
SQL-Statement-1.32/lib/SQL/Statement/Operation.pm
SQL-Statement-1.32/lib/SQL/Statement/Functions.pm
SQL-Statement-1.32/lib/SQL/Statement.pm
SQL-Statement-1.32/lib/SQL/Parser.pm
SQL-Statement-1.32/lib/SQL/Eval.pm
SQL-Statement-1.32/Changes
SQL-Statement-1.32/MANIFEST
SQL-Statement-1.32/META.yml
SQL-Statement-1.32/xt
SQL-Statement-1.32/xt/pod_coverage.t
SQL-Statement-1.32/xt/pod.t
SQL-Statement-1.32/xt/pod-cm.t
SQL-Statement-1.32/.aspell.local.pws
SQL-Statement-1.32/MANIFEST.SKIP
SQL-Statement-1.32/Makefile.PL
SQL-Statement-1.32/README
CPAN: File::Temp loaded ok (v0.22)
CPAN: YAML loaded ok (v0.72)

 CPAN.pm: Going to build R/RE/REHSACK/SQL-Statement-1.32.tar.gz

perl-64bit-hack: enabled
Checking if your kit is complete...
Looks good
Warning: prerequisite DBD::AnyData 0.110 not found.
Warning: prerequisite DBD::CSV 0.30 not found.
'EXTRALIBDIR' is not a known MakeMaker parameter name.
'OTHERLDFLAGS' is not a known MakeMaker parameter name.
Writing Makefile for SQL::Statement
---- Unsatisfied dependencies detected during ----
----     REHSACK/SQL-Statement-1.32.tar.gz    ----
   DBD::AnyData [requires]
   DBD::CSV [requires]
Running make install
 Delayed until after prerequisites
Running install for module 'DBD::AnyData'
Running make for R/RE/REHSACK/DBD-AnyData-0.110.tar.gz
Checksum for /home/.cpan/sources/authors/id/R/RE/REHSACK/DBD-AnyData-0.110.tar.gz ok
DBD-AnyData-0.110
DBD-AnyData-0.110/META.yml
DBD-AnyData-0.110/Changes
DBD-AnyData-0.110/MANIFEST
DBD-AnyData-0.110/MANIFEST.SKIP
DBD-AnyData-0.110/Build.PL
DBD-AnyData-0.110/Makefile.PL
DBD-AnyData-0.110/README
DBD-AnyData-0.110/lib
DBD-AnyData-0.110/lib/DBD
DBD-AnyData-0.110/lib/DBD/AnyData.pm
DBD-AnyData-0.110/t
DBD-AnyData-0.110/t/00-load.t
DBD-AnyData-0.110/t/manifest.t
DBD-AnyData-0.110/t/pod.t
DBD-AnyData-0.110/t/01-basic.t
CPAN: Module::Build loaded ok (v0.3622)

 CPAN.pm: Going to build R/RE/REHSACK/DBD-AnyData-0.110.tar.gz

perl-64bit-hack: enabled
Checking if your kit is complete...
Looks good
Warning: prerequisite AnyData 0.07 not found.
Warning: prerequisite SQL::Statement 1.27_02 not found.
'EXTRALIBDIR' is not a known MakeMaker parameter name.
'OTHERLDFLAGS' is not a known MakeMaker parameter name.
Writing Makefile for DBD::AnyData
---- Unsatisfied dependencies detected during ----
----     REHSACK/DBD-AnyData-0.110.tar.gz     ----
   SQL::Statement [requires]
   AnyData [requires]

Recursive dependency detected:
   SQL::Statement (have: N/A; want: 1.32)
 => REHSACK/SQL-Statement-1.32.tar.gz
 => DBD::AnyData (have: N/A; requires: 0.110)
 => REHSACK/DBD-AnyData-0.110.tar.gz
 => SQL::Statement (have: N/A; requires: 1.27_02).
Cannot resolve.
 REHSACK/DBD-AnyData-0.110.tar.gz
 [depend] -- NOT OK

Running make install
 Make had returned bad status, install seems impossible
Running install for module 'DBD::CSV'
Running make for H/HM/HMBRAND/DBD-CSV-0.31.tgz

Checksum for /home/.cpan/sources/authors/id/H/HM/HMBRAND/DBD-CSV-0.31.tgz ok
DBD-CSV-0.31/
DBD-CSV-0.31/README
DBD-CSV-0.31/MANIFEST.SKIP
DBD-CSV-0.31/t/
DBD-CSV-0.31/t/42_bindparam.t
DBD-CSV-0.31/t/11_dsnlist.t
DBD-CSV-0.31/t/51_commit.t
DBD-CSV-0.31/t/43_blobs.t
DBD-CSV-0.31/t/31_delete.t
DBD-CSV-0.31/t/50_chopblanks.t
DBD-CSV-0.31/t/30_insertfetch.t
DBD-CSV-0.31/t/00_pod.t
DBD-CSV-0.31/t/lib.pl
DBD-CSV-0.31/t/40_numrows.t
DBD-CSV-0.31/t/80_rt.t
DBD-CSV-0.31/t/00_pod_cov.t
DBD-CSV-0.31/t/10_base.t
DBD-CSV-0.31/t/70_csv.t
DBD-CSV-0.31/t/72_csv-schema.t
DBD-CSV-0.31/t/00_meta.t
DBD-CSV-0.31/t/60_misc.t
DBD-CSV-0.31/t/48_utf8.t
DBD-CSV-0.31/t/71_csv-ext.t
DBD-CSV-0.31/t/73_csv-case.t
DBD-CSV-0.31/t/41_nulls.t
DBD-CSV-0.31/t/20_createdrop.t
DBD-CSV-0.31/t/44_listfields.t
DBD-CSV-0.31/examples/
DBD-CSV-0.31/examples/passwd.pl
DBD-CSV-0.31/META.yml
DBD-CSV-0.31/MANIFEST
DBD-CSV-0.31/lib/
DBD-CSV-0.31/lib/DBD/
DBD-CSV-0.31/lib/DBD/CSV.pm
DBD-CSV-0.31/lib/Bundle/
DBD-CSV-0.31/lib/Bundle/DBD/
DBD-CSV-0.31/lib/Bundle/DBD/CSV.pm
DBD-CSV-0.31/ChangeLog
DBD-CSV-0.31/Makefile.PL

 CPAN.pm: Going to build H/HM/HMBRAND/DBD-CSV-0.31.tgz

perl-64bit-hack: enabled
Checking if your kit is complete...
Looks good
Warning: prerequisite SQL::Statement 1.3 not found.
'EXTRALIBDIR' is not a known MakeMaker parameter name.
'OTHERLDFLAGS' is not a known MakeMaker parameter name.
Writing Makefile for DBD::CSV
---- Unsatisfied dependencies detected during ----
----         HMBRAND/DBD-CSV-0.31.tgz         ----
   SQL::Statement [requires]

Recursive dependency detected:
   SQL::Statement (have: N/A; want: 1.32)
 => REHSACK/SQL-Statement-1.32.tar.gz
 => DBD::AnyData (have: N/A; requires: 0.110)
 => REHSACK/DBD-AnyData-0.110.tar.gz
 => SQL::Statement (have: N/A; requires: 1.27_02).
Cannot resolve.
 HMBRAND/DBD-CSV-0.31.tgz
 [depend] -- NOT OK

Running make install
 Make had some problems, won't install
Running make for R/RE/REHSACK/SQL-Statement-1.32.tar.gz
 Has already been unwrapped into directory /home/.cpan/build/SQL-Statement-1.32-pb0JXa

 CPAN.pm: Going to build R/RE/REHSACK/SQL-Statement-1.32.tar.gz


Warning: Prerequisite 'DBD::AnyData => 0.110' for 'REHSACK/SQL-Statement-1.32.tar.gz' failed when processing 'REHSACK/DBD-AnyData-0.110.tar.gz' with 'make => NO cannot resolve circular dependency'. Continuing, but chances to succeed are limited.
CPAN: Time::HiRes loaded ok (v1.9721)
---- Unsatisfied dependencies detected during ----
----     REHSACK/SQL-Statement-1.32.tar.gz    ----
   DBD::CSV [requires]

Recursive dependency detected:
   DBD::CSV (have: N/A; want: 0.31)
 => HMBRAND/DBD-CSV-0.31.tgz
 => SQL::Statement (have: N/A; requires: 1.3)
 => REHSACK/SQL-Statement-1.32.tar.gz
 => DBD::AnyData (have: N/A; requires: 0.110)
 => REHSACK/DBD-AnyData-0.110.tar.gz
 => SQL::Statement (have: N/A; requires: 1.27_02).
Cannot resolve.
 REHSACK/SQL-Statement-1.32.tar.gz
 [depend] -- NOT OK

Running make install
 Make had returned bad status, install seems impossible

perlmod--Install done

[Tecnoman]

Same Problem Here ! any help please ?

I am running WHM 11.28.64
CENTOS 5.5 x86_64 standard on server01

This module is required by cPanel, and the system may not function correctly until it is installed, and functional. Below is the results of the auto-install attempt:

Test Run
==============
Can't locate SQL/Statement.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at - line 1.
BEGIN failed--compilation aborted at - line 1.


Installer Run
==============
Testing connection speed...(using fast method)...Done
Ping:1 (ticks) Testing connection speed to ftp.osuosl.org using pureperl...(28700.00 bytes/s)...Done
Ping:1 (ticks) Testing connection speed to mirrors.servercentral.net using pureperl...(28050.00 bytes/s)...Done
Ping:1 (ticks) Testing connection speed to cpan.netnitco.net using pureperl...(29850.00 bytes/s)...Done
Three usable mirrors located
Mirror Check passed for cpan.netnitco.net (/index.html)
Disabling /bin/wget since LWP is available at /usr/local/cpanel/Cpanel/cPCPAN/Config.pm line 82.
Disabling /bin/ftp since Net::FTP is available at /usr/local/cpanel/Cpanel/cPCPAN/Config.pm line 87.
commit: wrote '/usr/lib/perl5/5.8.8/CPAN/Config.pm'
Going to read '/home/.cpan/Metadata'
Database was generated on Wed, 26 Jan 2011 15:03:26 GMT
Running install for module 'SQL::Statement'
Running make for R/RE/REHSACK/SQL-Statement-1.32.tar.gz
CPAN: Digest::SHA loaded ok (v5.50)
CPAN: Compress::Zlib loaded ok (v2.033)
Checksum for /home/.cpan/sources/authors/id/R/RE/REHSACK/SQL-Statement-1.32.tar.gz ok
CPAN: Archive::Tar loaded ok (v1.76)
SQL-Statement-1.32
SQL-Statement-1.32/t
SQL-Statement-1.32/t/04idents.t
SQL-Statement-1.32/t/03import.t
SQL-Statement-1.32/t/SQLtest.pm
SQL-Statement-1.32/t/17quoting.t
SQL-Statement-1.32/t/02execute.t
SQL-Statement-1.32/t/00error.t
SQL-Statement-1.32/t/01prepare.t
SQL-Statement-1.32/t/09ops.t
SQL-Statement-1.32/t/08join.t
SQL-Statement-1.32/t/TestLib.pm
SQL-Statement-1.32/t/06virtual.t
SQL-Statement-1.32/t/12eval.t
SQL-Statement-1.32/t/23dialects.t
SQL-Statement-1.32/t/10limit.t
SQL-Statement-1.32/t/05simple.t
SQL-Statement-1.32/lib
SQL-Statement-1.32/lib/SQL
SQL-Statement-1.32/lib/SQL/Dialects
SQL-Statement-1.32/lib/SQL/Dialects/ANSI.pm
SQL-Statement-1.32/lib/SQL/Dialects/Role.pm
SQL-Statement-1.32/lib/SQL/Dialects/AnyData.pm
SQL-Statement-1.32/lib/SQL/Dialects/CSV.pm
SQL-Statement-1.32/lib/SQL/Statement
SQL-Statement-1.32/lib/SQL/Statement/TermFactory.pm
SQL-Statement-1.32/lib/SQL/Statement/Structure.pod
SQL-Statement-1.32/lib/SQL/Statement/GetInfo.pm
SQL-Statement-1.32/lib/SQL/Statement/Term.pm
SQL-Statement-1.32/lib/SQL/Statement/Syntax.pod
SQL-Statement-1.32/lib/SQL/Statement/RAM.pm
SQL-Statement-1.32/lib/SQL/Statement/Placeholder.pm
SQL-Statement-1.32/lib/SQL/Statement/Roadmap.pod
SQL-Statement-1.32/lib/SQL/Statement/Function.pm
SQL-Statement-1.32/lib/SQL/Statement/Util.pm
SQL-Statement-1.32/lib/SQL/Statement/Embed.pod
SQL-Statement-1.32/lib/SQL/Statement/Operation.pm
SQL-Statement-1.32/lib/SQL/Statement/Functions.pm
SQL-Statement-1.32/lib/SQL/Statement.pm
SQL-Statement-1.32/lib/SQL/Parser.pm
SQL-Statement-1.32/lib/SQL/Eval.pm
SQL-Statement-1.32/Changes
SQL-Statement-1.32/MANIFEST
SQL-Statement-1.32/META.yml
SQL-Statement-1.32/xt
SQL-Statement-1.32/xt/pod_coverage.t
SQL-Statement-1.32/xt/pod.t
SQL-Statement-1.32/xt/pod-cm.t
SQL-Statement-1.32/.aspell.local.pws
SQL-Statement-1.32/MANIFEST.SKIP
SQL-Statement-1.32/Makefile.PL
SQL-Statement-1.32/README
CPAN: File::Temp loaded ok (v0.22)
CPAN: YAML loaded ok (v0.72)

CPAN.pm: Going to build R/RE/REHSACK/SQL-Statement-1.32.tar.gz

perl-64bit-hack: enabled
Checking if your kit is complete...
Looks good
Warning: prerequisite DBD::AnyData 0.110 not found.
Warning: prerequisite DBD::CSV 0.30 not found.
'EXTRALIBDIR' is not a known MakeMaker parameter name.
'OTHERLDFLAGS' is not a known MakeMaker parameter name.
Writing Makefile for SQL::Statement
---- Unsatisfied dependencies detected during ----
---- REHSACK/SQL-Statement-1.32.tar.gz ----
DBD::AnyData [requires]
DBD::CSV [requires]
Running make install
Delayed until after prerequisites
Running install for module 'DBD::AnyData'
Running make for R/RE/REHSACK/DBD-AnyData-0.110.tar.gz
Checksum for /home/.cpan/sources/authors/id/R/RE/REHSACK/DBD-AnyData-0.110.tar.gz ok
DBD-AnyData-0.110
DBD-AnyData-0.110/META.yml
DBD-AnyData-0.110/Changes
DBD-AnyData-0.110/MANIFEST
DBD-AnyData-0.110/MANIFEST.SKIP
DBD-AnyData-0.110/Build.PL
DBD-AnyData-0.110/Makefile.PL
DBD-AnyData-0.110/README
DBD-AnyData-0.110/lib
DBD-AnyData-0.110/lib/DBD
DBD-AnyData-0.110/lib/DBD/AnyData.pm
DBD-AnyData-0.110/t
DBD-AnyData-0.110/t/00-load.t
DBD-AnyData-0.110/t/manifest.t
DBD-AnyData-0.110/t/pod.t
DBD-AnyData-0.110/t/01-basic.t
CPAN: Module::Build loaded ok (v0.3622)

CPAN.pm: Going to build R/RE/REHSACK/DBD-AnyData-0.110.tar.gz

perl-64bit-hack: enabled
Checking if your kit is complete...
Looks good
Warning: prerequisite AnyData 0.07 not found.
Warning: prerequisite SQL::Statement 1.27_02 not found.
'EXTRALIBDIR' is not a known MakeMaker parameter name.
'OTHERLDFLAGS' is not a known MakeMaker parameter name.
Writing Makefile for DBD::AnyData
---- Unsatisfied dependencies detected during ----
---- REHSACK/DBD-AnyData-0.110.tar.gz ----
SQL::Statement [requires]
AnyData [requires]

Recursive dependency detected:
SQL::Statement (have: N/A; want: 1.32)
=> REHSACK/SQL-Statement-1.32.tar.gz
=> DBD::AnyData (have: N/A; requires: 0.110)
=> REHSACK/DBD-AnyData-0.110.tar.gz
=> SQL::Statement (have: N/A; requires: 1.27_02).
Cannot resolve.
REHSACK/DBD-AnyData-0.110.tar.gz
[depend] -- NOT OK


Running make install
Make had returned bad status, install seems impossible
Running install for module 'DBD::CSV'
Running make for H/HM/HMBRAND/DBD-CSV-0.31.tgz
Checksum for /home/.cpan/sources/authors/id/H/HM/HMBRAND/DBD-CSV-0.31.tgz ok
DBD-CSV-0.31/
DBD-CSV-0.31/README
DBD-CSV-0.31/MANIFEST.SKIP
DBD-CSV-0.31/t/
DBD-CSV-0.31/t/42_bindparam.t
DBD-CSV-0.31/t/11_dsnlist.t
DBD-CSV-0.31/t/51_commit.t
DBD-CSV-0.31/t/43_blobs.t
DBD-CSV-0.31/t/31_delete.t
DBD-CSV-0.31/t/50_chopblanks.t
DBD-CSV-0.31/t/30_insertfetch.t
DBD-CSV-0.31/t/00_pod.t
DBD-CSV-0.31/t/lib.pl
DBD-CSV-0.31/t/40_numrows.t
DBD-CSV-0.31/t/80_rt.t
DBD-CSV-0.31/t/00_pod_cov.t
DBD-CSV-0.31/t/10_base.t
DBD-CSV-0.31/t/70_csv.t
DBD-CSV-0.31/t/72_csv-schema.t
DBD-CSV-0.31/t/00_meta.t
DBD-CSV-0.31/t/60_misc.t
DBD-CSV-0.31/t/48_utf8.t
DBD-CSV-0.31/t/71_csv-ext.t
DBD-CSV-0.31/t/73_csv-case.t
DBD-CSV-0.31/t/41_nulls.t
DBD-CSV-0.31/t/20_createdrop.t
DBD-CSV-0.31/t/44_listfields.t
DBD-CSV-0.31/examples/
DBD-CSV-0.31/examples/passwd.pl
DBD-CSV-0.31/META.yml
DBD-CSV-0.31/MANIFEST
DBD-CSV-0.31/lib/
DBD-CSV-0.31/lib/DBD/
DBD-CSV-0.31/lib/DBD/CSV.pm
DBD-CSV-0.31/lib/Bundle/
DBD-CSV-0.31/lib/Bundle/DBD/
DBD-CSV-0.31/lib/Bundle/DBD/CSV.pm
DBD-CSV-0.31/ChangeLog
DBD-CSV-0.31/Makefile.PL

CPAN.pm: Going to build H/HM/HMBRAND/DBD-CSV-0.31.tgz

perl-64bit-hack: enabled
Checking if your kit is complete...
Looks good
Warning: prerequisite SQL::Statement 1.3 not found.
'EXTRALIBDIR' is not a known MakeMaker parameter name.
'OTHERLDFLAGS' is not a known MakeMaker parameter name.
Writing Makefile for DBD::CSV
---- Unsatisfied dependencies detected during ----
---- HMBRAND/DBD-CSV-0.31.tgz ----
SQL::Statement [requires]

Recursive dependency detected:
SQL::Statement (have: N/A; want: 1.32)
=> REHSACK/SQL-Statement-1.32.tar.gz
=> DBD::AnyData (have: N/A; requires: 0.110)
=> REHSACK/DBD-AnyData-0.110.tar.gz
=> SQL::Statement (have: N/A; requires: 1.27_02).
Cannot resolve.
HMBRAND/DBD-CSV-0.31.tgz
[depend] -- NOT OK


Running make install
Make had some problems, won't install
Running make for R/RE/REHSACK/SQL-Statement-1.32.tar.gz
Has already been unwrapped into directory /home/.cpan/build/SQL-Statement-1.32-V8dmX2

CPAN.pm: Going to build R/RE/REHSACK/SQL-Statement-1.32.tar.gz

Warning: Prerequisite 'DBD::AnyData => 0.110' for 'REHSACK/SQL-Statement-1.32.tar.gz' failed when processing 'REHSACK/DBD-AnyData-0.110.tar.gz' with 'make => NO cannot resolve circular dependency'. Continuing, but chances to succeed are limited.
CPAN: Time::HiRes loaded ok (v1.9721)
---- Unsatisfied dependencies detected during ----
---- REHSACK/SQL-Statement-1.32.tar.gz ----
DBD::CSV [requires]

Recursive dependency detected:
DBD::CSV (have: N/A; want: 0.31)
=> HMBRAND/DBD-CSV-0.31.tgz
=> SQL::Statement (have: N/A; requires: 1.3)
=> REHSACK/SQL-Statement-1.32.tar.gz
=> DBD::AnyData (have: N/A; requires: 0.110)
=> REHSACK/DBD-AnyData-0.110.tar.gz
=> SQL::Statement (have: N/A; requires: 1.27_02).
Cannot resolve.
REHSACK/SQL-Statement-1.32.tar.gz
[depend] -- NOT OK

Running make install
Make had returned bad status, install seems impossible

perlmod--Install done

[harzem]

Same problem here.

[checkperlmodules] The perl module SQL::Statement could not be installed.

Can't locate SQL/Statement.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.8/i686-linux /usr/local/lib/perl5/5.8.8 /usr/local/lib/perl5/site_perl/5.8.8/i686-linux /usr/local/lib/perl5/site_perl/5.8.8 /usr/local/lib/perl5/site_perl .) at - line 1.
BEGIN failed--compilation aborted at - line 1.

[hostingtech]

Try below script on shell :


/scripts/checkperlmodules --force

Or you can try mentioning module name at end of above line to force its installation.

[harzem]

I did that.
/scripts/checkperlmodules --force
/scripts/upcp --force

neither helps.

Edit: wait a minute, maybe it's working. I restarted cpanel after these commands, and I'm getting a PID.

Edit2: Nevermind, I confused the servers. I'm updating two servers, and the already-working one is working I'll update when I'm in a better state of mind, it's 1 AM here.

[harzem]

Now I did what this page says:
SQL::Statement - search.cpan.org

I manually installed it, but I don't know how I check whether it really worked or not. At first, it said this:

Checking if your kit is complete...
Looks good
Warning: prerequisite DBD::AnyData 0.110 not found.
Warning: prerequisite DBD::CSV 0.30 not found.
Writing Makefile for SQL::Statement

But then test shown PASS and install seems to be fine.

[computerwis]

Hi,
I think you shouldn't do the manual install. I might try it but I need a confirmation, that is really works.

Back to my problem: I did checkperlmodules and the upcp command with force and still the same problem.
Here is the end log:

perlmod--Install done
Notification => via EMAIL [level => 1]
Tested 119, 118 ok, 1 failed.
Failed install: SQL::Statement

It seems something

[computerwis]

I just found a solution that might work - Enable/Disable SuExec

Disable SuExec and I will try again.

http://forums.cpanel.net/f34/require...8-c-38839.html

[harzem]

Since my manual install i didnt receive any more error emails.

[ToT]

@ computerwis :
Critical bug on SQL-Statement-1.32 : https://rt.cpan.org/Public/Bug/Display.html?id=65041

Temporary solution : install SQL-Statement-1.31_002

How to :

root@test # cd /home/.cpan/sources/authors/id/R/RE/REHSACK/
root@test # wget http://search.cpan.org/CPAN/authors/....31_002.tar.gz
root@test # tar zxvf SQL-Statement-1.31_002.tar.gz
root@test # cd SQL-Statement-1.32 && perl Makefile.PL && make && make test && make install

Verify perl modules :

root@test # /scripts/checkperlmodules 

.............
perlmod--Install done
Using fast module check.....checked 119 modules in 0 second(s)
Tested 119, 119 ok, 0 failed.

Verify SQL::Statement version :

root@test # perl -MSQL::Statement -e "print \"SQL::Statement : \$SQL::Statement::VERSION\n\""
SQL::Statement : 1.32

[computerwis]

Thank You TOT, That helped.

Yes, there was no more errors.

[cPanelTristan]

Hello,

We have an internal case (#46461) opened about this upstream vendor bug that is causing this issue. Another method to use to resolve this would be the following, which was taken from that case:

cd /usr/local/src
wget http://search.cpan.org/CPAN/authors/id/H/HM/HMBRAND/DBD-CSV-0.31.tgz
tar -zxvf DBD-CSV-0.31.tgz
cd DBD-CSV-0.31
perl Makefile.PL
make install
cd ../
wget http://search.cpan.org/CPAN/authors/id/R/RE/REHSACK/DBD-AnyData-0.110.tar.gz
tar -zxvf DBD-AnyData-0.110.tar.gz
cd DBD-AnyData-0.110
perl Makefile.PL
make install
/scripts/perlinstaller SQL::Statement

This is basically a circular dependencies issue where SQL::Statement requires DBD::AnyData and DBD::AnyData requires SQL::Statement.

Thanks.

[netandino]

that should this problem happened to me with two servers I get the same from CentOS 5.x 32-bit and 64-bit 5.x

[cpdan]

Hello,

I've attached a new version to the rt report ready to be uploaded to CPAN and contacted the author directly to see if he is in a position to upload the fix.

If there is no response by tomorrow we'll be doing a hold back on it so that our fixed version will be used by our checkperlmodules

Thanks!

[MaraBlue]

Is the "upstream vendor bug" affecting *only* SQL::Statement, or other perl mods as well? I tried to install 2 mods tonight, Date::Calc and Date:Manip through WHM ->Software ->Install Perl Mods, and all I got on both was an "out of memory error." In 8 years of admin'ing cPanel servers, this is my first out of memory error

I checked the max memory ("unlimit -m") and it's unlimited. I installed both mods via SSH with no problems.