[Bitnami] mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Got into this error while trying to run "mysql_upgrade" command

bitnami@server:~$ mysql_upgrade --force -uroot -p
Enter password:
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) while connecting to the MySQL server
Upgrade process encountered error and will not continue.

Just do a symbolic link for the mysql.sock file.

bitnami@server:~$ ln -s /opt/bitnami/mysql/tmp/mysql.sock /tmp/mysql.sock
Wahlah! Problem solved!

bitnami@vulcan-clients:/tmp$ mysql_upgrade --force -uroot -p
Enter password:
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK

Visual Composer (version 4.4.1) fixes for Wordpress 4.7

Updated to Wordpress 4.7.2 recently and existing theme with old Visual Composer was broken.

Searched and tracked the error, and found the following scripts that solves the issues.

1. /wp-content/plugins/js_composer_theme/assets/js/backend/composer-view.js:99

2. /wp-content/plugins/js_composer_theme/assets/js/backend/composer-teaser.js:350

Test Pollen

Javascript for creating timeline


Google does crawl and parse iFrame content

I noticed that the number of 404s in my webmaster account starts to increase. I get "weird" links that I don't think should appear on my page, e.g. this:

A quick check shows that Google crawler picked up the URL from one of the Guardian iFrame:

I wonder whether any link juice is passed on to the URL, since its indexed by Google.

How to enable Facebook Comment reply function on Facebook Profile

This is a guide on how to enable Facebook comment reply on your Facebook profile.

Summary of steps:
1. Open Chrome
2. Enable emulate geolocation coordinate.
3. Set geolocation to New Zealand ("-41.211111", and "174.781111").
4. Open
5. Select "Check in"
6. Open
7. Comment reply should appear now!

Generate GoDaddy SSL Certificate (.crt) for Azure Websites (.pfx)

Step 1: Getting GoDaddy SSL cert.
Let's say you have a domain name of You'll first need to generate the the .csr file for GoDaddy with the following command:

openssl req -new -newkey rsa:2048 -nodes -keyout -out

This gives you 2 files: - This is the private key - This is the Certificate Signing Request

Copy the content of file to the SSL signing authority (GoDaddy).

Once approved, GoDaddy give you back a .zip file with the following 2 files:

18f1c77f369c0b59.crt - This is your cert
gd_bundle-g2-g1.crt - This is the GoDaddy Certificate Chain

Step 2: Convert a CERT/PEM certificate to a PFX certificate
openssl pkcs12 -export -out -inkey -in 18f1c77f369c0b59.crt

Step 3: Certificate to Upload to Azure.

Step 4: Assign SSL Bindings.

Step 5: Done!