Blog Archives

iptables to harden server

Recently, I got iptables settings that seem to harden server.  

This comes from a newly-provisioned vps. The iptables block all ports of the server except the ssh port(22). If you change the ssh port from the default 22

Posted in tips of hosting

How to download wistia video?

You may see on a web page a video  that is hosted by wistia.com. I mean the web page is not one of wistia.com pages but the video is indeed served by wistia by embedded code. How to download it?

Posted in tips of hosting

.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that ‘/var/www/domainhostseotool.com/public_html/’ is executable

Interestingly, the owner:group of /var/www/domainhostseotool.com/public_html is apache:apache and the mode is 755 . The owner:group of /var/www/domainhostseotool.com/public_html/.htaccess is also apache:apache and the mode is 644. Why does it complain the file is not readable and/or the directory is not executable?

Posted in tips of hosting

Use yum on CentOS 7/8 after EOL

I’ve been wondering why every major release of CentOS breaks yum on older release. For example, after CentOS 6 is EOL, you cannot use yum on CentOS6; after CentOS 7 EOL, you cannot use yum to install a software on

Posted in tips of hosting

How to sell serial numbers using License Manager for WooCommerce wordpress plugin?

After installing and activating the License Manager for WooCommerce wordpress plugin, you need to import the serial numbers to sell. You need to copy the SNs in a .txt file(one sn per line), then head into wordpress admin panel/WooCommerce/License Keys

Posted in tips of hosting

How to install and use WooCommerce wordpress plugin?

Yes, this is that famous wordpress plugin. If you type woocommerce as the keyword to search the plugin on your website’s wordpress admin/Add Plugin page, it appears as the first plugin with 5 million+ installations. But frankly speaking, this plugin

Posted in tips of hosting

cannot connect to vpn

I cannot connect to a pptp vpn. The following errors occur when clicking the connect button in windows 10: The modem(or other connecting device) has reported an error A device attached to the system is not functioning A connection to

Posted in tips of hosting

wp_options’ is marked as crashed and last (automatic?) repair failed

Today, when I accessed my website, it showed “database connection failed”. I opened the mysql log file /var/log/mariadb//mariadb.log and saw the following error: wp_options’ is marked as crashed and last (automatic?) repair failed I tried to repair the wp_options table:

Posted in tips of hosting

mysqlcheck: Got error: 1045: Access denied for user ‘root’@’localhost’ (using password: YES) when trying to connect

This error occurs when I run the following command:

Note that the command prompts for a password, and I input the correct password for the user root. Why does it still deny the access for root? If you ran

Posted in tips of hosting

set up v2ray with ws+tls

The idea  is your computer running v2ray client sends traffic to an https website address like https://domainhostseotool.com/ray. This website returns normal website content except for location /ray. For this special location, the httpd server Apache behaviors as a reverse proxy

Posted in tips of hosting