Author Archives: tabcom

How to bypass Google Authenticator in WordPress (or Joomla)

So you have configured WordPress to use 2-factor authentication – well done.  You are most likely using the Google Authenticator app on your mobile phone to generate the required pin code.

Problem

But what to do if your mobile phone gets damaged -or even worse- stolen?  How can you logon to WordPress to recover or change the Secret Key necessary to configure Google Authenticator on another mobile phone?

Solution

Temporarily rename the Google Authenticator plugin folder inside WordPress.  The plugin will no longer load and 2-factor authentication is temporarily disabled.  You can now simply login with username and password and retrieve or change the Secret Key.  After you rename the Google Authenticator plugin folder inside WordPress back to its original name, 2-factor authentication is again enabled.

The process in more detail:

cd wp-content/plugins
mv google-authenticator google-authenticator.tmp
2-factor authentication is now disabled.
Login to WordPress using just username and password authentication.
Go to Dashboard | Users
Generate a new Secret Key or just write down the existing Secret key.
Configure Google Authenticator on a mobile phone.
mv google-authenticator.tmp google-authenticator
2-factor authentication is now enabled
(Logout and) Login to WordPress using 2-factor authentication.

This way there is no need to change table fields in the database.

Alternatively there are Google Authentication apps (not made by Google) that offer extra features like exporting the Secret Keys or transferring Secret Keys between phones.  Some even offer to store the Secret Key(s) on the internet for you.

I prefer simply regaining access to the original keys rather than storing keys in multiple locations or in a non-trusted environment.

How to bypass Google Authenticator in WordPress (or Joomla) was last modified: September 26th, 2016 by tabcom

MySQL / phpMyAdmin

Next Training Session

Date: Wednesday 19 October 2016
Time: 08:00pm – 10:00pm
Location: (Rangeview) Tolga, QLD
Cost: $90
Subject MySQL / phpMyAdmin

Description

MySQL is a database engine frequently used in LAMP web site hosting.  LAMP is short for Linux-Apache-MySQL-PHP.  The operating system is Linux; the web server used is Apache and the web site is dynamic using the PHP programming language with a MySQL database backend to store information.  MySQL is a popular database engine used in combination with open source content management systems like WordPress and Joomla.

This 2 hour training session will teach you what SQL commands are, how to enter SQL commands directly from the mysql command prompt and how to use the web based mysql user interface named phpMyAdmin to administer MySQL databases.

Continue Reading →

MySQL / phpMyAdmin was last modified: September 25th, 2016 by tabcom

TPlink internet modem won’t connect

Problem

TPlink internet modem refuses to reconnect after a power outage.

Cause

There is no button battery to backup the current date/time. The current data/time value is lost and set to a default value. If the modem is configured to synchronize with internet time servers, this only works after connectivity is restored, not before.

Solution

Manually correct the date/time value.

TPlink internet modem won’t connect was last modified: September 17th, 2016 by tabcom