The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'General Discussion' started by computerwis, Jan 27, 2011.

  1. computerwis

    computerwis Member

    Joined:
    Aug 28, 2010
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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
     
  2. Tecnoman

    Tecnoman Active Member

    Joined:
    Oct 23, 2006
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    Same Problem Here ! any help please ?

    I am running WHM 11.28.64
    CENTOS 5.5 x86_64 standard on server01

     
  3. harzem

    harzem Member

    Joined:
    May 28, 2007
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
  4. hostingtech

    hostingtech Member

    Joined:
    Feb 4, 2010
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Try below script on shell :


    /scripts/checkperlmodules --force

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

    harzem Member

    Joined:
    May 28, 2007
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
    #5 harzem, Jan 27, 2011
    Last edited: Jan 27, 2011
  6. harzem

    harzem Member

    Joined:
    May 28, 2007
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    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:

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

    computerwis Member

    Joined:
    Aug 28, 2010
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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:

    It seems something
     
  8. computerwis

    computerwis Member

    Joined:
    Aug 28, 2010
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Australia
  9. harzem

    harzem Member

    Joined:
    May 28, 2007
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Since my manual install i didnt receive any more error emails.
     
  10. ToT

    ToT Member

    Joined:
    Jan 23, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    @ 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:
    root@test # cd /home/.cpan/sources/authors/id/R/RE/REHSACK/
    root@test # wget [url]http://search.cpan.org/CPAN/authors/id/R/RE/REHSACK/SQL-Statement-1.31_002.tar.gz[/url]
    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 :

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

    Code:
    root@test # perl -MSQL::Statement -e "print \"SQL::Statement : \$SQL::Statement::VERSION\n\""
    SQL::Statement : 1.32
    
     
    #10 ToT, Jan 29, 2011
    Last edited: Jan 29, 2011
  11. computerwis

    computerwis Member

    Joined:
    Aug 28, 2010
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Australia
    Thank You TOT, That helped.

    Yes, there was no more errors.
     
  12. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    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.
     
  13. netandino

    netandino Registered

    Joined:
    Jan 15, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  14. cPDan

    cPDan cPanel Staff
    Staff Member

    Joined:
    Mar 9, 2004
    Messages:
    711
    Likes Received:
    4
    Trophy Points:
    18
    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!
     
  15. MaraBlue

    MaraBlue Well-Known Member

    Joined:
    May 3, 2005
    Messages:
    335
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    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.
     
  16. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    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.
     
  17. MaraBlue

    MaraBlue Well-Known Member

    Joined:
    May 3, 2005
    Messages:
    335
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Carmichael, CA
    cPanel Access Level:
    Root Administrator
    Re: [Case 46461] Check Perl Modules : SQL::Statement cannot be installed for Cpanel/W

    Bingo! You nailed it, thank you Tristan.
     
  18. hartofalyon

    hartofalyon Registered

    Joined:
    Feb 4, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Re: [Case 46461] Check Perl Modules : SQL::Statement cannot be installed for Cpanel/W

    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?
     
  19. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    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.
     
  20. hartofalyon

    hartofalyon Registered

    Joined:
    Feb 4, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Re: [Case 46461] Check Perl Modules : SQL::Statement cannot be installed for Cpanel/W

    Got it. Thanks!
     
Loading...

Share This Page