How To Upgrade MySQL to 8.0 on CentOS/AWS Linux

Author: erics, August 31st, 2023

START: Server version: 5.7.43-log MySQL Community Server (GPL) FINISH: Server version: 8.0.34-log MySQL Community Server (GPL)

mysql --execute="SET GLOBAL innodb_fast_shutdown=0;"
service mysqld stop
yum remove mysql mysql-* mysql57-community-release

yum install https://dev.mysql.com/get/mysql80-community-release-el6-3.noarch.rpm
yum update
yum install mysql-community-server

cp /etc/my.cnf.rpmsave /etc/my.cnf
service mysqld start

grep 'temporary password' /var/log/mysqld.log | tail -1
mysql -p
Enter password: 
ALTER USER 'root'@'localhost' IDENTIFIED BY 'newRootPassword';

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

mysql --execute="SET GLOBAL innodb_fast_shutdown=0;"

service mysqld stop

yum remove mysql mysql-* mysql57-community-release

yum install https://dev.mysql.com/get/mysql80-community-release-el6-3.noarch.rpm

yum update

yum install mysql-community-server

cp /etc/my.cnf.rpmsave /etc/my.cnf

service mysqld start

grep 'temporary password' /var/log/mysqld.log | tail -1

mysql -p

Enter password:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'newRootPassword';

https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html Check and veify your my.cnf ssl entries if you see the following error in the /var/log/mysqld.log file at startup:

Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed

1	Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed

Categories: How-To's, Technology Tags: 5.7, 8.0, AWS, AWS Linux, CentOS, howto, mysql, MySQL 5.7, MySQL 8.0, tips, upgrade | No comments

How To Fix WPDataTables Error “You are trying to load a table of an unknown type” in WordPress

Author: erics, September 7th, 2022

If you get the following error in WordPress when using the WPDataTables plugin, follow these steps to fix it: “You are trying to load a table of an unknown type. Probably you did not activate the addon which is required to use this table type.” SOLUTION SUMMARY: You must update the plugin files manually, deactivate […]

Categories: Technology Tags: Activate, Deactivaate, Error, Fix, howto, Plugin, Reactivate, tips, update, upgrade, WordPress, WPDataTables | No comments

How To Upgrade Certbot, Python and PIP on AWS Linux 1

Author: erics, May 6th, 2020

I ran letsencrypt-auto renew and got the following error:

root@prod06b:/etc/httpd/conf.d # /root/letsencrypt/letsencrypt-auto renew
Error: couldn't get currently installed version for /opt/eff.org/certbot/venv/bin/letsencrypt: 
Traceback (most recent call last):
  File "/opt/eff.org/certbot/venv/bin/letsencrypt", line 7, in <module>
    from certbot.main import main
  File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/certbot/main.py", line 2, in <module>
    from certbot._internal import main as internal_main
  File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/certbot/_internal/main.py", line 10, in <module>
    import josepy as jose
  File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/josepy/__init__.py", line 41, in <module>
    from josepy.interfaces import JSONDeSerializable
  File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/josepy/interfaces.py", line 7, in <module>
    from josepy import errors, util
  File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/josepy/util.py", line 7, in <module>
    import OpenSSL
  File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/OpenSSL/__init__.py", line 8, in <module>
    from OpenSSL import crypto, SSL
  File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/OpenSSL/crypto.py", line 12, in <module>
    from cryptography import x509
ImportError: No module named cryptography

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

root@prod06b:/etc/httpd/conf.d # /root/letsencrypt/letsencrypt-auto renew

Error: couldn't get currently installed version for /opt/eff.org/certbot/venv/bin/letsencrypt:

Traceback (most recent call last):

File "/opt/eff.org/certbot/venv/bin/letsencrypt", line 7, in <module>

from certbot.main import main

File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/certbot/main.py", line 2, in <module>

from certbot._internal import main as internal_main

File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/certbot/_internal/main.py", line 10, in <module>

import josepy as jose

File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/josepy/__init__.py", line 41, in <module>

from josepy.interfaces import JSONDeSerializable

File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/josepy/interfaces.py", line 7, in <module>

from josepy import errors, util

File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/josepy/util.py", line 7, in <module>

import OpenSSL

