How to generate Self-Signed SSL on cPanel server using command line

Run and put your domain:

read -p "Domain: " domain; username=`/scripts/whoowns $domain`; email=`grep @ /var/cpanel/users/$username |tail -n1 |cut -d '=' -f2|sed -e 's/@/\%40/'`; whmapi1 generatessl domains=$domain countryName=US stateOrProvinceName=Texas localityName=Houston organizationName="The Justice League of GG" emailAddress=$email pass=`openssl rand -base64 15` keysize=2048 skip_certificate=0

Now use WHM to install it

Enjoy!… Read the rest

How to specify which IP address to use for curl or wget commands

Useful when you try to send a request from cPanel shell from your Dedicated IP address

For curl you need to use –interface to specify IP address

Example:

curl --interface 11.22.33.44 http://alltime.pp.ua/

For wget you need to use –bind-address to set IP from which you need to send a request

wget --bind-address=192.0.2.116 http://alltime.pp.ua/
Read the rest

How to install busybox

BusyBox combines tiny versions of many common UNIX utilities into a single small executable.

This may help you when you got your shell broken since busybox in independent binary which includes a lot of commands inside.

In simple words this tool can save your life 🙂

Find the latest version of busybox at https://busybox.net/downloads/binariesRead the rest

How to fix a login issue after WordPress Multisite split

The slave installation will lose users

wp user list

+—-+————+————–+————+—————–+——-+
| ID | user_login | display_name | user_email | user_registered | roles |
+—-+————+————–+————+—————–+——-+
+—-+————+————–+————+—————–+——-+

And you won’t be able to create new admin user because you don’t have appropriate MySQL tables

wp user create admin [email protected]
Read the rest

How to fix Unknown collation utf8mb4_unicode_520_ci error while importing data from an sql dump

Error:

ERROR 1273 (HY000) at line 849: Unknown collation: ‘utf8mb4_unicode_520_ci’

To fix simply replace utf8mb4_unicode_520_ci to utf8mb4_unicode_ci inside your SQL dump

Example:

sed -i 's/utf8mb4_unicode_520_ci/utf8mb4_unicode_ci/g' yoursqldumphere.sql

or

replace 'utf8mb4_unicode_520_ci' 'utf8mb4_unicode_ci' -- yoursqldumphere.sql
Read the rest

How to deal with “ea-php72” is not an EA4 SCL PHP error

Go to your WHM –> Home –> Software –> MultiPHP Manager

You should be able to resolve this by changing the domains to use an available version of PHP, or by installing the missing PHP versions.

You need to either install missed PHP version or set it to inherit

Command line solution:

Find main domain of account in issue and run:

whmapi1 php_set_vhost_versions version=inherit vhost=domainname.com
Read the rest

How to fix exim Could not complete sender verify

Check if you can reach a remote server

dig a gmail.com

If this timeouts then try over one of dns resolver directly

[~]# dig @8.8.8.8 a gmail.com

; <<>> DiG 9.11.4-P2-RedHat-9.11.4-26.P2.el7_9.2 <<>> @8.8.8.8 a gmail.com
; (1 server found)
;; global options: +cmd
;; connection timed out; no servers could be reached

Timeout means DNS resolver is dead

[~]# cat /etc/resolv.conf
Read the rest