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

computerwis

Member
Aug 28, 2010
10
0
51
Australia
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

Code:
[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

Active Member
Oct 23, 2006
26
0
151
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

Member
May 28, 2007
9
0
151
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.
 

harzem

Member
May 28, 2007
9
0
151
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.
 
Last edited:

harzem

Member
May 28, 2007
9
0
151
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

Member
Aug 28, 2010
10
0
51
Australia
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
 

ToT

Member
Jan 23, 2008
8
0
51
@ 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 :

Code:
[email protected] # cd /home/.cpan/sources/authors/id/R/RE/REHSACK/
[email protected] # wget [url]http://search.cpan.org/CPAN/authors/id/R/RE/REHSACK/SQL-Statement-1.31_002.tar.gz[/url]
[email protected] # tar zxvf SQL-Statement-1.31_002.tar.gz
[email protected] # cd SQL-Statement-1.32 && perl Makefile.PL && make && make test && make install
Verify perl modules :

Code:
[email protected] # /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 :

Code:
[email protected] # perl -MSQL::Statement -e "print \"SQL::Statement : \$SQL::Statement::VERSION\n\""
SQL::Statement : 1.32
 
Last edited:

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
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:

Code:
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

Registered
Jan 15, 2010
2
0
51
Re: [Case 46461] Check Perl Modules : SQL::Statement cannot be installed for Cpanel/W

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

cPanel Staff
Staff member
Mar 9, 2004
721
13
243
Re: [Case 46461] Check Perl Modules : SQL::Statement cannot be installed for Cpanel/W

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

Well-Known Member
May 3, 2005
334
2
168
Carmichael, CA
cPanel Access Level
Root Administrator
Re: [Case 46461] Check Perl Modules : SQL::Statement cannot be installed for Cpanel/W

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.
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Re: [Case 46461] Check Perl Modules : SQL::Statement cannot be installed for Cpanel/W

This is only affecting the ones indicated. This issue was due to circular dependencies, which would be different than an out of memory error.

Of note, whenever running a process in WHM, you will be limited by the maximum memory per cPanel process in WHM > Tweak Settings > Max cPanel process memory area. If you have it as 256MB or 512MB, I would suggest increasing it if you have such an error again.
 

MaraBlue

Well-Known Member
May 3, 2005
334
2
168
Carmichael, CA
cPanel Access Level
Root Administrator
Re: [Case 46461] Check Perl Modules : SQL::Statement cannot be installed for Cpanel/W

This is only affecting the ones indicated. This issue was due to circular dependencies, which would be different than an out of memory error.

Of note, whenever running a process in WHM, you will be limited by the maximum memory per cPanel process in WHM > Tweak Settings > Max cPanel process memory area. If you have it as 256MB or 512MB, I would suggest increasing it if you have such an error again.
Bingo! You nailed it, thank you Tristan.
 

hartofalyon

Registered
Feb 4, 2011
2
0
51
Re: [Case 46461] Check Perl Modules : SQL::Statement cannot be installed for Cpanel/W

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
Sorry, I'm not sure what "hold back" means. I received this error a few days ago. Is there anything I have to do or will an updated fix be automatically applied?
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Re: [Case 46461] Check Perl Modules : SQL::Statement cannot be installed for Cpanel/W

You can simply run the commands I noted previously to fix this issue in the meantime:

Code:
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
We do not have an ETA on this being resolved by the vendor.
 

hartofalyon

Registered
Feb 4, 2011
2
0
51
Re: [Case 46461] Check Perl Modules : SQL::Statement cannot be installed for Cpanel/W

Got it. Thanks!