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 - Easy Apache Running?

Discussion in 'EasyApache' started by vpsstore, Mar 5, 2013.

  1. vpsstore

    vpsstore Member

    Joined:
    Nov 13, 2010
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    I need to upgrade Mysql from 4.x to 5.x so that I can upgrade Cpanel/WHM. When I try to access the Mysql Software upgrade tool in WHM I get this message:

    WARNING: A running easyapache process was detected. Please wait for easyapache to finish before attempting to upgrade MySQL.

    If you are certain that the easyapache is no longer running, you may restart the MySQL upgrade by clicking the following button.


    I am not aware of any running process so I hit that button - to simply be returned to the same message. I then run

    Code:
    ps aux | grep easyapache
    and the output is:

    Code:
    root      3296  0.0  0.0   3100   740 pts/0    S+   17:21   0:00 grep easyapache
    [
    Does this mean I can go ahead and force an upgrade with:

    Code:
    /usr/local/cpanel/scripts/mysqlup --force
    ?

    Thanks
     
  2. cPanelKurtN

    cPanelKurtN Well-Known Member
    Staff Member

    Joined:
    Jan 29, 2013
    Messages:
    95
    Likes Received:
    1
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    cPanel/WHM and EasyApache determine if a current version of EA is running by examining the contents of the file, /var/run/easyapache.pid

    If, after examining the pid file and your process list, you are sure that the EasyApache process isn't running, then it is safe to delete this file.

    NOTE: The file stays around after an EasyApache build has completed. The mere existence of the file isn't an indication of a problem.
     
    #2 cPanelKurtN, Mar 6, 2013
    Last edited: Mar 6, 2013
  3. vpsstore

    vpsstore Member

    Joined:
    Nov 13, 2010
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    The above file does not appear to exist.

    I ran

    /usr/local/cpanel/scripts/mysqlup --force

    It did not appear to work. This is the output, which means very little to me :confused: I need to get from the current version up to 5.x

    Code:
    [root@vps ~]# /usr/local/cpanel/scripts/mysqlup --force
    Preparing...                ##################################################
    MySQL-shared                ##################################################
    Giving mysqld a couple of seconds to exit nicely
    MySQL-server                ##################################################
    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 vps.xxx.xxx 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 SUCCESS! 
    MySQL-client                ##################################################
    MySQL-devel                 ##################################################
    
    Packages installed...
    PACKAGE: MySQL-server-4.1.22-1.glibc23
    PACKAGE: MySQL-client-4.1.22-1.glibc23
    PACKAGE: MySQL-devel-4.1.22-1.glibc23
    PACKAGE: MySQL-shared-4.1.22-1.glibc23
    This script updates all the mysql privilege tables to be usable byMySQL 4.0 and above.This is needed if you want to use the new GRANT functions,CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1You can safely ignore all 'Duplicate column' and 'Unknown column' errorsbecause these just mean that your tables are already up to date.This script is safe to run even if your tables are already up to date!doneChecking C compiler....C compiler (/usr/bin/cc) OK (cached Tue Mar 12 23:02:51 2013)
    Tuned C compiler not available because it is not enabled....Done
    CPAN fallback is disabled since /var/cpanel/conserve_memory exists, and cpanm is available.
    Method: Using Perl Expect, Installer: cpanm
    You have make /usr/bin/make
    Falling back to HTTP::Tiny 0.009
    You have /bin/tar: tar (GNU tar) 1.15.1
    You have /usr/bin/unzip
    You have Cpanel::HttpRequest 2.1
    Testing connection speed...(using fast method)....Done
    Ping:0 (ticks) Testing connection speed to cpan.etla.org using pureperl...(cached .. 57500.00 bytes/s)...Done
    Ping:1 (ticks) Testing connection speed to cpan.mirror.anlx.net using pureperl...(cached .. 31100.00 bytes/s)...Done
    Ping:1 (ticks) Testing connection speed to mirror.bytemark.co.uk using pureperl...(cached .. 31000.00 bytes/s)...Done
    Ping:0 (ticks) Testing connection speed to cpan.cpantesters.org using pureperl...(cached .. 30350.00 bytes/s)...Done
    Ping:0 (ticks) Testing connection speed to mirror.sov.uk.goscomb.net using pureperl...(cached .. 28000.00 bytes/s)...Done
    Five usable mirrors located
    Ping:7 (ticks) Testing connection speed to 69.72.212.10 using pureperl...(using cached speed)...Done
    Ping:7 (ticks) Testing connection speed to 208.74.125.42 using pureperl...(using cached speed)...Done
    Ping:8 (ticks) Testing connection speed to 66.23.237.210 using pureperl...(using cached speed)...Done
    Three usable fallback mirrors located
    Fetching http://cpan.etla.org/index.html (connected:0).......(request attempt 1/12)...Resolving cpan.etla.org...(resolve attempt 1/65)......connecting to 85.119.82.193...@85.119.82.193......connected......receiving...100%......request success......Done
    Mirror Check passed for cpan.etla.org (/index.html)
    Searching on cpanmetadb ...
    Fetching http://cpanmetadb.cpanel.net/v1.0/package/DBD::mysql?cpanel_version=11.32.6.3&cpanel_tier=stable (connected:0).......(request attempt 1/12)...Using dns cache file /root/.HttpRequest/cpanmetadb.cpanel.net......searching for mirrors (mirror search attempt 1/3)......5 usable mirrors located. (less then expected)......mirror search success......connecting to 208.74.125.50...@208.74.125.50......connected......receiving...100%......request success......Done
    Searching DBD::mysql on cpanmetadb (http://cpanmetadb.cpanel.net/v1.0/package/DBD::mysql?cpanel_version=11.32.6.3&cpanel_tier=stable) ...
    Fetching http://cpanmetadb.cpanel.net/v1.0/package/DBD::mysql?cpanel_version=11.32.6.3&cpanel_tier=stable (connected:1).......(request attempt 1/12)...@208.74.125.50......connected......receiving...100%......request success......Done
    Source: fastest CPAN mirror ... --> Working on DBD::mysql
    Fetching http://cpan.etla.org///authors/id/C/CA/CAPTTOFU/DBD-mysql-4.022.tar.gz ... Fetching http://cpan.etla.org/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.022.tar.gz (connected:1).......(request attempt 1/12)...Resolving cpan.etla.org...(resolve attempt 1/65)......connecting to 85.119.82.193...@85.119.82.193......connected......receiving...93%...100%......request success......Done
    OK
    Unpacking DBD-mysql-4.022.tar.gz
    DBD-mysql-4.022/
    DBD-mysql-4.022/lib/
    DBD-mysql-4.022/lib/Bundle/
    DBD-mysql-4.022/lib/Bundle/DBD/
    DBD-mysql-4.022/lib/Bundle/DBD/mysql.pm
    DBD-mysql-4.022/lib/DBD/
    DBD-mysql-4.022/lib/DBD/mysql/
    DBD-mysql-4.022/lib/DBD/mysql/GetInfo.pm
    DBD-mysql-4.022/lib/DBD/mysql/INSTALL.pod
    DBD-mysql-4.022/lib/DBD/mysql.pm
    DBD-mysql-4.022/Makefile.PL.embedded
    DBD-mysql-4.022/mysql.xs
    DBD-mysql-4.022/README
    DBD-mysql-4.022/TODO
    DBD-mysql-4.022/ChangeLog
    DBD-mysql-4.022/INSTALL.html
    DBD-mysql-4.022/t/
    DBD-mysql-4.022/t/41bindparam.t
    DBD-mysql-4.022/t/51bind_type_guessing.t
    DBD-mysql-4.022/t/80procs.t
    DBD-mysql-4.022/t/25lockunlock.t
    DBD-mysql-4.022/t/40bindparam.t
    DBD-mysql-4.022/t/40nulls.t
    DBD-mysql-4.022/t/55utf8.t
    DBD-mysql-4.022/t/91errcheck.t
    DBD-mysql-4.022/t/41blobs_prepare.t
    DBD-mysql-4.022/t/31insertid.t
    DBD-mysql-4.022/t/35prepare.t
    DBD-mysql-4.022/t/50chopblanks.t
    DBD-mysql-4.022/t/42bindparam.t
    DBD-mysql-4.022/t/32insert_error.t
    DBD-mysql-4.022/t/50commit.t
    DBD-mysql-4.022/t/10connect.t
    DBD-mysql-4.022/t/86_bug_36972.t
    DBD-mysql-4.022/t/40bindparam2.t
    DBD-mysql-4.022/t/20createdrop.t
    DBD-mysql-4.022/t/40keyinfo.t
    DBD-mysql-4.022/t/40server_prepare.t
    DBD-mysql-4.022/t/mysql.mtest
    DBD-mysql-4.022/t/52comment.t
    DBD-mysql-4.022/t/65types.t
    DBD-mysql-4.022/t/30insertfetch.t
    DBD-mysql-4.022/t/40catalog.t
    DBD-mysql-4.022/t/70takeimp.t
    DBD-mysql-4.022/t/40types.t
    DBD-mysql-4.022/t/75supported_sql.t
    DBD-mysql-4.022/t/53comment.t
    DBD-mysql-4.022/t/85init_command.t
    DBD-mysql-4.022/t/mem_leak.pl
    DBD-mysql-4.022/t/40numrows.t
    DBD-mysql-4.022/t/76multi_statement.t
    DBD-mysql-4.022/t/71impdata.t
    DBD-mysql-4.022/t/35limit.t
    DBD-mysql-4.022/t/mysql.dbtest
    DBD-mysql-4.022/t/00base.t
    DBD-mysql-4.022/t/40blobs.t
    DBD-mysql-4.022/t/40nulls_prepare.t
    DBD-mysql-4.022/t/60leaks.t
    DBD-mysql-4.022/t/29warnings.t
    DBD-mysql-4.022/t/40server_prepare_error.t
    DBD-mysql-4.022/t/40listfields.t
    DBD-mysql-4.022/t/lib.pl
    DBD-mysql-4.022/dbdimp.c
    DBD-mysql-4.022/constants.h
    DBD-mysql-4.022/eg/
    DBD-mysql-4.022/eg/proc_example3.pl
    DBD-mysql-4.022/eg/proc_example2b.pl
    DBD-mysql-4.022/eg/issue21946.pl
    DBD-mysql-4.022/eg/bug30033pg.pl
    DBD-mysql-4.022/eg/proc_example2.pl
    DBD-mysql-4.022/eg/decimal_test.pl
    DBD-mysql-4.022/eg/proc_example1.pl
    DBD-mysql-4.022/eg/prepare_memory_usage.pl
    DBD-mysql-4.022/eg/bug21028.pl
    DBD-mysql-4.022/eg/proc_example2a.pl
    DBD-mysql-4.022/eg/bug14979.pl
    DBD-mysql-4.022/eg/proc_example4.pl
    DBD-mysql-4.022/eg/bug30033.pl
    DBD-mysql-4.022/myld
    DBD-mysql-4.022/Makefile.PL
    DBD-mysql-4.022/MANIFEST.SKIP
    DBD-mysql-4.022/README.OSX
    DBD-mysql-4.022/MANIFEST
    DBD-mysql-4.022/dbdimp.h
    DBD-mysql-4.022/META.yml
    Entering DBD-mysql-4.022
    Checking configure dependencies from META.yml
    Checking if you have DBI 1.08 ... Yes (1.623)
    Configuring DBD-mysql-4.022 ... Running Makefile.PL
    info [cpanm] /root/.cpanel/datastore/Cpanel::Sys::Compiler::test_compile_cc
    
    
    
    PLEASE NOTE:
    
    For 'make test' to run properly, you must ensure that the 
    database user 'root' can connect to your MySQL server 
    and has the proper privileges that these tests require such 
    as 'drop table', 'create table', 'drop procedure', 'create procedure'
    as well as others. 
    
    mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t';
    
    You can also optionally set the user to run 'make test' with:
    
    perl Makefile.PL --testuser=username
    
    I will use the following settings for compiling and testing:
    
      cflags        (mysql_config) = -I/usr/include/mysql -g -march=i386 -mcpu=i686
      embedded      (mysql_config) = 
      ldflags       (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      (guessed     ) = root
    
    To change these settings, see 'perl Makefile.PL --help' and
    'perldoc INSTALL'.
    
    Checking if your kit is complete...
    Looks good
    Using DBI 1.623 (for perl 5.008008 on i686-linux) installed in /usr/local/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI/
    Writing Makefile for DBD::mysql
    Writing MYMETA.yml and MYMETA.json
    OK
    Checking dependencies from MYMETA.yml ...
    Finding PREREQ from Makefile ...
    Checking if you have Data::Dumper 0 ... Yes (2.143)
    Checking if you have DBI 1.08 ... Yes (1.623)
    Checking if you have Test::More 0 ... Yes (0.98)
    Checking if you have Test::More 0 ... Yes (0.98)
    Checking if you have Data::Dumper 0 ... Yes (2.143)
    Checking if you have DBI 1.08 ... Yes (1.623)
    Building DBD-mysql-4.022 ... 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/local/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI -I/usr/include/mysql -g -march=i386 -mcpu=i686 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -Os   -DVERSION=\"4.022\" -DXS_VERSION=\"4.022\" -fpic "-I/usr/local/lib/perl5/5.8.8/i686-linux/CORE"   dbdimp.c
    `-mcpu=' is deprecated. Use `-mtune=' or '-march=' instead.
    dbdimp.c: In function 'mysql_st_fetch':
    dbdimp.c:3843: warning: ISO C90 forbids mixed declarations and code
    /usr/local/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI/Driver.xst > mysql.xsi
    /usr/local/bin/perl /usr/local/lib/perl5/5.8.8/ExtUtils/xsubpp  -typemap /usr/local/lib/perl5/5.8.8/ExtUtils/typemap  mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
    Warning: duplicate function definition 'do' detected in mysql.xs, line 242
    Warning: duplicate function definition 'rows' detected in mysql.xs, line 752
    cc -c  -I/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI -I/usr/include/mysql -g -march=i386 -mcpu=i686 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -Os   -DVERSION=\"4.022\" -DXS_VERSION=\"4.022\" -fpic "-I/usr/local/lib/perl5/5.8.8/i686-linux/CORE"   mysql.c
    `-mcpu=' is deprecated. Use `-mtune=' or '-march=' instead.
    mysql.xs: In function 'XS_DBD__mysql__db__ListDBs':
    mysql.xs:221: warning: ISO C90 forbids mixed declarations and code
    mysql.xs: In function 'XS_DBD__mysql__db_quote':
    mysql.xs:613: warning: ISO C90 forbids mixed declarations and code
    Running Mkbootstrap for DBD::mysql ()
    chmod 644 mysql.bs
    rm -f blib/arch/auto/DBD/mysql/mysql.so
    LD_RUN_PATH="/usr/lib/mysql" /usr/local/bin/perl myld cc  -shared -L/usr/local/lib dbdimp.o mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so 	\
    	   -L/usr/lib/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.3
    Manifying blib/man3/DBD::mysql::INSTALL.3
    Manifying blib/man3/Bundle::DBD::mysql.3
    Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
    Installing /usr/local/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so
    Appending installation info to /usr/local/lib/perl5/5.8.8/i686-linux/perllocal.pod
    OK
    Successfully reinstalled DBD-mysql-4.022
    1 distribution installed
    phpMyAdmin is up to date. Execute '/usr/local/cpanel/bin/updatephpmyadmin --force' to force an update.
    
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,460
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Have you tried upgrading from within WHM? The only reason I ask is this, the RPM system has changed. I've already run the MySQL upgrade from my stage server recently. But I just ran thru it again right now and it does this, first:

     
  5. vpsstore

    vpsstore Member

    Joined:
    Nov 13, 2010
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Yes, it first says there is an Easy Apache instance running - which it appears there is not. I then try the ignore and upgrade anyway and it just returns me to the same page. This is why I went down command line route.

    Rather frustrating.

    I need to get upgraded as I keep getting version change blocked messages and my clients want mysql 5.x

    Code:
    fatal,Newer releases of cPanel & WHM are not compatible with your MySQL version: 4.1. Upgrade your MySQL server to a version greater or equal to 5.0
    Code:
    [20130313.230102]   Detected version '11.32.6.3' from version file.
    [20130313.230102]   Target version set to '11.34.1.12'
    [20130313.230102]   Checking license
    [20130313.230102]   License file check complete
    [20130313.230102] E Blocker found: Newer releases of cPanel & WHM are not compatible with your MySQL version: 4.1. Upgrade your MySQL server to a version greater or equal to 5.0
    [20130313.230102] ***** FATAL: An attempt to up/downgrade to 11.34.1.12 was blocked. Please review blockers.
    [20130313.230102] E Detected events which require user notification during updatenow. Will send iContact the log
     
  6. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,460
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Please feel free to open a ticket to cPanel Technical Support at your earliest convenience. :)
     
  7. vpsstore

    vpsstore Member

    Joined:
    Nov 13, 2010
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Lol. I have done that and await a response. Thank you for replies, appreciated.
     
Loading...

Share This Page