How To Disable All Automatic WordPress Updates

Author: erics, April 22nd, 2024

To disable all automatic WordPress updates, just edit your WordPress/wp-config.php file and locate the line that says: /* That’s all, stop editing! Happy blogging. */ Add the following three lines ABOVE that line, then save and exit:

define( 'WP_AUTO_UPDATE_CORE', false );

1	define( 'WP_AUTO_UPDATE_CORE', false );

Categories: How-To's, Technology Tags: Auto, Automatic, Credentials, Creds, Disable, FTP, howto, Plugings, Prevent, Stop, tips, update, Updates, Upload, Uploads, WordPress | No comments

How To Stop WordPress From Using FTP For Updates Or Asking for FTP Credentials

Author: erics, April 22nd, 2024

Edit your WordPress/wp-config.php file and locate the line that says: /* That’s all, stop editing! Happy blogging. */ Add the following three lines ABOVE that line, then save and exit:

define('FS_METHOD', 'direct');
define('FS_CHMOD_DIR',0775);
define('FS_CHMOD_FILE',0664);

1

2

3

define('FS_METHOD', 'direct');

define('FS_CHMOD_DIR',0775);

define('FS_CHMOD_FILE',0664);

Be sure to refresh your browser to get the new settings! BONUS To force the use of FTP, change FS_METHOD from direct to ftpext: […]

Categories: How-To's, Technology Tags: Credentials, Creds, FTP, howto, Plugings, Prevent, Stop, tips, update, Updates, Upload, Uploads, WordPress | No comments

How To Clear All iptables Rules

Author: erics, March 20th, 2024

iptables -P INPUT ACCEPT
iptables -P FORWARD ACCEPT
iptables -P OUTPUT ACCEPT
iptables -t nat -F
iptables -t mangle -F
iptables -F
iptables -X

1

2

3

4

5

6

7

iptables -P INPUT ACCEPT

iptables -P FORWARD ACCEPT

iptables -P OUTPUT ACCEPT

iptables -t nat -F

iptables -t mangle -F

iptables -F

iptables -X

Categories: How-To's, Technology Tags: Clear, clear iptables, clear rules, howto, IPTables, Reset, reset iptables, Rules, tips | No comments

How To Diff Two Files In Vim

Author: erics, February 5th, 2024

shell> vim file1 file2 Create a vertical split window: Control-w v Enable visual diff on the left side: :diffthis Move the cursor to the right side buffer: Control-w Right-arrow Enable visual diff on the left side: :diffthis You should now see the differences highlighted on both sides.

Categories: How-To's, Technology Tags: :diffthis, Buffer, diff, howto, Split, tips, Vertical, vi, vim, Visual, Visual Diff | No comments

How To Display All Virtual Hosts Defined for Apache 2

Author: erics, January 29th, 2024

httpd -t -D DUMP_VHOSTS

1	httpd -t -D DUMP_VHOSTS

Categories: How-To's, Technology Tags: apache, Apache 2.4, Apache2, conf.d, howto, httpd, tips, vhost | No comments

How To Fix perl: symbol lookup error: undefined symbol: Perl_xs_handshake

Author: erics, November 9th, 2023

This was caused by having the PERL5LIB environment variable set.

root@server1:/root # /etc/webmin/restart-by-force-kill
Force stopping Webmin server in /usr/libexec/webmin
/etc/webmin/.stop-init: line 10: kill: (10111) - No such process
Starting Webmin server in /usr/libexec/webmin
/usr/bin/perl: symbol lookup error: /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/Net/SSLeay/SSLeay.so: undefined symbol: Perl_ss_handshake

root@ server1:/root # unset PERL5LIB

root@ server1:/root # /etc/webmin/restart-by-force-kill
Force stopping Webmin server in /usr/libexec/webmin
/etc/webmin/.stop-init: line 10: kill: (10111) - No such process
Starting Webmin server in /usr/libexec/webmin

1

2

3

4

5

6

7

8

9

10

11

12

root@server1:/root # /etc/webmin/restart-by-force-kill

Force stopping Webmin server in /usr/libexec/webmin

/etc/webmin/.stop-init: line 10: kill: (10111) - No such process

Starting Webmin server in /usr/libexec/webmin

/usr/bin/perl: symbol lookup error: /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/Net/SSLeay/SSLeay.so: undefined symbol: Perl_ss_handshake

root@ server1:/root # unset PERL5LIB

root@ server1:/root # /etc/webmin/restart-by-force-kill

