Blog
Apache Show Real IP Address when using CloudFlare
When using Apache web server behind cloudflare, apache logs show cloudflare IP address instead of real visitor IP address. To show actual…
MySQL ERROR 1193 Unknown system variable GTID_PURGED
When restoring MySQL backup taken on Amazon RDS, i get error root@PRD-50ml:~# mysql sok_db2 < db.sql ERROR 1193 (HY000) at line 24:…
Cloudways
How to clear cloudways varnish cache How to Setup a Website in CloudWays hosting server How to Delete CloudWays Application
MySQL create database
To create a database, you can use create database DB_NAME; Example To create a database with specific charset use create database DB_NAME…
bluehost
How to disable server side caching in bluehost For SSH access, you need to chat with support and ask them to enable…
Install PHP 7 on CentOS VestaCP
To install PHP 7. you need to first enable epel and remi repo. yum install -y epel-release rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm Remove existing…
How to Install ImunifyAV on Cpanel Server
ImunifyAV is a Free version of a malware scanner for websites. To install ImunifyAV on Cpanel To start/stop, run If that did…
MySQL root password in VestaCP
In VestaCP server, MySQL root password is stored in file /usr/local/vesta/conf/mysql.conf, to find MySQL root password, run cat /usr/local/vesta/conf/mysql.conf
Configure Nginx Reverse Proxy behind Cloudflare
On reverse proxy server, lets install some basic utilities. apt install -y wget wget https://raw.githubusercontent.com/serverok/server-setup/master/debian/1-basic-tools.sh bash 1-basic-tools.sh Install nginx apt install nginx…
VestaCP Update
To update VestaCP server, run v-list-sys-vesta-updates v-update-sys-vesta-all Example [root@backendz ~]# v-list-sys-vesta-updates PKG VER REL ARCH UPDT DATE — — — —- —-…
mssql
How to install MS SQL 2017 in Windows Server 2019 How to restore MS SQL database backup Install PHP drivers for Microsoft…