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.

MySql Upgrade problem in cPpkgversion

Discussion in 'General Discussion' started by Bulent Tekcan, Nov 23, 2006.

  1. Bulent Tekcan

    Bulent Tekcan Well-Known Member

    Joined:
    May 11, 2004
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    This setting from my cPpkgversion.But why not listed MySQL-embedded-5.0.27-0.glibc23.%arch%.rpm ?

    My server has a RHEL4 64Bit

    Bu still my mysql client is 4.1.21


    Code:
    package cPPkgs::MySQL;
    $PKGDATA = {
                 'x86_64' => {
                               '5.0' => {
                                          'flags' => '',
                                          'files' => [
                                                       'MySQL-shared-5.0.27-0.glibc23.%arch%.rpm',
                                                       'MySQL-devel-5.0.27-0.glibc23.%arch%.rpm',
                                                       'MySQL-client-5.0.27-0.glibc23.%arch%.rpm',
                                                       'MySQL-bench-5.0.27-0.glibc23.%arch%.rpm',
                                                       'MySQL-server-5.0.27-0.glibc23.%arch%.rpm',
                                                       'MySQL-shared-5.0.27-0.glibc23.%arch%.rpm'
                                                     ],
                                          'version' => '5.0.27',
                                          'release' => '0.glibc23',
                                          'dir' => '5.0.27-0'
                                        },
                               '4.0' => {
                                          'flags' => '',
                                          'files' => [
                                                       'MySQL-shared-4.0.27-0.%arch%.rpm',
                                                       'MySQL-devel-4.0.27-0.%arch%.rpm',
                                                       [COLOR="Red"]'MySQL-embedded-4.0.27-0.%arch%.rpm',[/COLOR]
                                                       'MySQL-client-4.0.27-0.%arch%.rpm',
                                                       'MySQL-bench-4.0.27-0.%arch%.rpm',
                                                       'MySQL-server-4.0.27-0.%arch%.rpm',
                                                       'MySQL-shared-4.0.27-0.%arch%.rpm'
                                                     ],
                                          'version' => '4.0.27',
                                          'release' => '0',
                                          'dir' => '4.0.27-0'
                                        },
                               '4.1' => {
                                          'flags' => '',
                                          'files' => [
                                                       'MySQL-shared-4.1.21-0.glibc23.%arch%.rpm',
                                                       'MySQL-devel-4.1.21-0.glibc23.%arch%.rpm',
                                                       [COLOR="red"]'MySQL-embedded-4.1.21-0.glibc23.%arch%.rpm',[/COLOR]
                                                       'MySQL-client-4.1.21-0.glibc23.%arch%.rpm',
                                                       'MySQL-bench-4.1.21-0.glibc23.%arch%.rpm',
                                                       'MySQL-server-4.1.21-0.glibc23.%arch%.rpm',
                                                       'MySQL-shared-4.1.21-0.glibc23.%arch%.rpm'
                                                     ],
                                          'version' => '4.1.21',
                                          'release' => '0.glibc23',
                                          'dir' => '4.1.21-0'
                                        }
                             },
    
    Also embedded not there http://httpupdate.cpanel.net/mysqlinstall/5.0.27-0/redhat_enterprise/4/
     
    #1 Bulent Tekcan, Nov 23, 2006
    Last edited: Nov 23, 2006
  2. Bulent Tekcan

    Bulent Tekcan Well-Known Member

    Joined:
    May 11, 2004
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    And also I received some error...

    Code:
    Ftp Setup Script Version 6.0
    Fetching version information from http://updates.cpanel.net/ftpinstall/version (STABLE)....Fetching http://updates.cpanel.net/ftpinstall/version (0)....@8.10.120.130......connected......receiving...100%......Done
    Done
    This is the pure-ftpd 1.0.20 installer release number 17.tls for platform redhat AS-4
    pure-ftpd is up to date.  Use ftpup --force to force a reinstall
    MySQL Setup Script Version 7.0
    Loaded cPPkgs::MySQL ok!
    This is the cPPkgs::MySQL 5.0.27 installer for Linux.
    Preparing...                ##################################################
    MySQL-shared                ##################################################
    Preparing...                ##################################################
    MySQL-devel                 ##################################################
    Preparing...                ##################################################
    MySQL-client                ##################################################
    Preparing...                ##################################################
    MySQL-bench                 ##################################################
    Preparing...                ##################################################
    Giving mysqld a couple of seconds to exit nicely
    MySQL-server                ##################################################
    [COLOR="red"]/usr/sbin/mysqld: Out of memory (Needed 219486208 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 164613120 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 123457536 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 219486208 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 164613120 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 123457536 bytes)[/COLOR]
    PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
    To do so, start the server, then issue the following commands:
    /usr/bin/mysqladmin -u root password 'new-password'
    /usr/bin/mysqladmin -u root -h  password 'new-password'
    See the manual for more instructions.
    
    NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
    the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
    able to use the new GRANT command!
    
    Please report any problems with the /usr/bin/mysqlbug script!
    
    The latest information about MySQL is available on the web at
    http://www.mysql.com
    Support MySQL by buying support/licenses at http://shop.mysql.com
    Starting MySQL[  OK  ]
    /usr/sbin/setfiles:  read 2 specifications
    /usr/sbin/setfiles:  labeling files under /
    /usr/sbin/setfiles:  hash table stats: 1 elements, 1/65536 buckets used, longest chain length 1
    /usr/sbin/setfiles:  Done.
    Method: Perl Expect
    Fetching CPAN timestamp...Done
    Testing connection speed...(this could take a while)...Done
    Ping:7.296 Testing connection speed to cpan.belfry.net using pureperl...(157700.00 bytes/s)...Done
    Ping:7.294 Testing connection speed to cpan.erlbaum.net using pureperl...(157700.00 bytes/s)...Done
    Ping:2.277 Testing connection speed to cpan.glines.org using pureperl...(313000.00 bytes/s)...Done
    Three usable mirrors located
    Mirror Check passed for cpan.glines.org (/index.html)
    commit: wrote '/usr/lib/perl5/5.8.5/CPAN/Config.pm'
    CPAN: File::HomeDir loaded ok
    CPAN: Storable loaded ok
    Going to read /home/.cpan/Metadata
      Database was generated on Fri, 24 Nov 2006 23:25:24 GMT
    Running install for module DBD::mysql
    Running make for C/CA/CAPTTOFU/DBD-mysql-3.0008.tar.gz
    CPAN: Digest::SHA loaded ok
    CPAN: Compress::Zlib loaded ok
    Checksum for /home/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0008.tar.gz ok
    Scanning cache /home/.cpan/build for sizes
    DBD-mysql-3.0008/
    DBD-mysql-3.0008/ChangeLog
    DBD-mysql-3.0008/constants.h
    DBD-mysql-3.0008/dbdimp.c
    DBD-mysql-3.0008/dbdimp.h
    DBD-mysql-3.0008/eg/
    DBD-mysql-3.0008/eg/prepare_memory_usage.pl
    DBD-mysql-3.0008/eg/proc_example1.pl
    DBD-mysql-3.0008/eg/proc_example2.pl
    DBD-mysql-3.0008/eg/proc_example3.pl
    DBD-mysql-3.0008/INSTALL.html
    DBD-mysql-3.0008/lib/
    DBD-mysql-3.0008/lib/Bundle/
    DBD-mysql-3.0008/lib/Bundle/DBD/
    DBD-mysql-3.0008/lib/Bundle/DBD/mysql.pm
    DBD-mysql-3.0008/lib/DBD/
    DBD-mysql-3.0008/lib/DBD/mysql/
    DBD-mysql-3.0008/lib/DBD/mysql/GetInfo.pm
    DBD-mysql-3.0008/lib/DBD/mysql/INSTALL.pod
    DBD-mysql-3.0008/lib/DBD/mysql.pm
    DBD-mysql-3.0008/lib/Mysql/
    DBD-mysql-3.0008/lib/Mysql/Statement.pm
    DBD-mysql-3.0008/lib/Mysql.pm
    DBD-mysql-3.0008/Makefile.PL
    DBD-mysql-3.0008/Makefile.PL.embedded
    DBD-mysql-3.0008/MANIFEST
    DBD-mysql-3.0008/MANIFEST.SKIP
    DBD-mysql-3.0008/META.yml
    DBD-mysql-3.0008/myld
    DBD-mysql-3.0008/mysql.xs
    DBD-mysql-3.0008/README
    DBD-mysql-3.0008/t/
    DBD-mysql-3.0008/t/00base.t
    DBD-mysql-3.0008/t/10dsnlist.t
    DBD-mysql-3.0008/t/20createdrop.t
    DBD-mysql-3.0008/t/30insertfetch.t
    DBD-mysql-3.0008/t/35limit.t
    DBD-mysql-3.0008/t/35prepare.t
    DBD-mysql-3.0008/t/40bindparam.t
    DBD-mysql-3.0008/t/40bindparam2.t
    DBD-mysql-3.0008/t/40blobs.t
    DBD-mysql-3.0008/t/40listfields.t
    DBD-mysql-3.0008/t/40nulls.t
    DBD-mysql-3.0008/t/40numrows.t
    DBD-mysql-3.0008/t/41bindparam.t
    DBD-mysql-3.0008/t/41blobs_prepare.t
    DBD-mysql-3.0008/t/42bindparam.t
    DBD-mysql-3.0008/t/50chopblanks.t
    DBD-mysql-3.0008/t/50commit.t
    DBD-mysql-3.0008/t/60leaks.t
    DBD-mysql-3.0008/t/dbdadmin.t
    DBD-mysql-3.0008/t/insertid.t
    DBD-mysql-3.0008/t/lib.pl
    DBD-mysql-3.0008/t/mysql.dbtest
    DBD-mysql-3.0008/t/param_values.t
    DBD-mysql-3.0008/t/._prepare_noerror.t
    DBD-mysql-3.0008/t/prepare_noerror.t
    DBD-mysql-3.0008/t/texecute.t
    DBD-mysql-3.0008/TODO
    
      CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-3.0008.tar.gz
    
    I will use the following settings for compiling and testing:
    
      cflags        (mysql_config) = -I/usr/include/mysql -g -pipe -m64
      embedded      (mysql_config) = 
      libs          (mysql_config) = -L/usr/lib64/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.53 (for perl 5.008005 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/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/Mysql.pm blib/lib/Mysql.pm
    cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
    cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
    cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
    gcc -c  -I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI -I/usr/include/mysql -g -pipe -m64 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m64   -DVERSION=\"3.0008\" -DXS_VERSION=\"3.0008\" -fPIC "-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE"   dbdimp.c
    /usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/Driver.xst > mysql.xsi
    /usr/bin/perl /usr/lib/perl5/5.8.5/ExtUtils/xsubpp  -typemap /usr/lib/perl5/5.8.5/ExtUtils/typemap  mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
    [COLOR="red"]Warning: duplicate function definition 'do' detected in mysql.xs, line 224
    Warning: duplicate function definition 'rows' detected in mysql.xs, line 567[/COLOR]
    gcc -c  -I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI -I/usr/include/mysql -g -pipe -m64 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m64   -DVERSION=\"3.0008\" -DXS_VERSION=\"3.0008\" -fPIC "-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE"   mysql.c
    mysql.xs: In function `XS_DBD__mysql__db_do':
    [COLOR="Red"]mysql.xs:292: warning: comparison is always false due to limited range of data type
    mysql.xs:293: warning: comparison is always false due to limited range of data type[/COLOR]
    Running Mkbootstrap for DBD::mysql ()
    chmod 644 mysql.bs
    rm -f blib/arch/auto/DBD/mysql/mysql.so
    /usr/bin/perl myld gcc  -shared dbdimp.o mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so   -L/usr/lib64/mysql -lmysqlclient -lz -lcrypt -lnsl -lm   
    chmod 755 blib/arch/auto/DBD/mysql/mysql.so
    cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
    chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
    Manifying blib/man3/DBD::mysql.3pm
    Manifying blib/man3/DBD::mysql::INSTALL.3pm
    Manifying blib/man3/Mysql.3pm
    Manifying blib/man3/Bundle::DBD::mysql.3pm
      /usr/bin/make  -- OK
    Running make install
    Installing /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so
    Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
    Writing /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBD/mysql/.packlist
    Appending installation info to /usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/perllocal.pod
      /usr/bin/make install UNINST=1 -- OK
    perlmod--Install done
    Install Complete
    portsentry is up to date (Wed Mar 10 07:21:21 2004)
    
    
    Complete 
     
    #2 Bulent Tekcan, Nov 25, 2006
    Last edited: Nov 25, 2006
  3. Bulent Tekcan

    Bulent Tekcan Well-Known Member

    Joined:
    May 11, 2004
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
Loading...

Share This Page