Force stopping Webmin server in /usr/libexec/webmin

/etc/webmin/.stop-init: line 10: kill: (10111) - No such process

Starting Webmin server in /usr/libexec/webmin

Categories: How-To's, Technology Tags: env, environment, Error, howto, perl, Perl_xs_handshake, PERL5LIB, symbol lookup error, tips, undefined symbol, unset, Webmin | No comments

How To Secure Self-Hosted Bamboo and Crucible with Let’s Encrypt SSL Certificates

Author: erics, September 14th, 2023

Summary In this blog we explore how to use certificates from Let’s Encrypt to secure self-hosted Bamboo and Crucible. Process To Follow Install Certbot Ensure that external DNS resolves to the correct IP addressping example.yourdomain.com Ensure that Port 80 is open from the outside to that IP address so that Let’s Encrypt can validate the […]

Categories: How-To's, Technology Tags: Bamboo, Crucible, howto, https, keytool, openssl, security, ssl, tips | No comments

How to add and delete security group rules in AWS via the CLI (and list them too!)

Author: erics, September 13th, 2023

Add inbound rule(s) for a security group ID:

shell> aws ec2 authorize-security-group-ingress --group-id sg-NNNNNNNN --protocol tcp --port 80 --cidr '0.0.0.0/0'

1	shell> aws ec2 authorize-security-group-ingress --group-id sg-NNNNNNNN --protocol tcp --port 80 --cidr '0.0.0.0/0'

## Delete inbound rule(s) for a security group ID

shell> aws ec2 revoke-security-group-ingress --group-id sg-NNNNNNNN --protocol tcp --port 80 --cidr '0.0.0.0/0'

1	shell> aws ec2 revoke-security-group-ingress --group-id sg-NNNNNNNN --protocol tcp --port 80 --cidr '0.0.0.0/0'

## List security groups by security group ID

shell> aws ec2 describe-security-groups --output json | jq -r '.SecurityGroups[]|.GroupId+" "+.GroupName'

1	shell> aws ec2 describe-security-groups --output json \| jq -r '.SecurityGroups[]\|.GroupId+" "+.GroupName'

## List inbound rules for a specific security group ID

shell> aws ec2 describe-security-groups --group-ids sg-NNNNNNNN --output json | jq -r '.SecurityGroups[].IpPermissions[]|. as $parent|(.IpRanges[].CidrIp+" "+($parent.ToPort|tostring))'

1	shell> aws ec2 describe-security-groups --group-ids sg-NNNNNNNN --output json \| jq -r '.SecurityGroups[].IpPermissions[]\|. as $parent\|(.IpRanges[].CidrIp+" "+($parent.ToPort\|tostring))'

Thanks to: https://www.bluematador.com/learn/aws-cli-cheatsheet

Categories: How-To's, Technology Tags: Add, AWS, aws cli, cli, Delete, Group, howto, Remove, security, Security Group, tips | No comments

How To Use SSL With sysbench To Test MySQL Server

Author: erics, September 7th, 2023

SUMMARY If sysbench is started with the “–mysql-ssl=on” option, it looks in the current directory for the following files:

client-cert.pem
client-key.pem
cacert.pem (note no dash)

1

2

3

client-cert.pem

client-key.pem

cacert.pem (note no dash)

PROCEDURE Locate the current MySQL database certificates, usually in /var/lib/mysql, and make sure that the OS user running sysbench is able to read the following 3 files:

ca.pem
client-cert.pem
client-key.pem

1

2

3

ca.pem

client-cert.pem

client-key.pem

Next, cd to the OS user’s home […]

Categories: How-To's, Technology Tags: How To, howto, mysql, ssl, SysBench, tips | No comments

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 Disable All Automatic WordPress Updates

How To Stop WordPress From Using FTP For Updates Or Asking for FTP Credentials

How To Clear All iptables Rules

How To Diff Two Files In Vim

How To Display All Virtual Hosts Defined for Apache 2

How To Fix perl: symbol lookup error: undefined symbol: Perl_xs_handshake

How To Secure Self-Hosted Bamboo and Crucible with Let’s Encrypt SSL Certificates

How to add and delete security group rules in AWS via the CLI (and list them too!)

How To Use SSL With sysbench To Test MySQL Server

How To Upgrade MySQL to 8.0 on CentOS/AWS Linux

Our Link Network

Business

Client Websites

Fine Dining

Friends & Family

Galleries

Health

Resources

Technology

Travel

The Archives

Latest Ramblings…

Various Topics of No Interest