Mysql Upgrade - Easy Apache Running?

vpsstore

Member
Nov 13, 2010
13
0
51
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
 

KurtN.

Well-Known Member
Jan 29, 2013
95
1
83
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.
 
Last edited:

vpsstore

Member
Nov 13, 2010
13
0
51
/var/run/easyapache.pid
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:
[[email protected] ~]# /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 [email protected]00%......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 [email protected]00%......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)[email protected]%......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 [email protected]3%...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.
 

vpsstore

Member
Nov 13, 2010
13
0
51
Have you tried upgrading from within WHM? The only reason I ask is this, the RPM system has changed.
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