Install and Secure Redis on CentOS 7

 

Redis Installation

Add the EPEL repository, and update YUM

 

Install Redis

 

Start Redis and setup automatically start Redis on boot

 

Verify the Installation

If Redis is running, it will return: PONG

 

Redis Configuration

Password settings

find and uncomment the requirepass line in the configuration file, and replace master_password with a secure password

 

Firewall settings

 

Local Benchmark Test

 

Check Redis Version

 

Setup PHP session to Redis

 

 

How to fix MySQL connection error: Authentication plugin ‘caching_sha2_password’ cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found

The problem is some MySQL clients not yet support new password encryption method.

 

Just change the user password encryption back to legacy version, then problem will be fixed.

The following SQL update specific user to legacy encryption:

 

Also, you can change the default authentication plugin to legacy version.

Update /etc/my.cnf and add the following line after [mysqld]:

 

 

Install wkhtmltopdf & wkhtmltoimage to CentOS with Chinese & Asian fonts support

Install dependencies

 

Install wkhtmltopdf and wkhtmltoimage

p.s. you can find more versions in the following link:

https://github.com/wkhtmltopdf/wkhtmltopdf/releases

 

Install  Chinese & Asian fonts support

 

References

https://wkhtmltopdf.org/

MySQL ERROR 1366 (HY000): Incorrect integer value: ” for column ‘id’ at row 1 Problem & Fix

 

Problem:

MySQL throw the following error message on insert or update statement executed

 

Why?

Try to update string value into integer column, and strict sql mode is enabled.

Mainly occurred on MySQL 5.x or above.

 

How to Fix:

1. Disable strict sql mode

Update /etc/my.cnf , and remove STRICT_TRANS_TABLES from sql-mode

 

References:

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_strict_trans_tables

Too many process sidekiq 4.2.7 gitlab-rails [0 of 25 busy]

I am running a small GitLab server for my personal use, but GitLab default concurrency settings up to 25.

So I try to update the max concurrency to free server resource.

 

Update Configuration

Add or update the value

 

Restart the Service

 

 

Most Simple and Fastest Way to Backup and Restore a MySQL Database (mysqldump & mysql client)

How to mysqldump and mysql to backup and restore a database:

Backup to .sql file

 

Restore from .sql file

 

Suggested to run the command in database server to get the fastest speed.

 

References:

https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html

How to Install NGINX and PHP-FPM on RHEL/CentOS 7

Basic Server Setup

 

 

 

Setup NGINX and PHP-FPM

 

 

Update Configuration

 

 

 

 

 

Create Virtual Hosts

 

 

 

 

Setup Firewall (Optional)

 

SELinux Settings (Optional for SELinux enabled)

 

Reboot after Setup

 

 

How to Install MySQL 5.7 on RHEL/CentOS 7

Basic Server Setup

 

 

 

Setup MySQL 5.7

 

 

Setup Firewall (Optional)

 

Reboot after Setup

 

Optional Settings for MySQL 5.7

Disable MySQL Strict Mode

Reference: https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

 

Fix MySQL Password Expired

To establish a global policy such that passwords never expire.

Update /etc/my.cnf

Reference: https://dev.mysql.com/doc/refman/5.7/en/password-expiration-policy.html

 

Convert .cer to .crt certificates for Apache/mod_ssl using OpenSSL

Assume you have a CER is an DER encoded X.509 certificate in binary form, and you want to have a PEM-encoded X.509 Certificate file for Apache.

The following command may help:

 

Apache/mod_ssl request PEM-encoded X.509 Certificate file

Reference: http://www.modssl.org/docs/2.8/ssl_reference.html#ToC10