File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/OpenSSL/__init__.py", line 8, in <module>

from OpenSSL import crypto, SSL

File "/opt/eff.org/certbot/venv/local/lib/python2.7/dist-packages/OpenSSL/crypto.py", line 12, in <module>

from cryptography import x509

ImportError: No module named cryptography

The solution in this article gave me the answer:

sudo rm -rf /opt/eff.org/*
sudo pip install -U certbot
sudo certbot renew --debug

1

2

3

sudo rm -rf /opt/eff.org/*

sudo pip install -U certbot

sudo certbot renew --debug

Turns out Python was old at version 2.7, so did the following also:

sudo yum -y install python36
sudo alternatives --config python
sudo pip install --upgrade pip

1

2

3

sudo yum -y install python36

sudo alternatives --config python

sudo pip install --upgrade pip

Also had to change the cron job script to call certbot directly instead of letsencrypt-auto : vi /root/letsencrypt-cron.sh

#!/bin/sh
#
# letsencrypt-cron.sh
#
#OLD: if ! /root/letsencrypt/letsencrypt-auto renew > /var/log/letsencrypt/renew.log 2>&1 ; then
#NEW:
if ! /usr/bin/certbot renew > /var/log/letsencrypt/renew.log 2>&1 ; then
    echo Automated renewal failed: 
    cat /var/log/letsencrypt/renew.log
    exit 1  
fi
apachectl graceful

1

2

3

4

5

6

7

8

9

10

11

12

#!/bin/sh

#

# letsencrypt-cron.sh

#

#OLD: if ! /root/letsencrypt/letsencrypt-auto renew > /var/log/letsencrypt/renew.log 2>&1 ; then

#NEW:

if ! /usr/bin/certbot renew > /var/log/letsencrypt/renew.log 2>&1 ; then

echo Automated renewal failed:

cat /var/log/letsencrypt/renew.log

exit 1

fi

apachectl graceful

Categories: How-To's, Technology Tags: AWS, AWS Linux, cert, Certbot, howto, Install, Linux, pip, Python, Renew, ssl, tips, upgrade, Yum | No comments

First post after upgrading to WordPress 5.4

Author: erics, April 5th, 2020

Decided to go for it and dive into the world of the WordPress block editor based on the improvements in version 5.4 – First, the upgrade went smoothly. Second, switching to the new block editor was easy. Third, making this post seems pretty painless. I disabled full-screen mode because I simply don’t like it ;-} […]

Categories: Technology Tags: upgrade, WordPress, Wordpress 5.4 | No comments

How To Downgrade PIP After Upgrade on Amazon Linux

Author: erics, March 25th, 2020

I tried upgrading pip when prompted to do so: sudo pip install –upgrade pip This worked, but removed the system install in /usr/bin/pip and replaced it with /usr/local/bin/pip – NOT GOOD! The solution is as follows:

/usr/local/bin/pip uninstall pip  
yum remove python27-pip
yum install python27-pip

1

2

3

/usr/local/bin/pip uninstall pip

yum remove python27-pip

yum install python27-pip

Categories: How-To's, Technology Tags: Amazon, Amazon Linux, AWS, CentOS, Downgrade, howto, Install, Linux, pip, pip install, pip uninstall, tips, Uninstall, upgrade, Yum | No comments

How To Fix Bamboo Start Errors After Java Upgrade

Author: erics, January 21st, 2020

PROBLEM DEFINITION Bamboo Catalina error found in catalina.out:

-Djava.endorsed.dirs=/volumes/data/bamboo/current/endorsed is not supported. Endorsed standards and standalone APIs
in modular form will be supported via the concept of upgradeable modules.
Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. Program will exit.

1

2

3

4

-Djava.endorsed.dirs=/volumes/data/bamboo/current/endorsed is not supported. Endorsed standards and standalone APIs

in modular form will be supported via the concept of upgradeable modules.

Error: Could not create the Java Virtual Machine.

Error: A fatal exception has occurred. Program will exit.

SOLUTION SUMMARY Correct by using Java 8 instead. Do it manually using alternatives –set, or interactively using alternatives –config. MANUAL PROCEDURE – two steps, one for java and one for javac

alternatives --set java /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/java
alternatives --set javac /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/javac

1 2	alternatives --set java /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/java alternatives --set javac /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/javac

INTERACTIVE PROCEDURE – two steps, one for java and one for javac

root@bamboo:/root # alternatives --config javac

There are 3 programs which provide 'javac'.

  Selection    Command
-----------------------------------------------
 + 1           /usr/lib/jvm/java-1.8.0-openjdk.x86_64/bin/javac
*  2           /usr/lib/jvm/java-11-amazon-corretto/bin/javac
   3           /usr/lib/jvm/java-1.7.0-openjdk.x86_64/bin/javac

Enter to keep the current selection[+], or type selection number: 

root@bamboo:/root # alternatives --config java

There are 4 programs which provide 'java'.

  Selection    Command
-----------------------------------------------
 + 1           /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/java
   2           /usr/lib/jvm/jre-1.6.0-openjdk.x86_64/bin/java
*  3           /usr/lib/jvm/java-11-amazon-corretto/bin/java
   4           /usr/lib/jvm/jre-1.7.0-openjdk.x86_64/bin/java

Enter to keep the current selection[+], or type selection number:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

root@bamboo:/root # alternatives --config javac

There are 3 programs which provide 'javac'.

Selection Command

-----------------------------------------------

+ 1 /usr/lib/jvm/java-1.8.0-openjdk.x86_64/bin/javac

* 2 /usr/lib/jvm/java-11-amazon-corretto/bin/javac

3 /usr/lib/jvm/java-1.7.0-openjdk.x86_64/bin/javac

Enter to keep the current selection[+], or type selection number:

root@bamboo:/root # alternatives --config java

There are 4 programs which provide 'java'.

Selection Command

-----------------------------------------------

+ 1 /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/java

2 /usr/lib/jvm/jre-1.6.0-openjdk.x86_64/bin/java

* 3 /usr/lib/jvm/java-11-amazon-corretto/bin/java

4 /usr/lib/jvm/jre-1.7.0-openjdk.x86_64/bin/java

Enter to keep the current selection[+], or type selection number:

Categories: How-To's, Technology Tags: alternatives, Bamboo, Catalina, catalina.out, Config, Endorsed, Endorsed standards, howto, Java, Java 8, java upgrade, java.endorsed.dirs, javac, set, tips, upgrade, Yum, yum update | No comments

How To Upgrade PHP on AWS Linux

Author: erics, August 22nd, 2019

As root:

PACKAGES=`yum list installed | grep php | awk -F. '{print $1}' | tr "\n\r" " "`
echo $PACKAGES
yum remove -y $PACKAGES

1

2

3

PACKAGES=`yum list installed | grep php | awk -F. '{print $1}' | tr "\n\r" " "`

echo $PACKAGES

yum remove -y $PACKAGES

~or~

yum remove php56 php56-cli php56-common php56-devel php56-gd php56-jsonc php56-jsonc-devel php56-mbstring php56-mcrypt php56-mysqlnd php56-pdo php56-pecl-imagick php56-process php56-xml

1	yum remove php56 php56-cli php56-common php56-devel php56-gd php56-jsonc php56-jsonc-devel php56-mbstring php56-mcrypt php56-mysqlnd php56-pdo php56-pecl-imagick php56-process php56-xml

THEN:

yum install php72 php72-bcmath php72-cli php72-common php72-devel php72-gd php72-imap php72-json php72-mysqlnd php72-pdo php72-pecl-apcu php72-pecl-imagick php72-pecl-imagick-devel php72-pecl-memcache php72-php-bcmath php72-php-common php72-php-json php72-process php72-runtime php72-xml php72-mbstring php72-pecl-mcrypt

1

yum install php72 php72-bcmath php72-cli php72-common php72-devel php72-gd php72-imap php72-json php72-mysqlnd php72-pdo php72-pecl-apcu php72-pecl-imagick php72-pecl-imagick-devel php72-pecl-memcache php72-php-bcmath php72-php-common php72-php-json php72-process php72-runtime php72-xml php72-mbstring php72-pecl-mcrypt

Be sure to restart your web server!!

Categories: How-To's, Technology Tags: Amazon, AWS, Install, Linux, php, php7, upgrade, Yum, yum install, yum list, yum remove, yum search | No comments

How To Install/Update CPAN on MacOS Mojave with fatal error: ‘EXTERN.h’ file not found

Author: erics, June 12th, 2019

The Problem Tried to install the latest version of cpan and got stuck. Tracked it down to the dependency module Mac::SystemDirectory which was failing to build:

cpan[1]> install Mac::SystemDirectory                                                                                                                                                                                                                                                    
Reading '/var/root/.cpan/Metadata'
  Database was generated on Sun, 09 Jun 2019 07:17:02 GMT
Running install for module 'Mac::SystemDirectory'
Running make for E/ET/ETHER/Mac-SystemDirectory-0.10.tar.gz
Checksum for /var/root/.cpan/sources/authors/id/E/ET/ETHER/Mac-SystemDirectory-0.10.tar.gz ok
Scanning cache /var/root/.cpan/build for sizes
............................................................................DONE

  CPAN.pm: Building E/ET/ETHER/Mac-SystemDirectory-0.10.tar.gz

HASCOMPILEREZFt/TESTUSSI.c:2:10: fatal error: 'EXTERN.h' file not found
#include "EXTERN.h"
         ^~~~~~~~~~
1 error generated.
Couldn't execute cc  -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -Os "-I/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE"   -c HASCOMPILEREZFt/TESTUSSI.c -o HASCOMPILEREZFt/TESTUSSI.o: Inappropriate ioctl for device at Makefile.PL line 14.
Requires a compiler
Warning: No success on command[/usr/bin/perl Makefile.PL INC=-I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE]
  ETHER/Mac-SystemDirectory-0.10.tar.gz
  /usr/bin/perl Makefile.PL INC=-I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE -- NOT OK
Running make test
  Make had some problems, won't test
Running make install
  Make had some problems, won't install
Failed during this command:
 ETHER/Mac-SystemDirectory-0.10.tar.gz        : writemakefile NO '/usr/bin/perl Makefile.PL INC=-I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE' returned status 6400

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

cpan[1]> install Mac::SystemDirectory

Reading '/var/root/.cpan/Metadata'

Database was generated on Sun, 09 Jun 2019 07:17:02 GMT

Running install for module 'Mac::SystemDirectory'

Running make for E/ET/ETHER/Mac-SystemDirectory-0.10.tar.gz

Checksum for /var/root/.cpan/sources/authors/id/E/ET/ETHER/Mac-SystemDirectory-0.10.tar.gz ok

Scanning cache /var/root/.cpan/build for sizes

............................................................................DONE

CPAN.pm: Building E/ET/ETHER/Mac-SystemDirectory-0.10.tar.gz

HASCOMPILEREZFt/TESTUSSI.c:2:10: fatal error: 'EXTERN.h' file not found

#include "EXTERN.h"

^~~~~~~~~~

1 error generated.

Couldn't execute cc -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -Os "-I/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE" -c HASCOMPILEREZFt/TESTUSSI.c -o HASCOMPILEREZFt/TESTUSSI.o: Inappropriate ioctl for device at Makefile.PL line 14.

Requires a compiler

Warning: No success on command[/usr/bin/perl Makefile.PL INC=-I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE]

ETHER/Mac-SystemDirectory-0.10.tar.gz

/usr/bin/perl Makefile.PL INC=-I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE -- NOT OK

Running make test

Make had some problems, won't test

Running make install

Make had some problems, won't install

Failed during this command:

ETHER/Mac-SystemDirectory-0.10.tar.gz : writemakefile NO '/usr/bin/perl Makefile.PL INC=-I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE' returned status 6400

The Solution Use the MacOS installer command to deploy the needed files:

xcode-select --install
sudo installer -pkg /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg -target /
installer: Package name is macOS_SDK_headers_for_macOS_10.14
installer: Installing at base path /
installer: The install was successful.

1

2

3

4

5

xcode-select --install

sudo installer -pkg /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg -target /

installer: Package name is macOS_SDK_headers_for_macOS_10.14

installer: Installing at base path /

installer: The install was successful.

The, rerunning the cpan install works:

cpan[1]> install Mac::SystemDirectory                                                                                                                                                                                                                                                    
...
Running make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/Mac/SystemDirectory/SystemDirectory.bs
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/Mac/SystemDirectory/SystemDirectory.bundle
Installing /Library/Perl/5.18/darwin-thread-multi-2level/Mac/SystemDirectory.pm
Installing /usr/local/share/man/man3/Mac::SystemDirectory.3pm
Appending installation info to /Library/Perl/Updates/5.18.2/darwin-thread-multi-2level/perllocal.pod
  ETHER/Mac-SystemDirectory-0.10.tar.gz
  /usr/bin/make install  -- OK

1

2

3

4

5

6

7

8

9

10

11

cpan[1]> install Mac::SystemDirectory

...

Running make install

Files found in blib/arch: installing files in blib/lib into architecture dependent library tree

Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/Mac/SystemDirectory/SystemDirectory.bs

Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/Mac/SystemDirectory/SystemDirectory.bundle

Installing /Library/Perl/5.18/darwin-thread-multi-2level/Mac/SystemDirectory.pm

Installing /usr/local/share/man/man3/Mac::SystemDirectory.3pm

Appending installation info to /Library/Perl/Updates/5.18.2/darwin-thread-multi-2level/perllocal.pod

ETHER/Mac-SystemDirectory-0.10.tar.gz

/usr/bin/make install -- OK

Categories: How-To's, Technology Tags: 10.14, CPAN, Error, extern.h, Fatal, Fatal Error, File not found, Header, headers, howto, Install, installer, Libraries, Library, MacOS, Mojave, not found, Package, perl, pkg, System, tips, update, upgrade, XCode | No comments

How To Upgrade MySQL to 5.7 on CentOS/AWS Linux

Author: erics, December 7th, 2017

START: Server version: 5.5.54-log MySQL Community Server (GPL) FINISH: Server version: 5.7.20-log MySQL Community Server (GPL)

mysql --execute="SET GLOBAL innodb_fast_shutdown=0;"
service mysqld stop
yum remove mysql mysql-*
yum install mysql57-devel mysql57-server mysql57-test
service mysqld start
mysql_upgrade
service mysqld restart

1

2

3

4

5

6

7

mysql --execute="SET GLOBAL innodb_fast_shutdown=0;"

service mysqld stop

yum remove mysql mysql-*

yum install mysql57-devel mysql57-server mysql57-test

service mysqld start

mysql_upgrade

service mysqld restart

If you do not restart MySQL server at the end, you will get this error:

ERROR 1682 (HY000): Native table 'performance_schema'.'session_variables' has the wrong structure

1	ERROR 1682 (HY000): Native table 'performance_schema'.'session_variables' has the wrong structure

Check and veify your my.cnf ssl entries if you see the following error in the /var/log/mysqld.log file at startup:

Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed

1	Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed

Categories: How-To's, Technology Tags: 5.5, 5.7, AWS, AWS Linux, CentOS, howto, mysql, MySQL 5.5, MySQL 5.7, tips, upgrade | No comments

How To Fix yum after Python Upgrade

Author: erics, December 8th, 2015

I upgraded to Python 2.7 and yum promptly broke. The quick fix is to edit the yum executable script and change the top line that invokes Python: sudo vim which yum CHANGE FROM: #!/usr/bin/python TO: #!/usr/bin/python26 UPDATED August 2nd, 2016: On one system, I had to use the following Python 2.4 fix instead, even though […]

Categories: How-To's, Technology Tags: 2.7, Broken, Fix, howto, Python, tips, upgrade, Yum | No comments

How To Upgrade MySQL to 8.0 on CentOS/AWS Linux

How To Fix WPDataTables Error “You are trying to load a table of an unknown type” in WordPress

How To Upgrade Certbot, Python and PIP on AWS Linux 1

First post after upgrading to WordPress 5.4

How To Downgrade PIP After Upgrade on Amazon Linux

How To Fix Bamboo Start Errors After Java Upgrade

How To Upgrade PHP on AWS Linux

How To Install/Update CPAN on MacOS Mojave with fatal error: ‘EXTERN.h’ file not found

How To Upgrade MySQL to 5.7 on CentOS/AWS Linux

How To Fix yum after Python Upgrade

Our Link Network

Business

Client Websites

Fine Dining

Friends & Family

Galleries

Health

Resources

Technology

Travel

The Archives

Latest Ramblings…

Various Topics of No Interest