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.

Cpanel Update MySQL Problem

Discussion in 'General Discussion' started by Zandaline, Mar 5, 2007.

  1. Zandaline

    Zandaline Member

    Joined:
    Apr 25, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    I'm running: WHM 10.8.0 cPanel 10.9.0-R139 and my updates are set to Automatic Release

    I got the report from the automated daily update and I see there was an error updating MySQL. It is the only error that occurs. Looking back this error happened yesterday and again today so I figure it's not going to work itself out. Do any of you have some suggestions on how to fix this?

    Thank you,




    Code:
    Checksum for /home/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.003.tar.gz ok Scanning cache /home/.cpan/build for sizes DBD-mysql-4.003/ DBD-mysql-4.003/ChangeLog DBD-mysql-4.003/constants.h DBD-mysql-4.003/dbdimp.c DBD-mysql-4.003/dbdimp.h DBD-mysql-4.003/eg/ DBD-mysql-4.003/eg/prepare_memory_usage.pl
    DBD-mysql-4.003/eg/proc_example1.pl
    DBD-mysql-4.003/eg/proc_example2.pl
    DBD-mysql-4.003/eg/proc_example3.pl
    DBD-mysql-4.003/INSTALL.html
    DBD-mysql-4.003/lib/
    DBD-mysql-4.003/lib/Bundle/
    DBD-mysql-4.003/lib/Bundle/DBD/
    DBD-mysql-4.003/lib/Bundle/DBD/mysql.pm
    DBD-mysql-4.003/lib/DBD/
    DBD-mysql-4.003/lib/DBD/mysql/
    DBD-mysql-4.003/lib/DBD/mysql/GetInfo.pm
    DBD-mysql-4.003/lib/DBD/mysql/INSTALL.pod
    DBD-mysql-4.003/lib/DBD/mysql.pm
    DBD-mysql-4.003/Makefile.PL
    DBD-mysql-4.003/Makefile.PL.embedded
    DBD-mysql-4.003/MANIFEST
    DBD-mysql-4.003/MANIFEST.SKIP
    DBD-mysql-4.003/META.yml
    DBD-mysql-4.003/myld
    DBD-mysql-4.003/mysql.xs
    DBD-mysql-4.003/README
    DBD-mysql-4.003/t/
    DBD-mysql-4.003/t/00base.t
    DBD-mysql-4.003/t/10dsnlist.t
    DBD-mysql-4.003/t/20createdrop.t
    DBD-mysql-4.003/t/30insertfetch.t
    DBD-mysql-4.003/t/35limit.t
    DBD-mysql-4.003/t/35prepare.t
    DBD-mysql-4.003/t/40bindparam.t
    DBD-mysql-4.003/t/40bindparam2.t
    DBD-mysql-4.003/t/40blobs.t
    DBD-mysql-4.003/t/40catalog.t
    DBD-mysql-4.003/t/40listfields.t
    DBD-mysql-4.003/t/40nulls.t
    DBD-mysql-4.003/t/40numrows.t
    DBD-mysql-4.003/t/41bindparam.t
    DBD-mysql-4.003/t/41blobs_prepare.t
    DBD-mysql-4.003/t/42bindparam.t
    DBD-mysql-4.003/t/50chopblanks.t
    DBD-mysql-4.003/t/50commit.t
    DBD-mysql-4.003/t/60leaks.t
    DBD-mysql-4.003/t/70takeimp.t
    DBD-mysql-4.003/t/75supported_sql.t
    DBD-mysql-4.003/t/80procs.t
    DBD-mysql-4.003/t/insertid.t
    DBD-mysql-4.003/t/lib.pl
    DBD-mysql-4.003/t/mysql.dbtest
    DBD-mysql-4.003/t/param_values.t
    DBD-mysql-4.003/t/prepare_noerror.t
    DBD-mysql-4.003/t/texecute.t
    DBD-mysql-4.003/t/utf8.t
    DBD-mysql-4.003/TODO
    Removing previously used /home/.cpan/build/DBD-mysql-4.003
    
      CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-4.003.tar.gz
    
    I will use the following settings for compiling and testing:
    
      cflags        (mysql_config) = -I/usr/include/mysql -g -pipe -march=i386 -mcpu=i686
      embedded      (mysql_config) = 
      libs          (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
      mysql_config  (guessed     ) = mysql_config
      nocatchstderr (default     ) = 0
      nofoundrows   (default     ) = 0
      ssl           (guessed     ) = 0
      testdb        (default     ) = test
      testhost      (default     ) = 
      testpassword  (default     ) = 
      testsocket    (default     ) = 
      testuser      (default     ) = 
    
    To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'.
    
    
    
    
    
    
    
    
    Checking if your kit is complete...
    Looks good
    Using DBI 1.54 (for perl 5.008007 on i686-linux) installed in /usr/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBI/
    Writing Makefile for DBD::mysql
    CPAN: YAML loaded ok
    cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod 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-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2   -DVERSION=\"4.003\" -DXS_VERSION=\"4.003\" -fpic "-I/usr/lib/perl5/5.8.7/i686-linux/CORE"   dbdimp.c
    dbdimp.c:1269: conflicting types for `mysql_dr_error'
    dbdimp.h:288: previous declaration of `mysql_dr_error'
    dbdimp.c: In function `mysql_st_fetch':
    dbdimp.c:3419: too few arguments to function `mysql_dr_error'
    dbdimp.c:3583: too few arguments to function `mysql_dr_error'
    dbdimp.c: In function `mysql_st_FETCH_internal':
    dbdimp.c:3915: too few arguments to function `mysql_dr_error'
    dbdimp.c:3929: too few arguments to function `mysql_dr_error'
    dbdimp.c: In function `mysql_bind_ph':
    dbdimp.c:4244: too few arguments to function `mysql_dr_error'
    dbdimp.c:4271: too few arguments to function `mysql_dr_error'
    dbdimp.c:4283: too few arguments to function `mysql_dr_error'
    dbdimp.c: In function `mysql_db_reconnect':
    dbdimp.c:4445: too few arguments to function `mysql_dr_error'
    make: *** [dbdimp.o] Error 1
      /usr/bin/make  -- NOT OK
    
    Running make install
      make had returned bad status, install seems impossible Bundle summary: The following items in bundle Bundle::DBD::mysql had installation problems:
      DBD::mysql
    
     
  2. amaralx

    amaralx Registered

    Joined:
    Dec 13, 2005
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hello, just to say that i have the same problem with the same versions but on freebsd 5.4.
    Any solution ???
     
  3. Zandaline

    Zandaline Member

    Joined:
    Apr 25, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Just giving this a Bump in hopes someone from Cpanel can help.
     
  4. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    865
    Likes Received:
    9
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Try this:
    Code:
    /scripts/perlinstaller --force Bundle::DBD::mysql
     
  5. dahu

    dahu Member

    Joined:
    Dec 7, 2001
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    i have the same problem too.

    Did you fix it ? did the kernow command "/scripts/perlinstaller --force Bundle::DBD::mysql" works ? (i just want to know before trying it)

    thank you
     
  6. amaralx

    amaralx Registered

    Joined:
    Dec 13, 2005
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    just to say that the command doesn't work :)

    The output in attached file
     

    Attached Files:

    • out.txt
      File size:
      21.9 KB
      Views:
      75
  7. elenlace

    elenlace Well-Known Member

    Joined:
    Sep 10, 2002
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    US
    I have the same issue. Any solutions yet?
     
  8. psrsathish

    psrsathish Active Member

    Joined:
    Jul 19, 2006
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    India.
    Hi,

    Check whether all the below Perl Modules are installed on your box, If not then install all the below perl modules to fix the issue :)


    DBD::mysql
    DBD::mysql::AutoTypes
    DBD::mysql::GetInfo
    DBD::mysql::Install
    DBD::mysql::SimpleMySQL
    DBD::mysqlPP
    DBIx::DBSchema::DBD::mysql
    DBIx::TextIndex::DBD::mysql
    Data::ObjectDriver::Driver::DBD::mysql
    SQL::AnyDBD::Mysql
     
  9. eagle

    eagle Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    141
    Likes Received:
    0
    Trophy Points:
    16
    Install of DBD::mysql still is not possible, not even with --force.

    Is there a fix for this?

    Edit:
    Going for the 4.003 manually doesn't work either:

     
    #9 eagle, Mar 14, 2007
    Last edited: Mar 14, 2007
  10. amaralx

    amaralx Registered

    Joined:
    Dec 13, 2005
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hi.
    Just to say that this is a perl module problem and not a cpanel problem.
    i try to compile manually the module and it also fails.

    This are the commands for manual instalation :
    Substitute the 1.2216 version by 4.003

    Manual installation

    For a manual installation you need to fetch the DBD::mysql source distribution. The latest version is always available from

    http://www.cpan.org/modules/by-module/DBD/

    The name is typically something like

    DBD-mysql-1.2216.tar.gz

    The archive needs to be extracted. On Windows you may use a tool like WinZip, on Unix you type

    gzip -cd DBD-mysql-1.2216.tar.gz | tar xf -

    This will create a subdirectory DBD-mysql-1.2216. Enter this subdirectory and type

    perl Makefile.PL
    make
    make test

    Any solutions by the perl team ?
    This is not the first time that a module fails to compile. Maybe we can try with diferent versions of perl.
    Just give some feedback.

    Pedro Rodrigues @ Portugal
     
  11. eagle

    eagle Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    141
    Likes Received:
    0
    Trophy Points:
    16
    Yeah, like I said...
    But in previous errors I know the CPanel team had contact with the perl team, and then they gave the message that the package was fixed....

    I have one other server that works fine with 4.003, so at one moment the package must have gone bad.
     
  12. jtatum

    jtatum Registered

    Joined:
    Jun 18, 2004
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    It depends on the version of mysql you are running. There is some ifdef'd code causing the problem in 4.003 which is discussed here:

    http://www.nnseek.com/e/perl.dbi.dev/dbd_mysql_4_003_released_error_compiling_374990101t.html

    Presumably, it will be fixed in the next version - when it comes out, upcp will invoke CPAN in a way that automatically pulls it down. In the meantime...

    Depending on what is going on with your install, this issue may or may not cause a problem. I just upgraded to perl 5.8.7 due to other issues and so did not have DBD::mysql installed at all. If you do regular updates, you may already have 4.001 installed and the nightly errors you see are just related to attempts to upgrade to 4.003. If so, the errors can probably be ignored.

    If you do not have an older version of DBD::mysql installed, 4.001 can be loaded by running

    perl -MCPAN -e shell

    At the CPAN prompt, type:

    force install CAPTTOFU/DBD-mysql-4.001.tar.gz
     
    #12 jtatum, Mar 14, 2007
    Last edited: Mar 14, 2007
  13. Blackcat

    Blackcat Member

    Joined:
    Sep 13, 2004
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Confirmed. The solution above :

    perl -MCPAN -e shell

    At the CPAN prompt, type:

    force install CAPTTOFU/DBD-mysql-4.001.tar.gz

    works.
     
Loading...

Share This Page