Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboHere is a quick guide on how to 1. rewrite index.php to root 2. redirect .php to no extension (non .php) 3. rewrite non .php to .php using a .htaccess file To do…
How to: MySQL search and replace, PHPMyadmin, Joomla Params etc.
Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboBelow are a few SQL statements I use to search and replace the value of params in Joomla， in this case I added another value. UPDATE `joomla_database_name`.`j15_modules` SET params = replace(params, '"cache":"0"', '"backname":"1","backlink":"1","cache":"0"')…
How to: CentOS Virtualmin MySQL mysqlcheck Cronjob
Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboHow to setup a mysqlcheck cronjob in Virtualmin to run automatically every midnight and make it check, optimize and repair all of your databases and tables. Setup mysqlcheck cronjob in Virtualmin – Login to Virtualmin –…
How to: CentOS Virtualmin MySQL Slow Query Log Setup and View
Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboHow to setup Slow Query Logging in MySQL in Virtualmin on CentOS. Steps: 1. Setup Slow Query logging for MySQL 2. Setup MySQL slow Query log viewing in Virtualmin 1. Setup Slow…
How to: CentOS Virtualmin Add Cronjob – Hourly, Daily, Weekly, Monthly Missing – Fix
Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboHow to Add or Fix the Cronjobs tab in your Virtualmin running CentOS or most other Systems. If your Virtualmin >> System >> Scheduled Cron Jobs tab does not contain the Hourly, Daily, Weekly, Monthly…
How to: CentOS 6 Virtualmin Logwatch Install and Configure – Mail to Email – Disable Service Monitoring – Debug and fix – MySQL and HTTP Error
Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboThis How to contains instructions on how to install and configure Logwatch 7.4.0 on CentOS 6 running Virtualmin, and how to – Configure Mail to Email – Disable Service Monitoring – Debug and Fix…
How to: CentOS Virtualmin PHPMyadmin Disable Root Logins and Force SSL
Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboAfter you have installed phpmyadmin with virtualmin into a domain there are two things you need to change in the phpmyadmin config file for this to work The phpmyadmin file can be found…
How to: CentOS Virtualmin Automated Remote Back-ups with rdiff-backup – PUSH
Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboAfter my guide on setting up Rdiff-Backup to PULL backups from another server, I setup Two-factor SSH and Virtualmin Authentication via Google-Authenticator – having set this up I did not want to allow Public Key…
How To: CentOS Two-factor SSH and Virtualmin Authentication via Google-Authenticator
Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboThis is my guide to setting up Two-factor SSH and Virtualmin Authentication via Google-Authenticator on CentOS. What is Google Authenticatorcode.google.com/p/google-authenticator/ OverviewThe Google Authenticator project includes implementations of one-time passcode generators for several mobile…